SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=2 AND photo2_2!="" THEN photo2_2 ELSE photo2 END photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND volume!=4  AND produit IN(0,7492,9175,9130,9181,9062,9191,9217,9106,9417,8971,9206,9205,9202,9189,9187,9166,9188,9184,9131,9200,9128,9185,9183,9180,9168,9165,9190,9186,9182,9169,8978,9061,9129,5768,9060,8975,8974,9167,7250,7251,7248,7245,7243,8976,7249,8973)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a