SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel 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,3952,7661,7660,7672,7781,6955,7658,7017,7224,6318,7220,6553,7362,7212,7222,6312,7372,6671,6939,5218,6175,7213,6082,7526,7197,7231,7211,5384,6953,5790,7662,7760,5220,7015,6404,4774,7659,6954,6326,5924,6983,7129)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%59%'ORDER BY CASE produit WHEN 3952 THEN (num*2)+1 WHEN 7661 THEN (num*2)+2 WHEN 7660 THEN (num*2)+3 WHEN 7672 THEN (num*2)+4 WHEN 7781 THEN (num*2)+5 WHEN 6955 THEN (num*2)+6 WHEN 7658 THEN (num*2)+7 WHEN 7017 THEN (num*2)+8 WHEN 7224 THEN (num*2)+9 WHEN 6318 THEN (num*2)+10 WHEN 7220 THEN (num*2)+11 WHEN 6553 THEN (num*2)+12 WHEN 7362 THEN (num*2)+13 WHEN 7212 THEN (num*2)+14 WHEN 7222 THEN (num*2)+15 WHEN 6312 THEN (num*2)+16 WHEN 7372 THEN (num*2)+17 WHEN 6671 THEN (num*2)+18 WHEN 6939 THEN (num*2)+19 WHEN 5218 THEN (num*2)+20 WHEN 6175 THEN (num*2)+21 WHEN 7213 THEN (num*2)+22 WHEN 6082 THEN (num*2)+23 WHEN 7526 THEN (num*2)+24 WHEN 7197 THEN (num*2)+25 WHEN 7231 THEN (num*2)+26 WHEN 7211 THEN (num*2)+27 WHEN 5384 THEN (num*2)+28 WHEN 6953 THEN (num*2)+29 WHEN 5790 THEN (num*2)+30 WHEN 7662 THEN (num*2)+31 WHEN 7760 THEN (num*2)+32 WHEN 5220 THEN (num*2)+33 WHEN 7015 THEN (num*2)+34 WHEN 6404 THEN (num*2)+35 WHEN 4774 THEN (num*2)+36 WHEN 7659 THEN (num*2)+37 WHEN 6954 THEN (num*2)+38 WHEN 6326 THEN (num*2)+39 WHEN 5924 THEN (num*2)+40 WHEN 6983 THEN (num*2)+41 WHEN 7129 THEN (num*2)+42 END,numErr153a