SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo,CASE WHEN isable!=0 THEN photo2 WHEN wi2=1 AND photo2_2!="" THEN photo2_2 ELSE photo2 END photo2,photo1_2, produit,num FROM produit_couleur 
WHERE prix!="0.00" AND affich=1 AND photo2!="" AND volume!=4  AND produit IN(0,9383,9340,6944,8764,9177,9321,8877,9335,7748,8907,7382,7801,6596,8342,8362,9388,9377,6922,8762,3827,9245,6894,8060,9220,7556,7925,1844,8319,6449,7943,6349,6258,8565,8919,2104,9366,6945,9144,7918,7110,8031,6257,9466,4650,7961,9084,8374,9068,6804,9276,5656,9284,6716,8931,6879,6255,9360,9254,6252,8304,9382,7545,7647,9469,7842,8735,9369,8327,8576,9525,7709,7897,7846,9407,5117,8924,7892,7818,9302,9265,8350,9344,9356,6259,9464,8019,9368,8483,9306,9522,8960,9289,9524,8175,6899,9520,9526,9270,9519,8224,5937,9295,9518,9515,9268,9465,9517,9514,9136,9484,9513,8965,9479,9512,9278,9240,9478,7543,9072,5138,7898,8211,9470,9477,9490,9365,5366,9487,7873,9294,9121,9486,6454,9463,9485,7830,9423,9483,8355,9425,9482,9230,9239,8761,9468,9410,9481,9275,9322,9475,8344,9111,9480,9071,9390,9474,7673,7855,7476,9473,8379,7394,9472,9087,9467,8562,9446,8384,6504,9471,9070,8419,7482,9461,7457,7470,9460,7212,6459,9459,4149,1839,9458,7920,8299,8069,5094,9457,9404,9174,9453,9085,9037,9452,9073,6850,9451,8416,7853,1840,9255,8415,9384,9449,9107,5741,5111,9445,8967,8821,9444,7664,7756,5119,7153,9443,8356,9389,9441,8377,7945,9440,9162,994,7475,9439,8447,7580,6004,9438,9082,7522,9437,9161,7478,9436,9083,9303,9435,8966,8560,8872,9434,8450,3568,6611,9433,6256,7408,9432,4147,7521,9431,9086,8530,9447,9429,4143,9476,9428,8953,9450,9427,4626,987,9442,9426,7826,8561,6601,9418,8371,7006,9417,8312,9422,9416,8952,6503,9415,8372,5388,7883,8586,9414,8951,8068,9328,9413,8395,7833,6859,8511,5745,9408,8421,7743,9420,9258,8358,4652,7542,7917,9411,9374,8359,990,7218,8622,6251,5098,9409,9092,8353,8895,9354,7916,6132,7558,8412,5133,9119,8383,5101,7877,9301,9105,7919,6127,9054,8378,1814,9345,8351,9014,8780,7763,5099,9364,9269,8361,2356,8778,8396,7377,9024,7597,7477,8711,8349,8897,9145,8442,7949,9281,8394,7832,3002,7767,3191,9244,7592,9304,9333,8254,9421,6109,7024,8900,9226,6938,5091,8889,7926,9448,8742,4250,9430,2461,8512,6377,9032,8258,8921,9234,7778,3196,8834,7856,8928,8736,8393,7473,9406,8347,9329,7322,6862,8933,8741,7771,8365,8994,7594,9206,6968,6253,9336,9405,6858,7004,9402,7741,9419,9401,9412,9400,8346,9403,9399,4146,9205,9397,8345,9204,9396,8260,5108,9395,8311,9171,9394,8256,8722,9282,7621,9327,9393,8253,9202,9090,8255,8882,9392,8380,9363,9150,8348,9362,9134,7732,9222,8656,7023,1809,9028,1288,5322,9381,6713,5132,9380,4257,7184,6108,7661,8597,9229,8044,7947,9379,6947,7523,9376,7900,6599,9343,6932,9342,9375,7662,9334,9175,7889,9305,9147,6680,9391,9015,7803,9224,9149,7747,9218,9287,7648,8920,9373,7868,9217,9233,7469,8326,9372,6723,6124,9371,6709,7938,9370,6443,5136,8945,7459,8016,9367,8385,9016,9359,7622,8599,9357,5109,9355,5473,9353,7712,9106,4653,9352,5139,9351,9172,8867,6734,9286,8593,9235,8918,9299,9164,9350,8890,9349,9163,9348,9158,9012,7008,9201,9139,9347,6610,9200,8595,8737,9035,9346,8094,9199,3123,9198,6597,7554,5315,9197,6506,9236,8569,9231,9130,9232,9424,9338,7940,9196,7068,9283,9117,8959,6609,9337,9017,6492,5134,9195,9120,9194,1811,9193,9115,9332,7874,9192,9094,9331,9093,8830,7944,9146,7219,9191,9076,9330,9075,9326,9398,9190,9074,9062,9066,9325,9065,9189,9064,9324,9063,9188,9044,9313,7009,9187,9043,9312,9042,9186,8790,9311,9179,9185,9277,9132,9341,9184,7565,9183,7564,9298,6461,9182,8914,9297,8904,3621,4654,9181,8899,9296,8926,9180,9036,9293,8905,9292,9030,8673,9173,9288,7854,6384,9013,9114,9006,9280,7764,9153,9168,9279,9361,8913,8908,9152,9010,9274,8971,9273,8958,9272,8957,9271,6612,9148,8954,9266,8398,9257,5535,9250,5135,9249,8020,9300,7005,9165,5994,9248,8367,9247,8875,8997,8930,9246,9112,8670,9091,9243,8929,9242,7131,9241,9339,9238,6755,9237,8922,7137,5987,5950,7954,9031,9135,7451,5316,9227,8364,9225,8917,8799,9034,2991,8916,9089,7734,8738,9267,8962,8915,9310,8910,9151,4042,9291,9011,8846,8998,8163,8903,8912,5140,7922,8363,8819,7736,8757,8963,9170,9125,8894,9123,8883,8626,5433,9122,8935,8321,8842,8584,8879,8868,7737,9285,9116,8756,8876,5537,7955,7366,7750,8861,7059,8706,9109,8827,7951,9104,8870,3769,8634,8829,9108,8845,8668,9055,8857,9228,9095,8138,5444,8449,7217,9176,8855,9069,8854,9160,8568,8772,7711,9378,8848,9002,5307,8880,8841,8577,8408,5624,9021,8796,7398,8303,7841,8603,8896,8993,8588,8784,2837,8763,8820,4640,8815,8243,8324,9138,4563,9137,8814,8873,8813,8643,6145,9126,6565,7921,8691,8171,8732,9124,8812,8080,8744,8893,8811,7329,7130,9004,7858,4632,7472,8850,7486,8992,8809,7952,8810,9009,5966,7987,8366,8750,9290,8047,8787,5443,7541,7216,8727,7395,8749,6606,7976,8794,8991,5137,9081,8793,9080,5306,7993,7942,8986,8923,8733,8791,8642,2107,9098,8719,8592,8789,9056,7294,8874,3124,8768,6171,9051,8375,8969,8776,9047,5899,9041,7705,9039,8906,8453,9096,9159,8775,9157,3126,7495,8774,9057,7048,8039,8666,8887,8746,9025,6754,8858,6598,9141,5967,8241,2839,9008,8853,9007,8688,7888,3122,8123,8725,9003,8866,7387,6000,8029,8860,7363,6464,8462,5470,6291,4834,8658,8708,3855,8782,9000,6877,8781,9128,8946,8999,8832,9127,8125,8995,5321,8734,4043,8469,8765,4562,8771,8606,6296,8667,8909,8747,9110,8665,9001,8692,8984,8807,8983,6013,8777,8721,8461,1812,8982,8720,8981,7374,6961,6739,7893,7536,7489,9169,8891,8685,8314,7297,8591,9143,8972,6006,8970,8705,8989,8704,7896,5465,8703,8770,6007,7867,8779,9061,9113,9060,8699,8707,6151,9059,8859,8888,8773,8323,5439,7895,5438,8949,5437,8499,8598,8767,6143,8947,8856,9053,8849,7726,6607,9052,8645,8940,4561,6960,8745,8939,6155,8671,3188,8865,4045,9049,4041,8580,4037,8936,3129,9033,8718,9100,8663,8911,8632,9027,8662,8892,8927,8465,8652,8660,8696,8340,8788,9019,7171,6880,6474,6284,7845,8026,6977,8728,6413,8886,8407,8884,7928,6232,8325,8683,5890,8828,7835,6959,8457,8119,7930,8315,8518,7731,8144,8608,5407,8619,3657,6208,6403,8233,7238,8729,5920,8621,4279,8028,8001,8987,7606,7474,8575,7484,8851,7295,8339,9131,6603,9129,8434,7368,4554,8617,7850,8726,6415,8978,8589,8730,8459,8717,8612,7992,7819,7989,6882,7729,7562,8885,7013,8852,5031,7725,8502,9022,8950,8003,8146,7406,7887,8523,8615,6412,8709,8443,9077,8519,8559,7306,8037,7851,6964,7935,8974,5004,8079,3609,8740,4423,8937,7293,4422,9166,6210,8466,8448,8240,6495,9156,4656,8034,6602,8118,8018,8480,3610,6854,5009,8702,7239,7226,7714,8753,3261,8600,6362,8250,4591,8522,7929,8275,6505,8743,8638,6302,8637,8655,8766,7480,8684,8818,8631,8878,8731,4368,8630,6169,8628,7331,8661,7420,8627,8452,7787,8397,8166,7204,8280,7544,8624,4429,8439,8160,7574,8651,8167,8611,8513,8454,7946,7384,8570,8601,6731,6261,6846,8641,5875,8467,7464,7299,8590,8748,7950,9101,7863,8646,5427,8620,6837,8862,8435,8864,7236,6963,7956,7985,6844,9097,8436,8322,6564,6888,8585,8427,5991,8644,8501,8607,7330,6685,7991,5511,8754,8046,8610,7603,6966,5768,8647,6970,6491,7157,8973,6502,8510,5435,7391,8297,7996,7062,8609,5408,5329,7303,8468,7538,4497,7309,7424,7936,8618,8370,6390,5093,8847,5092,8664,8392,8955,8739,7361,4663,9133,8126,2609,8604,3846,7061,8674,5884,8122,8701,8004,8824,7960,8822,8230,8697,6306,8635,8792,8693,6318,8633,6955,8800,9102,8686,8723,8405,8460,8124,6883,7981,8695,6874,8433,8074,8084,8245,8145,5434,8316,7890,5326,7571,7493,7549,8724,5409,1294,5354,7593,7632,8400,7383,7995,9058,7010,6962,6861,8491,4849,7706,7814,7210,7649,6604,8226,7393,1823,8446,7588,7663,8566,6758,8463,7349,8318,8751,8235,8639,8508,8517,6240,7862,6472,8143,7381,7965,8526,7468,8527,7864,8437,7637,8825,7667,8529,5645,8669,8221,8470,7247,8027,7351,8564,7158,4432,3023,8649,6929,7229,7548,8976,7458,8248,7160,8246,8506,8567,7235,7172,7251,5336,7352,3432,7488,8420,8008,7971,5426,6290,8002,5760,6566,5422,6847,7816,3789,8414,8507,2101,6974,8943,7355,8486,7735,6406,7861,8343,7551,8341,5436,5149,8596,8213,4485,7599,5343,8136,7413,6405,7941,5817,7094,8231,7241,8076,2598,8613,7605,9167,7964,589,7937,8242,8278,7923,7399,3128,7539,8429,7307,7386,8128,8525,6759,9154,6361,7372,7550,7586,4036,6868,6978,8505,5997,7650,7715,8261,7159,8276,5989,2610,7609,5481,7983,6408,8445,7866,8017,8271,5440,8455,8249,6737,6422,7533,8042,7485,7365,7282,7668,3861,8010,7865,7628,6096,6843,7857,6773,8614,7162,8237,8521,3680,8329,8602,6508,8137,8783,8432,8698,8232,8690,9079,8687,8247,8640,4264,7939,8520,7680,7811,8024,8500,5873,7590,8013,8274,6684,8335,7677,5431,7313,8484,8587,6204,7063,8302,6365,6498,7308,8336,8871,7978,5471,7589,8808,7444,8251,7312,6996,6200,8162,3029,7957,8473,8636,7427,8823,7367,7318,8168,8694,8239,6509,6383,6863,7362,7407,8985,8072,7328,7290,7396,6878,4205,8055,7173,8071,8272,8051,8332,7487,8654,5468,8481,8120,7633,6364,8430,6499,8228,7166,6887,7203,3918,7378,8456,2363,6864,8797,8938,7552,8898,7319,8170,7001,7364,7859,5191,5301,7585,7758,8352,8095,8338,7630,8478,8279,8223,6690,7894,4587,8264,7792,7291,7540,8528,7056,5332,6682,7644,6845,7815,4287,8426,7631,6263,7636,6727,6740,7302,8025,6650,8313,8078,7635,8418,6875,6958,6708,8217,6876,6312,7520,7011,8961,6706,6848,7400,6417,7899,7744,8214,7405,7813,7067,7619,7820,8441,7671,8406,7788,7371,8281,7576,4491,5816,8277,6982,6352,8659,5278,7429,6842,6692,7860,7782,7534,8225,8252,7379,8444,8005,8403,8417,3008,7598,5785,8117,8077,3027,6873,6317,3998,8438,5303,7587,5798,5325,6990,7596,7665,7781,7716,8423,8503,4456,8328,3254,6633,7783,8798,8222,7612,6691,7710,7620,8831,8298,4597,7828,8075,5175,6841,8425,6647,7410,5738,8234,5107,6407,6613,8498,7532,8440,7980,8504,7311,8479,6705,8135,8404,3952,8330,7373,7154,7452,8399,6881,6340,7301,8331,8083,7253,6102,7000,8497,1569,6668,7616,6967,7177,8381,8653,8227,8097,8386,8629,6733,8257,7490,5834,8268,7537,8337,8129,6732,8100,6871,7595,7658,8014,9358,5969,8023,8881,8839,7357,9103,6501,8700,3788,8752,7683,8625,6139,7449,4158,7167,7690,7997,7546,7972,4759,7258,8623,7870,6999,8488,6838,8431,7615,8833,5696,8334,8267,4799,7998,7651,8582,6671,7423,8116,8714,8496,8710,6818,8758,7672,7168,7434,6238,6941,4922,3844,7022,6972,8053,6886,8516,4426,7624,8236,6885,8218,8477,9142,6942,8112,6199,8835,7727,8485,7776,8401,9020,8011,7425,7822,8838,7641,7336,6688,5824,8422,7871,7607,7979,7262,7809,7259,8103,8826,6344,7829,7591,8391,7584,7844,8220,8215,7775,7777,8262,8760,6101,9088,8616,8424,7812,8204,6667,6829,7659,8571,8216,7426,9099,5584,8786,8474,6926,7510,8152,7494,6382,8219,6082,4920,8273,6314,8836,8161,7227,7335,8259,8837,8196,6301,8863,6331,8159,7966,6441,7984,8715,6040,1289,7491,8716,8489,2464,2463,3881,8712,8605,6642,8033,8089,8087,7261,7274,5174,8515,6217,7875,6484,8142,8487,7660,8035,8785,8085,8672,6458,8049,7263,8475,6341,8105,7962,7260,7583,8088,5218,7903,6648,7817,8769,8795,6797,8131,6313,8713,7730,5330,8759,7963,6052,6332,8494,7768,8169,7774,6866,6800,8150,5827,8106,7392,4268,8238,6311,8151,7986,6592,8092,6983)  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