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(27048, 27041, 2401, 27045, 27040, 27044, 27047, 27043, 27046, 27042, 4195, 24782, 23157, 21057, 23231, 22782, 25494, 25493, 24512, 9681, 23339, 27232, 27410, 26879, 6378, 6135, 26814, 27231, 26841, 27091, 26880, 27113, 27092, 11377, 24371, 16508, 16509, 27355, 27093, 27307, 27286, 27356, 10214, 26887, 26896, 26965, 27075, 25743, 27402, 4035, 17792, 9549, 26828, 26881, 14123, 17032, 16513, 12737, 19034, 9272, 20079, 25466, 2682, 3338, 612, 3534, 14039, 23773, 13770, 22564, 4750, 10677, 11555, 13744, 14164, 9164, 21909, 13141, 20409, 3287, 12927, 24597, 4115, 12833, 16765, 12334, 9471, 26031, 14119, 16515, 24390, 16516, 358, 3751, 11933, 9307, 8403, 25491, 12311, 24777, 13864, 4867, 9885, 20513, 17815, 10385, 25211, 11086, 8823, 25212, 4767, 4184, 14257, 12612, 19282, 19732, 26973, 17983, 19228, 18801, 24114, 25499, 26277, 25610, 25869, 4752, 24410, 10395, 572, 25858, 25542, 5608, 12932, 11774, 11044, 10678, 14968, 4277, 13802, 12678, 11172, 24145, 4809, 24120, 12050, 26794, 7760, 2396, 23349, 26276, 711, 3492, 25863, 10380, 4177, 20514, 3399, 4036, 4067, 12246, 25021, 20035, 9977, 11129, 11375, 17054, 15075, 24551, 5558, 9107, 20058, 13848, 26548, 23337, 24144, 13800, 7923, 19094, 11950, 19366, 11139, 6039, 11373, 11971, 4868, 12627, 19382, 7758, 18387, 22307, 3462, 22293, 3459, 20112, 18393, 10617, 10640, 13351, 4777, 4494, 17715, 13118, 10966) 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