SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prixgros,promogros,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prixgros!="0.00" AND affich=1 AND photo2!="" AND produit IN(0,2356,8523,2104,8518,1840,9151,9150,9148,1844,9174,9147,4650,7833,7835,6879,4654,1839,5366,7832,7382,4653,4632,4640,6850,6963,5408,6964,3789,6208,7521,7384,8434,4652,7471,7892,5354,7887,5322,6232,3777,5343,1823,7184,5336,8448,7923,5433,5316,7005,7893,7006,9225,4554,5440,8735,7888,7422,7894,7922,6877,7420,6132,6847,5133,5326,5321,6504,5329,8737,7916,7917,5109,5422,1809,6842,8734,6284,2101,1812,5132,3827,2461,6604,5111,7430,7441,6108,8435,6601,6109,5315,2107,5434,1814,6610,6844,7930,6602,7450,7919,6106,7328,3191,7226,7387,6508,5435,6503,1811,3196,5511,7898,7385,5436,7928,7436,5409,7921,6565,6843,7920,7448,7451,7329,6603,6505,8170,7929,8010,7411,5985,7543,6599,6612,6596,6004,8436,5987,8171,7545,6506,6611,7556,8016,7331,6566,7841,5656,6564,6502,6597,6598,7542,2462,7427,8020,8169,7437,7523,6609,7470,5332,1818,7541,7210,7554,5966,7438,8017,7432,7442,7522,7473,7495,7444,5991,7424,8018,5325,5745,8019,5989,5369,6000,7485,6878,5967,7472,5744,6001,7544,5994,5997,5969,7896,7388,7433,7445,6841,6848,7895,7378,3788,7918,5324,7419,6845,4891,7392,6567,5330,6866,6341,7414,6846,7532,6633,6647,7897)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%58%' ORDER BY (prixgros*(100-promogros)),produit,numErr153a