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,7863,6504,1839,6474,1840,9336,8020,2356,6505,9222,9164,9064,9036,9096,9037,8810,9075,8815,8812,8920,8908,8813,9035,3261,8921,5136,8791,7521,7864,6850,6974,9305,5343,8523,9143,6945,8434,8929,9139,9224,7667,9171,3789,8448,7068,7184,8931,5473,5316,7841,5140,7004,9362,5315,8935,5321,8491,9322,7764,8392,4656,7712,8436,9390,9043,9327,7153,9093,8917,7735,8954,7005,8324,4663,8435,8971,9524,5137,5426,9218,9519,7862,9518,9484,7219,9478,5306,9450,9179,9423,9410,8916,8870,9409,9391,8807,8446,9363,7131,9360,7130,8809,8899,5436,7009,9206,8866,9204,8842,5470,8910,9202,8326,7668,6773,8926,7677,8914,8788,8599,5511,8894,5439,8766,8822,6565,7680,8697,6603,6508,7236,6506,8820,8875,8732,8221,8790,8765,6495,5093,5031,4597,5409,8366,8507,8166,7706,5768,6210,8794,8167,7734,6566,8126,8364,7295,8684,8789,7482,7995,7945,8782,7355,8638,8693,8596,7474,6564,8744,8597,8367,5437,8363,7750,6377,8627,3609,8691,6151,7473,8633,8632,7937,7538,7313,8587,8635,8634,8443,8407,7890,7210,8631,8630,7398,8094,7247,7548,7413,7393,8008,7394,8257,8871,7716,7357,8051,7616,6705,5785,5696,4158,8399,8014,7615,5834,7000,6364,8129,8075,8783,5278,7251,8055,8636,8095,8313,6996,5471,4287,7308,6838,8808,8694,6365,6499,5301,8823,6740,7957,7318,7290)  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 (prix*(100-promo)) DESC,produit,numErr153a