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=1 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,1840,1839,6850,2356,7521,7184,5343,8434,7005,8448,5315,3789,5316,8436,8435,6504,7841,5436,5511,8523,5321,6565,6505,5409,6506,6508,7473,8020,6603,6564,6566,7210)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%55%'ORDER BY CASE produit WHEN 1840 THEN (num*2)+1 WHEN 1839 THEN (num*2)+2 WHEN 6850 THEN (num*2)+3 WHEN 2356 THEN (num*2)+4 WHEN 7521 THEN (num*2)+5 WHEN 7184 THEN (num*2)+6 WHEN 5343 THEN (num*2)+7 WHEN 8434 THEN (num*2)+8 WHEN 7005 THEN (num*2)+9 WHEN 8448 THEN (num*2)+10 WHEN 5315 THEN (num*2)+11 WHEN 3789 THEN (num*2)+12 WHEN 5316 THEN (num*2)+13 WHEN 8436 THEN (num*2)+14 WHEN 8435 THEN (num*2)+15 WHEN 6504 THEN (num*2)+16 WHEN 7841 THEN (num*2)+17 WHEN 5436 THEN (num*2)+18 WHEN 5511 THEN (num*2)+19 WHEN 8523 THEN (num*2)+20 WHEN 5321 THEN (num*2)+21 WHEN 6565 THEN (num*2)+22 WHEN 6505 THEN (num*2)+23 WHEN 5409 THEN (num*2)+24 WHEN 6506 THEN (num*2)+25 WHEN 6508 THEN (num*2)+26 WHEN 7473 THEN (num*2)+27 WHEN 8020 THEN (num*2)+28 WHEN 6603 THEN (num*2)+29 WHEN 6564 THEN (num*2)+30 WHEN 6566 THEN (num*2)+31 WHEN 7210 THEN (num*2)+32 END,numErr153a