SELECT id,marque,site,isable,ise,ghost,url,nom_es,alt,couleur_es couleur,essentiel_es 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,7647,8764,7868,7462,5366,7459,3479,1840,6899,7873,8762,6655,9365,4654,9084,1844,6879,9366,9220,2104,8483,9174,9369,8565,7382,6723,6259,8791,9278,8362,5190,7833,7492,8299,9289,9525,9067,6443,9095,4149,8812,7469,9230,8419,6680,7919,6932,8342,7664,9270,8385,9407,7800,7673,7743,6944,9268,9076,9090,6716,9306,9151,9276,7918,9275,7830,4143,9404,9035,9295,7917,7592,8882,9175,4626,8815,9107,8372,8933,4632,8371,9240,7856,6255,8906,6253,8358,4650,9148,4147,8383,9294,8384,9086,8258,7763,8814,8256,5138,4250,8793,9239,8378,8900,8380,2356,9153,8311,9006,8447,8254,1839,7916,9130,8374,7920,9164,8416,9066,9147,8255,6256,9065,8415,9163,7927,9171,8304,8377,9064,8355,9222,8345,8920,8361,7767,9172,7741,7853,3463,9115,9083,8253,7771,8929,8421,9120,7212,9139,7855,9089,6947,8924,8260,9037,1288,8915,7778,8344,8379,8810,7756,9062,8356,9093,8351,9036,8349,9116,9082,8346,8919,9100,9161,8918,7580,8348,9044,8967,9075,6938,9043,9418,6858,8931,1281,8963,8347,9034,8530,8359,6713,9010,7732,7456,6449,7826,8560,4257,9011,9149,6454,5134,7742,9113,8396,8450,7835,8353,8561,7023,7733,8959,7621,8811,7594,8869,9054,7661,8935,7926,9217,5388,7457,7597,8442,9135,9106,6709,6894,4146,9042,7889,6922,8908,9119,9136,8312,9091,7803,8916,7925,7832,5101,7622,9104,6258,7662,9038,7801,7748,9150,7747,5098,8350,5937,8944,9078,5091,5099,9030,9001,8917,8946,8926,7881,4653,8971,5135,8921,7880,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,8044,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( ) ORDER BY (id-(20*num)) DESCErr153a