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(361, 366, 455, 500, 607, 1016, 1487, 1488, 1490, 1557, 1985, 2201, 2202, 2203, 2204, 2205, 2206, 2207, 2208, 2209, 2210, 2211, 2212, 2213, 2214, 2215, 2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2248, 2492, 2654, 2656, 2659, 2781, 3139, 3302, 3664, 3688, 3869, 3881, 3916, 4052, 4057, 4176, 4178, 4251, 4253, 4254, 4323, 4563, 4569, 4698, 4739, 4803, 4951, 4952, 4981, 4982, 5374, 5425, 5426, 5465, 5507, 5703, 5753, 5802, 5803, 5805, 5808, 5882, 5883, 5920, 6153, 6175, 6358, 6490, 6596, 6750, 6909, 6963, 7714, 7987, 8101, 8592, 8754, 8980, 8981, 8982, 9179, 9188, 9220, 9428, 9432, 9455, 9562, 9712, 9714, 9728, 9729, 9773, 9862, 9892, 9911, 9932, 10017, 10108, 10119, 10272, 10274, 10445, 10446, 10447, 10448, 10483, 10484, 10505, 10536, 10584, 10648, 10766, 10917, 11008, 11013, 11116, 11317, 11318, 11319, 11320, 11322, 11324, 11367, 11461, 11462, 11463, 11464, 11489, 11490, 11491, 11492, 11493, 11512, 11513, 11514, 11515, 11516, 11522, 11636, 11703, 11753, 12175, 12177, 12331, 12509, 12520, 12523, 12570, 12577, 12654, 12655, 12656, 12657, 12658, 12696, 12697, 12747, 12748, 12756, 12777, 12806, 12920, 12921, 12922, 12923, 12924, 12999, 13041, 13058, 13059, 13063, 13131, 13239, 13477, 13571, 13620, 13648, 13649, 13650, 13861, 13891, 13920, 13922, 13923, 13943, 13963, 13987, 14105, 14125, 14126, 14127, 14128, 14134, 14226, 14227, 14228, 14229, 14230, 14260, 14262, 14264, 14302, 14303, 14382, 14383, 14384, 14404, 14821, 14822, 14829, 15111, 15210, 15211, 15276, 15312, 15487, 15503, 15615, 15700, 15891, 16021, 16023, 16027, 16050, 16104, 16556, 16606, 16607, 16608, 16609, 16668, 16845, 16905, 17216, 17257, 17259, 17407, 17701, 17702, 17703, 17704, 17834, 17877, 17898, 17911, 18070, 18098, 18175, 18176, 18177, 18178, 18378, 18490, 18500, 18501, 18507, 18552, 18662, 18714, 18820, 19081, 19082, 19083, 19167, 19270, 19410, 19520, 19551, 19552, 19585, 19588, 19753, 19871, 20023, 20111, 20176, 20393, 20394, 20447, 20448, 20470, 20480, 20518, 20727, 20729, 20773, 20995, 21002, 21051, 21419, 21466, 21508, 21509, 21510, 21511, 21512, 21563, 21564, 21565, 21566, 21567, 21578, 21663, 21767, 22262, 22304, 22309, 22566, 22676, 22831, 22841, 22859, 22909, 22923, 22924, 22933, 22936, 23050, 23051, 23162, 23163, 23164, 23435, 23439, 23680, 23778, 23902, 23913, 24051, 24076, 24400, 24439, 24562, 24568, 24569, 24570, 24601, 24735, 24768, 24812, 24823, 24841, 24842, 24846, 24847, 24848, 24849, 24850, 24856, 24872, 24969, 25383, 25456, 25457, 25589, 25592, 26002, 26087, 26149, 26327, 26338, 26339, 26340, 26342, 26368, 26667, 26935, 27012, 27013, 27134, 27141, 27234, 27298, 27299, 27313, 27317, 27341, 27453, 27675, 27839, 27889, 27946, 28021, 28022, 28023, 28024, 28044, 28101, 28173, 28234, 28268, 28270, 28271, 28272, 28282, 28284, 28307, 28308, 28316, 28329, 28330, 28331, 28360, 28443, 28472, 28473, 28474, 28475, 28476, 28488, 28491, 28492, 28493, 28494, 28501, 28502, 28503, 28504, 28505, 28671, 28698, 28734, 28778, 28779, 28780, 28781, 28782, 28805, 28807, 28810, 28811, 28812, 28835, 28836, 28837, 28838, 28856, 28857, 28858, 28859, 28860, 28895, 28896, 28955, 28956, 28979, 29002, 29029, 29154, 29155, 29156, 29157, 29158, 29160, 29184, 29240, 29242, 29243, 29244, 29245, 29261, 29366, 29484, 29577, 29578, 29579, 29590, 29607, 29608, 29609, 29610, 29612, 29613, 29614, 29615, 29616, 29617, 29621, 29624, 29655, 29656, 29657, 29658, 29665, 29666, 29687, 29688, 29833, 29838, 29929, 29936, 29985, 30128, 30167, 30172, 30225, 30248, 30249, 30250, 30251, 30252, 30263, 30273, 30286, 30298, 30299, 30308, 30334, 30335, 30406, 30407, 30408, 30409, 30410, 30574, 30575, 30576, 30577, 30578, 30691, 30693, 30821, 30887, 30905, 30922, 30923, 30929, 30986, 30987, 30988, 30998, 31000, 31001, 31002, 31007, 31117, 31135, 31136, 31150, 31152, 31184, 31185, 31186, 31187, 31188, 31190, 31192, 31199, 31234, 31261, 31295, 31296, 31376, 31468, 31469, 31470, 31471, 31472, 31496, 31515, 31526, 31578, 31736, 31746, 31818, 31821, 31822, 31824, 31825, 31826, 31979, 31980, 31987, 32003, 32092, 32149, 32224, 32225, 32452, 32548, 32558, 32561, 32735, 33078, 33079, 33120, 33121, 33133, 33278, 33284, 33337, 33446, 33447, 33448, 33449, 33450, 33451, 33452, 33453, 33454, 33455, 33456, 33457, 33458, 33459, 33462, 33463, 33464, 33465, 33466, 33489, 33490, 33491, 33492, 33493, 33494, 33495, 33496, 33498, 33499, 33500, 33501, 33502, 33503, 33504, 33505, 33506, 33507, 33508, 33509, 33519, 33520, 33521, 33522) 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