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 '%58%' AND ( id=13671 OR id=13374 OR id=9327 OR id=17027 OR id=9367 OR id=16176 OR id=17660 OR id=8643 OR id=17638 OR id=17634 OR id=9404 OR id=17009 OR id=16749 OR id=17288 OR id=17036 OR id=17278 OR id=14385 OR id=9445 OR id=10306 OR id=13193 OR id=4873 OR id=8071 OR id=16027 OR id=15297 OR id=15106 OR id=13167 OR id=9551 OR id=14230 OR id=12615 OR id=11294 OR id=14086 OR id=4972 OR id=15460 OR id=14229 OR id=14177 OR id=16167 OR id=15411 )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