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,4147,8384,7800,8351,8371,8345,8346,4143,8348,8347,4626,8260,9082,9107,9087,9086,9085,9084,8967,9083,7778,7733,4250,4149,8359,8362,8380,1281,8355,8311,8258,7917,7919,7927,7664,4257,6763,6858,7747,8416,7748,7763,7767,7801,8421,8383,8379,8378,5937,8372,8361,7920,8358,8385,7873,7830,8356,8353,8350,8349,8344,1288,8377)  AND produit NOT IN( ) AND ( id=10885 OR id=10533 OR id=15732 OR id=16647 OR id=17038 OR id=17001 OR id=17368 OR id=17000 OR id=16902 OR id=16887 OR id=16844 OR id=16839 OR id=16813 OR id=16809 OR id=16808 OR id=16645 OR id=15636 OR id=15617 OR id=15613 OR id=15606 OR id=15589 OR id=14882 OR id=14931 OR id=14858 OR id=14680 OR id=14210 OR id=14209 OR id=12038 OR id=11642 OR id=11650 OR id=11659 OR id=6518 )ORDER BY CASE produit WHEN 4147 THEN (num*0.2)+1 WHEN 8384 THEN (num*0.2)+2 WHEN 7800 THEN (num*0.2)+3 WHEN 8351 THEN (num*0.2)+4 WHEN 8371 THEN (num*0.2)+5 WHEN 8345 THEN (num*0.2)+6 WHEN 8346 THEN (num*0.2)+7 WHEN 4143 THEN (num*0.2)+8 WHEN 8348 THEN (num*0.2)+9 WHEN 8347 THEN (num*0.2)+10 WHEN 4626 THEN (num*0.2)+11 WHEN 8260 THEN (num*0.2)+12 WHEN 9082 THEN (num*0.2)+13 WHEN 9107 THEN (num*0.2)+14 WHEN 9087 THEN (num*0.2)+15 WHEN 9086 THEN (num*0.2)+16 WHEN 9085 THEN (num*0.2)+17 WHEN 9084 THEN (num*0.2)+18 WHEN 8967 THEN (num*0.2)+19 WHEN 9083 THEN (num*0.2)+20 WHEN 7778 THEN (num*0.2)+21 WHEN 7733 THEN (num*0.2)+22 WHEN 4250 THEN (num*0.2)+23 WHEN 4149 THEN (num*0.2)+24 WHEN 8359 THEN (num*0.2)+25 WHEN 8362 THEN (num*0.2)+26 WHEN 8380 THEN (num*0.2)+27 WHEN 1281 THEN (num*0.2)+28 WHEN 8355 THEN (num*0.2)+29 WHEN 8311 THEN (num*0.2)+30 WHEN 8258 THEN (num*0.2)+31 WHEN 7917 THEN (num*0.2)+32 WHEN 7919 THEN (num*0.2)+33 WHEN 7927 THEN (num*0.2)+34 WHEN 7664 THEN (num*0.2)+35 WHEN 4257 THEN (num*0.2)+36 WHEN 6763 THEN (num*0.2)+37 WHEN 6858 THEN (num*0.2)+38 WHEN 7747 THEN (num*0.2)+39 WHEN 8416 THEN (num*0.2)+40 WHEN 7748 THEN (num*0.2)+41 WHEN 7763 THEN (num*0.2)+42 WHEN 7767 THEN (num*0.2)+43 WHEN 7801 THEN (num*0.2)+44 WHEN 8421 THEN (num*0.2)+45 WHEN 8383 THEN (num*0.2)+46 WHEN 8379 THEN (num*0.2)+47 WHEN 8378 THEN (num*0.2)+48 WHEN 5937 THEN (num*0.2)+49 WHEN 8372 THEN (num*0.2)+50 WHEN 8361 THEN (num*0.2)+51 WHEN 7920 THEN (num*0.2)+52 WHEN 8358 THEN (num*0.2)+53 WHEN 8385 THEN (num*0.2)+54 WHEN 7873 THEN (num*0.2)+55 WHEN 7830 THEN (num*0.2)+56 WHEN 8356 THEN (num*0.2)+57 WHEN 8353 THEN (num*0.2)+58 WHEN 8350 THEN (num*0.2)+59 WHEN 8349 THEN (num*0.2)+60 WHEN 8344 THEN (num*0.2)+61 WHEN 1288 THEN (num*0.2)+62 WHEN 8377 THEN (num*0.2)+63 END,numErr153a