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(1, 3, 191, 200, 209, 243, 249, 304, 426, 459, 497, 517, 668, 686, 872, 881, 891, 920, 923, 924, 926, 927, 1026, 1184, 1190, 1191, 1192, 1196, 1197, 1198, 1199, 1200, 1201, 1203, 1204, 1206, 1207, 1211, 1212, 1256, 1258, 1259, 1260, 1262, 1333, 1471, 1558, 1559, 1560, 1561, 1565, 1574, 1874, 2028, 2099, 2164, 2165, 2167, 2172, 2325, 2344, 2412, 2515, 2586, 2972, 2976, 3037, 3038, 3331, 3358, 3404, 3432, 3433, 3561, 3600, 3634, 3737, 3760, 3985, 4002, 4121, 4136, 4173, 4175, 4191, 4194, 4202, 4203, 4266, 4337, 4373, 4562, 4572, 4675, 4695, 4697, 4757, 4873, 4886, 5062, 5156, 5180, 5188, 5402, 5515, 5525, 5646, 5648, 5799, 5902, 6009, 6119, 6172, 6174, 6192, 6194, 6537, 6725, 6903, 6912, 7045, 7328, 7329, 7591, 7768, 7799, 7901, 7931, 8127, 8424, 8532, 8802, 8806, 8815, 8853, 8893, 8947, 9757, 9816, 9820, 10401, 10424, 10428, 10494, 10506, 10645, 10657, 10797, 10798, 10886, 10961, 10964, 10994, 11190, 11999, 12069, 12099, 12169, 12231, 12353, 12394, 12545, 12546, 12547, 12548, 12549, 12556, 12624, 12625, 12634, 12819, 12897, 12987, 13007, 13023, 13129, 13130, 13212, 13253, 13254, 13472, 13527, 13617, 13752, 14086, 14145, 14295, 14381, 14386, 14396, 14451, 14452, 14453, 14454, 14455, 14637, 14747, 14971, 15154, 15205, 15207, 15209, 15228, 15229, 15230, 15232, 15235, 15275, 15341, 15363, 15462, 15508, 15512, 15563, 15824, 15996, 16113, 16529, 16839, 16858, 16870, 16871, 16872, 16902, 16903, 17000, 17077, 17098, 17120, 17167, 17221, 17279, 18040, 18486, 18592, 18751, 18760, 18883, 18884, 19114, 19213, 19291, 19700, 19797, 20097, 20110, 20177, 20396, 20397, 20398, 20400, 20401, 20418, 20420, 20421, 20422, 20423, 20437, 20438, 20439, 20440, 20441, 20449, 20450, 20451, 20452, 20453, 20461, 20462, 20463, 20464, 20465, 20467, 20468, 20508, 20568, 20789, 20807, 20808, 20809, 20830, 20841, 20842, 20843, 20869, 20878, 20887, 20950, 21016, 21037, 21039, 21040, 21041, 21075, 21076, 21077, 21102, 21104, 21105, 21193, 21195, 21237, 21238, 21239, 21718, 21719, 21720, 21721, 21722, 21723, 21729, 21731, 21733, 22048, 22049, 22185, 22337, 22376, 22436, 22456, 22463, 22498, 22521, 22540, 22566, 22623, 22681, 22754, 22755, 22775, 22813, 23145, 23182, 23185, 23285, 23745, 23768, 23787, 23914, 23967, 23979, 24021, 24023, 24036, 24039, 24040, 24047, 24066, 24068, 24101, 24160, 24161, 24167, 24168, 24191, 24241, 24283, 24531, 24548, 24621, 24623, 24629, 24646, 24648, 24677, 24679, 24692, 24698, 24704, 24729, 24755, 24775, 24861, 24873, 25076, 25175, 25179, 25183, 25238, 25342, 25343, 25399, 25431, 25442, 25477, 25479, 25480, 25481, 25564, 25569, 25570, 25580, 25590, 25593, 25611, 25921, 25965, 26016, 26034, 26049, 26206, 26207, 26208, 26300, 26301, 26347, 26348, 26361, 26414, 26447, 26506, 26507, 26531, 26545, 26561, 26570, 26626, 26629, 26703, 26896, 26989, 27051, 27053, 27176, 27177, 27202, 27397, 27398, 27399, 27417, 27418, 27421, 27429, 27475, 27476, 27477, 27478, 27481, 27482, 27671, 27673, 27674, 27760, 27769, 27774, 27789, 27992, 27993, 28080, 28218, 28281, 28285, 28288, 28302, 28311, 28314, 28315, 28317, 28328, 28334, 28373, 28403, 28404, 28427, 28428, 28429, 28430, 28466, 28467, 28468, 28580, 29012, 29096, 29253, 29338, 29361, 29375, 29427, 29595, 29604, 29837, 30049, 30119, 30196, 30219, 30276, 30295, 30325, 30346, 30400, 30498, 30622, 30623, 30632, 30633, 30634, 30635, 30665, 30696, 30698, 30700, 30702, 30738, 30771, 30772, 30837, 30838, 30862, 30890, 30910, 30911, 30915, 30919, 30940, 30942, 30965, 30966, 30967, 31005, 31029, 31038, 31060, 31070, 31073, 31090, 31091, 31122, 31123, 31124, 31168, 31169, 31432, 31502, 31691, 31692, 31727, 31856, 32053, 32146, 32171, 32198, 32370, 32572, 32616, 32617, 32748, 32752, 32764, 32848, 32849, 32850, 32851, 32852, 32853, 32854, 32855, 32856, 32857, 32858, 32859, 32860, 32861, 32862, 32864, 32865, 32866, 32867, 32868, 32870, 32871, 32872, 32873, 32874, 32877, 32878, 32882, 32883, 32909, 32921, 33410, 33427, 33461, 33481, 33544, 33563) 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