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 volume!=4  AND produit IN(0,4147,8384,7800,8351,8371,8345,8346,4143,8348,8347,4626,8260,9082,9107,9087,9086,9085,9084,8967,9083,7778,7733,4250,4149,8359,8362,8380,1281,8355,8311,8258,7917,7919,7927,7664,4257,6763,6858,7747,8416,7748,7763,7767,7801,8421,8383,8379,8378,5937,8372,8361,7920,8358,8385,7873,7830,8356,8353,8350,8349,8344,1288,8377)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a