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,7868,7462,5366,7459,1840,6899,6655,9365,4654,1844,6879,9366,9220,2104,8483,9174,9369,7382,8791,9278,7833,7492,9289,9525,9067,6443,9095,4149,8812,7469,9230,8342,9270,7743,9268,9076,9090,9151,9276,7918,9275,9404,9035,7592,8882,9175,8815,8933,4632,8906,6253,4650,9148,8814,5138,8793,8900,8380,2356,9153,9006,8447,1839,9130,9164,9066,9147,9065,9163,9171,9064,9222,8920,9172,7741,9115,8929,9120,7212,9139,9089,8924,9037,8915,8810,9062,9093,9036,9116,8919,9100,8918,9044,9075,9043,9418,8931,8963,9034,9010,7456,6449,9011,9149,6454,5134,7742,9113,7835,8959,8811,8869,9054,8935,9217,7457,9135,9106,9042,8908,9119,9136,9091,8916,7832,7622,9104,9038,9150,8944,9078,5091,9030,9001,8917,8946,8926,4653,8971,5135,8921,9013,4652,8890,9074,7854,7387,8903,8316,9224,3777,9124,5322,8813,5407,8899,9152,5139,7897,8964,3140,8904,2610,9117,9179,9069,5136,8957,6734,8434,8927,8518,9158,7521,8666,7864,9098,6850,8910,8905,8960,5473,9416,8954,8448,7874,8948,3789,8907,9007,9123,8366,5140,7764,8922,5427,9094,9166,7711,7863,8997,9096,9229,5408,8327,5315,9125,8449,7009,3261,5316,9146,8883,7898,4591,5137,7841,6964,7062,7184,4640,6877,7004,9092,7734,7922,7416,9028,9131,7059,6961,8990,9132,7710,8243,9241,8958,2107,8523,5307,8365,8913,3855,5321,7226,8325,6963,6968,8398,5884,7895,7712,8998,9128,8667,7736,1294,8370,7709,6880,8953,8889,7219,8375,8952,9173,7471,8968,9168,7489,7006,7892,5875,9126,8392,8894,8321,5306,5326,7737,8887,8893,5920,9165,6882,8507,8326,1812,8324,7133,8491,6962,8972,7130,9012,5760,7928,2598,8939,8951,7735,9033,5433,8962,4656,8339,8993,8249,9003,8453,9169,6204,6959,4561,6739,8241,5890,9408,7161,9138,8297,8886,8978,4041,8992,8949,8364,9027,8314,5896,6208,8408,6157,9176,8323,8245,9026,8439,8912,7858,1823,8888,9002,8480,8892,9048,9127,9004,7094,9122,4043,8982,7048,8452,8435,9061,6210,2837,8302,5470,5426,8319,9129,4834,4042,6960,2839,8315,6006,9057,7157,8340,7861,8242,7896,7851,9160,9134,5768,9052,5438,7437,6859,7567,8981,5444,7893,2838,9051,4155,7381,7770,6754,9023,8400,8456,6755,7606,8911,5898,5149,5343,8397,9137,6874,5899,6169,9024,9060,9039,8343,8436,4849,8446,8989,8514,8975,8363,8341,5431,9025,8660,8261,8974,9000,8529,9047,8942,7411,7888,7850,6861,7131,8880,8240,9018,5465,6966,8513,8248,7867,8986,8991,4663,8250,7422,8443,2609,4432,8987,6487,5437,9022,8476,7391,9041,9032,6232,7930,8969,7819,9159,8501,7574,9031,8280,8429,6787,7384,2101,8462,8495,8947,8395,8984,7807,9081,7845,8484,9009,8231,9114,4037,4045,7677,6955,9008,8940,8445,3004,8519,8937,8405,6731,8465,8909,5329,8329,9157,6685,7865,8394,8469,5831,8970,6694,8499,8318,8003,8891,7929,7386,8521,3846,6974,8995,7569,8427,6977,7787,9167,5409,8945,7420,8467,7663,5422,6970,6737,7667,7628,8004,9101,8983,8955,8512,8322,8428,8528,7862,8943,7890,3027,4205,8517,7866,8508,8506,7603,589,9080,8221,6706,7669,9050,6929,7680,9141,4036,7599,8460,7706,8936,8352,8278,8454,7668,3432,8999,8994,8393,4264,9097,6684,8432,6853,5375,5435,4667,7637,4622,5336,8246,8884,5434,9049,9154,6854,6759,8464,7162,9056,7432,6773,4678,6881,7715,6978,3989,7589,8950,7729,5436,9053,7716,7887,7923,8466,7612,7590,4266,9133,7631,6878,8985,8277,7744,3446,7610,7857,5471,8338,8279,8664,8468,8881,5817,4587,8463,7067,8414,8336,8500,8520,7630,8229,7636,8486,8235,7859,7650,7056,7753,7598,6708,9055,8527,6249,6240,3179,9059,7814,6732,8313,8478,7813,8233,8461,5301,8504,8526,8225,7049,7651,7576,8271,8976,8281,8430,7758,7921,8226,5303,8230,8335,6682,8274,4287,8222,6740,6261,8232,5468,8510,7001,7682,8739,8399,9079,6490,8498,7665,6472,7615,7428,7063,8961,8275,8330,8228,8331,5873,7424,7634,9019,7825,5191,8217,6286,7632,6949,8522,8251,8437,8214,6990,7586,8239,7595,7588,8973,7619,8403,7383,6705,8386,7442,4158,8252,8444,5278,7436,7717,6863,8404,8227,6873,8470,8938,7671,8257,8885,8237,7635,8433,7616,6690,7894,8473,4597,6996,7446,8213,7430,6876,3861,7639,6967,3998,7633,7860,6864,6875,8247,7788,7000,9102,7690,7811,8525,7792,7447,3788,9077,5182,4759,6200,7683,8420,7820,7438,8328,4799,7649,3918,4000,6999,7444,5798,2602,8295,7658,3028,7585,8441,7782,8264,5332,9058,7573,7441,8332,8479,8455,8418,8497,6727,8493,8298,8268,6958,8417,6263,7783,7781,5816,7644,8481,8840,7011,8276,5175,7816,6687,5293,8488,8223,8438,7815,6650,7429,8272,7587,3254,7620,5325,6871,6982,8423,6868,8234,7828,6691,7581,8898,7379,7390,7435,7427,8440,7389,7400,7385,7443,7490,7410,6733,6668,8337,7423,7021,6885,7577,8941,9099,5924,7491,7419,8357,8487,7026,8515,5384,6688,8477,8334,7434,7414,7643,7025,2003,3952,6667,5824,7776,8282,6829,8424,4612,8422,7426,7624,7440,5178,7498,4745,7642,8425,7583,6866,7829,7875,8516,6749,7017,8381,6692,3362,8215,7870,9156,9103,6284,5759,8009,8391,7672,7445,7392,6919,7730,8401,7774,7903,8485,6983,8216,6786,6181,3561,7659,5330,9088,7388,4920)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) 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