SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk txt,prix,promo,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,9102,9132,4849,8898,9019,9018,5375,9080,9141,7770,5817,6732,4264,9079,5431,6263,9081,8834,8845,6240,5191,6737,8464,8386,8508,8473,8163,8839,8763,6302,8076,4368,7971,6306,3680,8138,8261,8844,6733,8137,6749,5481,8136,8135,6383,7270,9020,9103,8784,8381,4745,9142,7776,8509,8758,8786,7281,8760,8759,8833,6199,7774,8838,8785,7271,8142,8835,7273,8863,7777,8862,7972,8494,7775,8262,8836,7274,8837)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%57%'ORDER BY CASE produit WHEN 9102 THEN (num*3)+1 WHEN 9132 THEN (num*3)+2 WHEN 4849 THEN (num*3)+3 WHEN 8898 THEN (num*3)+4 WHEN 9019 THEN (num*3)+5 WHEN 9018 THEN (num*3)+6 WHEN 5375 THEN (num*3)+7 WHEN 9080 THEN (num*3)+8 WHEN 9141 THEN (num*3)+9 WHEN 7770 THEN (num*3)+10 WHEN 5817 THEN (num*3)+11 WHEN 6732 THEN (num*3)+12 WHEN 4264 THEN (num*3)+13 WHEN 9079 THEN (num*3)+14 WHEN 5431 THEN (num*3)+15 WHEN 6263 THEN (num*3)+16 WHEN 9081 THEN (num*3)+17 WHEN 8834 THEN (num*3)+18 WHEN 8845 THEN (num*3)+19 WHEN 6240 THEN (num*3)+20 WHEN 5191 THEN (num*3)+21 WHEN 6737 THEN (num*3)+22 WHEN 8464 THEN (num*3)+23 WHEN 8386 THEN (num*3)+24 WHEN 8508 THEN (num*3)+25 WHEN 8473 THEN (num*3)+26 WHEN 8163 THEN (num*3)+27 WHEN 8839 THEN (num*3)+28 WHEN 8763 THEN (num*3)+29 WHEN 6302 THEN (num*3)+30 WHEN 8076 THEN (num*3)+31 WHEN 4368 THEN (num*3)+32 WHEN 7971 THEN (num*3)+33 WHEN 6306 THEN (num*3)+34 WHEN 3680 THEN (num*3)+35 WHEN 8138 THEN (num*3)+36 WHEN 8261 THEN (num*3)+37 WHEN 8844 THEN (num*3)+38 WHEN 6733 THEN (num*3)+39 WHEN 8137 THEN (num*3)+40 WHEN 6749 THEN (num*3)+41 WHEN 5481 THEN (num*3)+42 WHEN 8136 THEN (num*3)+43 WHEN 8135 THEN (num*3)+44 WHEN 6383 THEN (num*3)+45 WHEN 7270 THEN (num*3)+46 WHEN 9020 THEN (num*3)+47 WHEN 9103 THEN (num*3)+48 WHEN 8784 THEN (num*3)+49 WHEN 8381 THEN (num*3)+50 WHEN 4745 THEN (num*3)+51 WHEN 9142 THEN (num*3)+52 WHEN 7776 THEN (num*3)+53 WHEN 8509 THEN (num*3)+54 WHEN 8758 THEN (num*3)+55 WHEN 8786 THEN (num*3)+56 WHEN 7281 THEN (num*3)+57 WHEN 8760 THEN (num*3)+58 WHEN 8759 THEN (num*3)+59 WHEN 8833 THEN (num*3)+60 WHEN 6199 THEN (num*3)+61 WHEN 7774 THEN (num*3)+62 WHEN 8838 THEN (num*3)+63 WHEN 8785 THEN (num*3)+64 WHEN 7271 THEN (num*3)+65 WHEN 8142 THEN (num*3)+66 WHEN 8835 THEN (num*3)+67 WHEN 7273 THEN (num*3)+68 WHEN 8863 THEN (num*3)+69 WHEN 7777 THEN (num*3)+70 WHEN 8862 THEN (num*3)+71 WHEN 7972 THEN (num*3)+72 WHEN 8494 THEN (num*3)+73 WHEN 7775 THEN (num*3)+74 WHEN 8262 THEN (num*3)+75 WHEN 8836 THEN (num*3)+76 WHEN 7274 THEN (num*3)+77 WHEN 8837 THEN (num*3)+78 END,numErr153a