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 produit IN(0,9358,8462,9012,6255,6257,9119,9229,9073,8965,9070,9110,8840,8966,8469,8468,9009,8566,8467,8466,8461,9146,8460,8465,8559,8564,8567,8664,8463,9072,9071,6261,9408,7011,6256,6259,8651,6982,8659,8406,6887,7899,7172,4898,8196,2464,2463,3881,7022,6040,6885,5584,4922,4920,6886)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%60%' ORDER BY (id-(20*num)) DESCErr153a