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