SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=2 AND photo2_2!="" THEN photo2_2 ELSE photo2 END photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,5138,5134,9224,5091,7521,5135,5139,5407,5427,5136,7004,5140,5426,7009,5137,5094,5108,5092,6124,5438,5444,5093,5465,6171,5437,6143,6151,6155,6140,6633,5738,7532,6613,5107,6139)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%58%'ORDER BY CASE produit WHEN 5138 THEN (num*2)+1 WHEN 5134 THEN (num*2)+2 WHEN 9224 THEN (num*2)+3 WHEN 5091 THEN (num*2)+4 WHEN 7521 THEN (num*2)+5 WHEN 5135 THEN (num*2)+6 WHEN 5139 THEN (num*2)+7 WHEN 5407 THEN (num*2)+8 WHEN 5427 THEN (num*2)+9 WHEN 5136 THEN (num*2)+10 WHEN 7004 THEN (num*2)+11 WHEN 5140 THEN (num*2)+12 WHEN 5426 THEN (num*2)+13 WHEN 7009 THEN (num*2)+14 WHEN 5137 THEN (num*2)+15 WHEN 5094 THEN (num*2)+16 WHEN 5108 THEN (num*2)+17 WHEN 5092 THEN (num*2)+18 WHEN 6124 THEN (num*2)+19 WHEN 5438 THEN (num*2)+20 WHEN 5444 THEN (num*2)+21 WHEN 5093 THEN (num*2)+22 WHEN 5465 THEN (num*2)+23 WHEN 6171 THEN (num*2)+24 WHEN 5437 THEN (num*2)+25 WHEN 6143 THEN (num*2)+26 WHEN 6151 THEN (num*2)+27 WHEN 6155 THEN (num*2)+28 WHEN 6140 THEN (num*2)+29 WHEN 6633 THEN (num*2)+30 WHEN 5738 THEN (num*2)+31 WHEN 7532 THEN (num*2)+32 WHEN 6613 THEN (num*2)+33 WHEN 5107 THEN (num*2)+34 WHEN 6139 THEN (num*2)+35 END,numErr153a