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,9322,9433,7462,6968,9076,9476,7545,2104,9036,6599,3002,7897,1840,7459,3827,9371,8447,4650,6504,9356,7382,9067,9410,5950,6694,4654,9404,9419,2461,6879,9121,8166,6109,9114,7006,1814,7543,7892,1839,6899,9390,8584,6880,6882,9344,8576,8314,9006,9525,8788,9378,4632,9229,8589,8834,7489,9224,5133,8031,8960,9222,9369,6601,8735,9174,6495,8080,7898,5366,6597,9225,8449,9220,8483,3191,8617,9145,9164,6503,9413,8342,9171,9366,9388,7556,9241,1844,9403,9402,9151,9064,6377,9399,9089,9065,6655,9420,9474,9090,9172,8866,9395,9147,9066,8809,9392,9175,9095,9270,8876,8757,9502,4834,9448,9471,9501,5138,9305,9393,7868,9500,9508,8870,9415,9497,9506,9391,8736,9418,9120,9365,1809,9458,9496,9163,5094,8734,9416,9130,8872,9337,9150,9139,7469,9412,8865,9408,2356,9423,8763,9153,8929,9382,9358,9104,9117,9268,5108,9400,9152,9119,1811,7554,9217,7918,6474,9405,8321,8933,8781,9325,8319,9037,8842,6804,7922,9158,9278,9409,7961,9124,8931,9383,9346,9149,7833,8875,9397,9123,9010,6443,7943,3621,9146,9075,8790,9293,8241,9068,9275,3196,9379,9062,7835,8877,9313,9160,9115,8895,8768,8316,8924,9276,8789,8741,9138,5134,5132,9331,9007,9035,8744,8754,6964,7832,9289,6132,9435,9125,9135,9301,9359,9131,9044,5987,2991,9230,3855,5091,9327,9437,9137,7521,9363,9414,4640,9013,7743,9364,9269,9003,3140,9424,8738,1294,4653,9421,9274,6963,5322,7456,9422,9440,6961,9179,8869,9428,8453,9094,9450,9266,8462,5407,7492,9342,8727,9012,4652,9329,9272,9148,6945,7800,6602,8755,9141,9030,8774,9357,9132,5135,7947,9242,9122,7864,4149,8841,8827,9126,9043,9384,9355,9092,7854,9303,8846,9165,8928,7664,5511,9436,9078,6850,8782,9475,9128,8812,7742,7217,9380,9100,9034,6375,9348,9176,3777,9326,9106,8518,6253,6505,8670,9098,9091,6362,9438,9144,6734,9528,9377,9051,5139,6252,8853,9297,9048,8327,9527,9368,9133,8791,9524,7450,6449,9041,8900,9523,3168,9127,9011,9522,9396,8992,8964,7741,6506,9372,9054,9063,9520,9394,9069,9218,9519,9290,9052,8926,8380,9518,9340,8469,8998,8599,8796,9004,9093,9517,6108,9028,8915,7457,9425,9324,9129,8434,9511,6106,9033,8920,7212,9477,9347,9134,8935,9479,9245,9023,7004,8020,9254,9060,8366,6454,9510,8873,8893,7874,9509,9298,9008,8963,4491,9417,9038,8917,9507,8740,9001,9042,8775,6384,9025,8906,8848,9446,9009,8916,9505,9481,1823,8448,7484,9247,9039,8921,9504,9271,9157,3261,9503,9335,8460,9113,9494,9373,9031,7863,6124,9459,9166,7764,8807,9376,9018,5136,8879,9257,8468,8810,9463,9284,9154,8954,8868,9159,5427,9334,9026,9074,9447,9350,9027,8882,9277,9367,9081,9116,9014,8673,9080,8815,6596,9287,8467,5140,6603,9227,9024,7059,8860,7451,8972,5316,7110,9349,9032,9111,5109,7328,8340,8814,8732,9250,9061,8930,9339,9432,9047,8957,3123,9439,5760,5473,8721,9441,8461,7008,8019,9375,8990,8908,8699,9353,7867,8811,9336,9288,8982,7184,7523,8818,6959,7009,9389,8845,8913,7219,5004,8844,6962,7068,7954,9281,9053,5408,8691,9427,8986,7062,7531,9370,8339,6612,9381,8984,8958,8167,8730,6854,8946,5111,9332,8323,8903,9017,9192,9110,4591,5656,9292,8315,5137,8832,8750,4849,7133,9411,9226,6208,8919,8820,6232,7710,9328,8163,9056,8927,3008,8780,9167,7841,6459,9352,7387,2107,6004,9265,8949,8914,6610,7952,8981,5321,9309,9255,7893,8944,6142,5040,8465,8398,8708,9434,7888,7736,7473,9279,3004,8325,9304,9374,8466,8971,8855,7137,8997,8523,7482,7480,6960,7005,9016,8867,8242,7709,9204,6349,8968,7928,9206,9311,5149,8793,9205,7323,5375,9021,9478,7448,8250,5315,7216,8160,2610,7712,8595,8787,8993,8948,6502,8864,4667,8910,9202,9401,7381,3789,7488,7558,8975,8813,3007,7449,6261,8365,6476,9445,9002,7734,9267,8733,9105,6877,9442,9246,8987,7153,6376,9354,9000,8918,8765,9526,8318,8904,9430,9515,7770,5920,8562,7329,7865,9096,8634,7411,8243,4042,5985,9514,8999,8375,8854,8168,9050,8324,5009,9513,8991,5884,5967,9512,5831,9112,7562,9228,8939,8953,4423,9499,8559,8907,7239,9498,9057,5307,7940,4368,8892,7737,8668,7391,9173,8794,9495,6966,8952,6565,9492,8463,6755,7951,9491,8248,6210,8773,9490,9059,8370,6598,9487,6853,8491,7377,8742,8888,8890,6604,9486,8240,6739,9484,8749,589,5875,6412,9485,7416,9168,8569,9483,4432,8776,9482,8966,5443,3609,8829,8940,8326,8685,9480,8495,7851,4422,8772,8947,8922,8719,7993,9049,8883,8126,7493,8452,4656,8597,9473,8529,5444,8897,9472,6169,8408,7238,9461,7226,4561,5542,3769,8427,6006,5994,8756,3846,7858,7565,9460,2609,7711,3126,4429,9022,9170,6564,9249,8566,8297,9360,8170,8950,5306,6007,3170,8246,9109,8661,9234,8983,2839,9143,9449,6737,7714,8586,9444,5431,8899,8665,9443,8341,7842,3122,9282,7384,5890,8592,9055,5433,8593,6406,8942,5899,8612,9248,2101,7131,8018,9243,9079,8392,8697,8079,8936,8364,9302,9312,7422,7048,4563,9431,8912,6157,8746,8851,8995,4045,5031,8874,8231,8363,7297,7322,5422,1812,5966,6408,8970,8666,7944,3171,5329,8905,7298,9426,8994,7130,8016,9191,7589,4037,7295,9280,8911,4155,6013,8671,8454,5465,6415,9429,8945,4041,8725,5535,5326,9108,5093,8770,8887,8435,6473,7299,8343,7705,5541,2422,3432,5768,8688,9188,4264,2837,6146,7866,7567,7935,5624,8959,7161,8857,8603,8884,5438,8766,7330,8937,8407,3124,8000,8969,5437,9398,6302,8456,5354,8698,7150,7857,8507,6611,9182,4678,5470,8635,8608,7420,6754,6171,9201,8564,4043,7374,9457,8886,7157,8627,7976,8322,8245,7477,9299,8962,7094,8896,4497,7895,8439,6001,8706,6204,8443,8798,9187,6859,8400,8718,9181,8880,5898,9361,9194,8480,5896,3610,9286,7887,7819,7236,9351,8978,2598,7946,8709,8429,7750,7300,7331,8567,4663,8568,7541,7599,2838,9283,8508,7735,5092,8695,8405,6403,7542,9019,8894,8696,9338,6706,8951,8047,6306,7386,8394,7218,9406,9097,5426,5745,9333,5336,8519,7474,7991,8352,9169,7949,8621,7471,5343,6035,9330,8505,7845,7472,8611,8414,6862,6290,8989,8249,8722,8607,8909,6861,8703,7960,8974,5439,8588,8647,8891,8667,6127,8600,8499,8436,7171,6405,7432,6874,8633,9296,8261,8280,7486,7987,7921,7930,6475,8123,8527,8367,8632,7267,4622,6970,7470,8861,8664,6977,7956,8717,8528,7850,7564,8615,8432,8502,6497,8753,8428,8446,8745,8171,8500,8513,7522,9015,6487,8511,6609,7296,7590,8501,8731,8478,7010,7945,8748,3027,8395,8684,8778,3128,6685,4485,9273,7606,7609,8624,9345,8274,7013,6020,9343,8226,7605,6145,6240,7061,7303,8858,8235,7667,8144,7139,5817,8521,9341,9258,8660,6974,7938,9244,8943,6846,8663,9310,9156,8517,8652,8767,8464,6787,7478,9300,8985,7929,7294,6390,8520,8512,8859,8651,9102,7603,6000,8622,8525,7787,8747,8726,6284,7024,7955,9238,8302,8003,8637,9237,7428,8514,5030,9285,8526,8923,3129,7971,8522,7569,6464,8027,8335,6731,8662,8609,7896,7663,6018,8601,8397,7807,8125,9200,8275,7593,8645,8771,7424,6844,6607,9199,8889,8705,9198,8476,7574,3188,8737,7437,6837,8856,9197,8955,7890,8585,8591,8004,7861,7950,9453,9101,8445,8143,9196,8976,5435,8046,8137,6955,5409,9452,7923,7862,6143,9195,8486,6758,7536,8715,6490,8329,9362,9451,6881,7677,8822,9193,8336,7706,6413,8145,9077,7637,7406,8649,8484,7160,3657,9190,8271,8506,8638,8710,3989,7628,8704,8702,7818,8221,8849,9189,8430,8278,8630,8084,8338,4036,7475,9186,7813,7680,8570,8683,8232,5434,8598,9185,7729,8393,8640,9184,7814,7669,8631,8026,9103,6847,8001,9183,8504,6929,8596,6291,7632,7668,5991,8669,8230,5440,8687,8674,7585,7159,8779,9180,8433,6684,8720,8619,8239,7158,8606,6296,8406,5436,7476,9236,8437,7900,6151,8777,8247,6759,7309,9235,7588,7307,5989,6492,6888,7162,7942,9233,8225,6843,6606,9232,8237,6773,8751,9231,7442,7715,8693,8138,7650,6978,8604,8658,8973,3788,6155,8643,7592,7753,6140,7268,5191,7615,8017,8830,7586,7758,4562,8656,8470,8277,8590,8581,7598,7631,5969,8878,9058,4799,7995,5537,7436,4759,6508,8620,7576,7000,9314,8626,7495,7001,9307,8646,8229,7634,8821,8578,6732,5303,7538,8728,7383,8281,8690,8303,6200,7056,9308,8828,7649,7067,8692,8819,8233,5301,7550,8642,8222,6708,7981,8654,7444,7846,9316,8602,7446,6999,8686,8426,7633,7635,7460,8119,8498,7154,9315,7368,7430,7049,6496,8700,8217,8313,8122,8214,7820,7395,7731,8213,4287,7549,7229,5816,7630,7210,8644,4000,6740,8128,8716,3918,7792,7349,8573,6263,8961,8639,9291,3861,8881,7551,8583,4205,6848,7533,8655,5182,7639,8044,7962,2602,7744,8628,8610,6864,4158,7250,7438,4587,7964,8743,8481,7859,7936,8510,6996,8013,8850,8455,5468,8074,8792,7811,7616,7937,7978,8420,7610,7965,8582,6472,6838,6566,8418,3446,7571,7544,7619,6876,7464,6318,8264,8295,7355,7142,7894,5471,7235,8707,6967,7651,8711,8227,7682,8124,6498,6883,3998,8024,8579,8386,8252,8800,7366,7011,4597,8824,8039,8228,7825,8701,8112,5332,8331,7241,8729,8479,6286,7234,7515,6727,6873,8008,8572,7447,8403,7413,7992,8885,4266,8002,3163,8739,8404,7306,6553,8493,6705,3094,8618,6958,5785,5744,8118,7658,8257,7352,8574,6887,7063,7224,8028,8473,6841,7247,8852,8938,6842,7468,6491,7816,5873,7393,7204,6982,5278,7983,6422,8441,7563,7394,8659,7782,3179,7398,8175,3028,7717,7941,8577,7573,7716,5645,8034,5325,9136,7463,8076,8272,8330,8176,7725,8497,8503,8094,7555,8438,7636,7458,8847,8223,7690,7351,7363,7815,6690,7548,8575,7783,8279,7289,8037,8276,8251,7399,7293,7587,7671,5997,8839,7441,5798,6520,8224,8337,6845,7408,8029,8332,6863,7314,8298,6875,7485,8038,7781,6949,7539,7282,8417,6682,1569,2462,7644,6990,6396,8040,6868,5834,8097,7172,8268,7683,6139,9456,7620,8328,8823,9455,5175,7788,7313,9454,7870,8399,7989,3254,6878,8799,6687,7860,7243,7364,5293,7595,8587,8724,6650,6249,7152,8042,8423,7665,8051,8641,7427,7612,7957,8146,8425,8444,7290,8136,8234,2363,8752,7828,8023,7581,8072,8723,6691,8129,7361,7899,7203,7996,6692,8694,7222,7429,6364,7435,7959,8898,8831,7220,7400,6499,8613,8440,8162,7985,8381,8100,6562,7443,6493,5649,7390,7249,3029,6871,8071,7325,7490,8636,7410,7552,7362,7389,8808,7173,7379,8014,3680,6668,7318,4456,7385,7487,8614,6733,7540,6317,8840,6647,7312,8488,7353,7372,3952,7308,7452,8095,1818,3362,6340,7596,6002,6513,6749,8120,7291,7578,6365,7167,8515,7534,5481,6972,7939,7258,7822,7311,7365,3844,8045,7423,5738,8078,8424,7253,7135,7812,5696,8117,8334,5107,7276,8477,6633,7519,7659,6613,6383,8516,8075,6312,7498,7367,7768,7532,8083,7591,8629,7301,8485,7248,7396,7643,7251,8005,9020,6361,6407,7440,8010,8625,8282,3023,7371,7776,8783,7302,7660,8797,6102,4268,6461,7270,5178,7520,8135,5824,8871,7997,6818,6501,7233,8216,7357,7265,7844,6352,7202,8267,6133,8786,5174,6509,8116,8941,8055,8106,3561,7319,7724,9142,7166,8053,9099,7378,8833,9088,7231,7388,7177,8758,5811,7407,8760,5924,7245,8838,4922,7288,8571,7875,7537,7727,8215,7405,7198,8401,5965,8150,7380,6417,7281,6983,8025,8142,6942,8077,6326,7419,7546,8152,4745,8623,7138,6886,7980,6382,8220,8653,5565,8431,8011,6489,8616,4612,7199,1289,6314,2825,7979,7572,7526,8496,7260,6667,7494,7017,7272,6238,7274,6941,8759,8218,8259,7622,6344,7414,6458,7672,7283,2608,8085,5759,6484,4920,7728,2003,6866,7871,7335,7723,7499,6273,8103,8219,8087,7624,8088,8509,8475,6181,8159,6829,7211,3881,7213,8489,6797,7026,8092,8196,7271,4898,8605,7392,6648,7129,7336,2463,7445,8169,6816,7168,8487,6800,8494,7726,7425,6581,7730,7261,5584,8714,7022,6592,6885,8785,4001,8835,8009,8836,7617,8713,7118,8863,8357,8672,6160,8795,6926,8826,7903,7259,7491,6331,6954,8769,8474,6642,7777,8131,5218,7263,4774,6441,5384,8837,6217,8712,6199,6558,7817,7963,6671,7510,7583,7972,7577,7373,7584,6022,8262,8825,7829,6096,2606,8784,7417,8862,6919,8033,6040,8580,7262,7426,7953,2611,7273,8422,8049,7434,6052,7025,6786,8035,7774,8132,8236,6311,6923,7966,8273,8151,5330,8238,7775,6301,2464,7984,7607,7200,8204,8089,7021,7504,6688,3649,7642,7809,6175,7998,5827,7230,7641,7227,8391,7986,7403,6341,6646,8161,6313,6595,8105,6082,7264,6332,6627,4426,6582,6101)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND ( promo!='0' OR prixo!='0') ORDER BY ( (CASE WHEN site IN (1,3,4) THEN 10 ELSE 0 END) +1000-num+promo + (CASE WHEN prixo=0 THEN 0 ELSE ((prixo-prix)/prixo*50 ) END ) ) DESC,produit DESC,numErr153a