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(4030, 20890, 26692, 26693, 26760, 26822, 26694, 27125, 26821, 26888, 27124, 26890, 26759, 26823, 19401, 27039, 27267, 27286, 9181, 26758, 27412, 16271, 17560, 16502, 26889, 26204, 18801, 3761, 17852, 4539, 26893, 23333, 18996, 12628, 2154, 17115, 23234, 23334, 16577, 24103, 12998, 11171, 4170, 7016, 20575, 22538, 13117, 13009, 4067, 16481, 4184, 3198, 25108, 5367, 27266, 21619, 14569, 18458, 22293, 10944, 10943, 13945, 4011, 3616, 26796, 26748, 24359, 26712, 24231, 24930, 24235, 19515, 12162, 4997, 24911, 9987, 4337, 18451, 19095, 22996, 3322, 667, 12773, 4278, 8968, 3323, 26713, 23975, 19298, 4275, 8977, 13114, 4279, 14095, 5476, 13135, 17275, 3872, 17576, 11172, 24144, 9781, 9886, 7725, 3873, 11402, 11357, 4492, 1949, 4777, 17776, 14642, 13800, 17495, 3326, 22461, 13040, 20078, 15069, 12704, 19556, 11129, 19947, 20102, 10477, 24140, 8403, 14484, 24133, 4050, 12598, 23549, 12165, 19624, 8912, 24114, 24145, 25799, 25794, 25793, 11061, 24143, 4068, 7698, 9888, 12212, 14156, 4039, 12213, 11174, 8382, 23551, 12942, 21762, 13052, 3665, 11222, 4939, 3070, 21582, 12707, 11160, 13823, 9264, 6049, 6978, 21324, 22777, 24549, 4276, 10982, 22317, 9503, 23550, 23741, 11438, 12688, 12116, 26794, 3850, 19482, 20531, 17624, 19057, 13460, 12527, 10341, 12148, 12681, 7385, 14093, 20501, 13612, 11549, 11130, 11131, 12196, 4809, 7592, 6012, 6039, 17574, 22954, 4940, 24560, 13973, 11132, 9978, 12703, 12742, 23106, 14875, 20082, 7590, 20099, 13143, 24146, 21530, 12117, 11248, 17464, 18196, 14223, 22776, 11973, 11137, 20516, 8137, 11974, 11371, 24561, 24120, 25803, 19381, 11435, 4168, 23219, 19383, 12693, 1270, 4135, 17761, 19936, 20086, 10792, 3933, 7758, 17986, 6143, 15000, 12836, 11060, 11011, 3639, 23525, 9991, 13975, 20528, 1394, 13133, 17573, 12874, 21581, 8913, 13723, 4318, 8299, 12506, 24142, 8933, 8048, 20573, 23800, 13097, 19384, 10639, 23552, 11227, 13242, 21133, 24927, 11128, 19938, 19937, 10665, 10627, 11197, 12322, 20172, 11135, 8956, 12479, 9668, 11305, 11353, 10368, 10921, 9325, 1260, 12626, 4494, 6149, 14323, 12932, 9451, 11173, 7726, 12065, 12529, 18033, 11159, 5000, 181, 16175, 20514, 8485, 5059, 8430, 3583, 13771, 19939, 22550, 23624, 4386, 13010, 12687, 6931, 19402, 11439, 17742, 4371, 19796, 11373, 920, 19005, 20096, 20031, 3399, 19909, 9505, 4211, 19717, 24573, 10214, 3926, 13784, 17715, 20035, 20893, 20612, 21561, 17987, 3462, 12124, 7357, 12505, 11909, 6774, 12769, 20070, 20032, 4248, 9990, 14545, 12627, 21620, 11404, 530, 1313, 3634, 21571, 22793, 6655, 9979, 10438, 20177, 8330, 19836, 7863, 5257, 3459, 12728, 22452, 22307, 20112, 10959, 4115, 4370, 6604, 13335, 19555, 20081, 20485, 26648, 16434, 11045, 12508, 19732, 3864, 19285, 19364, 23370, 12050, 12700, 23618, 21539, 24782, 22371, 19382, 12927, 22969, 11372, 18029, 7633, 25681, 22975, 3292, 18445, 18630, 17634, 17323, 19203, 21625) 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