SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=2 AND photo2_2!="" THEN photo2_2 ELSE photo2 END photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,7647,7868,7462,7459,3479,6899,7873,6655,9365,9084,9366,8483,9369,6723,6259,9278,8362,5190,7492,9289,9525,6443,4149,7469,9230,6680,7919,6932,7664,9270,8385,7800,7673,7743,6944,9268,6716,9276,7918,9275,7830,4143,9404,7917,7592,4626,9107,8372,8371,7856,6255,6253,8358,4147,8383,8384,9086,8258,7763,8256,4250,8378,8380,8311,8447,8254,7916,7920,8416,8255,6256,8415,7927,8377,8355,8345,8361,7767,7741,3463,9083,8253,7771,8421,7212,6947,8260,1288,7778,8344,8379,8356,8351,8349,9082,8346,9161,8348,8967,6938,6858,1281,8347,8359,6713,7732,7456,6449,7826,4257,6454,7742,8396,8450,8353,7023,7733,7621,7594,7661,7926,7457,7597,8442,6709,6894,4146,7889,6922,9136,8312,7803,7925,7622,6258,7662,7801,7748,7747,8350,5937)  AND produit NOT IN( ) AND ( id=10898 OR id=15855 OR id=16840 OR id=16647 OR id=15656 OR id=15609 OR id=15604 OR id=15599 OR id=15594 OR id=15586 OR id=14174 OR id=11663 OR id=7831 ) AND ( promo!='0' OR prixo!='0') ORDER BY ( (CASE WHEN site IN (1,3,4) THEN 10 ELSE 0 END) +1000-num+promo + (CASE WHEN prixo=0 THEN 0 ELSE ((prixo-prix)/prixo*50 ) END ) ) DESC,produit DESC,numErr153a