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(457, 524, 543, 660, 664, 775, 803, 929, 1016, 1024, 1064, 1066, 1068, 1071, 1073, 1074, 1077, 1079, 1080, 1081, 1083, 1108, 1112, 1205, 1218, 1219, 1236, 1265, 1270, 1575, 1577, 1579, 1771, 1923, 1931, 1932, 1934, 1939, 1940, 1942, 1943, 1944, 1948, 1950, 1951, 2105, 2106, 2109, 2449, 2475, 2534, 2625, 2626, 2666, 2669, 2670, 2672, 2675, 2987, 3112, 3119, 3147, 3152, 3181, 3182, 3183, 3184, 3388, 3663, 3665, 3718, 3799, 3914, 4209, 4233, 4264, 4265, 4288, 4325, 4351, 4362, 4368, 4532, 4540, 4602, 4686, 4861, 4885, 4997, 5052, 5098, 5186, 5187, 5189, 5218, 5223, 5315, 5551, 5781, 5954, 6120, 6131, 6132, 6133, 6176, 6190, 6214, 6248, 6304, 6427, 6494, 6495, 6740, 6928, 6948, 7076, 7078, 7180, 7355, 7364, 7397, 7398, 7457, 7526, 7617, 7680, 7865, 7866, 8000, 8053, 8055, 8056, 8057, 8072, 8073, 8074, 8075, 8076, 8103, 8104, 8105, 8106, 8148, 8211, 8212, 8330, 8625, 8800, 8854, 8865, 8884, 8886, 8925, 9169, 9170, 9171, 9198, 9199, 9200, 9305, 9433, 9504, 9506, 9736, 9918, 9927, 10375, 10438, 10444, 10516, 10575, 10701, 10828, 10839, 10892, 10923, 10959, 10996, 11408, 11536, 11896, 12054, 12521, 12840, 13138, 13390, 13407, 13495, 13553, 13554, 13708, 13775, 13937, 14022, 14030, 14167, 14168, 14169, 14170, 14193, 14194, 14195, 14381, 14464, 14501, 14555, 14581, 14870, 15059, 15101, 15151, 15354, 15386, 15408, 15447, 15519, 15521, 15522, 15556, 15667, 15696, 15699, 15710, 15752, 15782, 15841, 15851, 15852, 15853, 15860, 15861, 15866, 15932, 16008, 16028, 16109, 16152, 16442, 16627, 16654, 16655, 16681, 16837, 16944, 17275, 17283, 17284, 17285, 17286, 17322, 17777, 17849, 17850, 17961, 18033, 18034, 18431, 18449, 18487, 18505, 18513, 18524, 18558, 18638, 18654, 18655, 18945, 18970, 19001, 19015, 19048, 19052, 19102, 19120, 19301, 19321, 19668, 19869, 19915, 20239, 20607, 20806, 20831, 20832, 20834, 20867, 20868, 20878, 20901, 20914, 20915, 20916, 21094, 21236, 21407, 21552, 21569, 21576, 21718, 21758, 22037, 22038, 22039, 22040, 22041, 22051, 22315, 22317, 22319, 22320, 22327, 22335, 22359, 22458, 22517, 22527, 22533, 22582, 22591, 22594, 22634, 22639, 22654, 22918, 22919, 22976, 22992, 23075, 23208, 23209, 23362, 23363, 23364, 23365, 23367, 23368, 23369, 23370, 23371, 23372, 23374, 23375, 23376, 23377, 23378, 23379, 23380, 23381, 23382, 23383, 23384, 23385, 23386, 23387, 23388, 23389, 23390, 23391, 23392, 23393, 23442, 23459, 23531, 23532, 23533, 23534, 23535, 23536, 23537, 23538, 23539, 23540, 23541, 23542, 23543, 23544, 23545, 23546, 23547, 23548, 23549, 23550, 23551, 23552, 23553, 23554, 23555, 23556, 23557, 23558, 23559, 23560, 23565, 23566, 23623, 23787, 23898, 23900, 23911, 23994, 23996, 24024, 24062, 24097, 24102, 24108, 24153, 24156, 24167, 24175, 24176, 24182, 24185, 24192, 24193, 24216, 24217, 24218, 24219, 24234, 24239, 24253, 24270, 24284, 24359, 24360, 24458, 24460, 24483, 24486, 24509, 24533, 24534, 24536, 24539, 24541, 24543, 24550, 24552, 24557, 24559, 24571, 24572, 24574, 24575, 24600, 24614, 24627, 24628, 24661, 24682, 24689, 24691, 24702, 24724, 24737, 24746, 24862, 24877, 24878, 24882, 24883, 24884, 24885, 24886, 24887, 24888, 24889, 24890, 24893, 24894, 24895, 24896, 24897, 24898, 24899, 24900, 24905, 24906, 24907, 24909, 24910, 24911, 24912, 24913, 24914, 24915, 24916, 24917, 24918, 24919, 24920, 24921, 24922, 24923, 24928, 24929, 24930, 24931, 24932, 24933, 24934, 24935, 24937, 24938, 24939, 24965, 24966, 24998, 24999, 25036, 25037, 25038, 25039, 25135, 25165, 25169, 25173, 25175, 25186, 25354, 25355, 25356, 25357, 25358, 25375, 25376, 25380, 25384, 25396, 25397, 25398, 25400, 25401, 25409, 25436, 25437, 25439, 25591, 25596, 25606, 25607, 25623, 25674, 25675, 25677, 25681, 25899, 25959, 25960, 25961, 25978, 26076, 26077, 26078, 26145, 26176, 26209, 26341, 26396, 26406, 26433, 26436, 26530, 26531, 26543, 26544, 26546, 26547, 26549, 26551, 26553, 26556, 26557, 26566, 26567, 26568, 26569, 26589, 26593, 26634, 26664, 26684, 26702, 26704, 26747, 26772, 26895, 26896, 26897, 26898, 26900, 26985, 26992, 27058, 27059, 27060, 27061, 27062, 27080, 27180, 27200, 27204, 27209, 27218, 27344, 27346, 27347, 27348, 27349, 27350, 27351, 27369, 27370, 27371, 27372, 27373, 27395, 27396, 27421, 27465, 27474, 27481, 27482, 27604, 27676, 27678, 27679, 27769, 27770, 27771, 27772, 27806, 27817, 27842, 27843, 27848, 27849, 27858, 27861, 27862, 27863, 27864, 27865, 27866, 27867, 27868, 27869, 27870, 27871, 27872, 27873, 27890, 27891, 27892, 27893, 27894, 27895, 27896, 27897, 27898, 27899, 27900, 27901, 27902, 27903, 27904, 27960, 27961, 27962, 27963, 27975, 27983, 27984, 27994, 27995, 28004, 28005, 28007, 28008, 28009, 28034, 28074, 28144, 28156, 28157, 28159, 28183, 28184, 28185, 28186, 28187, 28192, 28193, 28194, 28195, 28196, 28201, 28267, 28274, 28294, 28295, 28296, 28297, 28298, 28302, 28324, 28337, 28338, 28393, 28394, 28426, 28433, 28442, 28449, 28485, 28486, 28508, 28509, 28526, 28531, 28551, 28552, 28582, 28640, 28655, 28656, 28657, 28658, 28667, 28757, 28758, 28759, 28768, 28769, 28770, 28771, 28772, 28783, 28784, 28785, 28786, 28787, 28803, 28804, 28806, 28808, 28809, 28829, 28830, 28831, 28832, 28833, 28851, 29091, 29113, 29114, 29115, 29116, 29128, 29148, 29182, 29191, 29301, 29333, 29368, 29576, 29595, 29635, 29673, 29696, 29697, 29735, 29736, 29790, 29793, 29854, 29855, 29856, 29868, 29871, 29888, 29911, 29939, 30022, 30023, 30024, 30025, 30035, 30036, 30037, 30038, 30039, 30047, 30063, 30107, 30182, 30183, 30184, 30185, 30186, 30204, 30205, 30206, 30207, 30208, 30277, 30292, 30294, 30326, 30327, 30328, 30369, 30377, 30380, 30387, 30388, 30478, 30479, 30499, 30506, 30508, 30588, 30589, 30590, 30591, 30642, 30643, 30644, 30668, 30708, 30807, 30854, 30859, 30868, 30871, 30886, 30895, 30903, 30921, 30949, 30969, 30970, 31073, 31074, 31167, 31233, 31280, 31281, 31284, 31334, 31347, 31348, 31349, 31350, 31367, 31485, 31486, 31488, 31502, 31576, 31595, 31680, 31734, 31823, 31857, 31866, 31876, 31877, 31878, 31894, 31897, 31900, 31919, 31924, 31926, 31932, 31964, 31965, 31971, 31972, 31973, 31974, 32060, 32061, 32063, 32081, 32119, 32120, 32121, 32124, 32161, 32162, 32195, 32241, 32242, 32275, 32276, 32390, 32392, 32430, 32438, 32439, 32440, 32441, 32442, 32458, 32521, 32525, 32528, 32732, 32747, 32750, 32762, 32778, 32794, 32813, 32814, 32815, 32816, 32817, 32879, 32880, 33054, 33132, 33187, 33200, 33201, 33306, 33325, 33476, 33598, 33599, 33600, 33601, 33602, 33606, 33618, 33637, 33639, 33647, 33648, 33649, 33656, 33657, 33660) 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