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(256, 434, 469, 560, 616, 718, 733, 768, 794, 813, 827, 883, 908, 915, 991, 993, 1078, 1110, 1664, 1665, 1667, 1854, 1920, 2095, 2096, 2100, 2324, 2341, 2368, 2374, 2429, 2435, 2480, 2488, 2495, 2529, 2549, 2632, 2916, 2917, 2918, 2919, 3069, 3084, 3133, 3211, 3212, 3248, 3355, 3370, 3384, 3416, 3443, 3479, 3571, 3697, 3698, 3710, 3785, 3788, 3833, 4024, 4049, 4097, 4123, 4329, 4332, 4475, 4518, 4599, 4664, 4716, 4775, 4794, 5036, 5038, 5197, 5198, 5576, 5624, 5823, 5853, 6145, 6146, 6293, 6294, 6295, 6392, 7010, 7034, 7035, 7169, 7183, 7192, 7234, 7235, 7330, 7508, 7515, 7517, 7657, 7833, 7839, 7909, 7995, 8021, 8525, 8575, 8583, 8587, 8588, 8658, 8659, 8692, 8694, 8730, 8756, 8775, 8799, 8979, 8996, 9176, 9194, 9240, 9243, 9554, 9693, 9708, 9709, 9710, 10080, 10342, 10460, 10539, 10612, 10800, 10849, 11179, 11180, 11181, 11182, 11203, 11204, 11205, 11206, 11279, 11308, 11521, 11718, 11749, 11762, 11870, 11871, 11910, 11969, 11970, 11988, 11992, 12001, 12015, 12034, 12035, 12044, 12048, 12109, 12110, 12111, 12154, 12179, 12191, 12237, 12239, 12259, 12260, 12300, 12480, 12649, 12674, 12932, 12943, 13004, 13054, 13214, 13417, 13633, 13675, 13730, 13754, 13866, 14021, 14153, 14192, 14259, 14296, 14336, 14339, 14340, 14403, 14432, 14450, 14456, 14460, 14670, 14783, 14802, 14824, 14866, 14868, 14897, 14898, 14899, 14900, 14907, 14909, 14910, 14912, 14918, 14919, 14921, 14922, 14988, 15020, 15031, 15033, 15077, 15171, 15238, 15270, 15422, 15520, 15536, 15601, 15603, 15701, 15705, 15713, 15769, 15770, 15796, 15865, 15870, 15914, 15947, 16115, 16557, 16649, 16673, 16781, 16787, 16811, 16890, 16949, 17044, 17045, 17046, 17057, 17086, 17169, 17195, 17223, 17225, 17321, 17327, 17328, 17400, 17401, 17423, 17475, 17485, 17537, 17620, 17637, 17668, 17670, 17671, 17672, 17732, 17778, 18099, 18108, 18109, 18239, 18240, 18241, 18242, 18283, 18392, 18410, 18411, 18608, 18609, 18610, 18611, 18612, 18625, 18708, 18785, 18816, 18828, 18888, 18892, 19007, 19013, 19123, 19165, 19168, 19169, 19278, 19299, 19391, 19392, 19422, 19431, 19441, 19498, 19505, 19519, 19627, 19787, 19819, 19820, 19821, 19822, 20091, 20093, 20094, 20214, 20242, 20282, 20283, 20284, 20285, 20286, 20478, 20479, 20481, 20482, 20483, 20543, 20660, 20661, 20716, 20783, 20786, 20788, 20793, 20805, 20810, 20839, 20845, 20871, 20877, 20893, 20898, 20904, 20969, 20970, 21035, 21124, 21185, 21186, 21400, 21483, 21533, 21535, 21585, 21603, 21628, 21652, 21664, 21710, 21745, 21798, 21877, 21902, 21952, 22028, 22096, 22097, 22204, 22205, 22261, 22279, 22280, 22365, 22368, 22371, 22414, 22480, 22492, 22525, 22544, 22560, 22562, 22612, 22698, 22781, 22812, 22926, 22999, 23000, 23001, 23002, 23062, 23071, 23072, 23074, 23097, 23174, 23187, 23210, 23504, 23764, 23765, 23766, 23806, 23807, 23823, 23824, 23825, 23826, 23827, 23893, 23946, 23950, 24072, 24125, 24200, 24473, 24697, 24728, 24732, 24739, 24802, 24983, 25013, 25017, 25033, 25034, 25052, 25053, 25054, 25056, 25057, 25069, 25070, 25071, 25072, 25073, 25106, 25107, 25108, 25120, 25121, 25132, 25188, 25268, 25328, 25329, 25391, 25395, 25447, 25777, 25922, 26162, 26203, 26263, 26607, 26608, 26860, 26862, 26894, 27337, 27340, 27625, 27670, 27914, 28525, 28631, 28736, 29035, 29350, 29351, 29721, 29787, 29801, 29803, 29816, 29843, 29911, 29925, 29961, 29963, 29966, 29967, 30001, 30002, 30010, 30012, 30013, 30014, 30015, 30020, 30084, 30253, 30338, 30339, 30340, 30341, 30342, 30445, 30948, 31069, 31134, 31494, 31752, 31758, 31769, 31773, 31845, 31847, 31849, 31928, 32183, 32214, 33704) 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