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,7006,6004,3827,9303,7470,6132,5109,6610,6124,7110,5111,9528,9527,9522,9517,9509,5656,9507,9430,7523,8586,7940,8906,9302,7374,8688,8907,7944,8562,8568,6459,6127,7565,8595,9388,9383,9382,7008,9017,8685,9364,7294,9014,9361,7217,5745,7949,7564,7522,7942,8628,5744,6464,7955,8687,7218,5967,7938,9169,7395,8598,7475,8593,8686,8640,8606,9168,9308,9307,7476,8639,7472,7061,7399,8629,5738,7311,7939,5107)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)),produit,numErr153a