SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk txt,prix,promo,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,9228,9245,6109,6961,9271,9254,6963,6962,2104,6968,7888,6879,4640,9313,9359,9340,5950,9293,9330,9332,8880,9008,3621,6108,3168,9502,9498,9490,9497,8827,9486,9475,9440,9460,9449,9395,8846,8673,9292,7296,7299,9274,8893,9265,9257,9255,8913,9246,8796,9149,8861,8145,7993,8080,9123,8453,5760,9160,9004,9126,7991,7987,9090,8123,8892,8119,9028,8830,9003,9031,9002,9241,7892,3855,9127,9106,8829,9054,8912,1823,8891,7992,9032,8878,8742,9176,7867,7893,7493,6960,9133,8911,8995,9027,2610,8250,8945,7391,8884,9154,7384,9105,2609,8978,5329,7589,6706,8771,8341,7325,8456,7989,7887,7599,8527,7293,8122,8478,8235,8480,8526,8338,8707,8752,8239,8499,7923,8850,8505,7586,8271,8614,8504,7576,8232,8885,7585,8237,8225,8336,7632,6200,8230,8437,7649,7894,7312,7633,7276,6967,7816,8613,8213,8479,8214,7815,7587,8276,8441,8438,7291,8337,8332,8268,5175,8425,6691,8234,7385,7596,7584,5174,8236,4001,5824,5811,7578,6688,8216,8424,6786,7025,8215,6489,8220,6217,8391,7494,4268,7723,7617,7227,8496,6972,7283,7491,3561,7272,8795,7829,7986,8049,8487,8161,7984,7335,7314,8219)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a