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(523, 582, 1208, 1580, 1581, 1582, 1583, 1584, 1585, 1905, 3059, 3193, 3283, 4350, 4622, 5347, 5348, 5857, 6071, 6075, 6465, 6562, 6563, 6587, 6592, 6613, 6730, 6792, 6905, 6906, 7854, 8001, 8461, 8462, 9013, 9014, 9015, 9016, 9185, 9657, 9669, 9670, 9819, 10864, 10891, 10937, 11652, 11796, 11809, 11898, 11952, 12120, 12395, 12514, 12561, 12588, 13178, 13284, 13290, 13291, 13467, 13915, 14111, 14112, 14587, 14992, 15393, 15451, 15452, 15453, 15454, 15455, 15500, 15502, 15737, 15910, 16080, 16084, 16529, 16906, 16907, 16908, 16925, 16926, 17040, 17041, 17042, 17043, 17144, 17145, 17370, 17592, 17593, 17594, 17595, 17596, 17603, 17604, 17605, 17606, 17607, 17614, 17615, 17616, 17845, 17846, 17847, 17854, 17857, 17872, 17913, 17914, 17919, 17920, 17922, 17929, 17930, 17931, 17959, 17973, 17976, 17977, 17978, 18904, 19779, 19953, 20228, 20505, 20934, 21059, 21183, 21986, 22269, 22339, 22342, 22610, 22615, 22803, 23484, 23625, 23905, 24045, 24158, 24170, 24215, 24455, 24456, 24464, 24465, 24466, 24467, 24468, 24469, 24470, 24471, 24478, 24481, 24482, 24606, 24611, 24625, 24674, 24750, 24757, 24758, 24760, 24803, 24807, 24808, 24809, 24810, 24814, 24815, 24816, 24836, 24837, 24838, 24863, 24869, 25047, 25048, 25049, 25050, 25051, 25055, 25083, 25125, 25370, 25405, 25406, 25408, 25434, 25605, 25657, 25661, 25662, 25663, 25664, 25665, 25666, 25667, 25668, 25669, 25670, 25671, 25672, 25673, 25693, 25694, 25695, 25696, 25697, 25698, 25699, 25700, 25701, 25702, 25703, 25704, 25705, 25706, 25707, 25708, 25709, 25710, 25713, 25714, 25715, 25716, 25717, 25718, 25719, 25720, 25721, 25722, 25723, 25724, 25725, 25726, 25918, 25949, 26019, 26045, 26046, 26047, 26048, 26060, 26061, 26074, 26075, 26086, 26146, 26147, 26179, 26649, 26650, 26754, 26755, 26790, 27438, 27439, 27457, 27464, 27469, 27470, 27471, 27803, 27846, 27974, 27982, 27985, 28062, 28154, 28160, 28342, 28343, 28344, 28345, 28346, 28363, 28378, 28530, 28544, 28638, 28717, 29013, 29034, 29036, 29037, 29038, 29039, 29042, 29043, 29044, 29057, 29058, 29071, 29072, 29073, 29083, 29106, 29120, 29197, 29207, 29376, 29443, 29465, 29498, 29560, 29571, 29702, 29711, 29747, 29758, 29762, 29769, 29773, 29774, 29955, 30041, 30042, 30050, 30072, 30086, 30087, 30088, 30090, 30091, 30092, 30093, 30103, 30104, 30105, 30106, 30108, 30109, 30110, 30111, 30112, 30113, 30114, 30115, 30116, 30117, 30118, 30123, 30124, 30125, 30126, 30127, 30136, 30137, 30138, 30139, 30140, 30157, 30158, 30159, 30160, 30161, 30179, 30191, 30218, 30220, 30224, 30237, 30240, 30318, 30427, 30428, 30430, 30431, 30442, 30443, 30451, 30452, 30456, 30457, 30458, 30459, 30460, 30461, 30462, 30464, 30465, 30474, 30488, 30497, 30500, 30501, 30505, 30512, 30513, 30514, 30515, 30517, 30520, 30522, 30535, 30542, 30646, 30697, 30747, 30748, 30766, 30769, 30770, 30778, 30779, 30797, 30799, 30805, 30806, 30822, 30824, 30832, 30833, 30842, 30855, 30870, 30872, 30893, 30906, 30930, 30931, 30938, 30941, 31064, 31065, 31066, 31067, 31068, 31087, 31129, 31130, 31176, 31177, 31178, 31179, 31180, 31286, 31287, 31383, 31395, 31412, 31592, 31627, 31628, 31630, 31631, 31633, 31643, 31648, 31650, 31651, 31652, 31684, 31685, 31686, 31687, 31688, 31864, 31958, 31959, 32008, 32009, 32010, 32011, 32013, 32014, 32019, 32044, 32045, 32046, 32093, 32094, 32099, 32100, 32226, 32227, 32228, 32229, 32526, 32531, 32532, 32533, 32534, 32582, 32598, 32652, 32653, 32654, 32655, 32656, 32671, 32672, 32673, 32674, 32675, 32676, 32677, 32678, 32679, 32680, 32695, 32696, 32698, 32974, 32975, 32976, 33111, 33112, 33185, 33219, 33220, 33223, 33360, 33372, 33373, 33386, 33474, 33541) 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