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,8845,8763,9079,9141,9132,9081,9080,2991,3432,8898,8473,8163,8839,6306,4368,8076,8844,8508,7875,7270,6733,7274,8863,7271,8785,8494,8835,7768,8836,8837,8862,8760,8784,9142,9020,8838,8509,8759,8833,8786,8758)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%59%'ORDER BY CASE produit WHEN 8845 THEN (num*2)+1 WHEN 8763 THEN (num*2)+2 WHEN 9079 THEN (num*2)+3 WHEN 9141 THEN (num*2)+4 WHEN 9132 THEN (num*2)+5 WHEN 9081 THEN (num*2)+6 WHEN 9080 THEN (num*2)+7 WHEN 2991 THEN (num*2)+8 WHEN 3432 THEN (num*2)+9 WHEN 8898 THEN (num*2)+10 WHEN 8473 THEN (num*2)+11 WHEN 8163 THEN (num*2)+12 WHEN 8839 THEN (num*2)+13 WHEN 6306 THEN (num*2)+14 WHEN 4368 THEN (num*2)+15 WHEN 8076 THEN (num*2)+16 WHEN 8844 THEN (num*2)+17 WHEN 8508 THEN (num*2)+18 WHEN 7875 THEN (num*2)+19 WHEN 7270 THEN (num*2)+20 WHEN 6733 THEN (num*2)+21 WHEN 7274 THEN (num*2)+22 WHEN 8863 THEN (num*2)+23 WHEN 7271 THEN (num*2)+24 WHEN 8785 THEN (num*2)+25 WHEN 8494 THEN (num*2)+26 WHEN 8835 THEN (num*2)+27 WHEN 7768 THEN (num*2)+28 WHEN 8836 THEN (num*2)+29 WHEN 8837 THEN (num*2)+30 WHEN 8862 THEN (num*2)+31 WHEN 8760 THEN (num*2)+32 WHEN 8784 THEN (num*2)+33 WHEN 9142 THEN (num*2)+34 WHEN 9020 THEN (num*2)+35 WHEN 8838 THEN (num*2)+36 WHEN 8509 THEN (num*2)+37 WHEN 8759 THEN (num*2)+38 WHEN 8833 THEN (num*2)+39 WHEN 8786 THEN (num*2)+40 WHEN 8758 THEN (num*2)+41 END,numErr153a