SELECT * FROM Collection where ( SH = 'CR' ) ORDER BY PN DESC LIMIT 0, 24