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