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=2 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,9344,7993,7647,8070,8764,9424,9284,7868,5366,9234,7462,6504,8757,7459,1205,8762,1840,8867,3479,7947,7543,6899,9328,9290,7873,9329,6109,6655,9045,8565,4654,9353,9365,1844,8706,9084,9220,6879,9366,9040,9174,2104,8483,8299,8176,9376,9369,6377,7382,6723,8791,3002,6259,9177,8419,9412,9281,9278,9409,9393,8362,7833,9225,5190,9470,9410,9287,7492,9407,9411,7556,9289,9067,7545,9525,9095,6106,6443,9469,8812,8738,4149,9306,9301,9250,7469,6503,6349,9230,9466,9523,7558,6680,9295,9524,9526,7919,9522,9282,6932,9520,8342,7664,997,9519,9402,9270,9240,9518,9326,8385,9517,9395,7800,8060,9484,9337,7673,9479,9293,7743,9294,9478,9292,6944,9076,9413,9268,8069,9477,9090,6716,9364,9151,9276,9239,9476,7328,7918,8059,9342,9458,9275,8790,3171,7830,8374,5969,7541,4143,9035,9286,9404,5741,9448,9471,7917,8882,9266,7592,8304,8815,9175,4626,8066,8809,7450,9107,8933,7554,8372,9450,4632,8371,7853,9447,6108,7856,8065,8906,2461,6255,9442,9245,6253,7855,4650,6804,8358,8068,9423,9148,4147,9422,9428,8383,9421,3621,8384,7756,9420,9429,9086,8064,9419,9415,8258,8814,9474,7763,5138,9283,8256,7580,8063,8793,9300,4250,8900,9433,8378,2356,8736,8380,8530,9006,9153,8311,8062,8019,9346,8447,1839,2991,8254,9130,9399,7916,8061,8560,9164,9379,7920,9066,8735,8416,9143,9147,8255,9065,4429,6256,8058,8561,9163,9355,8415,9171,9258,7927,9064,9392,8377,990,9222,9459,8355,5388,8920,9271,8345,9334,9269,8361,9172,5535,7767,1973,9425,9406,7741,9115,9247,3463,9305,8834,9083,1061,9267,9378,8253,5101,8929,3168,7771,9120,9285,8421,9139,8734,7212,987,8924,9089,6947,5098,9037,9274,8260,8915,9439,1288,1068,9277,8768,7778,5099,9339,9298,8344,8810,9181,8379,9093,9062,8356,1073,9036,9397,8351,7881,9116,9449,8349,9303,9405,9082,1976,8919,9436,8346,8918,9100,9161,7880,9044,6384,8348,9075,9377,8967,9043,9400,6938,8931,9418,6858,8963,9242,1281,9034,9191,8347,8708,8741,8359,9010,9461,6713,9362,5950,7732,8895,9226,7456,9322,8827,6449,1814,9460,7826,9011,9354,4257,5134,9149,6454,9113,9313,7742,1809,8727,8396,7835,9457,8450,6601,9414,8353,8855,9446,7023,5133,9401,7733,8811,8959,7621,8869,9015,7594,8935,9054,7661,9217,9372,7926,9361,9368,7457,9304,9350,7597,9135,9311,8442,9363,9106,6709,9403,7480,6894,9042,9254,4146,9398,9349,7889,8908,8670,6922,9391,9119,9136,9091,9257,8312,8916,9340,7803,7832,9417,7925,9390,9324,7622,8599,9104,6258,9389,8868,7662,9360,9038,7801,9388,8796,7748,9384,9150,7747,5094,9236,8350,9327,8865,5937,6602,8163,8944,7451,8807,9078,5091,9371,6474,7542,9030,9325,8917,9001,8946,9370,8926,9345,9309,9343,4653,9358,1811,9374,7943,9435,8971,9348,5135,9396,8921,8780,9013,8160,5132,9438,4652,9437,8890,7137,3827,9434,8872,8673,9074,9299,7854,8754,8903,7387,9224,8316,8774,5040,9206,9381,9205,9515,6132,9513,9202,8656,8842,9512,8841,9490,5108,9333,9017,9330,3777,8740,5322,9124,6376,9487,9341,9486,8813,9485,9336,9331,8853,8643,5407,6390,5542,9472,8899,9380,5139,9152,3191,7323,8964,7897,9014,9227,3196,8844,3140,9394,8781,9373,7217,9351,8904,9427,8866,2610,9016,9189,9117,9357,8020,7448,9179,9356,8877,9069,5136,8755,8957,9246,6734,9359,8434,9338,8927,9235,8518,7493,9158,9233,8848,8772,7521,9232,6362,9272,8666,9231,5109,9288,7864,9335,6604,9347,8870,9098,6599,8750,6375,9367,6850,6302,8820,8861,8910,7139,5004,4368,8905,8170,6506,9297,5473,8960,8954,9416,8448,8763,7874,9255,8948,7449,3789,7329,8907,9187,8789,9007,8366,9123,6142,9483,5140,9482,8166,9481,7764,9480,8922,9475,8875,9473,5427,8782,9237,9094,3769,7711,9166,7863,7267,9096,8997,7484,8581,5092,9273,5985,8845,7377,9312,5408,9229,3007,9444,8327,9443,5315,9188,8018,9441,8879,9440,6473,9125,7009,8449,3261,7299,7303,9432,5316,9431,5987,7952,5009,9146,7239,7331,8883,9445,4591,7898,8562,9243,5137,8079,7841,9184,8773,9426,6004,7976,6124,9279,7062,6964,7184,8654,6877,4640,7004,8874,7734,9092,7954,7922,6505,7960,6610,9375,8699,7416,6597,9028,7059,9131,4423,5624,7216,8671,6612,6961,8721,8990,7710,9132,3123,8243,8958,9241,8732,2422,2107,9228,8523,9352,5111,3170,5307,6306,8365,9280,8857,8913,5321,3855,6603,7226,8719,7268,7951,8080,8325,8846,6476,6963,6146,6968,5967,8583,8398,9332,5884,6296,6461,9200,7712,7895,8998,7368,8667,9128,7736,8573,8370,1294,6598,6492,8859,9296,8167,9185,3609,6408,5031,8600,7709,9183,8953,6880,7219,8889,8375,9452,8952,7330,8854,9180,5656,6405,9173,7971,8788,7471,6502,8968,9168,8730,8691,7489,7006,8592,5875,7892,8665,9126,4422,8818,8392,7731,8589,6406,8894,7987,7238,8321,5306,8603,7737,5326,4554,8887,6013,9265,5920,8893,8783,8733,7523,8756,4485,8873,6882,9165,8507,7991,8326,9249,1812,8426,8324,7322,6564,8787,7133,8137,8697,7544,7309,9238,3124,6291,8491,4497,8765,6962,7130,8972,4563,8608,6415,9248,8569,8864,7531,9012,8612,9190,7928,5760,2598,9186,8775,8939,8696,8642,8951,9453,7735,9310,3122,9451,7486,9182,5511,7296,5433,9033,4656,8962,4279,8339,8249,8993,7946,9003,7374,8453,9169,8615,8718,6204,4561,6959,6739,9244,3126,8647,5890,8241,7161,9408,6171,9138,8297,8027,8593,8886,8725,8123,8598,8572,6001,6553,4041,8978,6495,8992,6412,8578,6007,8949,8364,8748,7488,9027,5896,8314,7298,6208,8822,8591,8408,7515,6157,8610,7171,9176,8245,8323,6565,9026,6127,8303,8439,8851,8047,8912,7858,8709,4562,1823,6035,8584,6609,8888,7944,9002,7935,8480,8570,8145,8688,8609,8016,8892,6497,9048,7297,9127,7094,9004,4043,9122,7048,8982,8435,8452,8797,8829,6210,9061,2837,8726,5966,8302,5470,8039,5426,7150,8794,8319,4834,9129,4042,8607,8635,8577,2839,6960,6006,8315,5030,9057,7157,8171,7861,8340,7300,8242,7851,7896,7965,9160,5768,9134,7474,9052,5438,5649,8668,7437,7981,6859,7567,8683,3188,8611,5444,8981,2838,7893,4155,9051,8126,8576,8744,7381,6754,7770,8400,9023,6755,8456,8143,7606,7236,6290,5898,8911,5541,8138,5343,5149,6018,8397,6874,9137,5899,7363,8604,8674,8596,6169,8684,9024,3129,9060,8585,9039,8436,8343,8446,4849,8514,8989,8363,8975,8568,8341,8722,5431,8017,9025,7536,8037,7562,7725,3610,8660,6403,8261,8624,8974,8704,9000,8645,8830,6508,8579,6000,8529,8590,9047,7950,8942,6143,7411,8606,7888,7850,8034,6861,8084,7131,8575,7294,8880,8634,8240,5465,9018,8627,6966,8633,8622,8513,8601,8632,8248,8766,7867,6496,8986,8747,8621,8588,8991,4663,8619,6151,8250,8125,8029,8698,8702,8443,7422,7956,2609,8731,4432,8459,8669,8685,8987,5437,6487,8703,9022,8856,8476,6607,7391,8693,7366,8457,9041,8001,9032,7930,6232,7819,8969,8501,9159,7574,8819,6155,8770,8280,9031,6787,8429,6140,7384,8720,2101,8630,8462,8144,8495,8395,8947,7807,8984,7845,9081,3657,8753,8849,9291,5093,8484,8628,9009,6020,8231,4037,9114,4045,8649,7677,7229,7533,8777,7936,6955,6475,9008,7550,8767,7295,8574,8445,8940,8663,7142,8519,3004,8405,8937,6731,6562,7983,8465,8013,8909,8329,5329,6685,9157,8394,7865,7349,8469,8640,5831,8652,8970,7964,6694,8074,8499,8003,8318,7929,8891,8521,7386,6974,3846,7569,8995,5991,8427,6977,8771,7937,8858,7538,6498,7787,7204,8631,8038,6413,7220,5409,9167,8687,8945,8010,8000,8128,7420,7663,8467,7941,5422,6970,8026,7460,8728,7667,6737,7628,8655,7995,8004,8046,9101,3008,8983,8512,8955,3094,8322,7464,8428,8124,8700,7862,8528,7890,8943,3023,6318,7234,3027,8517,4205,8639,7866,8506,8508,7603,7555,7250,7978,8044,589,8221,9080,7669,6706,8002,8175,6929,9050,7680,8711,4036,9141,8686,7599,7706,8460,7355,8936,8278,8352,7668,8454,8701,3432,7241,8999,8393,8994,7247,4264,6684,9097,6361,8432,7351,6853,5435,5375,7637,4667,5645,4622,7235,8737,7289,5336,7398,8246,5989,8884,5434,8040,8008,9049,7468,9154,7224,6854,6759,8023,7162,8464,5997,9056,6773,7432,7251,4678,7715,6881,7458,8644,6978,3163,7352,3989,7463,7589,7248,8950,5436,7729,8808,9053,7716,6422,7534,8602,2363,7887,7245,7923,7612,8466,4266,7590,7631,9133,6878,8168,6417,7996,8277,8985,7744,8695,3446,8119,7610,8717,5471,7857,8279,8338,7311,8664,8881,8468,4587,5817,7318,8463,7067,8743,7177,8414,6499,8336,4491,8646,8653,8500,7630,8520,7636,8229,7939,8486,8075,8224,7859,8235,7056,7650,7753,8707,6708,7598,6501,9055,6249,8527,3179,6240,7243,7992,6365,9059,8162,8118,6340,8626,8025,8847,8129,7814,6493,8852,7959,8028,6396,7282,7487,8042,8313,6732,8100,3029,6139,8478,6352,7813,8071,8233,5301,8461,8120,8504,6002,8526,7049,8225,7651,8620,7166,7576,8051,8271,7539,8878,8281,8976,7758,8430,7485,7361,7249,7921,5303,8226,6364,8230,7378,8122,6682,8335,4287,8274,7203,8222,8072,7364,6740,8618,1569,6261,5468,8232,8694,8752,7001,8510,7957,7222,7682,7989,8399,8739,7288,9079,8014,6490,7665,8498,7615,6472,7063,7428,7319,8076,8961,8839,8330,8275,8331,8228,5873,8724,7634,7424,5696,7314,8623,9019,7825,8613,8823,5191,6286,8217,6949,7632,8251,8522,6613,8437,5107,8214,6990,7985,8077,7586,7595,8239,6633,7588,5738,8973,8403,7619,6705,7383,7532,8136,7537,6317,7353,8386,4158,7442,8252,8850,8444,8723,5278,8729,7717,7436,6863,7312,8404,2462,6873,8227,8871,8470,7152,7167,7671,8938,8257,7362,8095,8885,7635,8237,7520,8614,7357,8433,7616,1818,6690,8146,7308,7894,4597,8473,6996,7325,6509,7446,8097,8213,7540,3680,6876,7430,7639,3861,3998,6967,7860,7633,6875,6864,7788,8247,7000,7173,7690,9102,8629,7811,7792,8525,3788,7447,8055,9077,4759,5182,7683,6200,7820,8420,8328,7438,4799,7258,7546,7649,7253,3918,6999,4000,5798,7444,8295,2602,7658,8045,3028,7372,7585,8625,7365,8641,8441,7782,7972,8264,5332,9058,7573,7441,8332,8479,8455,7997,8418,8497,7519,7291,6513,6727,8493,8298,8268,6958,8417,6263,7783,7781,7265,5816,7644,8481,8840,7172,7011,7301,8276,5175,7816,6407,6687,5293,8078,8488,6383,7135,8223,6312,8438,7815,6650,7429,8117,7367,8272,7371,8005,7587,3254,7620,5325,6871,6982,7276,8423,6868,8234,7828,6691,7581,8083,8898,7379,7390,7233,7435,7427,8440,7389,7400,7302,7385,8135,7443,7490,7270,7410,6733,6668,8337,7504,7423,7021,6885,7577,6595,8941,9099,5924,7491,8169,7419,8357,8487,7724,7026,8616,8152,8515,5384,8837,6800,6688,8477,8334,7434,7414,8033,7643,8786,6484,8159,7025,2003,3952,6667,5824,7168,7776,8282,6829,8424,4612,7727,8571,8422,7426,7624,7440,5178,7498,4745,7642,8425,7583,6866,7829,7875,6101,8516,6749,7017,8381,6692,3362,7373,8215,7870,6022,9156,6096,9103,6284,8862,8784,8825,8580,7726,5759,8009,8391,7672,7445,8238,7392,6919,7730,8401,7774,7903,8485,6983,8216,6786,6181,3561,7986,7659,5330,8769,9088,7199,7388,4920,6314,7979)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a