SELECT art.estretail, art.id FROM artitems art WHERE ( art.objectcat = 172) 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 1 WHEN STATUS='a5' THEN 1 WHEN STATUS='10' THEN 2 WHEN STATUS='aa' THEN 2 WHEN STATUS='9' THEN 3 WHEN STATUS='a9' THEN 3 ELSE 3 END), `status` ASC, art.when_published_timestamp DESC LIMIT 9,9 Search Color: Mool: Call415-215-6533 Mool: Call415-215-6533 Mool: Call415-215-6533 Mool: call415-215-6533 Mool: Call/Quote*415-776-0104 Mool: Call/Quote*415-776-0104 Mool: Call/Quote*415-776-0104 Mool: call415-776-0104 Mool: call-415-776-0104 Mool: Call415-215-6533