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