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,5094,9224,5108,6124,5138,5091,5134,5135,5092,5407,5136,7521,5139,5093,6145,7008,7004,6143,6171,5427,5140,7009,5137,7522,5444,5443,5437,6151,5465,5438,6155,6140,5439,5426,7010,6647,7532,5107,6613,5738,6139,6633)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 5094 THEN (num*2)+1 WHEN 9224 THEN (num*2)+2 WHEN 5108 THEN (num*2)+3 WHEN 6124 THEN (num*2)+4 WHEN 5138 THEN (num*2)+5 WHEN 5091 THEN (num*2)+6 WHEN 5134 THEN (num*2)+7 WHEN 5135 THEN (num*2)+8 WHEN 5092 THEN (num*2)+9 WHEN 5407 THEN (num*2)+10 WHEN 5136 THEN (num*2)+11 WHEN 7521 THEN (num*2)+12 WHEN 5139 THEN (num*2)+13 WHEN 5093 THEN (num*2)+14 WHEN 6145 THEN (num*2)+15 WHEN 7008 THEN (num*2)+16 WHEN 7004 THEN (num*2)+17 WHEN 6143 THEN (num*2)+18 WHEN 6171 THEN (num*2)+19 WHEN 5427 THEN (num*2)+20 WHEN 5140 THEN (num*2)+21 WHEN 7009 THEN (num*2)+22 WHEN 5137 THEN (num*2)+23 WHEN 7522 THEN (num*2)+24 WHEN 5444 THEN (num*2)+25 WHEN 5443 THEN (num*2)+26 WHEN 5437 THEN (num*2)+27 WHEN 6151 THEN (num*2)+28 WHEN 5465 THEN (num*2)+29 WHEN 5438 THEN (num*2)+30 WHEN 6155 THEN (num*2)+31 WHEN 6140 THEN (num*2)+32 WHEN 5439 THEN (num*2)+33 WHEN 5426 THEN (num*2)+34 WHEN 7010 THEN (num*2)+35 WHEN 6647 THEN (num*2)+36 WHEN 7532 THEN (num*2)+37 WHEN 5107 THEN (num*2)+38 WHEN 6613 THEN (num*2)+39 WHEN 5738 THEN (num*2)+40 WHEN 6139 THEN (num*2)+41 WHEN 6633 THEN (num*2)+42 END,numErr153a