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