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 volume!=4  AND produit IN(0,4652,1844,3827,8586,4650,5138,8597,1809,9383,5656,9382,8924,7218,9303,5994,8919,8928,5366,7832,9522,9517,9509,9507,9508,9425,8918,9430,7833,8595,5109,9302,6610,7062,8593,6004,8883,6006,8365,6124,5111,7523,8568,6596,8562,5139,7110,7473,8370,3007,6459,5136,5407,5433,9388,7835,7940,8624,7482,7006,8327,8491,3789,7008,8685,5473,7944,9111,7374,7477,5745,7294,7949,7565,4834,7737,7470,7712,5427,6464,8375,7564,7938,7942,7858,8325,5465,5444,7153,5408,9308,5875,9109,6755,9307,7472,5439,5443,5438,5437,7705,5884,3129,7522,8690,7842,7478,8923,7476,7549,7395,7955,7013,4045,4043,4041,2839,4561,7475,8507,7818,7735,6846,6970,5426,8519,7094,5409,7157,7061,6787,6844,7551,7393,5354,7010,5435,8024,7413,7159,6847,7900,4036,7158,5434,5440,7394,7399,7408,7715,7162,6843,7407,8295,5468,7744,5303,7056,7154,5471,6848,6996,7063,5738,6841,6842,5107,8444,7939,6647,5873,4287,3788,4158,4759,7671,7630,7636,6845)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)),produit,numErr153a