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=1 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,7863,1839,1840,2356,9222,9164,9064,9036,9096,9037,8810,9075,8815,8812,8920,8908,8813,9035,3261,8921,5136,8791,7521,7864,6850,6974,5343,8523,6945,8434,8929,9139,9224,7667,9171,3789,8448,7068,7184,8931,5473,5316,7841,5140,7004,5315,8935,5321,8491,7764,8392,4656,7712,8436,9043,7153,9093,8917,7735,8954,7005,8324,4663,8435,8971,5137,5426,9218,7862,7219,5306,9179,8916,8446,7131,7130,8899,5436,7009,5470,8910,8326,7668,6773,8926,7677,8914,8894,5439,7680,8221,4597,5409,8366,8507,7706,5768,6210,7734,8364,8367,5437,8363,7750,8443,8407,7890,8257,7716,7616,6705,5785,4158,8399,7615,5834,7000,5278,8313,6996,5471,4287,6838,5301,6740)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%61%' 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