SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es 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 produit IN(0,8757,8738,8812,7558,8342,9076,9090,9458,9471,8815,9415,8814,8736,9153,8447,9459,9089,8768,8810,9075,9418,8741,9461,9460,9149,9414,8811,8754,8316,9490,8740,9124,9487,9486,9485,8813,9472,9152,7323,7493,9416,7449,9123,7484,9125,7416,9028,6961,8243,6968,6880,7330,7489,9126,8321,5920,8733,8756,6882,7322,6962,7486,8339,6959,8241,9027,7488,8314,9176,8323,9026,9127,9122,8319,6960,8315,8340,8242,7567,7381,9023,8400,6874,9024,8343,8341,9025,7536,8529,8240,6966,8248,8250,8459,9022,7391,8457,7930,7533,8318,7386,7569,7538,8322,8528,6881,7534,7487,7539,8399,7428,7383,6317,7537,6873,7325,7446,6876,6967,6864,6875,7447,7429,6871,6868,7379,7390,7435,7389,7400,7443,7490,7410,7423,7491,7026,7434,7025,7426,7440)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a