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 volume!=4  AND produit IN(0,2991,9325,9324,9132,8845,7770,8834,8163,4368,9438,6302,8763,6306,8137,9440,9439,9437,9436,9435,9483,9482,9481,9434,9480,9433,9432,8844,9431,7971,9141,9018,3680,8076,5431,9081,3989,8464,9080,6737,4849,5375,6204,4264,3432,8136,7282,5481,8508,8261,9019,4205,9079,7800,5817,6240,8383,8258,8415,7763,9102,8839,8256,8253,5191,6732,8385,8416,7767,6200,8384,8255,8421,7778,7771,8254,8260,6263,6727,6383,7276,8138,8386,8493,7972,8135,8473,8898,5293,7270,6733,6749,8833,7801,9142,7768,7776,9020,8053,8509,7774,7281,8838,8391,6199,8786,8759,8758,8760,6816,4745,7875,7271,8142,8784,7273,9103,8862,8381,7274,8785,8835,7272,7775,7777,8837,8494,6301,8262,8836,8863,8419,7803,8411)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a