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