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