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