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(30, 435, 512, 515, 609, 707, 708, 753, 859, 1618, 1781, 2110, 2154, 2383, 2390, 2400, 2401, 2406, 2407, 2418, 2684, 2687, 3073, 3074, 3146, 3148, 3281, 3287, 3378, 3534, 3647, 3835, 4374, 4497, 4750, 4752, 4759, 4844, 5363, 5428, 5439, 5641, 6134, 6135, 6528, 6789, 7163, 7177, 7181, 7813, 7831, 7963, 8007, 8434, 9181, 9357, 10330, 10698, 10778, 10779, 10780, 10781, 10992, 11139, 11200, 11428, 11675, 11767, 12107, 12648, 12739, 13144, 13593, 13594, 13934, 14321, 14989, 15347, 15399, 15651, 15697, 15698, 15913, 16092, 16093, 16517, 17437, 17438, 17439, 17951, 18024, 18738, 18929, 18930, 18932, 19208, 19227, 19332, 19456, 19809, 20096, 20189, 20303, 20338, 20379, 20409, 20575, 20753, 21014, 21058, 21068, 21069, 21097, 21098, 21099, 21100, 21107, 21126, 21131, 21132, 21139, 21155, 21231, 21253, 21362, 21414, 21555, 21560, 21676, 21913, 21964, 22027, 22259, 22260, 22467, 22894, 22955, 24048, 24258, 24656, 24660, 24672, 24684, 24685, 24695, 25454, 25467, 25484, 25486, 25497, 25515, 25529, 25538, 25543, 25545, 26032, 26413, 27504, 27505, 27506, 27507, 27508, 27509, 27510, 27512, 27547, 27548, 27549, 27550, 27551, 27552, 27553, 27554, 27555, 27556, 27571, 27572, 27573, 27574, 27575, 27576, 27577, 27578, 27579, 27580, 27581, 27582, 27583, 27584, 27585, 27586, 27589, 27590, 27591, 27592, 27593, 27594, 27595, 27596, 27597, 27598, 27599, 27600, 27601, 27602, 27603, 27608, 27609, 27610, 27611, 27612, 27613, 27614, 27615, 27616, 27617, 27618, 27619, 27620, 27622, 27623, 27624, 27626, 27627, 27628, 27629, 27630, 27631, 27632, 27633, 27634, 27635, 27636, 27637, 27638, 27639, 27640, 27641, 27642, 27643, 27644, 27645, 27646, 27647, 27648, 27649, 27650, 27651, 27652, 27653, 27654, 27655, 27656, 27657, 27658, 27659, 27660, 27661, 27662, 27681, 27682, 27683, 27684, 27685, 27686, 27687, 27688, 27689, 27690, 27691, 27692, 27693, 27694, 27695, 27696, 27697, 27698, 27699, 27700, 27701, 27702, 27703, 27704, 27705, 27706, 27707, 27708, 27709, 27710, 27711, 27712, 27713, 27714, 27715, 27721, 27722, 27723, 27724, 27725, 27726, 27727, 27728, 27729, 27730, 27731, 27732, 27733, 27734, 27735, 27736, 27737, 27738, 27739, 27740, 27741, 27742, 27743, 27744, 27745, 27746, 27747, 27748, 27749, 27750, 27751, 27752, 27753, 27754, 27755, 27756, 27757, 27966, 29900, 30180, 31004, 31440, 32173, 33631) 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