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,7947,6504,3191,6503,9389,9423,9384,6602,7562,1814,7946,7943,5094,6601,8853,8588,8744,5108,7377,9524,9519,9518,9484,7216,9478,3196,7306,9327,8599,5133,8876,8855,8789,8612,5132,8782,6603,6506,6604,8125,8721,6505,9398,6142,9390,9016,8820,6502,8725,8879,5511,4423,7936,5092,6565,6564,6461,8765,4422,7303,7951,7935,8589,8766,8719,7295,8866,7941,8590,7309,8604,8569,6403,7236,8047,8126,7549,7950,8570,8783,5093,8718,8046,7550,8693,6508,8094,8640,7937,8596,6566,3023,3008,7551,7210,7355,7247,7352,5645,7548,7290,7308,7319,8095,8823,8694,7378,8051,7318,7357,8808,8055,8075,4491,8014,7353,7546,7253,7552,7166,7520,8587,7313,7957)  AND produit NOT IN( ) AND ( id=14596 OR id=13119 OR id=13122 OR id=17387 OR id=16484 OR id=17385 OR id=17660 OR id=17545 OR id=14477 OR id=17336 OR id=16363 OR id=13162 OR id=16619 OR id=16260 OR id=16891 OR id=15021 OR id=16448 OR id=11376 OR id=13373 OR id=11295 OR id=17278 OR id=17272 OR id=14075 OR id=13865 OR id=17271 OR id=15932 OR id=16888 OR id=15103 OR id=15709 OR id=14653 OR id=15692 OR id=13148 OR id=14067 OR id=15435 OR id=14175 OR id=14638 OR id=15440 OR id=12438 OR id=14626 OR id=14720 OR id=13710 OR id=14740 OR id=14104 OR id=13568 OR id=16427 OR id=17021 OR id=12823 OR id=11027 ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a