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=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,6504,6474,9336,8020,6505,8809,9322,9362,9305,9524,9519,9202,9518,9484,9478,9450,9410,9423,9409,8807,6377,8599,8166,9143,8842,9363,8167,6506,8870,6603,9391,9390,9360,9327,6495,6565,9206,9204,5511,3609,8094,8875,5031,8697,8732,7236,6564,7474,8126,7945,8788,8820,8866,8627,8789,8794,8782,8638,7473,8822,7482,8691,8597,8766,8744,8634,8684,8596,7937,6151,6508,7295,7995,8765,8635,6566,8632,8633,5093,8631,7355,7538,8630,8783,8693,7210,7247,8008,7393,7251,7413,7548,7398,7394,8055,8636,8095,7308,8808,8587,7313,8694,6365,6499,8823,8790,7957,7318,8075,8871,7357,8051,5696,8014,6364,8129,7290)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND ( promo!='0' OR prixo!='0') ORDER BY (prix*(100-promo)),produit,numErr153a