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,8708,9504,7217,9503,9328,5009,5967,9523,7238,9341,6146,5966,8774,6001,9412,9403,7298,8854,8696,7300,7981,9304,6007,8857,7536,8585,6607,8859,8856,8598,7533,8013,9316,6140,9315,7241,3094,6361,7485,7532,7487,7166,8162,7177,7243,6002,1569,3179,7690,6417,7537,8653)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )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 8708 THEN (num*2)+8 WHEN 9504 THEN (num*2)+9 WHEN 7217 THEN (num*2)+10 WHEN 9503 THEN (num*2)+11 WHEN 9328 THEN (num*2)+12 WHEN 5009 THEN (num*2)+13 WHEN 5967 THEN (num*2)+14 WHEN 9523 THEN (num*2)+15 WHEN 7238 THEN (num*2)+16 WHEN 9341 THEN (num*2)+17 WHEN 6146 THEN (num*2)+18 WHEN 5966 THEN (num*2)+19 WHEN 8774 THEN (num*2)+20 WHEN 6001 THEN (num*2)+21 WHEN 9412 THEN (num*2)+22 WHEN 9403 THEN (num*2)+23 WHEN 7298 THEN (num*2)+24 WHEN 8854 THEN (num*2)+25 WHEN 8696 THEN (num*2)+26 WHEN 7300 THEN (num*2)+27 WHEN 7981 THEN (num*2)+28 WHEN 9304 THEN (num*2)+29 WHEN 6007 THEN (num*2)+30 WHEN 8857 THEN (num*2)+31 WHEN 7536 THEN (num*2)+32 WHEN 8585 THEN (num*2)+33 WHEN 6607 THEN (num*2)+34 WHEN 8859 THEN (num*2)+35 WHEN 8856 THEN (num*2)+36 WHEN 8598 THEN (num*2)+37 WHEN 7533 THEN (num*2)+38 WHEN 8013 THEN (num*2)+39 WHEN 9316 THEN (num*2)+40 WHEN 6140 THEN (num*2)+41 WHEN 9315 THEN (num*2)+42 WHEN 7241 THEN (num*2)+43 WHEN 3094 THEN (num*2)+44 WHEN 6361 THEN (num*2)+45 WHEN 7485 THEN (num*2)+46 WHEN 7532 THEN (num*2)+47 WHEN 7487 THEN (num*2)+48 WHEN 7166 THEN (num*2)+49 WHEN 8162 THEN (num*2)+50 WHEN 7177 THEN (num*2)+51 WHEN 7243 THEN (num*2)+52 WHEN 6002 THEN (num*2)+53 WHEN 1569 THEN (num*2)+54 WHEN 3179 THEN (num*2)+55 WHEN 7690 THEN (num*2)+56 WHEN 6417 THEN (num*2)+57 WHEN 7537 THEN (num*2)+58 WHEN 8653 THEN (num*2)+59 END,numErr153a