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,7382,8342,7897,8960,7898,8447,6859,9092,9134,9175,8959,9062,8962,7922,8321,8449,7921,7495,9001,7896,7895,8660,9131,7729,7226,8522,8397,7424,8004,6955,5326,7383,4432,6204,8302,7444,7427,4205,3918,8264,5332,6727,6650,6958,7429,7782,5325,7781,7783,8222,6668,7870,8431,6671,7423,6818,7434,6941,6942,9088,6667,7659,6926,7660,7730,5330,5827,7392,6983)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a