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,9076,6968,6253,9136,8383,7826,4147,9036,2104,7801,8377,7662,8346,1840,7897,7916,8450,4143,4650,8447,6255,6259,7918,8442,7919,7382,4149,7771,8256,6723,7747,4654,9161,9107,9086,9121,6879,9084,6947,7594,7006,9114,6256,4626,7926,7856,1839,7892,6257,9230,9071,8321,7917,6882,6880,9085,7457,9082,8420,4250,9174,9151,8312,6454,7621,9164,9147,8384,7212,7597,9064,9150,8361,6449,9162,7661,8371,9139,9148,8967,9083,8396,9171,9097,7763,6451,8412,8358,9220,9165,8415,7868,7592,7767,1844,9106,6251,7790,8372,9065,9176,8421,9087,9006,9131,7647,7622,8258,9130,9167,8966,6443,6709,9172,9100,8359,7648,6680,9066,9166,8416,7872,8260,7925,9222,9089,7743,8345,9113,9090,6252,7469,7778,8311,9163,9175,8347,6442,9073,8349,9224,9124,6938,9120,9119,7459,8255,9135,9144,8348,6944,7732,8929,9054,8351,6902,9072,2356,9127,7803,5138,9141,6899,6713,9068,9153,7741,6922,8253,8355,9111,9145,6858,6932,9028,7023,6894,9070,5366,9128,8350,8483,9096,9123,8385,7889,8254,9091,9157,7830,8965,9037,9129,8380,9218,9159,7748,9094,9102,6258,9229,9104,9217,9132,9112,9133,8360,8933,9146,9115,9152,4146,9010,8362,9011,7673,8927,9079,7835,9154,9035,9062,9158,9075,9126,9022,7833,9012,8931,9101,9077,7521,9061,8924,9110,9021,9160,9170,5134,9117,8974,8906,9138,9109,9049,9044,9081,9169,9149,7832,2609,8998,9059,3261,9080,8946,4632,9095,9060,9030,6964,6850,9004,5091,9053,8935,9125,9007,9034,8993,3855,4653,9057,8930,8462,4652,8453,9063,4640,9116,9033,9179,9241,6945,9105,9108,9137,9173,8452,9098,5427,9069,8963,7865,8908,9027,9013,9055,9043,6963,9418,5354,9003,5322,6961,5407,4849,9168,9156,8900,8518,8319,5135,8954,8243,8921,8241,8812,7489,8928,9032,7004,8997,6734,2610,7864,5760,7854,9092,8434,9025,5408,9416,9074,8917,7888,8915,9122,8791,7863,8972,5139,9052,8926,9047,7062,3027,3789,9002,8810,8314,9093,8960,6974,8989,9042,6962,8327,9051,8448,7383,8920,6881,7184,8945,8916,8955,7764,4264,7094,8468,5136,9001,8366,5343,7874,8491,7867,8957,8465,8815,4205,9019,8882,8242,7861,6208,8953,8469,5140,1823,8903,6959,8952,8339,8814,9041,5473,8342,4591,9000,8523,8240,7059,7381,8971,8386,5316,9024,7005,8991,8907,8985,7841,7219,5149,5890,8978,7157,9134,8811,8461,7008,8316,5884,8918,9008,7009,8951,7893,8370,8999,7068,8958,6232,7667,5875,8460,2107,7866,8914,8340,8909,8919,9408,5137,6706,7712,5336,8813,8976,7736,5431,7928,8893,7153,5321,8910,8449,8398,6732,8507,6877,6854,8325,6263,4663,8324,8454,8436,6966,7010,7887,8365,8315,2598,8973,8392,8904,7923,8793,5329,5426,7576,8297,8891,6847,7226,5315,8455,8400,8323,8435,7816,7609,8250,8375,8248,7709,8983,8890,8466,6755,7391,7734,7898,4656,6261,5433,8943,8899,8246,7735,8939,6739,8467,8894,6859,7842,7894,8923,8959,5307,4561,8970,8249,8987,8922,8517,5817,6210,8883,2101,7819,7131,8992,5443,8341,5768,5326,8326,8456,7677,7589,8364,8322,7851,7922,7737,1294,8363,8529,6846,5444,9009,7714,9058,4042,8408,8245,8938,8427,5899,7011,8519,6169,2839,6960,8521,7061,9056,5440,8463,8405,589,1812,8950,7930,8418,8484,5436,8429,8446,8439,8982,7858,6967,4045,8225,7668,8994,4834,7429,8905,8506,8508,7711,8984,6685,8497,7900,7427,8367,8433,8318,7663,8937,9039,5306,7895,4037,5422,5873,7384,6874,8338,7048,7420,7160,8949,7130,8889,7705,8888,7890,8528,4041,8432,5435,7013,6861,3918,5465,8247,7862,8913,6006,8969,7850,8559,2837,8885,7750,8480,8443,8504,8445,8880,7603,8343,8329,8213,5438,8892,5920,8352,5437,8660,4043,6862,6737,6759,5470,8986,7063,7386,6754,8414,8407,7781,7628,7818,6758,7649,7593,7585,7605,3846,8221,8417,4036,8884,6844,7921,9031,8280,7813,8666,8470,7845,7644,5816,6837,5191,5434,8488,8395,8230,6970,7783,8473,8261,8393,7599,5409,8214,7680,8995,6731,8912,7706,8268,8394,6977,7857,8512,8478,7162,7637,8223,8501,3861,7929,7444,4597,6472,8278,8336,7574,8430,7612,6843,7024,8667,8505,5439,8981,8513,6982,6773,8499,8003,6200,7715,6204,7159,8479,8502,8940,7158,8566,6929,8275,8511,8520,8705,8886,7787,8298,7307,6842,8239,7716,7896,8272,6864,5278,7811,7710,3432,6873,8486,6841,8947,8257,8936,5785,8911,6705,6727,8404,7387,7590,8403,8332,8503,8525,6240,8331,8406,7814,8330,8232,6863,8271,7636,7586,7683,8222,8252,7782,7665,8498,8438,7595,7619,7860,7815,6878,8226,8399,8481,7788,7587,8328,8276,5834,6958,7690,7598,6990,8527,6682,8217,6875,7495,6845,7400,5798,8664,7671,8441,8251,8510,8279,6955,6690,8274,7154,8526,3998,8564,7001,8522,6999,3952,7846,6708,5301,8264,7067,8237,7056,8437,8281,8500,5303,8440,8567,7000,5332,8233,4759,4799,8227,7631,8397,8277,8887,7758,6888,7615,8231,7658,3788,7620,6978,6684,7588,7635,8228,8313,8235,3128,7859,7651,5175,5471,7424,4432,6876,7650,3254,6838,5325,7633,7616,7729,5468,6996,7632,4587,7490,7820,7606,4158,7744,8004,6650,6848,8335,8881,7410,8961,8898,7792,6871,6740,7630,4287,6883,8444,8739,7379,8962,6868,7452,6887,7875,8423,8234,7828,8302,8337,6733,6691,7899,7022,6885,5584,6688,6926,7903,7491,8474,7730,2463,7425,8219,7624,6829,3881,8489,8196,8494,7392,5218,8487,7777,6671,7775,7774,8236,8273,5330,2464,7434,7607,8204,7641,5827,8422,6217,6199,7817,8391,7583,7584,7426,8262,7829,6040,6866,7871,7659,8516,7768,7591,8485,9020,8334,7776,7660,4268,5824,6818,8477,7812,7844,6668,9103,6284,7870,8425,6692,8381,8424,7596,8515,6972,7822,3844,7423,8216,8267,6238,1289,8496,6667,6941,8431,8218,7672,4920,8220,5174,9142,9099,9088,4922,6886,8215,8401,6983,6942)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%58%' 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