SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es 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,7008,9383,7061,8906,9017,9388,9169,9307,9361,9528,9527,9522,8907,9517,9509,9308,9507,9430,8685,7522,8562,7472,9382,9364,8568,9168,7940,5656,9014,5111,9302,8687,7944,6459,7523,8595,7374,7565,7217,8688,7294,7955,8686,6127,7218,5744,6464,7564,5967,8586,5745,7475,8639,8593,8640,7942,7938,8628,7949,7476,8598,7395,8606,7399,8629,5738,7311,7939,5107)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%56%' ORDER BY (prix*(100-promo)) DESC,produit,numErr153a