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=2 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,7993,7492,9344,8764,8070,9284,7647,9424,9234,6902,5366,8757,6442,6504,8867,7872,1840,7543,9136,7947,9290,9107,9328,8762,1205,6109,9161,9329,9353,6259,4654,8706,4143,1844,9166,9086,9174,9097,9084,9164,9151,8447,9130,8565,9045,9054,8371,9067,9176,7771,9006,9147,4147,9139,9028,6947,9076,9100,7856,9066,9165,4626,9113,8299,9040,9148,7916,9036,8974,8450,9222,9090,8312,9065,9131,7917,9163,9150,8416,8933,2104,8415,9171,8419,9177,9124,8377,8812,9167,6255,9011,9089,7826,9064,8968,4250,9035,9026,8372,8906,9128,8361,4650,5388,1073,8909,5190,9220,9106,8358,8882,9153,8345,8929,9022,7767,2356,9157,8383,8815,9132,9083,1839,8560,8062,9129,8256,9115,9159,7919,9120,9078,8384,8791,6879,8421,8810,9175,9082,8814,9127,6256,9172,8561,1976,8993,8258,5138,9101,7763,8908,9050,8378,8915,9062,7778,8900,2609,7927,7833,9126,8260,8964,9240,1068,9049,8311,8793,9123,7920,7835,9102,9230,9037,9104,8379,9096,9154,8356,8927,9007,8344,5134,9239,1973,4632,7800,8920,8978,8396,9091,9038,4149,8963,9004,8349,8946,9077,8355,9034,8452,8351,7832,8530,1061,9018,8346,9093,6968,8253,9044,9069,8967,4653,8453,8255,9224,6964,7664,9075,7382,8347,4652,7853,8064,9119,8359,8919,8972,8254,9135,3855,6713,8924,9081,7743,5091,6880,7661,7521,9225,7732,9043,5101,8063,4640,1288,3261,9418,7594,8971,6961,7926,8903,8955,8348,9010,9061,6253,5135,9033,7457,6850,997,9057,6938,8935,9001,6858,3777,9000,1281,9030,6963,6454,9217,8975,7742,9169,9324,8380,7854,7580,990,8893,7621,8917,9141,7212,9095,8891,3463,8998,9055,7741,8921,8989,7597,3789,9125,8353,9074,7880,8069,9098,8442,5139,9002,4257,9042,9079,7456,8931,4849,6449,8918,7865,7592,5407,9134,7023,8434,5098,987,5760,7733,5322,9027,6894,9143,8913,6655,5408,2610,7801,8944,9060,6709,9305,8945,7868,9339,7881,8059,9241,7462,8813,8990,5941,6974,7489,7790,7863,9003,7873,5427,8889,6899,8518,9047,7889,7864,5099,8058,8997,8385,8916,8243,6944,9277,9149,7459,8907,7892,7673,9267,8241,6680,5136,6962,8360,9303,7855,5741,9059,7830,8899,9357,6451,6734,8319,7469,8811,9080,7748,9384,6716,7094,9310,3479,9168,7756,8060,9281,8362,9361,8939,5937,8890,6959,7918,9398,8912,4146,9362,9056,7747,7006,9152,8483,9094,8304,8068,8495,8350,9116,7888,7803,8904,9133,6258,7004,8960,6922,8523,6208,6932,7184,8959,7925,7062,8374,8065,8949,7622,5890,9266,7662,9390,9146,6723,9342,9349,6443,9448,9012,8448,8314,9013,8066,9402,9476,9138,5343,9459,9322,9269,8926,9449,9409,8339,9334,8061,3027,9419,9416,9423,8985,5473,9247,9403,9408,9391,9413,7161,9395,9117,7383,9388,8994,6157,6881,9411,4264,8866,9228,7764,9458,7861,9331,9524,9474,7712,9023,9410,9433,9523,9258,5140,8970,9522,9156,4591,9428,5884,9393,9520,9446,7874,9358,9519,8242,7841,9461,9518,9380,9517,9460,9420,8240,9484,8943,9479,9287,9412,8888,8957,9025,9478,9052,9477,9376,8370,8983,8366,6706,2107,9471,9450,8987,9447,9053,9364,4678,9442,9244,9179,9024,9425,9292,8491,8976,9360,9226,9173,9415,9422,9291,6877,9293,9421,9526,7711,9429,9336,9515,9304,8316,9158,6232,7157,9250,5315,8938,2598,7867,5875,9513,9389,8973,9363,8995,8327,9512,8948,9490,8951,1823,8954,9487,8392,4205,5426,8886,8910,9486,9341,9485,8905,8892,7009,9274,9327,9483,5316,9379,4554,9439,7219,9482,9309,9436,8507,7381,8859,9481,9301,9048,6882,9480,8953,9452,5137,9475,8324,9417,9017,9325,8952,9399,7734,5149,8400,6853,5133,9473,9206,6854,9205,7471,8958,9472,8249,8449,9202,9426,8365,9280,5433,9245,8436,9355,8446,9397,7735,9457,8297,9229,4656,9242,7736,9453,7059,9347,9014,9288,5307,9451,5321,9405,5094,9326,8325,9374,5132,9114,7928,9248,8666,9445,6132,9378,7667,9392,1809,9444,8870,9427,8855,9443,9016,9441,8375,5375,8364,9440,6601,9254,8398,9137,7943,9438,6604,9401,6787,9437,1814,8340,4663,9373,8435,9435,8922,9160,6503,7770,8872,9400,8895,9434,8599,8465,7709,8386,7677,9381,5108,9432,8439,9370,1811,6732,1812,9431,8326,8342,8857,9051,8807,9396,8809,6169,8869,7866,3827,8937,8788,9346,7567,9265,8841,7576,8856,9377,8842,9311,5092,5336,5306,7893,8879,9337,7737,9414,8894,8999,8820,8984,8877,9372,8883,9340,7217,9406,5109,9272,8853,8992,7850,8991,6602,9255,8849,9243,7569,9257,4561,9368,8822,6694,8854,9354,8765,9271,8766,9350,7130,9394,8245,9351,3191,8315,7930,9279,7303,3989,8667,8529,7668,8911,6739,9333,4279,8454,8445,8982,8848,9298,8773,9330,7663,9375,6731,9019,8789,9338,6685,9299,8781,9122,8731,7897,8329,9237,8782,9371,8875,9313,4041,8464,8790,8341,6124,8456,5896,9367,6375,8455,8732,7894,5511,7226,7628,9359,7862,8338,8570,8885,8408,8942,6610,9356,6874,5329,3196,9058,6142,9352,8719,9032,8519,9249,7819,9348,5004,7923,8697,7887,8774,8884,5768,9345,7377,8880,8506,9343,4043,9286,6612,9300,6362,5431,5436,6263,7133,9335,8363,7391,6210,9332,6505,9092,7484,9312,6599,9285,6861,9283,3140,9246,5873,9282,2837,9273,5111,8250,7946,8321,7048,6966,5470,9297,5920,9181,8708,9296,7574,9227,8521,8834,8721,8428,8562,7422,4485,8462,7858,7816,7216,5816,8517,9189,8698,6960,6004,9039,2839,9190,6506,9233,7562,9041,8699,8248,6603,8432,7309,2101,8395,8484,7851,9008,6474,7898,8725,5817,5438,8969,6565,5326,8685,8981,8718,9191,8459,8323,5542,3028,8612,9236,5987,5293,3007,9188,4155,8840,7131,8343,6376,7895,8020,8528,7669,9184,8747,8418,5031,9238,8604,8322,5009,9235,8794,8878,4834,9232,5444,9231,8514,8735,8693,9200,6461,5831,4042,8429,5985,8741,8589,8845,7236,8950,7890,8887,2838,8827,5898,8865,6476,9187,8696,9186,7935,9031,7950,2991,6508,8819,6754,9185,6755,5182,8691,8473,8501,9183,8457,9009,8775,9182,6597,9180,8513,1294,7951,7922,8280,2461,5899,8947,6502,7420,5434,7441,5093,7599,7807,8852,6146,7384,8688,7435,8590,8352,7238,7416,7680,7589,8019,8868,8744,8414,4491,8427,5656,8864,7297,3621,6598,5422,8443,8851,8405,589,5409,8986,8704,8268,8722,6967,7845,8936,6415,8230,8703,7386,7706,8497,4597,3846,8686,8508,8018,8736,8017,8420,8684,8670,6006,8480,8720,8275,7954,7921,8569,8213,7298,8660,8687,8734,6475,4622,6473,7811,7162,7814,8639,8493,6035,7427,6127,7446,7929,6106,3123,6108,8665,8488,7374,7585,7488,8223,8016,8768,8593,8700,7944,3004,8701,7437,4423,8504,8221,8898,5967,8861,8624,3168,4422,8225,6564,8858,8393,6487,7295,8318,6495,3918,8167,6737,7637,7387,8166,8818,7486,9015,8633,8728,7531,8727,6013,8222,8013,8755,7956,8940,8003,7447,8143,5950,8640,8850,8596,3432,5966,5191,5465,8469,7936,6204,7063,6384,8630,8763,6377,7619,6977,7436,6171,8520,7941,8417,6497,7429,6759,8430,7239,7430,6609,7438,7612,8468,8645,8873,8598,4667,8635,8261,7523,7813,5541,7644,8278,8467,8126,7450,5030,8466,7983,8214,8668,6864,6929,6472,8588,7586,8628,8756,5435,8739,3609,8874,8632,8740,7171,8738,6001,8272,8568,6727,5437,6958,6412,8163,3008,7781,7300,8463,7474,7432,3124,7857,8663,8846,7241,8332,8047,7606,7533,7328,7536,8168,8585,8847,6773,8460,6143,8777,4563,6240,7355,8160,8652,8796,7995,8962,7485,8239,8627,8298,4562,6200,8001,8246,7965,8231,6496,8470,7224,6859,7349,7960,3657,8438,3122,8227,7538,8601,5991,8752,7294,8525,8634,7896,3126,8733,7981,8498,6403,8767,7715,7649,6007,8724,7234,8437,8631,3002,6607,5332,3188,6490,6151,7480,7603,8743,4045,8499,4037,8748,8394,7815,8512,8750,4036,8839,6970,8228,8125,8478,3094,4429,8074,7590,5969,8247,8176,7558,6000,8461,3610,7400,5989,8233,7550,8217,6018,8336,7235,8829,3129,8647,7964,8830,7787,6349,7289,8271,7937,8844,8606,3861,7398,7322,7250,7783,8002,7448,6155,7444,6413,8780,8144,8723,6140,8683,7247,5040,8128,8753,7468,6955,7539,6405,5997,7411,7351,7428,8044,8486,8124,7451,7464,8433,7463,8656,7352,7598,7458,7782,5645,7011,8046,3171,8008,8440,6020,8232,7460,8754,6990,8654,8077,3952,7595,7442,6633,4432,7353,7545,5738,8476,8403,8276,6705,7556,7532,8441,7537,6302,6613,6261,4158,8730,8252,8522,8444,8772,5107,8771,8330,8671,8251,7650,8961,8479,8399,8500,7288,8669,8014,3170,7665,7541,7615,6687,7710,7658,7319,8673,7717,8787,6949,6408,8331,7952,7634,8737,5696,4368,8623,7331,7825,7424,8823,8729,6286,8138,5278,8526,7308,7389,6863,2422,7683,7137,7000,7554,7690,8643,8629,8235,7792,8226,3788,8527,8055,6390,4759,6306,7820,8674,6875,8770,8328,8080,7957,5535,5798,7299,4799,7329,7546,8076,6999,8664,7253,7493,7788,8079,7860,6406,8404,3254,7520,8726,6873,7443,8871,7971,7152,8510,7671,5624,8257,8608,8095,7587,7635,7976,7357,3769,3998,8600,7616,7987,6690,7573,6996,7267,6509,7449,8097,8274,7540,8004,6876,5175,7639,8397,7682,8709,7859,7379,7001,8607,7067,7150,7610,8707,5471,7588,8279,4497,7311,8695,8881,7385,4587,8171,7318,7633,7177,7992,7744,7632,6499,8621,8783,8603,8653,8711,7630,8123,7636,8581,7939,7989,8075,7991,3446,7490,8277,8717,7753,7620,7248,7330,8010,8592,3023,6982,8797,8000,6684,7875,6361,5325,7251,8702,6978,6291,8808,7268,6417,3680,7716,7368,7534,6498,2363,8145,7245,8237,4266,8644,7631,8610,6878,6318,7056,7323,6708,8655,8694,8614,6364,7542,7651,8649,7166,8302,8051,2462,8281,8573,7758,6296,7249,8084,5303,8426,7378,7229,6002,8170,6682,7167,4287,7390,7203,7139,8072,8335,6740,8118,1569,3163,5468,4000,7049,8229,8120,8264,6501,7729,8129,8423,6249,8583,3179,7731,7243,7296,6365,8642,8162,8481,6340,7410,8025,8611,6493,7325,5301,6871,7959,8137,6396,8646,7487,8615,8313,8613,8100,8027,6139,8625,6352,5649,8071,8641,8295,7361,8626,6492,8578,8303,8602,8622,6290,6733,6422,7301,8234,8609,8028,7978,8619,6749,7996,8023,7282,7364,8576,6553,8026,6691,7828,8591,7544,8618,8577,8042,7725,7581,6650,8337,6868,7997,8572,8579,8039,1818,8146,8083,7367,7363,7276,8620,8045,8224,7265,8584,7222,8122,7515,7302,7312,7362,8136,7985,6383,6513,8119,6312,8037,7233,6407,6317,8029,8575,7366,3029,8034,7204,7258,8117,7372,7173,7135,7314,7365,6562,7220,8038,8005,8040,7371,7555,7519,6804,7270,7142,8135,7172,8574,8175,8078,7291,7726,8580,8825,8784,8862,6284,9103,6096,6866,7870,6022,7829,8215,7373,3362,6692,8381,7017,8516,6101,8009,5759,7972,8391,6181,6314,8425,4920,7388,7199,9088,8769,5330,7659,7986,3561,6786,7672,8216,6983,8485,7903,7774,8401,7730,6919,7392,8238,7445,7583,8487,7642,8169,6800,8837,5384,8515,8152,8616,7026,7724,8357,7419,7491,8477,5924,9099,8941,6595,7577,6885,7021,7423,7504,6668,2602,6688,8334,4745,8282,7498,5178,7440,7624,7426,8422,8571,7727,4612,8424,6829,7776,7434,7168,5824,6667,2003,7025,8159,6484,8786,7643,8033,7414,7979)  AND couleur NOT LIKE "%rose%" AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) AND cm LIKE '%55%' ORDER BY (id-(20*num)) DESCErr153a