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