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