CASE WHEN EXISTS (SELECT 1 FROM oc_product_special sp WHERE sp.product_id = p.product_id) THEN 0 ELSE 1 END,IF(p.`price` = '0', 1, 0) ASC, IF(p.`image` != 'NULL', 0, 1) ASC,FIELD(p.manufacturer_id,573,570,563) DESC