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,9340,9383,6944,9335,8877,7748,7382,8907,7801,8342,6596,8362,9377,9388,6922,9245,3827,6894,7556,9220,7925,8319,1844,6449,6349,7943,6258,2104,8919,9366,9144,6945,7918,8031,7110,6257,7961,4650,9084,6804,9068,9276,9284,5656,6716,6879,8931,6255,9254,9360,6252,7545,9382,7647,8735,7842,9369,8576,8327,9525,7897,7709,7846,7892,8924,7818,9265,9302,8350,9356,9344,6259,9368,8019,8483,8960,9522,9289,8175,9524,6899,9526,9520,9270,8224,9519,5937,9515,9518,9268,9514,9517,9136,9513,9484,8965,9512,9479,9278,7543,9478,9072,7898,5138,8211,9490,9477,9365,9487,5366,7873,9486,9121,6454,9485,9463,7830,9483,9423,8355,9482,9425,9230,9481,9410,9275,9475,9322,8344,9480,9111,9071,9474,9390,7673,9473,7476,8379,9472,7394,9087,9446,8562,8384,9471,6504,9070,9461,7482,7457,9460,7470,7212,9459,6459,4149,9458,1839,7920,9457,5094,9404,9453,9174,9085,9452,9037,9073,9451,6850,8416,9255,1840,8415,9449,9384,9107,9445,5111,8967,9444,8821,7664,9443,7153,8356,9441,9389,8377,9440,7945,9162,9439,7475,8447,9438,6004,9082,9437,7522,9161,9436,7478,9083,9435,9303,8966,9434,8872,8450,9433,6611,6256,9432,7408,4147,9431,7521,9086,9429,9447,4143,9428,9476,8953,9427,9450,4626,9426,9442,7826,9418,6601,8371,9417,7006,8312,9416,9422,8952,9415,6503,8372,9414,8586,8951,9413,9328,8395,6859,7833,8511,9408,5745,8421,9258,9420,8358,7542,4652,7917,9374,9411,8359,8622,7218,6251,9092,9409,8353,9354,8895,7916,7558,6132,8412,9119,5133,8383,9105,9301,7919,9054,6127,8378,9345,1814,8351,8780,9014,7763,9269,9364,8361,8778,2356,8396,9024,7377,7597,8711,7477,8349,9145,8897,8442,9281,7949,8394,3002,7832,7767,9244,3191,7592,9333,9304,8254,6109,9421,7024,9226,8900,6938,8889,5091,7926,8742,9448,4250,2461,9430,8512,9032,6377,8258,9234,8921,7778,8834,3196,7856,8736,8928,8393,9406,7473,8347,7322,9329,6862,8741,8933,7771,8994,8365,7594,6968,9206,6253,9405,9336,6858,9402,7004,7741,9401,9419,7743,9400,9412,8346,9399,9403,4146,9397,9205,8345,9396,9204,8260,9395,5108,8311,9394,9171,8256,9282,8722,7621,9393,9327,8253,9090,9202,8255,9392,8882,8380,9150,9363,8348,9134,9362,7732,8656,9222,7023,9028,1809,1288,9381,5322,6713,9380,5132,4257,6108,7184,7661,9229,8597,8044,9379,7947,6947,9376,7523,7900,9343,6599,6932,9375,9342,7662,9175,9334,7889,9147,9305,6680,9015,9391,7803,9149,9224,7747,9287,9218,7648,9373,8920,7868,9233,9217,7469,9372,8326,6723,9371,6124,6709,9370,7938,6443,8945,5136,7459,9367,8016,8385,9359,9016,7622,9357,8599,9355,5109,9353,5473,9106,7712,9352,4653,9351,5139,8867,9172,9286,6734,9235,8593,9299,8918,9350,9164,9349,8890,9348,9163,9012,9158,9201,7008,9347,9139,9200,6610,8737,8595,9346,9035,9199,8094,9198,3123,7554,6597,9197,5315,9236,6506,9231,8569,9232,9130,9338,9424,9196,7940,9283,7068,8959,9117,9337,6609,6492,9017,9195,5134,9194,9120,9193,1811,9332,9115,9192,7874,9331,9094,8830,9093,9146,7944,9191,7219,9330,9076,9326,9075,9190,9398,9062,9074,9325,9066,9189,9065,9324,9064,9188,9063,9313,9044,9187,7009,9312,9043,9186,9042,9311,8790,9185,9179,9132,9277,9184,9341,9183,7565,9298,7564,9182,6461,9297,8914,3621,8904,9181,4654,9296,8899,9180,8926,9293,9036,9292,8905,8673,9030,9288,9173,6384,7854,9114,9013,9280,9006,9153,7764,9279,9168,8913,9361,9152,8908,9274,9010,9273,8971,9272,8958,9271,8957,9148,6612,9266,8954,9257,8398,5535,9250,9249,5135,9300,8020,9165,7005,9248,5994,9247,8367,8997,8875,9246,8930,8670,9112,9243,9091,9242,8929,9241,7131,9238,9339,9237,6755,7137,8922,5950,5987,9031,7954,7451,9135,9227,5316,9225,8364,8799,8917,2991,9034,9089,8916,8738,7734,8962,9267,9310,8915,9151,8910,9291,4042,8846,9011,8163,8998,8912,8903,7922,5140,8819,8363,8757,7736,8963,9125,9170,9123,8894,8626,8883,9122,5433,8321,8935,8584,8842,8868,8879,9285,7737,8756,9116,5537,8876,7366,7955,8861,7750,8706,7059,8827,9109,9104,7951,3769,8870,8829,8634,8845,9108,9055,8668,9228,8857,8138,9095,8449,5444,9176,7217,9069,8855,9160,8854,8772,8568,9378,7711,9002,8848,8880,5307,8577,8841,5624,8408,8796,9021,8303,7398,8603,7841,8993,8896,8784,8588,8763,2837,4640,8820,8243,8815,9138,8324,9137,4563,8873,8814,8643,8813,9126,6145,7921,6565,8171,8691,9124,8732,8080,8812,8893,8744,7329,8811,9004,7130,4632,7858,8850,7472,8992,7486,7952,8809,9009,8810,7987,5966,8750,8366,9290,8787,8047,7541,5443,8727,7216,8749,7395,7976,6606,8991,8794,9081,5137,9080,8793,7993,5306,8986,7942,8733,8923,8642,8791,9098,2107,8592,8719,9056,8789,8874,7294,8768,3124,9051,6171,8969,8375,9047,8776,9041,5899,9039,7705,8453,8906,9159,9096,9157,8775,7495,3126,9057,8774,8039,7048,8887,8666,9025,8746,8858,6754,9141,6598,8241,5967,9008,2839,9007,8853,7888,8688,8123,3122,9003,8725,7387,8866,8029,6000,7363,8860,8462,6464,6291,5470,8658,4834,3855,8708,9000,8782,6877,9128,8781,8999,8946,9127,8832,8995,8125,8734,5321,8469,4043,8765,8771,4562,6296,8606,8909,8667,9110,8747,9001,8665,8984,8692,8983,8807,8777,6013,8461,8721,8982,1812,8981,8720,6961,7374,7893,6739,7489,7536,8891,9169,8314,8685,8591,7297,8972,9143,8970,6006,8989,8705,7896,8704,5465,8770,8703,7867,6007,9061,8779,9060,9113,8707,8699,9059,6151,8888,8859,8323,8773,7895,5439,8949,5438,8499,5437,8767,8598,8947,6143,9053,8856,7726,8849,9052,6607,8940,8645,6960,4561,8939,8745,8671,6155,8865,3188,9049,4045,8580,4041,8936,4037,9033,3129,9100,8718,8911,8663,9027,8632,8892,8662,8465,8927,8660,8652,8340,8696,9019,8788,6880,7171,6284,6474,8026,7845,8728,6977,8886,6413,8884,8407,6232,7928,8683,8325,8828,5890,6959,7835,8119,8457,8315,7930,7731,8518,8608,8144,8619,5407,6208,3657,8233,6403,8729,7238,8621,5920,8028,4279,8987,8001,7606,8575,7474,8851,7484,8339,7295,9131,9129,6603,7368,8434,8617,4554,8726,7850,8978,6415,8730,8589,8717,8459,7992,8612,7989,7819,7729,6882,8885,7562,8852,7013,7725,5031,9022,8502,8950,8146,8003,7887,7406,8615,8523,8709,6412,9077,8443,8559,8519,8037,7306,6964,7851,8974,7935,8079,5004,8740,3609,8937,4423,7293,9166,4422,8466,6210,8240,8448,9156,6495,8034,4656,8118,6602,8480,8018,6854,3610,8702,5009,7226,7239,8753,7714,8600,3261,8250,6362,8522,4591,8275,7929,8743,6505,6302,8638,8655,8637,7480,8766,8818,8684,8878,8631,4368,8731,6169,8630,7331,8628,7420,8661,8452,8627,8397,7787,7204,8166,7544,8280,4429,8624,8160,8439,8651,7574,8611,8167,8454,8513,7384,7946,8601,8570,6261,6731,8641,6846,8467,5875,7299,7464,8748,8590,9101,7950,8646,7863,8620,5427,8862,6837,8864,8435,6963,7236,7985,7956,9097,6844,8322,8436,6888,6564,8427,8585,8644,5991,8607,8501,7330,7991,6685,8754,5511,8610,8046,6966,7603,8647,5768,6491,6970,8973,7157,8510,6502,7391,5435,7996,8297,8609,7062,5329,5408,8468,7303,4497,7538,7424,7309,8618,7936,6390,8370,8847,5093,8664,5092,8955,8392,8739,7361,9133,4663,2609,8126,3846,8604,8674,7061,8122,5884,8004,8701,7960,8824,8230,8822,6306,8697,8792,8635,6318,8693,6955,8633,9102,8800,8723,8686,8460,8405,6883,8124,8695,7981,8433,6874,8084,8074,8145,8245,8316,5434,5326,7890,7493,7571,8724,7549,1294,5409,5354,7632,7593,7383,8400,9058,7995,6962,7010,6861,4849,8491,7814,7706,7649,7210,8226,6604,1823,7393,7588,8446,8566,7663,8463,6758,8318,7349,8235,8751,8508,8639,6240,8517,6472,7862,7381,8143,8526,7965,8527,7468,8437,7864,8825,7637,8529,7667,8669,5645,8470,8221,8027,7247,8564,7351,4432,7158,8649,3023,7229,6929,8976,7548,8248,7458,8246,7160,8567,8506,7172,7235,5336,7251,3432,7352,8420,7488,7971,8008,6290,5426,5760,8002,5422,6566,7816,6847,8414,3789,2101,8507,8943,6974,8486,7355,6406,7735,8343,7861,8341,7551,5149,5436,8213,8596,7599,4485,8136,5343,6405,7413,5817,7941,8231,7094,8076,7241,8613,2598,9167,7605,589,7964,8242,7937,7923,8278,3128,7399,8429,7539,7386,7307,8525,8128,9154,6759,7372,6361,7586,7550,6868,4036,8505,6978,7650,5997,8261,7715,8276,7159,2610,5989,5481,7609,6408,7983,7866,8445,8271,8017,8455,5440,6737,8249,6422,8042,7533,7365,7485,7282,3861,7668,7865,8010,6096,7628,7857,6843,8614,6773,8237,7162,3680,8521,8602,8329,8137,6508,8432,8783,8232,8698,9079,8690,8247,8687,4264,8640,8520,7939,7811,7680,8500,8024,7590,5873,8274,8013,8335,6684,5431,7677,8484,7313,6204,8587,8302,7063,6498,6365,8336,7308,7978,8871,7589,5471,7444,8808,7312,8251,6200,6996,3029,8162,8473,7957,7427,8636,7367,8823,8168,7318,8239,8694,6383,6509,7362,6863,8985,7407,7328,8072,7396,7290,4205,6878,7173,8055,8272,8071,8332,8051,8654,7487,8481,5468,7633,8120,8430,6364,8228,6499,6887,7166,3918,7203,8456,7378,6864,2363,8938,8797,8898,7552,8170,7319,7364,7001,5191,7859,7585,5301,8352,7758,8338,8095,8478,7630,8223,8279,7894,6690,8264,4587,7291,7792,8528,7540,5332,7056,7644,6682,7815,6845,8426,4287,6263,7631,6727,7636,7302,6740,6650,8025,8078,8313,8418,7635,6958,6875,8217,6708,6312,6876,7011,7520,6706,8961,7400,6848,7899,6417,8214,7744,7813,7405,7619,7067,8441,7820,8406,7671,7371,7788,7576,8281,5816,4491,6982,8277,8659,6352,7429,5278,6692,6842,7782,7860,8225,7534,7379,8252,8005,8444,8417,8403,7598,3008,8117,5785,3027,8077,6317,6873,8438,3998,7587,5303,5325,5798,7596,6990,7781,7665,8423,7716,4456,8503,3254,8328,7783,6633,8222,8798,6691,7612,7620,7710,8298,8831,7828,4597,5175,8075,8425,6841,7410,6647,8234,5738,6407,5107,8498,6613,8440,7532,8504,7980,8479,7311,8135,6705,3952,8404,7373,8330,7452,7154,6881,8399,7301,6340,8083,8331,6102,7253,8497,7000,6668,1569,6967,7616,8381,7177,8227,8653,8386,8097,6733,8629,7490,8257,8268,5834,8337,7537,6732,8129,6871,8100,7658,7595,9358,8014,8023,5969,8839,8881,9103,7357,8700,6501,8752,3788,8625,7683,7449,6139,7167,4158,7997,7690,7972,7546,7258,4759,7870,8623,8488,6999,8431,6838,8833,7615,8334,5696,8267,7998,4799,8582,7651,6671,7423,8116,8714,8496,8710,6818,8758,7672,7168,7434,6238,6941,4922,3844,7022,6972,8053,6886,8516,4426,7624,8236,6885,8218,8477,9142,6942,8112,6199,8835,7727,8485,7776,8401,9020,8011,7425,7822,8838,7641,7336,6688,5824,8422,7871,7607,7979,7262,7809,7259,8103,8826,6344,7829,7591,8391,7584,7844,8220,8215,7775,7777,8262,8760,6101,9088,8616,8424,7812,8204,6667,6829,7659,8571,8216,7426,9099,5584,8786,8474,6926,7510,8152,7494,6382,8219,6082,4920,8273,6314,8836,8161,7227,7335,8259,8837,8196,6301,8863,6331,8159,7966,6441,7984,8715,6040,1289,7491,8716,8489,2464,2463,3881,8712,8605,6642,8033,8089,8087,7261,7274,5174,8515,6217,7875,6484,8142,8487,7660,8035,8785,8085,8672,6458,8049,7263,8475,6341,8105,7962,7260,7583,8088,5218,7903,6648,7817,8769,8795,6797,8131,6313,8713,7730,5330,8759,7963,6052,6332,8494,7768,8169,7774,6866,6800,8150,5827,8106,7392,4268,8238,6311,8151,7986,6592,8092,6983)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (id-(20*num)) DESCErr153a