SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo,CASE WHEN isable!=0 THEN photo WHEN wi1!=2 AND photo1_2!="" THEN photo1_2 WHEN wi1!=4 AND photo1_4!="" THEN photo1_4 ELSE photo END 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,5985,9424,6598,9448,3007,9277,9267,8708,9504,7217,9503,9328,5009,5967,9523,7238,9341,6146,5966,8774,6001,9412,9403,7298,8854,8696,7300,7981,9304,6007,8857,7536,8585,6607,8859,8856,8598,7533,8013,9316,6140,9315,7241,3094,6361,7485,7532,7487,7166,8162,7177,7243,6002,1569,3179,7690,6417,7537,8653)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a