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