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=1 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,8342,8319,9490,9487,9486,9485,9472,9471,9461,9460,9459,9458,8447,9418,9416,9415,9414,7558,9024,8736,7322,8741,6968,9090,9028,9149,9076,9075,9153,9152,9089,8738,8757,9125,9123,9122,8321,8756,9176,8243,8815,8814,8813,9126,9124,8812,8811,7486,8810,8733,8768,9025,8241,9127,6961,7489,7536,8314,8323,6960,9027,8340,6880,6959,8457,8315,7930,5920,7484,8339,8459,6882,9022,8740,8240,8250,8322,7330,8754,6966,7391,7538,6874,8316,7493,7383,8400,6962,8318,7381,8529,8248,7488,8343,8341,8242,7539,7386,6868,7533,7487,6864,8528,6875,6876,7400,7429,7534,7379,6317,6873,7410,7452,6881,8399,6967,7490,7537,6871,7449,7423,7434,7425,7426,7494,7491)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)),produit,numErr153a