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