SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel 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,5950,7893,7299,9257,9395,9449,7991,6963,2104,9340,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,9228,9149,9027,9154,9241,8880,9502,6169,9497,9126,5329,9274,9330,7391,9293,6706,9265,8456,8338,9475,6883,7589,9002,6960,9332,9498,9245,7576,9491,9313,9255,9486,8893,9254,9481,7384,8250,9461,8878,8341,9460,9440,7818,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,6888,8526,8332,8752,8828,3254,6871,7493,8214,7987,8271,8829,8080,8123,7993,7989,8742,7992,8830,8771,7323,8614,7296,8276,8792,8213,8707,7385,8505,8796,7293,8237,8778,8145,8122,8770,8613,2611,8479,8119,8336,6691,8673,7325,8234,7276,3128,8337,8641,7291,7396,7314,7312,8425,6972,8236,7491,7986,7283,7494,6786,4268,6217,8049,7227,7617,7984,8795,4001,7272,6866,6284,5174,6489,5824,7596,3561,5811,7578,7335,8424,8220,7025,7723,8215,8496,8391,8216,6688,8487,8219,7584,7829,7579)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%58%' ORDER BY (prix*(100-promo)),produit,numErr153a