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,4149,6257,8383,6259,7664,7916,7917,4626,6255,7767,4250,7856,9162,9072,9136,9082,9107,6252,8415,4146,4143,6938,7778,7800,7918,6253,4147,8256,6251,7747,8447,5190,8421,8416,8380,8379,8372,8371,8362,8361,6713,8254,7818,8359,6258,6256,8358,8356,8355,8353,8312,8311,8260,8255,7889,6894,6716,7830,7648,6680,8385,7803,7873,7748)  AND produit NOT IN( ) AND ( id=11664 OR id=14677 OR id=16842 OR id=16836 OR id=16651 OR id=16648 OR id=15764 OR id=15716 OR id=15653 OR id=15696 OR id=15639 OR id=14931 OR id=14647 OR id=14397 OR id=11654 OR id=11645 OR id=11651 OR id=3939 )ORDER BY CASE produit WHEN 4149 THEN (num*0.2)+1 WHEN 6257 THEN (num*0.2)+2 WHEN 8383 THEN (num*0.2)+3 WHEN 6259 THEN (num*0.2)+4 WHEN 7664 THEN (num*0.2)+5 WHEN 7916 THEN (num*0.2)+6 WHEN 7917 THEN (num*0.2)+7 WHEN 4626 THEN (num*0.2)+8 WHEN 6255 THEN (num*0.2)+9 WHEN 7767 THEN (num*0.2)+10 WHEN 4250 THEN (num*0.2)+11 WHEN 7856 THEN (num*0.2)+12 WHEN 9162 THEN (num*0.2)+13 WHEN 9072 THEN (num*0.2)+14 WHEN 9136 THEN (num*0.2)+15 WHEN 9082 THEN (num*0.2)+16 WHEN 9107 THEN (num*0.2)+17 WHEN 6252 THEN (num*0.2)+18 WHEN 8415 THEN (num*0.2)+19 WHEN 4146 THEN (num*0.2)+20 WHEN 4143 THEN (num*0.2)+21 WHEN 6938 THEN (num*0.2)+22 WHEN 7778 THEN (num*0.2)+23 WHEN 7800 THEN (num*0.2)+24 WHEN 7918 THEN (num*0.2)+25 WHEN 6253 THEN (num*0.2)+26 WHEN 4147 THEN (num*0.2)+27 WHEN 8256 THEN (num*0.2)+28 WHEN 6251 THEN (num*0.2)+29 WHEN 7747 THEN (num*0.2)+30 WHEN 8447 THEN (num*0.2)+31 WHEN 5190 THEN (num*0.2)+32 WHEN 8421 THEN (num*0.2)+33 WHEN 8416 THEN (num*0.2)+34 WHEN 8380 THEN (num*0.2)+35 WHEN 8379 THEN (num*0.2)+36 WHEN 8372 THEN (num*0.2)+37 WHEN 8371 THEN (num*0.2)+38 WHEN 8362 THEN (num*0.2)+39 WHEN 8361 THEN (num*0.2)+40 WHEN 6713 THEN (num*0.2)+41 WHEN 8254 THEN (num*0.2)+42 WHEN 7818 THEN (num*0.2)+43 WHEN 8359 THEN (num*0.2)+44 WHEN 6258 THEN (num*0.2)+45 WHEN 6256 THEN (num*0.2)+46 WHEN 8358 THEN (num*0.2)+47 WHEN 8356 THEN (num*0.2)+48 WHEN 8355 THEN (num*0.2)+49 WHEN 8353 THEN (num*0.2)+50 WHEN 8312 THEN (num*0.2)+51 WHEN 8311 THEN (num*0.2)+52 WHEN 8260 THEN (num*0.2)+53 WHEN 8255 THEN (num*0.2)+54 WHEN 7889 THEN (num*0.2)+55 WHEN 6894 THEN (num*0.2)+56 WHEN 6716 THEN (num*0.2)+57 WHEN 7830 THEN (num*0.2)+58 WHEN 7648 THEN (num*0.2)+59 WHEN 6680 THEN (num*0.2)+60 WHEN 8385 THEN (num*0.2)+61 WHEN 7803 THEN (num*0.2)+62 WHEN 7873 THEN (num*0.2)+63 WHEN 7748 THEN (num*0.2)+64 END,numErr153a