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 volume!=4  AND produit IN(0,9322,8327,7947,9301,8883,7712,8366,8599,9302,9389,9403,5108,5094,7110,9222,9303,7951,9398,9304,7943,9390,7482,6461,9388,7940,9463,9527,9522,9517,9430,9413,8935,9384,9120,8931,7217,9383,8928,7734,9382,9017,7477,8924,9224,9014,9172,8791,9016,7297,8919,5135,9171,6171,5138,7298,6464,9015,7938,8900,8882,5091,8920,5134,8918,8933,6945,8926,8793,7854,5407,5136,5137,7068,8597,7874,8595,8922,8398,7710,7736,7711,4923,8598,6124,8593,7737,8921,5139,8612,8606,8569,8586,5444,8899,5443,8894,7705,8568,7130,8326,5438,7562,7008,7709,7059,7944,5140,7294,7949,7935,7009,8589,7565,6151,8365,7300,7048,7218,7945,8375,7564,7942,9316,6606,6607,9315,8325,9314,5465,9308,6155,9307,7851,8588,6140,8596,8685,6755,5439,5437,8408,8604,8590,6143,6145,7306,8923,7478,7476,5092,7309,7303,7946,7295,8324,7219,8364,7004,7131,7750,7842,8363,7153,7937,5093,7522,7955,7475,8370,7062,8392,5427,8570,8491,7936,7950,7735,8367,5426,7061,7941,7706,7010,7022,5468,6040,7290,5301,5303,6139,7056,7313,7957,8587,7154,7067,7049,5471,7744,7063,7939,5738,7311,5107,6613)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)),produit,numErr153a