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