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 volume!=4  AND produit IN(0,4147,8346,4143,7919,7747,6259,8358,7917,7801,8258,8311,9404,9365,9161,9086,9107,9084,9082,9085,9087,9083,4146,7767,8421,7856,8355,8384,8383,8380,8372,7732,8371,8362,8361,8359,8349,8345,8253,8260,8256,4250,7733,7763,7778,6938,6713,3463,6454,7673,8385,7830,7748)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( )ORDER BY CASE produit WHEN 4147 THEN (num*2)+1 WHEN 8346 THEN (num*2)+2 WHEN 4143 THEN (num*2)+3 WHEN 7919 THEN (num*2)+4 WHEN 7747 THEN (num*2)+5 WHEN 6259 THEN (num*2)+6 WHEN 8358 THEN (num*2)+7 WHEN 7917 THEN (num*2)+8 WHEN 7801 THEN (num*2)+9 WHEN 8258 THEN (num*2)+10 WHEN 8311 THEN (num*2)+11 WHEN 9404 THEN (num*2)+12 WHEN 9365 THEN (num*2)+13 WHEN 9161 THEN (num*2)+14 WHEN 9086 THEN (num*2)+15 WHEN 9107 THEN (num*2)+16 WHEN 9084 THEN (num*2)+17 WHEN 9082 THEN (num*2)+18 WHEN 9085 THEN (num*2)+19 WHEN 9087 THEN (num*2)+20 WHEN 9083 THEN (num*2)+21 WHEN 4146 THEN (num*2)+22 WHEN 7767 THEN (num*2)+23 WHEN 8421 THEN (num*2)+24 WHEN 7856 THEN (num*2)+25 WHEN 8355 THEN (num*2)+26 WHEN 8384 THEN (num*2)+27 WHEN 8383 THEN (num*2)+28 WHEN 8380 THEN (num*2)+29 WHEN 8372 THEN (num*2)+30 WHEN 7732 THEN (num*2)+31 WHEN 8371 THEN (num*2)+32 WHEN 8362 THEN (num*2)+33 WHEN 8361 THEN (num*2)+34 WHEN 8359 THEN (num*2)+35 WHEN 8349 THEN (num*2)+36 WHEN 8345 THEN (num*2)+37 WHEN 8253 THEN (num*2)+38 WHEN 8260 THEN (num*2)+39 WHEN 8256 THEN (num*2)+40 WHEN 4250 THEN (num*2)+41 WHEN 7733 THEN (num*2)+42 WHEN 7763 THEN (num*2)+43 WHEN 7778 THEN (num*2)+44 WHEN 6938 THEN (num*2)+45 WHEN 6713 THEN (num*2)+46 WHEN 3463 THEN (num*2)+47 WHEN 6454 THEN (num*2)+48 WHEN 7673 THEN (num*2)+49 WHEN 8385 THEN (num*2)+50 WHEN 7830 THEN (num*2)+51 WHEN 7748 THEN (num*2)+52 END,numErr153a