SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo,CASE WHEN isable!=0 THEN photo WHEN wi1!=2 AND photo1_2!="" THEN photo1_2 WHEN wi1!=4 AND photo1_4!="" THEN photo1_4 ELSE photo END photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,5985,9424,6598,9448,3007,9277,9267,9328,9403,9412,9523,9504,9341,8859,9503,9316,9315,7217,9304,8857,8856,8854,8696,5009,7238,6146,8708,7298,5967,8774,5966,8585,7300,8598,6001,8013,7536,7241,6607,7485,7533,7981,6007,3094,6140,8653,7537,6417,7690,8162,3179,7166,6361,7532,7487,7177,7243,6002,1569)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%56%'ORDER BY CASE produit WHEN 5985 THEN (num*2)+1 WHEN 9424 THEN (num*2)+2 WHEN 6598 THEN (num*2)+3 WHEN 9448 THEN (num*2)+4 WHEN 3007 THEN (num*2)+5 WHEN 9277 THEN (num*2)+6 WHEN 9267 THEN (num*2)+7 WHEN 9328 THEN (num*2)+8 WHEN 9403 THEN (num*2)+9 WHEN 9412 THEN (num*2)+10 WHEN 9523 THEN (num*2)+11 WHEN 9504 THEN (num*2)+12 WHEN 9341 THEN (num*2)+13 WHEN 8859 THEN (num*2)+14 WHEN 9503 THEN (num*2)+15 WHEN 9316 THEN (num*2)+16 WHEN 9315 THEN (num*2)+17 WHEN 7217 THEN (num*2)+18 WHEN 9304 THEN (num*2)+19 WHEN 8857 THEN (num*2)+20 WHEN 8856 THEN (num*2)+21 WHEN 8854 THEN (num*2)+22 WHEN 8696 THEN (num*2)+23 WHEN 5009 THEN (num*2)+24 WHEN 7238 THEN (num*2)+25 WHEN 6146 THEN (num*2)+26 WHEN 8708 THEN (num*2)+27 WHEN 7298 THEN (num*2)+28 WHEN 5967 THEN (num*2)+29 WHEN 8774 THEN (num*2)+30 WHEN 5966 THEN (num*2)+31 WHEN 8585 THEN (num*2)+32 WHEN 7300 THEN (num*2)+33 WHEN 8598 THEN (num*2)+34 WHEN 6001 THEN (num*2)+35 WHEN 8013 THEN (num*2)+36 WHEN 7536 THEN (num*2)+37 WHEN 7241 THEN (num*2)+38 WHEN 6607 THEN (num*2)+39 WHEN 7485 THEN (num*2)+40 WHEN 7533 THEN (num*2)+41 WHEN 7981 THEN (num*2)+42 WHEN 6007 THEN (num*2)+43 WHEN 3094 THEN (num*2)+44 WHEN 6140 THEN (num*2)+45 WHEN 8653 THEN (num*2)+46 WHEN 7537 THEN (num*2)+47 WHEN 6417 THEN (num*2)+48 WHEN 7690 THEN (num*2)+49 WHEN 8162 THEN (num*2)+50 WHEN 3179 THEN (num*2)+51 WHEN 7166 THEN (num*2)+52 WHEN 6361 THEN (num*2)+53 WHEN 7532 THEN (num*2)+54 WHEN 7487 THEN (num*2)+55 WHEN 7177 THEN (num*2)+56 WHEN 7243 THEN (num*2)+57 WHEN 6002 THEN (num*2)+58 WHEN 1569 THEN (num*2)+59 END,numErr153a