SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk txt,prix,promo,prixo, photo, 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,9201,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,9514,9452,7495,9513,9512,9456,8522,8222,9455,9454,9453,7444,6955,7424,9451,9286,9406,9283,6958,9345,8264,9343,9233,8706,9300,7782,9236,8656,3002,8710,9285,7443,8716,4432,5332,9282,7545,5325,7556,9235,6390,9234,8799,6291,7267,9232,5535,7541,8643,7554,9231,7268,9200,8397,9015,6296,8004,8476,7139,8581,8583,6318,8715,7368,7542,6491,8573,6492,7729,8578,8576,8642,7302,8962,7725,8711,7544,8112,7367,8579,8083,7361,8577,7442,7364,8582,8302,8303,8572,6553,5649,7282,8039,7362,7366,8584,8037,8031,7365,7142,7372,8040,6317,7204,8575,7363,5537,6407,8078,8175,6562,7515,8034,7555,8574,7220,7371,8038,6650,7233,8029,7961,7519,6804,7962,7870,7230,7499,7498,7963,8151,7730,7504,6592,6311,7260,8132,7261,7526,6101,6581,6332,8580,6301,7809,6441,7728,8105,7510,7211,7262,8035,6458,6313,8431,6595,6941,8712,8259,6800,6797,8159,8106,6983,6646,7423,8475,7727,7660,7979,7017,6582,7434,6314,6926,8571,6181,8033,7440,7724,6818,7419,6668,7373,8714,6642,5330,7263,7445,6816,6919,6082,6175,8713,6096,6942,7659,9088,6671,6627,6326,7264,7392,7726,6667,5827,6558)  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