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 volume!=4  AND produit IN(0,3952,7661,7660,7672,7781,7658,7659,6955,7017,7220,7372,6553,6983,7362,7662,6318,6671,7224,7222,7212,5924,6326,6954,6312,4774,5384,7211,7231,7526,6082,7213,6175,5218,7129)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )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 7658 THEN (num*2)+6 WHEN 7659 THEN (num*2)+7 WHEN 6955 THEN (num*2)+8 WHEN 7017 THEN (num*2)+9 WHEN 7220 THEN (num*2)+10 WHEN 7372 THEN (num*2)+11 WHEN 6553 THEN (num*2)+12 WHEN 6983 THEN (num*2)+13 WHEN 7362 THEN (num*2)+14 WHEN 7662 THEN (num*2)+15 WHEN 6318 THEN (num*2)+16 WHEN 6671 THEN (num*2)+17 WHEN 7224 THEN (num*2)+18 WHEN 7222 THEN (num*2)+19 WHEN 7212 THEN (num*2)+20 WHEN 5924 THEN (num*2)+21 WHEN 6326 THEN (num*2)+22 WHEN 6954 THEN (num*2)+23 WHEN 6312 THEN (num*2)+24 WHEN 4774 THEN (num*2)+25 WHEN 5384 THEN (num*2)+26 WHEN 7211 THEN (num*2)+27 WHEN 7231 THEN (num*2)+28 WHEN 7526 THEN (num*2)+29 WHEN 6082 THEN (num*2)+30 WHEN 7213 THEN (num*2)+31 WHEN 6175 THEN (num*2)+32 WHEN 5218 THEN (num*2)+33 WHEN 7129 THEN (num*2)+34 END,numErr153a