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,7621,7594,9114,7592,7597,9136,7622,8442,7647,7648,9117,8483,9010,9115,9160,9138,9007,9135,9044,9137,9013,9003,9179,9094,9043,9092,9034,9091,9041,9011,8998,9093,9004,8915,9033,9134,8893,9008,9042,9001,9031,9159,9116,9032,8913,8914,8997,9002,9000,8999,8892,8248,8890,8888,8912,8995,8231,8994,7589,8911,8887,8884,8407,8886,8443,8880,8480,7599,8405,8519,8505,8909,8891,8499,8280,8527,8502,8446,8500,8501,7590,8478,7609,7606,8274,7605,8226,8235,8521,8517,8520,7603,8525,8526,8522,8335,7593,8275,8889,8445,8329,8336,7637,8506,8271,7628,8221,8278,8338,8232,8504,7632,8230,7585,8406,7307,7588,8225,8237,7650,7615,7586,8277,7631,7598,7634,8229,8281,7649,8233,8222,7635,7633,8498,8313,8217,8214,8213,7630,8881,8481,7616,7610,7619,7651,8227,8252,8228,8331,8479,8403,8885,8404,8739,8441,8330,8272,8503,8497,7636,8223,8279,8251,8276,7587,8337,8332,8268,7620,7595,7612,8444,8234,8440,7596,8334,8477,7591,8282,8216,8267,8215,8401,8220,8218,8219,7624,7617,7583,7584,8236,8273,7607)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)),produit,numErr153a