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,9024,6968,8319,7489,6962,9176,9152,9127,9090,9089,9022,9149,9122,9025,6961,8243,9178,8242,9153,8241,8316,8250,9124,8341,9028,8240,8314,6959,9126,8447,9123,8340,8321,9125,9026,8323,8400,8843,6960,8339,9076,7391,8815,8814,6882,8812,8342,9027,7885,7428,8248,8757,6966,9023,6874,8810,8741,6967,7886,8811,8524,7429,6283,7447,9075,8813,7400,7322,7390,7449,6880,7323,8736,7493,7410,7025,6881,7383,8738,8768,7490,6873,8529,7381,7452,8343,7534,5920,7567,7558,8528,7386,7325,7416,7423,8315,7486,8740,6864,7569,8756,8318,7379,7435,8457,7330,8459,7446,7930,8322,7484,8733,8754,6871,7443,7533,7538,7389,7488,6317,6868,7536,7539,7434,7494,7403,7537,7417,6876,7026,7487,6875,7426,6867,7491,7380,8399,7440,7425)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%61%' ORDER BY (prix*(100-promo)) DESC,produit,numErr153a