SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel 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,5094,9224,5108,6124,5138,5091,5134,5135,5092,5407,7521,5136,5427,7004,5140,7008,5139,5426,5137,7009,5443,5444,5437,7010,5438,5465,7522,5093,6143,6145,5439,6171,6151,6155,6140,6647,7532,5107,6613,5738,6139,6633)  AND produit NOT IN( ) AND cm LIKE '%62%' AND ( id=14596 OR id=13119 OR id=13122 OR id=17387 OR id=16484 OR id=17385 OR id=17660 OR id=17545 OR id=14477 OR id=17336 OR id=17021 OR id=12823 OR id=16619 OR id=16891 OR id=17271 OR id=16888 OR id=16448 OR id=17278 OR id=13162 OR id=17272 OR id=14626 OR id=15709 OR id=15435 OR id=16363 OR id=15932 OR id=16260 OR id=12438 OR id=14075 OR id=15692 OR id=14720 OR id=14740 OR id=15440 OR id=14638 OR id=14653 OR id=14175 OR id=13148 OR id=14067 OR id=15103 OR id=13865 OR id=11295 OR id=13373 OR id=11376 OR id=15021 OR id=11027 OR id=13710 OR id=14104 OR id=13568 OR id=16427 )ORDER BY CASE produit WHEN 5094 THEN (num*0.2)+1 WHEN 9224 THEN (num*0.2)+2 WHEN 5108 THEN (num*0.2)+3 WHEN 6124 THEN (num*0.2)+4 WHEN 5138 THEN (num*0.2)+5 WHEN 5091 THEN (num*0.2)+6 WHEN 5134 THEN (num*0.2)+7 WHEN 5135 THEN (num*0.2)+8 WHEN 5092 THEN (num*0.2)+9 WHEN 5407 THEN (num*0.2)+10 WHEN 7521 THEN (num*0.2)+11 WHEN 5136 THEN (num*0.2)+12 WHEN 5427 THEN (num*0.2)+13 WHEN 7004 THEN (num*0.2)+14 WHEN 5140 THEN (num*0.2)+15 WHEN 7008 THEN (num*0.2)+16 WHEN 5139 THEN (num*0.2)+17 WHEN 5426 THEN (num*0.2)+18 WHEN 5137 THEN (num*0.2)+19 WHEN 7009 THEN (num*0.2)+20 WHEN 5443 THEN (num*0.2)+21 WHEN 5444 THEN (num*0.2)+22 WHEN 5437 THEN (num*0.2)+23 WHEN 7010 THEN (num*0.2)+24 WHEN 5438 THEN (num*0.2)+25 WHEN 5465 THEN (num*0.2)+26 WHEN 7522 THEN (num*0.2)+27 WHEN 5093 THEN (num*0.2)+28 WHEN 6143 THEN (num*0.2)+29 WHEN 6145 THEN (num*0.2)+30 WHEN 5439 THEN (num*0.2)+31 WHEN 6171 THEN (num*0.2)+32 WHEN 6151 THEN (num*0.2)+33 WHEN 6155 THEN (num*0.2)+34 WHEN 6140 THEN (num*0.2)+35 WHEN 6647 THEN (num*0.2)+36 WHEN 7532 THEN (num*0.2)+37 WHEN 5107 THEN (num*0.2)+38 WHEN 6613 THEN (num*0.2)+39 WHEN 5738 THEN (num*0.2)+40 WHEN 6139 THEN (num*0.2)+41 WHEN 6633 THEN (num*0.2)+42 END,numErr153a