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,8845,8763,9079,9141,9132,9081,9080,2991,3432,8898,8473,8163,8839,6306,4368,8076,8844,8508,7875,7270,6733,7274,8863,7271,8785,8494,8835,7768,8836,8837,8862,8760,8784,9142,9020,8838,8509,8759,8833,8786,8758)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%55%' ORDER BY (prix*(100-promo)) DESC,produit,numErr153a