SELECT * FROM artitems art WHERE ( art.objectcat = 3 OR art.objectcat = 52 OR art.objectcat = 10 OR art.objectcat = 11 OR art.objectcat = 19 OR art.objectcat = 20 OR art.objectcat = 21 OR art.objectcat = 22 OR art.objectcat = 42 OR art.objectcat = 43 OR art.objectcat = 44 OR art.objectcat = 45 OR art.objectcat = 46 OR art.objectcat = 47 OR art.objectcat = 48 OR art.objectcat = 49 OR art.objectcat = 51 ) AND ( 1 ) AND ( 1 ) AND ( 1 ) AND ( 1 ) AND (art.publish = 1 AND art.hidden = 0) AND (status = 0 OR (status > 4 AND status < 10)) ORDER BY (CASE WHEN STATUS='0' THEN 0 WHEN STATUS='a' THEN 0 WHEN STATUS='5' THEN 2 WHEN STATUS='a5' THEN 2 WHEN STATUS='10' THEN 3 WHEN STATUS='aa' THEN 3 WHEN STATUS='9' THEN 2 WHEN STATUS='a9' THEN 2 ELSE 3 END), `status` ASC, art.when_published_timestamp DESC Search Color:

SELECT * FROM artitems art WHERE ( art.objectcat = 3 OR art.objectcat = 52 OR art.objectcat = 10 OR art.objectcat = 11 OR art.objectcat = 19 OR art.objectcat = 20 OR art.objectcat = 21 OR art.objectcat = 22 OR art.objectcat = 42 OR art.objectcat = 43 OR art.objectcat = 44 OR art.objectcat = 45 OR art.objectcat = 46 OR art.objectcat = 47 OR art.objectcat = 48 OR art.objectcat = 49 OR art.objectcat = 51 ) AND ( 1 ) AND ( 1 ) AND ( 1 ) AND ( 1 ) AND (art.publish = 1 AND art.hidden = 0) AND (status = 0 OR (status > 4 AND status < 10)) ORDER BY (CASE WHEN STATUS='0' THEN 0 WHEN STATUS='a' THEN 0 WHEN STATUS='5' THEN 2 WHEN STATUS='a5' THEN 2 WHEN STATUS='10' THEN 3 WHEN STATUS='aa' THEN 3 WHEN STATUS='9' THEN 2 WHEN STATUS='a9' THEN 2 ELSE 3 END), `status` ASC, art.when_published_timestamp DESC