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