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, FIELD(p.`article`,122533,133840,122535,122534,122536,122537,122538,122539,122284,122283,122281,122282,122280,97567,122279,122278,122277,122443,122442,122441,122440,122439,133841,122438,122437,122436,122435,122434,122433,122432,122431,238141,133836,133837,238139,238140) DESC, IF(p.`image` != 'NULL', 0, 1) ASC