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 volume!=4  AND produit IN(0,9076,6968,6253,9136,8383,7826,4147,9036,2104,7801,5190,8377,7662,8346,1840,7897,7742,7916,8450,4143,4650,8447,6255,6259,7918,8442,7919,9067,7382,4149,7771,8256,6723,7747,4654,6694,9161,9107,9086,6879,9084,6947,7594,7006,9114,6256,4626,7926,7856,1839,7892,9230,8321,7917,6882,6880,7457,9082,8420,4250,9174,9151,8312,6454,7621,9164,9147,8384,7212,7597,9064,9150,8361,6449,7661,8371,9139,9148,8967,7456,9083,8396,9171,9097,7763,6451,8358,9220,9165,8415,7868,7592,7767,1844,9106,7790,3479,8372,9065,9176,8421,7462,9006,9131,7647,7622,8258,9130,9167,6443,6709,9172,9100,8359,6680,9066,9166,8416,7872,8260,7925,9222,9089,7743,7492,8345,9113,9090,7469,7778,8311,9163,9175,8347,6442,8349,9224,9124,6938,6655,9120,9119,3463,7459,8255,9135,8348,6944,7732,8929,9054,8351,6902,2356,9127,7803,5138,9141,6899,6713,9153,7741,6922,8253,8355,6858,6932,7733,8964,9028,7023,6894,5366,9128,8350,8483,9096,9123,8385,7889,8254,9091,9157,7830,9037,9129,8380,9159,7748,9094,9102,6258,9229,9104,9217,9132,9133,8360,8933,9146,9115,9152,4146,9010,9050,8362,9011,9078,7673,8927,9079,7835,9154,9035,9062,9158,9018,9075,9126,9022,7833,9012,8931,9101,9077,7521,9061,8924,9160,9026,5134,8975,9117,8974,8906,9138,9049,9044,9081,9169,9149,7832,2609,8998,9059,3261,9080,8946,4632,9095,9060,9030,6964,6850,9004,5091,9053,8935,9125,9007,9034,8993,3855,4653,9057,8462,4652,8453,4640,9116,9033,9179,9241,9137,9173,8452,9098,5427,9069,8963,7865,8908,9027,9013,9055,9043,6963,3777,9418,9003,5322,6961,5407,4849,9168,9156,8900,8968,8518,8319,5135,9038,8954,8243,8921,8241,8812,7489,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,8991,8907,8985,7841,5375,7219,5149,5890,8978,7157,9134,8811,8461,8316,5884,8918,9008,7009,8951,7893,8370,8999,8958,6232,7667,5875,8460,2107,6157,7866,8340,7161,8909,8919,9408,5137,6706,7712,5336,8813,8976,7736,5431,7928,8893,6853,5321,8910,8449,8398,6732,8507,3989,6877,6854,8325,6263,4663,5293,8324,8454,8436,6966,7887,8365,8315,2598,8973,8392,7770,8904,7923,8793,5329,5426,7576,8297,8891,7226,5315,8455,8400,8323,8435,7816,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,7894,8959,5307,4561,8970,8249,8987,8922,8428,8517,5817,6210,8464,8883,2101,7819,7422,7131,8992,8341,5768,5326,8326,8456,7677,7589,8364,8322,7851,7922,7737,1294,8363,8529,7441,5444,9009,9058,4042,5831,8408,3028,8245,8938,7567,8427,5899,7011,8519,6169,2839,6960,8521,7435,9056,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,7427,8942,7133,8433,4155,8318,7663,8937,3140,9039,5306,7895,4037,5422,5873,7384,6874,8338,7048,7420,8949,7130,8889,8888,7890,8528,4041,8432,5435,7416,8493,6861,3918,5465,8247,7862,8913,6006,8969,7850,2837,8885,8480,8443,8504,8445,8880,7603,8343,8329,8213,5438,8892,5920,8352,5437,8660,4043,7447,6737,6759,5182,5470,8986,7063,7386,6754,8414,7781,7628,7649,7585,7436,8869,3846,8221,8417,4036,8884,7921,5898,9031,8280,7813,8666,8470,7845,7644,5896,5816,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,7437,3004,8667,8981,8513,6982,6773,8499,8003,6200,7715,8514,6204,8479,8940,6929,8275,8520,8886,7787,8298,6490,8239,7716,7896,7717,7438,3179,8272,6864,5278,7811,7710,3432,6873,8486,8947,8257,8936,8911,6705,6727,8404,7387,4266,7590,8403,8332,8525,6286,6240,8331,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,6958,7690,7598,6990,8527,6682,8217,6875,7400,5798,8664,7671,8441,8251,8510,8279,6955,6690,7432,6949,8274,8526,3998,7001,8522,6999,3952,7442,6708,7428,5301,8264,7067,8237,7056,8437,8281,8500,5303,8440,7634,7000,5332,7049,8233,4759,6687,4799,8227,7631,8397,8277,8887,7758,7615,8231,7753,7658,3788,7620,6978,7443,6684,7588,7635,8228,8313,8235,7682,7859,7411,7651,5175,5471,7424,8295,4432,6876,7650,3446,3254,5325,7610,7633,7616,7729,5468,7573,6996,7632,4587,7490,7820,7606,4158,7389,7744,8004,7639,6650,8335,8881,7410,8961,8898,7792,6871,6740,7630,4287,8444,8739,4000,8476,7379,8962,6868,7875,8229,8423,7390,7385,8234,7828,8302,8337,6733,7581,6691,6749,8009,6885,6688,8357,7903,7491,7730,7026,7624,6181,6829,7392,7445,8487,6786,7774,5330,7434,7021,7025,8422,5384,7577,7642,8391,7583,7426,7829,6919,6866,5178,7643,7659,8516,7498,8485,8334,7440,8282,7776,5824,8477,6668,2602,9103,6284,7870,8425,6692,8381,3362,8424,8515,7423,8216,2003,4612,6667,7017,7414,7672,5759,4920,5924,8941,3561,9099,9088,7388,8215,8401,6983,7419,4745)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%59%' ORDER BY (id-(20*num)) DESCErr153a