SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk 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,6504,1840,8176,6377,8791,9409,9410,9067,8812,9524,9519,9518,9484,9478,8790,9035,8815,8809,9450,9423,2356,1839,9164,9143,9171,9064,9222,8920,9305,8929,9139,9037,8810,9093,9036,9075,9043,8931,9362,9322,8869,8935,9363,8908,9391,8916,9390,8599,9360,9327,8807,6474,8917,8926,8971,8921,9224,9206,9202,8842,3777,6376,8813,9336,5542,8899,8964,3140,8866,8020,9179,5136,8434,7521,7864,8870,6375,6850,8820,8910,6506,5473,8954,8448,3789,8789,8366,5140,8166,7764,8875,8782,7863,9096,5315,6473,7009,3261,5316,5137,7841,7184,7004,7734,6505,8732,8523,5321,6603,6476,7712,8167,3609,5031,7219,8788,8691,8392,8894,5306,8783,8507,8326,8324,6564,7133,8697,8491,8765,7130,7531,7735,5511,4656,6495,8364,8822,6565,6497,8435,6210,5470,5426,8794,8635,5030,5768,7474,4155,8126,8744,7236,5541,5343,8596,8684,8436,8446,8363,6508,7131,8634,8627,8633,8632,8766,6496,4663,6151,8443,5437,8693,8630,5093,7677,6475,7295,6974,7937,7538,8631,5409,7667,7995,7862,7890,8221,7669,7680,7706,7355,7668,7247,7398,8008,7224,6773,7251,7248,5436,8808,7716,7245,4266,7610,5471,7318,6499,8075,7753,6249,6365,8129,6493,7959,8313,5301,8051,7249,6364,4287,6740,8694,7957,8399,8014,7615,5696,7825,8823,6286,6705,7353,4158,5278,7717,8871,7152,8257,8095,7357,7616,7308,4597,6996,7639,7000,8055)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) 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