SELECT id,marque,site,isable,ise,ghost,url,nom_uk,alt,couleur_uk couleur,essentiel_uk 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,9335,8877,6596,9377,9388,9245,3827,7556,6449,6349,7943,9366,7918,8031,7110,7961,6804,9276,9284,5656,9254,6252,9360,7545,9382,8735,9369,8576,9525,9265,9302,9356,9344,9368,8483,8019,9289,9522,8175,6899,9524,9526,9270,9520,8224,9519,9515,9268,9518,9514,9517,9513,9484,9512,9278,9479,7543,9478,9490,9365,9477,9487,9486,6454,9485,9463,9483,9423,9482,9230,9425,9481,9275,9410,9475,9322,9480,9474,9390,9473,7476,9472,7394,9446,8562,9471,6504,9461,7457,7482,9460,7212,7470,9459,4149,6459,9458,9457,9404,5094,9453,9452,9451,9255,9449,9384,9445,5111,9444,7664,8821,9443,9441,9389,9440,7945,9439,7475,9438,6004,9437,7522,9436,7478,9435,9303,9434,8872,9433,6611,9432,7408,9431,9429,9447,9428,9476,9427,9450,9426,9442,6601,9417,9422,9415,6503,9414,8586,9413,9328,5745,9258,9420,7542,9374,9411,8622,7218,9409,9354,8895,7558,6132,5133,9301,6127,9345,1814,8780,9014,9269,9364,8778,7377,8711,7477,8897,9281,7949,3002,9244,3191,9333,9304,6109,9421,9226,8742,9448,2461,9430,6377,9234,8834,3196,8736,9406,7473,7322,9329,8741,6253,9206,9405,9336,9402,7741,9401,7743,9419,9400,9412,9399,9403,9397,9205,9396,9204,9395,5108,9394,9282,8722,9393,9327,9202,9392,8380,9363,9362,8656,1809,9381,9380,5132,6108,8044,8597,9379,7947,9376,7523,9343,6599,9375,9342,9334,9305,9015,9391,9287,9373,7868,9233,7469,9372,9371,6124,9370,6443,7938,7459,9367,8016,9359,9016,9357,8599,9355,5109,9353,9352,9351,8867,9286,9235,8593,9299,9350,9349,9348,9201,9347,9200,6610,8737,8595,9346,9199,8094,9198,3123,7554,6597,9197,9236,6506,9231,8569,9232,9338,9424,9196,7940,9283,9337,6609,6492,9017,9195,9194,9193,1811,9332,9192,9331,8830,7944,9191,9330,9326,9190,9398,9325,9189,9324,9188,9313,9187,9312,9186,9311,8790,9185,9277,9184,9341,9183,7565,9298,7564,9182,6461,9297,3621,9181,9296,9180,9293,9292,8673,9288,6384,9280,9279,9361,9274,9273,9272,8958,9271,6612,9266,9257,5535,9250,9249,9300,8020,9248,5994,9247,8875,9246,8670,9243,9242,9241,9238,9339,9237,7137,5950,5987,7954,7451,9227,9225,8799,2991,8738,8962,9267,9310,9291,8846,8163,8819,8757,8626,8584,8842,8868,8879,9285,8756,9116,5537,8876,7366,7955,8861,8706,8827,7951,3769,8870,8829,8634,8845,8668,9228,8857,8138,9095,7217,8855,8854,8772,8568,9378,8848,8577,8841,5624,8796,8303,7398,8603,8896,8784,8588,8763,8820,4563,8873,8643,6145,6565,8171,8691,8732,8080,8744,7329,8850,7472,7486,7952,8809,7987,5966,8750,9290,8787,8047,7541,8727,7216,8749,7395,7976,6606,8794,7993,7942,8733,8642,8592,8719,8789,8874,7294,8768,3124,6171,8776,8775,3126,8774,8039,8746,8858,6598,5967,8853,8688,8123,3122,8725,7387,8866,8029,6000,7363,8860,6464,6291,8658,8708,8782,8781,8832,8125,8734,8765,8771,4562,6296,8606,8747,8665,8692,8807,8777,6013,8721,8720,7374,7536,8685,8591,7297,9143,8705,8704,8770,8703,6007,8779,8707,8699,6151,8859,8773,8767,8598,6143,8856,7726,8849,6607,8645,8745,8671,6155,8865,3188,8580,3129,8718,8663,8632,8662,8652,8696,8788,7171,6474,8026,8728,6413,8683,8828,8119,7731,8608,8144,8619,3657,6403,8729,7238,8621,5920,8028,8001,8575,7474,8851,7484,7295,6603,7368,8617,8726,6415,8730,8589,8717,7992,8612,7989,7562,8852,7725,5031,8146,7406,8615,8709,6412,8037,7306,7935,8079,5004,8740,3609,4423,7293,4422,6495,8034,8118,6602,8018,3610,8702,5009,7239,8753,8600,6362,8743,6505,6302,8638,8655,8637,7480,8766,8818,8684,8878,8631,4368,8731,8630,7331,8628,8661,8627,7787,7204,8166,7544,4429,8624,8160,8651,8611,8167,7946,8601,8570,8641,7299,7464,8748,8590,7950,8646,8620,8862,8864,7236,7985,7956,6564,8585,8644,5991,8607,7330,7991,8754,5511,8610,8046,8647,6491,6502,7996,8609,7303,4497,7538,7309,8618,7936,6390,8847,5093,5092,8739,7361,8126,8604,8674,8122,8004,8701,7960,8824,8822,6306,8697,8792,8635,6318,8693,8633,8800,8723,8686,8124,8695,7981,8084,8074,8145,7493,7571,8724,7549,7995,7210,6604,7393,7349,8751,8639,8143,7965,7468,8825,8669,5645,8027,7247,7351,4432,8649,3023,7229,7548,7458,7172,7235,7251,7352,7488,7971,8008,6290,8002,6566,7355,6406,7551,8596,4485,8136,6405,7413,7941,8076,7241,8613,7964,7937,7399,7539,7307,8128,7372,6361,7550,5997,5989,5481,6408,7983,8017,6422,8042,7533,7365,7485,7282,8010,6096,8614,3680,8602,8137,6508,8783,8698,8690,8687,8640,7939,8024,8013,7313,8587,8302,6498,6365,7308,7978,8871,8808,7312,3029,8162,7957,8636,7367,8823,8168,7318,8694,6383,6509,7362,7407,7328,8072,7396,7290,7173,8055,8071,8051,8654,7487,8120,6364,6499,7166,7203,7378,2363,8797,7552,8170,7319,7364,8095,7291,7792,7540,8426,7302,8025,8078,6312,7520,6417,7405,7371,7788,4491,8659,6352,7534,8005,3008,8117,8077,6317,4456,6633,8798,8831,8075,6647,5738,6407,5107,6613,7532,7980,7311,8135,7373,7301,6340,8083,6102,7253,1569,7177,8653,8097,8629,7537,8129,8100,9358,8014,8023,5969,8839,7357,8700,6501,8752,8625,7449,6139,7167,7997,7690,7972,7546,7258,8623,8833,5696,7998,8582,8116,8714,8710,8758,7168,8053,4426,8112,8835,7727,8011,8838,7336,7979,7262,7809,7259,8103,8826,6344,7844,8760,6101,8616,8571,8786,7510,8152,7494,6382,6082,6314,8836,8161,7227,7335,8259,8837,6301,8863,6331,8159,7966,6441,7984,8715,8716,8712,8605,6642,8033,8089,8087,7261,7274,6484,8142,8035,8785,8085,8672,6458,8049,7263,8475,6341,8105,7962,7260,8088,6648,8769,8795,6797,8131,6313,8713,8759,7963,6052,6332,8169,6866,6800,8150,8106,8238,6311,8151,7986,6592,8092)  AND ( site!=3 OR ise=0 OR num<7 ) AND produit NOT IN( ) ORDER BY (prix*(100-promo)) DESC,produit,numErr153a