SELECT s.id, s.extra, ss.ref_seminarka FROM seminarka AS s LEFT JOIN seminarka_spisovatel AS ss ON s.id = ss.ref_seminarka WHERE s.id IN(13, 15, 18, 20, 21, 22, 163, 197, 208, 328, 489, 491, 535, 538, 591, 610, 619, 654, 726, 727, 737, 738, 744, 761, 762, 776, 778, 779, 783, 784, 790, 822, 850, 867, 889, 896, 1114, 1116, 1118, 1119, 1121, 1122, 1123, 1126, 1127, 1128, 1129, 1130, 1132, 1133, 1146, 1170, 1396, 1452, 1686, 1716, 1721, 1722, 1723, 1724, 1727, 1728, 1729, 1891, 1892, 1937, 1983, 1984, 2133, 2134, 2135, 2136, 2137, 2138, 2139, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2148, 2180, 2419, 2504, 2538, 2563, 2633, 2694, 2697, 2698, 2699, 2700, 2701, 2702, 2703, 2705, 2707, 2708, 2709, 2710, 2711, 2712, 2713, 2714, 2716, 2717, 2718, 2719, 2720, 2818, 3116, 3129, 3142, 3167, 3168, 3201, 3216, 3219, 3230, 3247, 3257, 3261, 3276, 3332, 3359, 3375, 3386, 3387, 3395, 3398, 3411, 3463, 3480, 3491, 3522, 3528, 3543, 3628, 3630, 3643, 3685, 3699, 3759, 3771, 3795, 3796, 3828, 3888, 3889, 3913, 3995, 4063, 4098, 4100, 4112, 4171, 4319, 4341, 4342, 4397, 4438, 4444, 4445, 4446, 4495, 4529, 4558, 4565, 4568, 4575, 4600, 4607, 4608, 4661, 4693, 4694, 4729, 4779, 4841, 4858, 4879, 4884, 4898, 4899, 4909, 4950, 4988, 5116, 5154, 5199, 5225, 5273, 5368, 5415, 5495, 5505, 5506, 5523, 5527, 5528, 5529, 5553, 5596, 5698, 5699, 5762, 5797, 5888, 5974, 5975, 5979, 5980, 6086, 6371, 6474, 6478, 6545, 6555, 6558, 6597, 6619, 6644, 6672, 6735, 6821, 6823, 6858, 6954, 6958, 7007, 7018, 7038, 7147, 7148, 7211, 7281, 7363, 7440, 7491, 7492, 7524, 7569, 7728, 7735, 7755, 7785, 7851, 7852, 7861, 7870, 7939, 7949, 7972, 7989, 7991, 8002, 8109, 8110, 8115, 8135, 8140, 8171, 8174, 8179, 8188, 8221, 8272, 8281, 8364, 8374, 8380, 8428, 8569, 8648, 8649, 8711, 8731, 8748, 8835, 8876, 8899, 8940, 8967, 8976, 8984, 9141, 9229, 9266, 9279, 9282, 9285, 9302, 9381, 9496, 9497, 9510, 9608, 9724, 9786, 9789, 9791, 9792, 9793, 9814, 9827, 9890, 9905, 9910, 9952, 10019, 10078, 10131, 10206, 10283, 10284, 10377, 10411, 10414, 10479, 10497, 10507, 10531, 10595, 10688, 10727, 10732, 10749, 10833, 10862, 10867, 11069, 11283, 11290, 11333, 11334, 11406, 11407, 11420, 11487, 11527, 11628, 11647, 11674, 11712, 11713, 11717, 11751, 11761, 11775, 11777, 11778, 11805, 11828, 11829, 11850, 11859, 11860, 11864, 11907, 11928, 11962, 12042, 12079, 12084, 12104, 12134, 12135, 12136, 12158, 12219, 12220, 12227, 12255, 12257, 12347, 12443, 12450, 12495, 12557, 12572, 12615, 12620, 12672, 12685, 12691, 12734, 12789, 12800, 12808, 12850, 12883, 12947, 13017, 13021, 13048, 13146, 13186, 13235, 13266, 13342, 13352, 13408, 13497, 13522, 13562, 13582, 13608, 13676, 13677, 13679, 13817, 13819, 13822, 13829, 13859, 13909, 13964, 14032, 14045, 14085, 14114, 14148, 14161, 14225, 14266, 14338, 14367, 14409, 14488, 14624, 14700, 14701, 14702, 14703, 14715, 14791, 14818, 14863, 14947, 14949, 14950, 14979, 15064, 15072, 15076, 15103, 15129, 15202, 15203, 15204, 15257, 15300, 15302, 15309, 15310, 15315, 15318, 15426, 15436, 15441, 15465, 15497, 15498, 15523, 15549, 15564, 15565, 15613, 15617, 15626, 15656, 15658, 15671, 15681, 15691, 15707, 15728, 15729, 15735, 15749, 15750, 15821, 15827, 15848, 15912, 15915, 15926, 15928, 15937, 15955, 15958, 15960, 16072, 16318, 16319, 16320, 16363, 16406, 16407, 16408, 16409, 16457, 16495, 16496, 16518, 16544, 16545, 16586, 16603, 16604, 16618, 16677, 16715, 16716, 16936, 16938, 16940, 16941, 16951, 16952, 16954, 17007, 17103, 17107, 17108, 17111, 17148, 17157, 17217, 17230, 17319, 17339, 17345, 17350, 17355, 17359, 17397, 17404, 17416, 17422, 17455, 17456, 17480, 17481, 17496, 17497, 17498, 17499, 17500, 17509, 17510, 17511, 17529, 17530, 17531, 17532, 17546, 17547, 17548, 17597, 17599, 17706, 17730, 17831, 17949, 17992, 18010, 18031, 18032, 18039, 18078, 18146, 18183, 18199, 18203, 18236, 18296, 18305, 18306, 18307, 18313, 18314, 18324, 18389, 18514, 18515, 18516, 18631, 18637, 18639, 18649, 18667, 18686, 18697, 18723, 18724, 18753, 18771, 18786, 18787, 18822, 18834, 18854, 18855, 18856, 18860, 18879, 18973, 18974, 19018, 19078, 19187, 19209, 19277, 19311, 19325, 19331, 19336, 19379, 19386, 19387, 19393, 19460, 19461, 19525, 19526, 19529, 19535, 19546, 19549, 19566, 19594, 19617, 19622, 19632, 19636, 19665, 19689, 19725, 19795, 19807, 19816, 19831, 19844, 19875, 19988, 20080, 20115, 20117, 20134, 20151, 20181, 20202, 20243, 20253, 20295, 20321, 20322, 20323, 20328, 20340, 20342, 20362, 20363, 20367, 20372, 20403, 20410, 20416, 20417, 20526, 20564, 20669, 20672, 20674, 20685, 20696, 20698, 20699, 20707, 20714, 20750, 20763, 20784, 20883, 20889, 21028, 21070, 21163, 21192, 21219, 21221, 21264, 21300, 21328, 21332, 21355, 21356, 21358, 21361, 21415, 21416, 21426, 21525, 21544, 21562, 21588, 21595, 21614, 21617, 21645, 21698, 21736, 21740, 21782, 21799, 21801, 21909, 21958, 21971, 22125, 22132, 22216, 22245, 22270, 22283, 22284, 22358, 22381, 22418, 22454, 22480, 22553, 22563, 22596, 22597, 22660, 22809, 22848, 22871, 22878, 22886, 22897, 22908, 22914, 23026, 23031, 23033, 23059, 23083, 23120, 23160, 23179, 23198, 23199, 23200, 23201, 23429, 23440, 23470, 23740, 23748, 23802, 23803, 23804, 23811, 23812, 23820, 23926, 24028, 24032, 24056, 24157, 24224, 24318, 24405, 24555, 24564, 24599, 24612, 24634, 24731, 24733, 24743, 24753, 24767, 24771, 24821, 24864, 24865, 24867, 24868, 24925, 24944, 24945, 25066, 25166, 25290, 25322, 25324, 25353, 25393, 25394, 25421, 25424, 25427, 25429, 25432, 25573, 25625, 25630, 25632, 25633, 25636, 25905, 25907, 25926, 25927, 25928, 25933, 25935, 25936, 25938, 25939, 25940, 25942, 25943, 25953, 25968, 25969, 25970, 25981, 25984, 25998, 26003, 26004, 26005, 26007, 26012, 26039, 26097, 26109, 26184, 26202, 26351, 26352, 26353, 26400, 26498, 26499, 26534, 26628, 26653, 26861, 27206, 27334, 27374, 27375, 27376, 27377, 27378, 27379, 27380, 27381, 27383, 27385, 27387, 27388, 27389, 27391, 27392, 27393, 27394, 27442, 27443, 27444, 27445, 27446, 27447, 27451, 27452, 27480, 27489, 27518, 27519, 27520, 27521, 27522, 27526, 27527, 27528, 27529, 27530, 27531, 27532, 27533, 27534, 27535, 27536, 27537, 27538, 27539, 27540, 27541, 27542, 27543, 27544, 27545, 27558, 27559, 27560, 27561, 27562, 27563, 27564, 27565, 27566, 27913, 27917, 27999, 28003, 28016, 28045, 28127, 28220, 28221, 28238, 28243, 28260, 28355, 28357, 28382, 28437, 28438, 28439, 28440, 28441, 28637, 28713, 28738, 28874, 28877, 29062, 29127, 29713, 29957, 29994, 29995, 30082, 30147, 30293, 30310, 30494, 30496, 30645, 30727, 30736, 30764, 30765, 30768, 30847, 30848, 30918, 30920, 30932, 30934, 30935, 30936, 31276, 31279, 31323, 31368, 31392, 31396, 31442, 31530, 31605, 31737, 31764, 31765, 31766, 31767, 31768, 31769, 31771, 31774, 31775, 31777, 31778, 31780, 31782, 31784, 31794, 31795, 31796, 31797, 31798, 31800, 31801, 31802, 31803, 31804, 31805, 31806, 31871, 32106, 32107, 32335, 32336, 32337, 32338, 32339, 32340, 32341, 32342, 32343, 32344, 32345, 32346, 32355, 32356, 32357, 32358, 32359, 32360, 32361, 32362, 32363, 32364, 32365, 32411, 32412, 32413, 32414, 32415, 32416, 32417, 32418, 32419, 32421, 32422, 32423, 32424, 32425, 32605, 32771, 32772, 32811, 33250, 33497, 33559, 33587, 33590, 33626, 33644) and s.autorizace >0 and s.id in (select distinct STR_SEMINARKA_FK from strom where STR_SEMINARKA_TYP_FK in (2, 4, 20) or (STR_SEMINARKA_TYP_FK=17 and STR_SUBKATEGORIE_FK=247) or (STR_SEMINARKA_TYP_FK in (18, 1, 9, 11) and STR_SUBKATEGORIE_FK in (117, 342))) GROUP BY s.id