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,8976,7250,9063,5768,9168,9190,9189,9188,9187,9186,9185,9218,9417,9217,9206,9205,9204,9202,7245,9201,9200,9199,9198,9197,9196,9195,9194,9193,9192,9191,9184,9183,9182,9181,9180,9175,7251,9169,9167,9166,9165,9145,9144,9131,9130,9129,9128,9109,9108,9106,8975,9105,9061,9062,7492,9060,8974,8978,8973,8971,8966,8965,5785,7248,7249,5834,7243)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)),produit,numErr153a