SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk 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,9132,8845,9018,8256,7770,9141,9079,9081,4849,9080,9019,5375,4264,3989,8386,6732,5431,8464,4205,5817,9103,8898,6263,6737,5191,8508,8261,6204,8493,2991,8862,6727,7771,3432,8473,6240,8415,6200,8839,8834,8163,8383,4368,8416,8076,7767,6302,8258,7800,8758,8138,3680,8421,8759,6306,7778,5481,7763,8260,8381,8253,8784,7971,8255,8384,8137,7282,8254,8136,6383,6749,8135,6733,7276,7972,7974,6729,7970,8863,8494,8411,8141,7272,7277,8419,7973,7780,6813,8382,6741,8836,8385,7775,8413,8262,8835,8052,7777,7779,7273,7803,8763,7774,8785,8838,9102,9020,9142,5293,8833,7801,7768,7776,8509,7875,4745,8391,8844,6199,8786,8760,6816,7281,7270,7271,8142,7969,6301,7274,8837,5849)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%59%' ORDER BY (prix*(100-promo)) DESC,produit,numErr153a