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