SELECT id,marque,site,isable,ise,ghost,url,nom,alt,couleur couleur,essentiel txt,prix,promo,prixo, photo, 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,9036,2104,1840,7897,7742,4650,8447,7918,9067,7382,4149,4654,6694,9121,6879,7006,9114,1839,7892,9230,8321,6882,6880,7457,8420,9174,9151,6454,9164,9147,7212,9064,9150,6449,9139,9148,7456,9171,9097,6451,9220,9165,7868,7592,1844,9106,9065,9176,7462,9006,9131,7622,9130,9167,8966,6443,9172,9100,9066,9166,9222,9089,7743,7492,9113,9090,6252,7469,9163,9175,6442,9224,9124,6655,9120,9119,7459,9135,9144,8929,9054,2356,9127,5138,9141,6899,9068,9153,7741,9111,9145,8964,9028,5366,9128,8483,9096,9123,9091,9157,9037,9129,8380,9218,9159,9094,9102,9229,9104,9217,9132,9112,9133,8360,8933,9146,9115,9152,9010,9050,9011,9078,8927,9079,7835,9154,9035,9062,9158,9018,9075,9126,9022,7833,9012,8931,9101,9077,7521,9061,8924,9110,9021,9160,9170,9026,5134,8975,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,9508,9007,9034,8993,9506,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,3777,9418,5354,9003,5322,6961,5407,4849,9168,9156,8900,8968,8518,8319,5135,9038,8954,8243,8921,8241,8812,7489,8928,9032,7004,8997,6734,2610,7864,5760,7854,9092,8434,9025,5408,9416,9074,9023,8917,7888,8915,9122,8791,8990,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,8948,4678,5136,9001,8366,8495,5343,9048,7874,8491,7867,8957,8465,8815,4205,8944,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,5375,7219,5149,5890,8978,7157,9134,8811,8461,7008,8316,5884,9502,8918,9008,7009,9501,8951,7893,8370,8999,7068,9500,8958,6232,7667,9497,5875,8460,2107,9496,6157,7866,8914,8340,7161,8909,8919,9408,5137,6706,7712,5336,8813,8976,7736,5431,7928,8893,7153,6853,5321,8910,8449,8398,6732,8507,3989,6877,6854,8325,6263,4663,5293,8324,8454,8436,6966,7010,7887,8365,8315,2598,8973,8392,7770,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,7471,6787,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,8428,8517,5817,6210,8464,8883,2101,7819,7422,7131,8992,5443,8341,5768,5326,8326,8456,7677,7589,8364,8322,7851,7922,7737,1294,8363,8529,6846,7441,5444,9009,7714,9058,4042,5831,8408,3028,8245,8938,7567,8427,5899,7011,8519,6169,2839,6960,8521,7435,7061,9056,5440,8463,8405,589,1812,8950,7930,8418,7569,8484,5436,8429,8446,8840,8439,8982,7858,6967,4045,8225,7668,8994,4834,7429,8905,4667,8506,8508,7711,8984,6685,8497,7900,7427,8367,8942,7133,8433,4155,8318,7663,8937,3140,9039,5306,7895,4037,5422,5873,7384,6874,8338,7048,7420,7160,8949,7130,8889,7705,8888,7890,8528,4041,8432,5435,7416,7013,8493,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,7447,6862,6737,6759,5182,5470,8986,7063,7386,6754,8414,8407,7781,7628,7818,6758,7649,7593,7585,7605,7436,8869,3846,8221,8417,4036,8884,6844,7921,5898,9031,8280,7813,8666,8470,7845,7644,5896,5816,6837,5191,5434,8488,8395,8230,6970,7783,7669,8473,2838,8261,8393,7599,5409,8214,7680,8995,6731,8912,7706,8268,8394,4622,6977,7857,8512,8478,7162,7446,7637,8223,8501,3861,7929,7444,4597,6472,7807,7430,8278,8336,7574,8430,7612,6487,6843,7437,7024,3004,8667,8505,5439,8981,8513,6982,6773,8499,8003,6200,7715,8514,6204,7159,8479,8502,8940,7158,8566,6929,8275,8511,8520,8705,8886,7787,8298,7307,6490,6842,8239,7716,7896,7717,7438,3179,8272,7563,6864,5278,7811,7710,3432,6873,8486,6841,8947,8257,8936,5785,8911,6705,6727,8404,7387,4266,7590,8403,8332,8503,8525,6286,6240,8331,8406,7825,7814,8330,8232,6863,8271,7636,7586,7683,8222,8252,7782,7665,8498,6249,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,7432,6949,8274,7154,8526,3998,8564,7001,8522,6999,3952,7846,7442,6708,7428,5301,8264,7067,8237,7056,8437,8281,8500,5303,8440,7634,8567,7000,5332,7049,8233,4759,6687,4799,8227,7631,8397,8277,8887,7758,6888,7615,8231,7753,7658,3788,7620,6978,7443,6684,7588,7635,8228,8313,8235,7682,3128,7859,7411,7651,5175,5471,7424,8295,4432,6876,7650,3446,3254,6838,5325,7610,7633,7616,7729,5468,7573,6996,7632,4587,7490,7820,7606,4158,7389,7744,8004,7639,6650,6848,8335,8881,7410,8961,8898,7792,6871,6740,7630,2611,4287,6883,8444,8739,4000,8476,7379,8962,6868,7452,6887,7875,8229,8423,7390,7385,8234,7828,8302,8337,6733,7581,6691,6749,7899,7617,8009,7022,4001,6885,5584,7118,6688,7403,8357,6160,6926,7903,7491,6954,8474,7730,2463,7425,7026,8219,7624,8509,6181,6829,3881,8489,8196,8494,4898,7392,7129,5218,7445,6816,8487,7777,6671,4774,7775,6786,7774,8236,6923,8273,5330,2464,7434,7607,8204,7641,5827,6175,7021,7723,7025,8422,5384,7577,6217,6199,7817,7642,8391,7583,7584,7426,8262,7829,2606,7417,6919,6040,6866,6273,5178,7871,7643,7659,8516,7498,7768,7591,8485,9020,8334,7440,8282,7776,7660,4268,5824,6818,8477,7812,7844,6668,2602,9103,6284,7870,8425,6692,8381,3362,8424,7596,7578,8515,6972,7822,3844,7423,8216,8267,2003,6238,4612,1289,2825,7572,8496,6667,7017,6941,8431,8218,7414,7672,2608,5759,4920,6489,8220,5174,5924,8941,3561,9142,9099,9088,7388,5811,4922,6886,8215,8401,7380,6983,6942,7419,4745,6646)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%61%' 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