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 produit IN(0,9250,9371,9151,6879,7952,6109,9273,8845,4632,6968,9054,6964,2104,9104,9372,2461,9337,7293,9089,9148,9090,9100,9147,9150,9078,9502,9526,9501,9500,9499,9498,9497,9495,9496,9492,9491,9490,9487,9486,9485,9483,9482,9481,9480,9475,9474,9473,9472,9225,9471,9446,9266,7328,9324,9298,9393,8757,9245,9226,9399,9395,9356,9368,8834,2991,8736,9152,9313,4429,9153,9402,9373,9242,9401,8735,8768,9376,6106,7450,8734,9378,9325,3621,6108,9397,9417,9272,8755,9346,8741,8738,9312,9149,6384,3168,7451,9012,9377,9380,8670,9288,9396,8754,9119,7480,7449,8772,8796,8163,9379,9354,9332,8316,8727,9355,9279,9414,9181,8740,9310,9367,7448,9350,9357,8990,8873,9243,9191,9184,9351,9340,8160,5040,5950,8763,4368,5624,9338,9331,9254,8993,7329,9269,9146,9098,3170,9069,8997,3769,9007,9358,9238,1294,7387,9038,7493,8733,8787,9124,7137,8170,6302,9461,9460,7976,9459,9458,9449,9444,9443,9160,9441,8827,9440,9439,8750,9438,9437,9436,2610,9435,9434,9433,9432,9431,8889,9429,9123,9428,9427,9426,7322,9415,9405,9229,9400,8243,9394,9392,9381,9241,8673,9375,2422,9138,9048,9370,9359,9106,9408,8079,8818,6405,8851,7323,9353,8829,9352,7331,8171,6408,9349,8654,9348,8861,9347,8887,9335,9330,8972,6290,9326,4640,9311,9114,8610,9297,7489,9296,8000,7330,9248,9293,8756,8603,9292,8608,9033,7960,8671,8749,8991,8780,9274,8080,9271,9418,9416,9265,9258,9257,9137,9255,7993,9249,8864,9247,9246,8027,8865,8462,7971,8730,9126,9237,9125,9227,9244,8986,8426,7299,9199,9198,8683,9197,9196,9195,8617,9194,4497,9028,9193,3855,9192,9190,8241,9189,9132,9188,9187,7991,9186,9176,8912,9185,9002,9051,9129,9183,6961,9182,8968,6880,9180,8975,6963,9023,8600,6406,8246,8748,6306,8123,8658,8622,8886,9026,8940,9039,8846,8777,9228,8615,9061,8874,6959,8340,9165,7150,8647,8992,9004,1823,8709,7411,8460,8939,8469,8892,8119,7471,9031,9024,9041,9128,6283,8949,8982,8981,7229,8607,9280,9141,8893,8084,8453,9166,9000,8468,8726,8592,8847,8947,8742,9018,6208,8465,9052,9025,8484,8339,7606,8611,8942,8966,8601,8467,8452,8315,7892,8619,6962,6854,9060,8314,9122,8145,7381,8984,8323,5760,8138,8767,8969,7987,8242,8695,8655,7296,8978,5149,9127,8343,8989,9050,6966,8609,8888,8621,9056,7770,8318,8702,9081,8495,6232,5431,9291,9009,8830,8999,9133,8261,9097,8480,8911,8240,8250,4667,7867,8936,7865,8248,6853,8937,8913,8987,8466,6960,5375,9057,6498,9157,8970,8591,9008,8529,8909,7893,9003,9080,9159,9144,7888,8505,8463,9047,5831,2101,7422,6487,8737,7650,6169,3004,8943,589,7384,8974,8858,8602,8950,9022,8461,8717,8995,8427,9032,7391,6737,8753,8122,6694,8674,9059,9145,4849,8464,8983,6261,8226,5329,9049,7590,5422,9154,8728,9055,7866,8878,8778,8322,8649,2609,8771,9101,8669,8651,3846,3163,9110,8432,8819,3432,8626,8454,8880,4264,8028,7386,8700,7420,8118,8341,8042,8664,8231,7978,8559,9027,8429,3680,9167,7599,7589,8428,8618,5336,8168,6240,8499,8500,7857,8994,8233,8414,8743,3027,8646,8352,8336,9105,8456,8508,9079,4622,9053,8566,6706,8644,7598,8945,8976,6881,8528,9019,8707,5817,8862,8338,8564,8504,2462,8430,8076,8852,7814,6422,8884,8136,7428,7813,8985,8478,7222,8137,7432,8955,7923,8520,8274,8232,7887,8228,7314,8527,7996,8891,7992,7258,8229,8729,7894,7588,7989,7325,8247,8526,8230,8433,8225,9102,8510,8235,6732,6490,8023,8525,5816,7585,7172,8825,8659,1818,8567,7173,7985,8839,3029,8239,8885,9156,8406,7811,8614,3128,8335,8973,8723,6263,8938,4456,8481,7619,8739,8227,8418,8437,6513,5191,8217,6200,7649,8724,8470,8850,2602,7312,8420,7632,8275,8386,7167,8417,6967,4000,6687,8613,9058,8237,8271,8045,8117,8473,8214,8213,7011,8276,7135,7576,7816,5481,7633,3028,8840,8752,8493,7586,7276,8272,8441,7658,6022,8498,7972,6982,8223,6887,8438,7644,8497,6383,7573,7291,8298,7620,6312,8005,8135,5182,8479,5175,8337,7301,8898,7379,7587,8423,3254,8332,7815,8268,7390,6102,7997,7828,8625,6692,8440,7581,6691,7410,8234,7899,7400,7389,7270,7490,7385,6733,7265,8488,7202,3952,7596,7452,6749,7491,8049,7231,8795,8785,2464,8085,7283,5384,2463,6484,7336,7984,8422,6885,7129,7966,6344,3649,7274,7583,7273,8836,7986,7494,8273,6238,6648,8672,8826,6040,8053,7168,7643,7025,4922,8863,8087,8131,6341,6052,6786,7200,7271,8605,7403,5218,7138,7022,6331,8142,7227,8238,8494,8161,6199,8844,8092,8103,7953,7617,2003,4898,5584,7272,8089,7335,8262,8357,7812,8009,7768,8485,8282,8516,2611,8267,8088,7259,6954,3881,8941,4612,7875,7578,8838,6489,8515,8833,5178,8496,7844,9020,8786,7584,8424,7380,7281,4001,8835,8758,6382,5759,8759,8215,8401,8509,6217,9103,8784,8425,8381,3362,9099,8219,9142,6972,7774,3561,5924,6829,6886,7426,7776,7591,3844,5824,4268,8216,5174,8334,8224,7641,7607,6160,7577,7642,2606,7026,7021,7829,8760,7775,8011,8487,7672,6688,8391,7572,7822,7998,8837,4426,6923,8489,7777,8116,7871,2825,8169,7425,4745,8220,7624,7414,2608,8616,5565,7199,1289,6273,8152,8474,4774,8477,7417,7723,5811,8236,7903,4920,7388,8218)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a