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