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