SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es 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,9054,8449,7382,1823,8867,9175,7865,9287,9195,9194,9190,7416,9104,7922,6204,8522,8654,7489,6880,9241,7888,9100,7921,6964,8340,8660,4432,9166,9106,9133,7867,9038,9078,6966,8909,589,4264,8248,9154,7866,4622,8664,8414,3027,9185,9183,8974,8891,9057,7590,6881,6487,8989,8526,6490,9097,8225,2602,6263,9077,8739,8418,8455,3861,4000,6472,3028,5325,6982,7302,5175,6868,8425,6871,9099,9088,7643,2003,2825,2606,2611,6160,6273,6489,7491,6238,6885,7903,6199,1289,8196,4268,6786)  AND produit NOT IN( ) AND ( id=1521517341 OR id=17228 OR id=16153 OR id=17156 OR id=17205 OR id=17340 OR id=16315 OR id=17322 OR id=16625 OR id=17157 OR id=17327 OR id=17505 OR id=16912 OR id=17475 OR id=16972 OR id=17382 OR id=17417 OR id=17080 OR id=16925 OR id=16924 OR id=16853 OR id=16883 OR id=16699 OR id=16687 OR id=16684 OR id=16093 OR id=16170 OR id=16986 OR id=16730 OR id=16602 OR id=15000 OR id=16359 OR id=17337 OR id=15109 OR id=15101 OR id=14373 OR id=16660 OR id=16123 OR id=16045 OR id=13593 OR id=15255 OR id=16033 OR id=16009 OR id=15818 OR id=15878 OR id=12121 OR id=17183 OR id=16342 OR id=15572 OR id=15949 OR id=15456 OR id=15710 OR id=16268 OR id=13790 OR id=12898 OR id=15365 OR id=15355 OR id=15356 OR id=16053 OR id=15359 OR id=13909 OR id=16284 OR id=14872 OR id=15366 OR id=14644 OR id=15453 OR id=13653 OR id=5089 OR id=15389 OR id=13797 OR id=11707 OR id=14993 OR id=15360 OR id=15437 OR id=15454 OR id=16433 OR id=16966 OR id=16435 OR id=15315 OR id=11693 OR id=16345 ) ORDER BY (prix*(100-promo)),produit,numErr153a