select VISUALCARDID, DISCOUNT
from DISCCLI
where VISUALCARDID in (10006, 10012, 10023, 10056, 10128, 10139, 10148, 10176, 10180, 10265,
10282, 10305, 10311, 10332, 10346, 10388, 10414, 10447, 10451, 10458,
10461, 10464, 10467, 10481, 10494, 10504, 10507, 10558, 10582, 10612,
10616, 10638, 10651, 10660, 10677, 10690, 10715, 10738, 10750, 10771,
10789, 10797, 10852, 10853, 10855, 10894, 10895, 10907, 10916, 10925,
10940, 10959, 10970, 11066, 11081, 11082, 11105, 11159, 11200, 11217,
11227, 11299, 11328, 11383, 11388, 11394, 11401, 11419, 11422, 11463,
11489, 11491, 11496, 11522, 11529, 11541, 11570, 11574, 11580, 11617,
11642, 11690, 11741, 11756, 11788, 11853, 11861, 11879, 11880, 11944,
11998, 12032, 12053, 12088, 12112, 12116, 12153, 12156, 12213, 12215,
12222, 12227, 12291, 12408, 12451, 12469, 12475, 12524, 12565, 12569,
12576, 12581, 12582, 12586, 12623, 12638, 12639, 12642, 12665, 12686,
12697, 12706, 12741, 12748, 12790, 12812, 12817, 12846, 12864, 12883,
12892, 12913, 12941, 12958, 12964, 12968, 12995, 13010, 13027, 13029,
13055, 13062, 13100, 13101, 13171, 13204, 13211, 13221, 13229, 13246,
13259, 13274, 13295, 13325, 13332, 13358, 13363, 13375, 13396, 13400,
13432, 13441, 13445, 13454, 13465, 13502, 13508, 13543, 13551, 13568,
13600, 13607, 13609, 13661, 13686, 13696, 13704, 13716, 13735, 13822,
13827, 13848, 13862, 13869, 13885, 13888, 13949, 13955, 13962, 13965,
13967, 13980, 13995, 14004, 14017, 14041, 14044, 14063, 14090, 14094,
14101, 14103, 14118, 14119, 14135, 14153, 14171, 14213, 14223, 14271,
14280, 14291, 14319, 14333, 14412, 14429, 14436, 14459, 14461, 14469,
14486, 14502, 14537, 14538, 14550, 14571, 14573, 14574, 14582, 14616,
14619, 14630, 14639, 14658, 14736, 14750, 14752, 14756, 14757, 14788,
14830, 14878, 14881, 14912, 14918, 14927, 14944, 14955, 14957, 14984,
14990, 14998, 15059, 15081, 15122, 15145, 15158, 15174, 15194, 15222,
15239, 15320, 15357, 15366, 15394, 15435, 15452, 15472, 15492, 15495,
15532, 15537, 15543, 15602, 15603, 15626, 15713, 15826, 15950, 15952,
16022, 16025, 16054, 16058, 16068, 16080, 16168, 16183, 16186, 16196,
16226, 16242, 16251, 16297, 16315, 16341, 16350, 16356, 16412, 16471,
16491, 16505, 16509, 16566, 16603, 16614, 16629, 16675, 16704, 16728,
16737, 16746, 16757, 16772, 16827, 16863, 16889, 16895, 16931, 16944,
16960, 16981, 16998, 17000, 17017, 17034, 17036, 17122, 17125, 17131,
17157, 17194, 17196, 17275, 17334, 17342, 17364, 17377, 17392, 17411,
17501, 17517, 17526, 17539, 17586, 17631, 17660, 17676, 17742, 17757,
17813, 17867, 17903, 17926, 17991, 18011, 18030, 18034, 18055, 18059,
18069, 18105, 18154, 18156, 18159, 18243, 18263, 18266, 18267, 18308,
18317, 18345, 18357, 18378, 18386, 18394, 18395, 18433, 18468, 18524,
18525, 18573, 18589, 18632, 18642, 18695, 18765, 18796, 18820, 18839,
18905, 18970, 18982, 18985, 19056, 19061, 19062, 19079, 19122, 19123,
19135, 19141, 19151, 19184, 19204, 19234, 19263, 19273, 19334, 19346,
19358, 19412, 19453, 19478, 19496, 19506, 19558, 19631, 19652, 19695,
19720, 19743, 19744, 19747, 19749, 19751, 19770, 19773, 19778, 19796,
19797, 19881, 19914, 19932, 19998, 20019, 20038, 20060, 20088, 20190,
20198, 20215, 20224, 20231, 20315, 20347, 20351, 20411, 20414, 20415,
20464, 20491, 20544, 20558, 20563, 20587, 20617, 20650, 20668, 20739,
20751, 20782, 20795, 20837, 20838, 20892, 20916, 20925, 20928, 20987,
21087, 21142, 21149, 21161, 21163, 21170, 21188, 21190, 21198, 21218,
21224, 21258, 21262, 21272, 21301, 21304, 21342, 21343, 21359, 21377,
21402, 21511, 21550, 21557, 21561, 21583, 21586, 21607, 21630, 21704,
21708, 21715, 21742, 21766, 21829, 21853, 21907, 21923, 21938, 21989,
22021, 22038, 22060, 22082, 22124, 22156, 22169, 22178, 22206, 22236,
22257, 22342, 22350, 22352, 22353, 22355, 22417, 22538, 22580, 22606,
22622, 22646, 22654, 22715, 22729, 22734, 22739, 22763, 22785, 22787,
22848, 22851, 22878, 22883, 22895, 22940, 22974, 23012, 23020, 23044,
23046, 23063, 23113, 23121, 23131, 23143, 23231, 23262, 23306, 23428,
23496, 23497, 23595, 23653, 23654, 23691, 23700, 23739, 23776, 23784,
23851, 23857, 23863, 23871, 23877, 23878, 23894, 23913, 23919, 23996,
24097, 24662, 24705, 24749, 24829, 24834, 24860, 24900, 24914, 25026,
25067, 25074, 25087, 25104, 25108, 25121, 25138, 25188, 25304, 25340,
25392, 25454, 25460, 25462, 25520, 25545, 25557, 25563, 25568, 25591,
25612, 25627, 25663, 25698, 25721, 25749, 25770, 25803, 25827, 25842,
25857, 25861, 25886, 25902, 25914, 25918, 25923, 25924, 25938, 25945,
25966, 26011, 26039, 26045, 26060, 26076, 26141, 26149, 26155, 26157,
26173, 26175, 26182, 26228, 26237, 26278, 26294, 26342, 26359, 26409,
26439, 26470, 26486, 26493, 26544, 26560, 26564, 26588, 26682, 26689,
26696, 26699, 26717, 26755, 26765, 26774, 26788, 26870, 26871, 26928,
26938, 27004, 27041, 27052, 27083, 27087, 27100, 27116, 27123, 27124,
27125, 27135, 27144, 27163, 27193, 27201, 27233, 27258, 27278, 27279,
27312, 27315, 27333, 27350, 27354, 27363, 27368, 27386, 27389, 27428,
27441, 27506, 27511, 27545, 27549, 27568, 27581, 27592, 27607, 27608,
27612, 27633, 27651, 27712, 27723, 27731, 27782, 27796, 27813, 27817,
27840, 27846, 27870, 27927, 27933, 27940, 27950, 27957, 27962, 28022,
28023, 28027, 28060, 28068, 28079, 28106, 28133, 28137, 28141, 28155,
28157, 28174, 28177, 28184, 28187, 28188, 28200, 28201, 28233, 28240,
28244, 28245, 28313, 28325, 28332, 28340, 28357, 28397, 28417, 28421,
28448, 28449, 28465, 28483, 28497, 28507, 28511, 28529, 28533, 28569,
28577, 28587, 28588, 28603, 28606, 28648, 28661, 28675, 28696, 28784,
28821, 28830, 28835, 28840, 28868, 28893, 28896, 28904, 28965, 28974,
28975, 28978, 28986, 29002, 29003, 29028, 29045, 29091, 29098, 29118,
29138, 29139, 29144, 29168, 29171, 29275, 29284, 29298, 29311, 29323,
29332, 29355, 29376, 29382, 29386, 29395, 29402, 29450, 29489, 29493,
29511, 29515, 29537, 29548, 29551, 29580, 29615, 29667, 29729, 29749,
29772, 29778, 29781, 29785, 29791, 29876, 29879, 29881, 29893, 29922,
29967, 29974, 29976, 29993, 30017, 30027, 30032, 30054, 30063, 30078,
30092, 30119, 30123, 30143, 30146, 30181, 30203, 30218, 30221, 30236,
30241, 30246, 30258, 30261, 30282, 30344, 30357, 30371, 30375, 30378,
30408, 30420, 30485, 30507, 30535, 30540, 30560, 30562, 30572, 30577,
30590, 30611, 30653, 30662, 30687, 30702, 30717, 30738, 30757, 30769,
30827, 30838, 30848, 30851, 30861, 30863, 30889, 30925, 30927, 30938,
30973, 30998, 31015, 31042, 31053, 31097, 31105, 31107, 31130, 31131,
31142, 31158, 31177, 31182, 31186, 31195, 31215, 31217, 31235, 31249,
31281, 31296, 31348, 31414, 31438, 31463, 31470, 31474, 31475, 31493,
31509, 31513, 31525, 31542, 31545, 31559, 31592, 31595, 31606, 31607,
31608, 31626, 31647, 31654, 31661, 31672, 31674, 31687, 31717, 31739,
31742, 31746, 31777, 31779, 31801, 31819, 31839, 31853, 31866, 31869,
31886, 31888, 31902, 31914, 31917, 31918, 31931, 31935, 31944, 31950,
32009, 32024, 32055, 32070, 32121, 32128, 32152, 32202, 32216, 32239,
32243, 32249, 32262, 32294, 32306, 32317, 32375, 32404, 32443, 32482,
32490, 32507, 32518, 32641, 32689, 32700, 32709, 32725, 32740, 32766,
32767, 32776, 32799, 32809, 32827, 32836, 32843, 32844, 32873, 32885,
32913, 32932, 32937, 32945, 32946, 32948, 32974, 32982, 32983, 33019,
33027, 33034, 33054, 33068, 33074, 33080, 33103, 33112, 33134, 33141,
33145, 33146, 33148, 33168, 33178, 33194, 33218, 33221, 33246, 33263,
33270, 33277, 33298, 33300, 33360, 33406, 33408, 33413, 33415, 33442,
33464, 33477, 33478, 33483, 33513, 33515, 33529, 33539, 33559, 33561,
33601, 33611, 33618, 33626, 33636, 33640, 33650, 33672, 33694, 33697,
33704, 33706, 33724, 33733, 33742, 33750, 33765, 33804, 33855, 33877,
33935, 33993, 34051, 34065, 34100, 34145, 34168, 34174, 34175, 34188,
34203, 34229, 34235, 34262, 34265, 34282, 34378, 34478, 34488, 34499,
34511, 34544, 34546, 34567, 34570, 34581, 34588, 34600, 34646, 34690,
34735, 34745, 34764, 34788, 34809, 34819, 34829, 34830, 34834, 34838,
34853, 34909, 34977, 35004, 35007, 35017, 35034, 35051, 35068, 35117,
35124, 35125, 35141, 35143, 35160, 35162, 35175, 35177, 35181, 35187,
35188, 35200, 35206, 35208, 35210, 35219, 35242, 35245, 35309, 35312,
35348, 35382, 35427, 35430, 35449, 35494, 35514, 35548, 35556, 35560,
35592, 35593, 35596, 35648, 35651, 35652, 35671, 35737, 35743, 35749,
35783, 35829, 35837, 35838, 35868, 35887, 35937, 35945, 35956, 35989,
35994, 36001, 36014, 36023, 36037, 36044, 36048, 36062, 36071, 36086,
36091, 36109, 36111, 36151, 36170, 36202, 36205, 36212, 36214, 36215,
36216, 36251, 36261, 36263, 36266, 36271, 36272, 36278, 36297, 36304,
36306, 36312, 36314, 36319, 36326, 36355, 36356, 36376, 36381, 36396,
36399, 36428, 36479, 36482, 36489, 36493, 36531, 36557, 36582, 36608,
36610, 36613, 36615, 36625, 36668, 36674, 36720, 36749, 36750, 36776,
36777, 36796, 36863, 36866, 36892, 36923, 36926, 36931, 36947, 36987,
36992, 37028, 37036, 37057, 37065, 37108, 37124, 37128, 37149, 37157,
37159, 37172, 37176, 37186, 37194, 37206, 37232, 37336, 37341, 37344,
37346, 37357, 37374, 37381, 37405, 37414, 37466, 37499, 37504, 37516,
37560, 37591, 37603, 37622, 37623, 37627, 37642, 37655, 37672, 37677,
37680, 37700, 37718, 37725, 37733, 37750, 37751, 37754, 37771, 37775,
37778, 37905, 37910, 37925, 37926, 37934, 38007, 38012, 38021, 38034,
38035, 38054, 38059, 38107, 38118, 38121, 38139, 38152, 38157, 38159,
38173, 38204, 38208, 38211, 38213, 38219, 38220, 38226, 38243, 38256,
38330, 38388, 38394, 38401, 38408, 38409, 38410, 38418, 38446, 38469,
38482, 38502, 38525, 38529, 38547, 38560, 38590, 38606, 38613, 38622,
38662, 38712, 38725, 38735, 38741, 38753, 38778, 38779, 38788, 38800,
38803, 38811, 38818, 38819, 38822, 38877, 38912, 38918, 38932, 38960,
38971, 38977, 38988, 38993, 39007, 39012, 39058, 39060, 39076, 39127,
39144, 39162, 39164, 39185, 39201, 39222, 39228, 39239, 39253, 39290,
39297, 39299, 39305, 39323, 39334, 39340, 39355, 39359, 39361, 39382,
39405, 39436, 39446) order by VISUALCARDID asc