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