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,5950,7893,7299,9257,9395,9449,7991,6963,2104,9340,9028,8945,9054,9004,9176,2609,6879,8319,7888,4640,7892,6961,6968,8913,8453,1823,5760,3855,2610,8995,9008,7887,9032,6962,7867,7816,7894,7923,9127,9003,9228,9149,9027,9154,9241,8880,6169,9126,5329,9274,9330,7391,9293,6706,9265,8456,8338,9475,7589,9002,6960,9332,9245,7576,9313,9255,9486,8893,9254,9481,7384,8250,9461,8878,8341,9460,9440,9359,6864,8891,8225,6472,9292,8850,8504,9031,6967,9271,8884,3621,9246,8499,8438,6109,7586,8230,3168,8861,6108,8827,7585,8846,8527,7649,8239,8510,8441,6200,7599,8235,8480,8268,8232,7633,8478,5175,7587,7815,8526,8332,8752,3254,6871,7493,8214,7987,8271,8829,8080,8123,7993,7989,7992,8830,8771,7323,8614,7296,8276,8213,8707,7385,8796,8237,8145,8122,8770,8613,8479,8119,8336,6691,8673,7325,8234,7276,8337,8641,7291,7314,7312,8425,7491,7986,6786,6866,6284,5824,3561,8424,7025,8215,8391,8216,6688,8487,7829)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%55%' 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