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,7893,6963,2104,9028,8945,9144,9054,9004,9176,9145,2609,6879,8319,7888,9105,4640,7892,6961,6968,8913,8453,1823,5760,3855,2610,8995,9008,7887,9032,6962,7867,7816,7894,7923,9127,9003,9149,9027,9154,9241,8880,6169,9126,5329,7391,6706,8456,8338,6883,7589,9002,6960,7576,8893,7384,8250,8341,7818,6864,8891,8225,6472,8504,9031,6967,8884,8499,8438,7586,8230,7585,8527,7649,8239,8510,8441,6200,7599,8235,8480,8268,8232,7633,8478,5175,7587,7815,6888,8526,8332,3254,6871,8214,8271,8276,8213,8505,8237,8479,8336,6691,8234,3128,8337,8425,6972,8236,7491,4268,6217,6866,6284,5174,5824,7596,8424,8220,8215,8496,8391,8216,6688,8487,8219,7584,7829)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%58%' 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