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