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=2 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,8449,7558,7543,9413,7731,7382,9284,8867,9374,9131,9062,9175,8960,9001,8959,7383,8447,3989,7897,4678,8342,4205,7226,9290,9287,5326,9092,8321,7922,9281,6859,7427,7898,7446,8660,7895,7416,7435,7441,7921,6204,7429,7436,9299,3918,7430,7447,7896,7438,9457,7781,6727,9134,7437,9445,9515,7783,9452,9513,9512,8522,8222,9453,7444,6955,7424,9451,9286,9406,9283,6958,9345,8264,9343,9233,8706,9300,7782,9236,8656,3002,9285,7443,4432,5332,9282,7545,5325,7556,9235,6390,9234,6291,7267,9232,5535,7541,8643,7554,9231,7268,9200,8397,9015,6296,8004,8476,7139,8581,8583,6318,7368,7542,8573,6492,7729,8578,8576,8642,7302,8962,7725,8711,7544,7367,8579,8083,7361,8577,7442,7364,8302,8303,8572,6553,5649,7282,8039,7362,7366,8584,8037,7365,7142,7372,8040,6317,7204,8575,7363,6407,8078,8175,6562,7515,8034,7555,8574,7220,7371,8038,6650,7233,8029,7519,6804,7870,7498,7730,7504,6101,8580,6595,6800,8159,6983,7423,7727,7979,7017,7434,6314,8571,6181,8033,7440,7724,7419,6668,7373,5330,7445,6919,6096,7659,9088,7392,7726,6667)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%58%' 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