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(26946, 26947, 26948, 27312, 14123, 6912, 4114, 11280, 26736, 4212, 20515, 24553, 11400, 17715, 27370, 19380, 17054, 12678, 20517, 12246, 8913, 14994, 25491, 20378, 12312, 9884, 26031, 19288, 9550, 4115, 9307, 9108, 24145, 17983, 13803, 24487, 7761, 9273, 11088, 24114, 4867, 4277, 5217, 24120, 14156, 19732, 4035, 15075, 6132, 25021, 6039, 11135, 4868, 929, 13075, 4184, 11248, 23533, 20079, 20031, 9470, 9978, 10702, 9977, 12050, 7758, 25793, 11950, 26548, 17986, 12669, 19381, 10047, 7397, 3718, 10640, 4067, 3459, 9106, 11159, 4582, 20573, 16658, 13097, 22975, 4777, 26713, 15006, 4278, 12927, 12124, 19909, 22293, 20172, 24133, 14529, 5956, 16217, 22307, 24541, 19280, 12320, 11128, 20112, 17852, 14484, 14859, 12769, 12247, 4213, 15982, 10368, 17560, 19402, 24560, 12467, 12634, 3320, 12506, 10826, 20086, 10665, 12213, 9551, 1713, 11254, 13984, 3076, 14298, 19842, 7358, 26252, 20077, 16231, 15247, 19660, 3462, 19383, 7385, 14093, 21148, 19700, 17634, 13105, 21875, 11137, 6193, 23532, 13141, 16965, 4974, 21769, 12279, 12567, 11411, 5357, 15025, 3855, 11160, 10638, 11173, 13460, 7629, 7646, 19304, 17987, 16037, 12929, 23064, 3760, 19515, 7951, 8878, 9500, 7631, 20806, 5039, 834, 17578, 20657, 23547, 9176, 19828, 20070, 5526, 10675, 6130, 15069, 18266, 8485, 16228, 16512, 5000, 11371, 13020, 13684, 20046, 6143, 18903, 4318, 9628, 11287, 21359, 4123, 3571, 11203, 20528, 22608, 4332, 7177, 881, 13052, 16557, 21094, 11305, 8091, 14095, 19482, 20195, 14745, 21090, 1605, 643, 22533, 22564, 23531, 23548, 9888, 1265, 4011, 209, 21910, 2586, 7812, 23535, 10449, 12945, 20868, 21762, 11247, 5963, 8909, 9107, 12268, 13140, 11372, 9668, 9933, 13823, 5254, 17323, 13318, 2324, 22461, 14997, 15070, 12770, 20864, 11308, 4030, 5010, 12322, 22234, 19382, 4494, 14195, 9469, 23536, 11373, 2920, 20350, 4095, 23080, 20278, 12704, 11131, 11347, 14246, 20612, 18033, 14234, 20489, 13961, 20069, 10223, 12693, 12532, 23675, 6511, 17180, 14663, 24927, 9417, 20516, 22456, 596, 21571, 21874, 9991, 19627, 23437, 13057, 10919, 20743, 20381, 21001, 22231, 23537, 11167, 25357, 9468, 10526, 20500, 21569, 20032, 22838, 9471, 15418, 24185, 9979, 14531, 22790, 22990, 23559, 9781, 22037, 9746, 8327, 23623, 21882, 19707, 19296, 10185, 9206, 12700, 11634, 15983, 3776, 7787, 5525, 13050, 26976, 9864, 14004, 18392, 10982, 658, 4875, 4050, 2375, 24176, 24897, 10341, 23663, 13771, 19095, 8730, 14193, 17624, 13243, 18547, 19001, 21619, 17781, 257, 18800, 4275, 6149, 12196, 11533, 10192) 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