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