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,6945,8931,1839,9037,6850,1840,7153,7521,2356,8921,7004,9171,9222,7184,9224,9218,8920,8326,5136,5473,7712,9164,9139,9035,5315,7068,9093,7219,9075,9064,7009,9043,9179,8914,8899,8926,9036,7764,8908,8971,8954,7005,8367,8929,7131,5316,8364,8917,8916,7734,8910,5140,8363,8894,8935,7750,7841,8815,8324,8813,8812,7130,8810,8366,5137,5306,8791,9096,5470,5321,5439,5437,8407,8434,8523,8443,6210,8448,4656,3261,7863,8435,8436,5768,8392,4663,7890,5409,8491,7706,8446,7862,7864,7667,8221,5426,3789,8507,6974,7735,5436,5343,7668,6773,7680,7677,5471,6996,5301,4287,6740,8313,5278,5785,7716,4597,6705,8399,7000,7616,8257,5834,4158,6838,7615)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a