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