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,4149,6257,8383,6259,7664,7916,7917,4626,6255,7767,4250,7856,9162,9072,9136,9082,9107,6252,8415,4146,4143,6938,7778,7800,7918,6253,4147,8256,6251,7747,8447,5190,8421,8416,8380,8379,8372,8371,8362,8361,6713,8254,7818,8359,6258,6256,8358,8356,8355,8353,8312,8311,8260,8255,7889,6894,6716,7830,7648,6680,8385,7803,7873,7748)  AND produit NOT IN( ) AND ( id=15667 OR id=12993 OR id=14859 OR id=14865 OR id=14666 OR id=16810 OR id=17218 OR id=17361 OR id=17222 OR id=17217 OR id=16642 OR id=15853 OR id=15847 OR id=15739 OR id=15743 OR id=15694 OR id=15673 OR id=15668 OR id=15641 OR id=15383 OR id=14713 OR id=14569 OR id=14513 OR id=14438 OR id=14404 OR id=14226 OR id=14270 OR id=13929 OR id=13939 OR id=12532 OR id=11638 OR id=11636 OR id=11634 OR id=11655 OR id=11646 OR id=11648 OR id=11657 OR id=11557 ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a