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,7382,6596,7918,3827,7556,1844,2104,9174,1840,9150,9147,5366,4650,6879,1839,7892,7888,6850,7917,4640,2356,7833,7920,7521,5354,4632,9151,9225,7835,7919,4652,7832,9148,7916,7006,7893,7184,5343,8434,5322,4653,6964,7897,7887,7005,4654,8448,7898,6208,5408,6232,6847,6846,5315,4554,7928,5440,8518,5133,3789,5316,6132,5326,8436,5433,8435,6504,5329,6601,6844,7841,5132,5109,7427,6503,5436,7420,7922,1814,1809,5111,6604,6610,5511,2107,8523,1811,5435,3191,6602,3196,6612,7384,5321,7896,6565,7930,6004,6505,6599,7921,7522,8735,5409,5434,6877,7495,5656,5987,6109,7523,2461,6506,6508,7895,6611,6843,7470,6108,1812,7444,6502,7543,7473,6963,7472,7387,7545,8019,8020,8737,6603,8018,5325,6597,6564,7328,5994,7923,8734,5745,6566,8017,8016,7451,7894,6609,1823,5336,7226,2101,6598,5966,7554,7210,7544,5422,7929,5967,7329,7542,5991,8171,7485,5969,6000,5989,5997,6633,7541,6841,7532,6647,7331,7424,6842,5332,3788,6878,8010,7378,8170,6848,6845,6866,8169,7392,5330,6341,6284)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%57%' ORDER BY (prix*(100-promo)) DESC,produit,numErr153a