SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo, photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND volume!=4  AND produit IN(0,6968,2104,7897,8447,7382,6694,6879,9114,7892,6880,8314,4632,7489,8960,9229,7898,8449,9145,8342,9241,9151,9089,9090,9147,9175,9502,9501,9500,9497,9418,9496,9416,9150,9408,9153,9104,9152,9119,8321,8319,7922,9124,9149,9123,9146,8241,9062,9160,8316,9138,9007,6964,9125,9131,3855,9137,4640,9003,1294,6963,6961,8453,8462,9012,9148,9141,9132,9122,9126,9092,9165,9078,9128,9100,9176,9106,9098,9144,9051,9048,9133,9041,9127,8992,9054,9069,9052,8469,9004,9028,9129,9033,9134,9023,9060,8893,9008,9038,9001,9025,9009,1823,9039,9157,8460,9031,9166,9018,8468,9154,9159,9026,9027,9081,9080,8467,9024,8972,9032,8340,9061,9047,5760,8461,8990,7867,8982,6959,8913,6962,9053,8986,8339,8984,6854,8323,9110,8315,4849,6208,6232,9056,9167,7387,8949,8981,7893,8465,7888,3004,8466,8997,6960,8242,8968,5149,5375,8250,2610,8993,4667,7381,8975,6261,9002,9105,8987,9000,8318,7770,7865,8243,8999,9050,8991,5831,8939,8559,9057,8892,7391,6966,8463,8248,9059,6853,8888,8240,589,7416,4432,8966,8940,8495,8947,9049,8452,8529,6169,7226,8427,3846,2609,9022,8566,8950,8246,8983,6737,5431,8341,7384,9055,8942,2101,9079,8936,7422,8912,8995,8231,5422,8970,5329,8994,7589,8911,8454,8945,5326,8887,8343,3432,4264,7866,8959,8884,8937,8969,8456,7857,4678,7420,8564,8886,8322,8962,7895,6204,6859,8880,8480,7887,8978,8429,8567,7599,8508,7411,9019,6706,7386,9097,5336,8352,7471,8505,8414,8989,8909,8974,8891,8499,7432,8261,7921,8527,4622,8664,8528,8432,8428,8500,6487,7590,8478,3027,3128,7606,8274,8226,6240,8235,5817,8660,8943,9156,8464,8985,8520,9102,8525,6284,8302,7428,8526,8522,8335,7896,8397,8275,7424,8889,8476,7437,8955,8004,9101,8976,6955,7923,8486,6490,6881,8336,9077,8484,8271,3989,7818,8430,8338,7813,8232,7729,7814,9103,8504,7632,8230,7585,8433,8239,8406,8437,8247,7588,6888,8225,8237,7442,7650,8973,7592,5191,7586,8470,7598,9058,7436,7576,7495,8229,6732,7383,6200,7649,8233,8222,7444,7446,7633,8498,7430,8217,8214,8213,5816,4000,3918,6263,3861,4205,5182,2602,6864,7438,8481,8510,8455,7811,8420,6472,8418,7619,8264,7894,6967,8227,6883,8386,7011,8228,5332,8479,6727,7447,8885,8739,8493,6958,7658,6887,8473,8938,7816,6982,8441,7782,3028,7573,5325,8272,8497,8438,8223,7815,7783,8276,7587,7441,8337,8332,8298,7781,8417,7644,6868,8268,7620,5175,7870,3254,6687,5293,6650,8423,7427,8425,8234,7828,7581,6691,7899,6692,7429,7435,8898,7400,8440,8381,7443,7390,6871,7490,7410,7389,7379,6668,7385,6733,8840,8488,3952,7452,3362,7596,6749,7578,8515,6972,7822,3844,7423,8424,7812,8334,8477,7659,8516,7498,7768,7591,8485,7643,9020,7440,8282,7776,7660,4268,5178,5824,6818,8216,7844,8267,5174,8941,3561,9142,9099,9088,7388,5811,5924,4922,7875,8215,8401,7380,6983,6942,7419,4745,6886,8220,8431,6489,4612,1289,2825,7572,8496,6667,7017,6238,6941,8218,7622,7414,7672,2608,5759,4920,2003,7871,7723,6273,8219,7624,8509,6181,6829,3881,8489,7026,8196,4898,7392,7129,2463,7445,6816,8487,8494,7425,7730,5584,7022,6885,4001,8009,7617,7118,8357,6160,6926,7903,7491,6954,8474,7777,5218,4774,5384,6217,6199,7817,6671,7583,7577,7584,8262,7829,2606,7417,6919,6040,6866,7426,2611,8422,7434,7025,6786,7774,8236,6923,8273,5330,7775,2464,7607,8204,7021,6688,7642,6175,5827,7641,8391,7403,6646)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)),produit,numErr153a