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(4213, 4325, 22565, 10688, 6621, 4788, 16428, 7820, 8059, 10715, 8598, 10261, 9891, 12104, 3356, 9998, 7140, 10717, 12380, 9706, 12300, 10660, 7451, 8675, 9271, 3887, 4588, 12002, 12170, 4899, 1991, 6329, 8975, 5903, 3039, 3138, 4208, 2788, 7208, 9496, 6931, 11611, 10260, 10946, 12359, 10907, 8668, 8074, 8101, 10909, 12323, 8587, 8105, 9214, 8953, 9946, 5023, 12198, 8092, 5367, 4032, 7831, 6774, 11175, 7355, 7383, 4448, 11055, 7135, 11051, 10918, 4777, 8604, 10784, 10047, 8956, 4736, 11974, 8680, 4378, 10820, 6730, 11946, 5149, 11640, 11406, 10702, 5821, 12153, 4391, 7185, 11137, 4230, 10163, 8113, 9766, 7695, 7079, 12241, 9570, 8428, 22446, 4602, 5383, 9912, 6778, 8797, 9864, 12124, 6955, 10761, 8057, 11261, 8924, 6162, 4349, 7198, 6063, 15729, 7633, 22913, 9788, 10277, 7047, 11347, 5957, 4412, 6471, 1505, 4910, 13937, 22945, 9210, 1892, 11453, 10287, 8222, 11859, 5185, 11152, 11962, 7037, 12071, 21366, 9070, 9757, 6597, 3423, 11346, 6258, 11907, 11211, 7984, 3332, 12311, 8280, 6937, 9635, 7859, 8979, 12661, 11251, 4750, 11759, 7813, 11705, 8565, 6464, 11774, 8594, 5680, 12197, 5118, 6126, 10278, 6527, 6118, 4491, 5396, 5216, 5438, 2141, 14348, 11823, 8648, 5783, 7357, 8067, 6040, 2693, 4972, 10111, 11553, 25308, 4493, 4581, 5956, 6594, 9742, 7131, 6440, 9887, 11428, 12195, 12091, 11437, 10330, 4747, 5864, 7100, 5668, 4335, 7657, 7107, 9745, 4322, 2144, 5708, 10541, 7741, 4451, 4438, 11588, 6166, 12246, 12117, 3037, 5217, 12374, 9951, 9200, 6749, 4446, 16197, 16310, 12152, 12230, 6987, 11334, 9417, 9181, 12113, 4624, 10124, 6827, 12098, 17166, 3339, 8957, 5356, 10781, 11356, 12352, 7812, 4490, 11400, 12666, 11304, 555, 11439, 10488, 7491, 7931, 12324, 3322, 4385, 6828, 5307, 8439, 5873, 4680, 7693, 7986, 6979, 7728, 4314, 9924, 8958, 11909, 5527, 16512, 9979, 4494, 12062, 11506, 8132, 8601, 8840, 12369, 9950, 8971, 3182, 10676, 4007, 11615, 4913, 5608, 10291, 4294, 11656, 10048, 3378, 5366, 9665, 9889, 4931, 10943, 3131, 11911, 12130, 7726, 9060, 13645, 4742, 8976, 12128, 11135, 10323, 4492, 11839, 4582, 7399, 10563, 3134, 9552, 9991, 10835, 12304, 12209, 10531, 2824, 10678, 4204, 4084, 7759, 10908, 11266, 11781, 6598, 4809, 21549, 4139, 4383, 10834, 5641, 7606, 12068, 10206, 4348, 6474, 8457, 9135, 7492, 12530, 3482, 7664, 3394, 11123, 23232, 11501, 5756, 12340, 5496, 5475, 12256, 8176, 6695, 4694, 8848, 9990, 12151, 12116, 4418, 8103, 4395, 4883, 4867, 4940, 3511, 12073, 9969, 8908, 9867, 16507, 17032, 2400, 21147, 18733, 10408, 4939, 9973, 4863, 10734, 9399, 6999, 10403, 5349, 12247, 4224, 10436, 11708, 4901, 8621, 8864, 12053, 9507, 3835, 9588, 11852, 9235, 5042, 11128, 8001, 6685, 6591, 8920, 9533, 7653, 4370, 10619, 11196, 6579, 6375, 11830, 4315, 11877, 11199, 9680, 9743, 5000, 8431, 6483, 7631, 11952, 3582, 1572, 1511, 6920, 19558, 10413, 10178, 9056, 4635, 11045, 12322, 8279, 4921, 11302, 8626, 390, 23032, 12052, 11170, 11069, 12148, 8333, 2406, 17817, 7991, 20985, 9837, 6071, 11654, 8812, 10288, 10945, 2156, 5672, 7872, 8713, 11503, 9684, 11927, 8376, 8329, 6593, 14012, 11131, 9602, 6839, 4641, 8584, 11326, 10982, 11160, 11975, 7277, 12145, 6132, 7592, 11230, 6473, 7358, 7758, 8926, 5919, 19718, 6463, 6655, 7629, 11272, 4318, 9155, 8345, 8576, 10529, 8656, 30, 5572, 11993, 12162, 10944, 9761, 13836, 17924, 4252, 5114, 9589, 11519, 10411, 10428, 4615, 8485, 10093, 4981, 9808, 5876, 10871, 12231, 10949, 8854, 7450, 11678, 8260, 7290, 10782, 5049, 1551, 5874, 6386, 11751, 6465, 9685, 10551, 7632, 7599, 4540, 8909, 11626, 10004, 4721, 22534, 10576, 6482, 6014, 5593, 4923, 8167, 6681, 13377, 11556, 10306, 8696, 5382, 11864, 4584, 10271, 11215, 8020, 8432, 11709, 11209, 11806, 4697, 9794, 19946, 8984, 11879, 11767, 3967, 9423, 8171, 10290, 7437, 10289, 21723, 8577, 11120, 9981, 11619, 10282, 10632, 4468, 7495, 10794, 7260, 4169, 3534, 8877, 3494, 8440, 4662, 11977, 6939, 6129, 11674, 10545, 7735, 21359, 6149, 7211, 10329, 8918, 13049, 20175, 6049, 8346, 11490, 8426, 6140, 10299, 12746, 6525, 9415, 10947, 11464, 7600, 10607, 10836, 4076, 7852, 16899, 5109, 8155, 2680, 5500, 5227, 8913, 8966, 21215, 7569, 2115, 8968, 8153, 6207, 9162, 10906, 5003, 5344, 11126, 10494, 8660, 6538, 10677, 8996, 10295, 7122, 11153, 6151, 8878, 7147, 7978, 5596, 7186, 10624, 10060, 3851, 5818, 8940, 11536, 6007, 9473, 1847, 6462, 5678, 10617, 12541, 6990, 9454, 4117, 5973, 6189, 3800, 11694, 4926, 1904, 6038, 9347, 10817, 3160, 1977, 5558, 10459, 7192, 10547, 9585, 6292, 10839, 7269, 6075, 5520, 6523, 6543, 12288, 9180, 10767, 9921, 8465, 3242, 1846, 5872, 8464, 6815, 11816, 7525, 5841, 4133, 10027, 6690, 8060, 8322, 13945, 11895, 11085, 10675, 12045, 11606, 5488, 11411, 10524, 4585, 8231, 11435, 11530, 10895, 5365, 8481, 11145, 12347, 9789, 10232, 9949, 11549, 11355, 5098, 14171, 6607, 7174, 12345, 6188, 19382, 4818, 5875, 7121, 6191, 5221, 6093, 9232, 9014, 7088, 9240, 4196, 11758, 7692, 6873, 6485, 8125, 490, 1668, 16514, 6528, 10012, 10526, 1882, 10553, 4171, 8771, 3796, 8599, 9198, 10334, 4713, 6209, 6510, 9470, 19717, 10996, 10959, 9781, 11855, 11700, 11950, 10296, 4423, 8954, 6646, 4739, 9611, 4970, 10722, 7972, 8104, 7045, 3780, 7922, 9608, 10019, 5414, 10336, 11698, 4421, 7959, 8844, 4571, 2697, 9917, 9534, 5758, 10414, 9536, 12260, 4346, 9013, 10460, 10023, 11173, 8173, 11197, 5762, 6324, 7427, 5274, 9492, 6948, 10402, 7003, 10539, 4178, 11244, 3388, 11218, 8866, 10801, 4538, 8796, 6907, 8737, 9624, 4658, 9223, 7962, 10025, 8567, 10862, 9899, 6374, 4909, 8555, 4450, 12171, 4608, 4409, 6331, 4399, 12348, 4359, 11291, 3872, 11650, 7250, 11602, 5613, 10268, 3040, 9728, 12154, 12135, 19824, 8352, 7413, 7797, 7740, 8671, 9497, 14163, 919, 17762, 17820, 18232, 21420, 21342, 6904, 6929, 7680, 10844, 7912, 8006, 8290, 9504, 7434, 11222, 11625, 10304, 11994, 10727, 7532, 7523, 12245, 11002, 8366, 14084, 8960, 4759, 8178, 12240, 11159, 4316, 8305, 10429, 8798, 4408, 4226, 12072, 4884, 8695, 6978, 6428, 7691, 8248, 5225, 5803, 10952, 3555, 4789, 9374, 4344, 6886, 5933, 11555, 5273, 4743, 10395, 11800, 5417, 24153, 8077, 3980, 3022, 5922, 12001, 10626, 3995, 9989, 11420, 11878, 10017, 7616, 11595, 8304, 5451, 5813, 3521, 9952, 3864, 6467, 7327, 8221, 11539, 11176, 7513, 2153, 9720, 20516, 10437, 11330, 8806, 5517, 6936, 9843, 11959, 4819, 11407, 11750, 14791, 7018, 8899, 7515, 10521, 8179, 9215, 8142, 11037, 8216, 7768, 5775, 5921, 11834, 6204, 5554, 5328, 5782, 12108, 10507, 6172, 5360, 7428, 6448, 11206, 12237, 12156, 10279, 5078, 12219, 11427, 20392, 6235, 5205, 12083, 11522, 10300, 3867, 6514, 7276, 2687, 10985, 11030, 8380, 5523, 1960, 3720, 5627, 9960, 8757, 286, 667, 14967, 18368, 20674, 21341, 11514, 7310, 8516, 5781, 7268, 4077, 7736, 6866, 11374, 8069, 4495, 8114, 5100, 11815, 12101, 9682, 10858, 10554, 10476, 10378, 11850, 10568, 12211, 4919, 3162, 11630, 10267, 4170, 3112, 6570, 11274, 10056, 3436, 6128, 10185, 11178, 8175, 4382, 8670, 9609, 10449, 9814, 7888, 9201, 11899, 4366, 3184, 7594, 9600, 10002, 6918, 11857, 6202, 5127, 1228, 10981, 3926, 6094, 6322, 7785, 9482, 3925, 3727, 4562, 5021, 11804, 7923, 11797, 12225, 11788, 7951, 10620, 11581, 9613, 4928, 6804, 9756, 11167, 6454, 11487, 6452, 9228, 7819, 9420, 5058, 8135, 12187, 3176, 11049, 5667, 11517, 5699, 3883, 9233, 5187, 10307, 9266, 11528, 3387, 10439, 2672, 10783, 6844, 10424, 8664, 9831, 9668, 9681, 3758, 5870, 5631, 7847, 8754, 9469, 8099, 6795, 10721, 9401, 6185, 10596, 4368, 11235, 9576, 11205, 11290, 11369, 12341, 5447, 3481, 8559, 11129, 8284, 12332, 11963, 8054, 7557, 8732, 9997, 9690, 1923, 7063, 5099, 7435, 7512, 6461, 12360, 9450, 6544, 7949, 11390, 12381, 8901, 11402, 8778, 11637, 7220, 6466, 9586, 9793, 11551, 9664, 9015, 9506, 11557, 4801, 5850, 10176, 10993, 9666, 8410, 12362, 4803, 6330, 11770, 6836, 10480, 2971, 11309, 7396, 4949, 7524, 8430, 13612, 21267, 21546, 4520, 10875, 7177, 12064, 9797, 8863, 10427, 8588, 9121, 7179, 7016, 9241, 4305, 20695, 9220, 5800, 11190, 12210, 10863, 8879, 5145, 9654, 8720, 10870, 11433, 11001, 8835, 10090, 11404, 11075, 9447, 9129, 7947, 9140, 8072, 12317, 12044, 11491, 3823, 9185, 2671, 7207, 12137, 6845, 9657, 12204, 6644, 8838, 11871, 6323, 6362, 9483, 9513, 11124, 8716, 7658, 4971, 11136, 7109, 8557, 2149, 10536, 8836, 11000, 9919, 7265, 9244, 10511, 10527, 10950, 10803, 11509, 9245, 9701, 9737, 22880, 11202, 4628, 12094, 6788, 11789, 9382, 6406, 8195, 3981, 5141, 12079, 4350, 8925, 6619, 6756, 12331, 23524, 9023, 7132, 8058, 3488, 7566, 9773, 6637, 11245, 11395, 11301, 5682, 9156, 9791, 5211, 21678, 3545, 3950, 4280, 11207, 9678, 8736, 7395, 6092, 11418, 5006, 9619, 7769, 9286, 4056, 10365, 10391, 3928, 7904, 5515, 12251, 4633, 6086, 5218, 8088, 11817, 10440, 9425, 11279, 4237, 8615, 18902, 11143, 4814, 5698, 11497, 12222, 12207, 8331, 8977, 10592, 10087, 11966, 6142, 12233, 7449, 11628, 11076, 10489, 5975, 9792, 7853, 5581, 5024, 6742, 4610, 8802, 7677, 6754, 6438, 4263, 7076, 5810, 5825, 8002, 10716, 8792, 8156, 3680, 5125, 9471, 11825, 6495, 10229, 7799, 10846, 7755, 11550, 11318, 3572, 8093, 8375, 12287, 12200, 3193, 5119, 4823, 9501, 11174, 7556, 4912, 8554, 8995, 4303, 7765, 11813, 8444, 6243, 8606, 9597, 7504, 11306, 10690, 11835, 9628, 7655, 8488, 8447, 6823, 8154, 3774, 4266, 10808, 14328, 10270, 4009, 6532, 11413, 4220, 6957, 8408, 4123, 8163, 11738, 10656, 11492, 6054, 9933, 8473, 11246, 4609, 6135, 11353, 10786, 8616, 5995, 8659, 7973, 8256, 10281, 9985, 4781, 4841, 6806, 7456, 4532, 3406, 12055, 2138, 7064, 12134, 12047, 6095, 11140, 9028, 3373, 8091, 5982, 11582, 8941, 12046, 9419, 4529, 12095, 11908, 6137, 9909, 4902, 8714, 8768, 9957, 8512, 9625, 6427, 3691, 3510, 7638, 7982, 8296, 5315, 6810, 9927, 4497, 3682, 11995, 10940, 3592, 11521, 10255, 7804, 7939, 12115, 12353, 3538, 7087, 8384, 9740, 1183, 9024, 8374, 10785, 7771, 4029, 11947, 5633, 7963, 11105, 9279, 3514, 11121, 7909, 7665, 9131, 19380, 6385, 3320, 5904, 3951, 8277, 11273, 11978, 10495, 7757, 672, 1630, 14825, 2891, 20988, 22429, 23100, 11669, 5092, 8767, 6696, 11263, 4427, 4771, 4342, 9925, 11161, 12057, 5807, 11546, 6186, 7870, 12061, 8711, 9593, 4726, 8159, 4236, 7278, 5193, 6477, 10937, 12268, 4855, 4857, 3489, 7270, 6499, 6555, 9965, 7385, 4107, 4095, 8748, 8837, 11254, 11186, 4817, 8536, 10681, 7534, 10390, 6097, 11736, 11050, 6053, 4407, 9249, 4145, 10377, 11335, 6494, 9150, 9736, 11541, 11086, 5275, 7645, 8166, 8699, 9631, 4374, 3336, 5643, 10948, 6153, 10077, 8887, 8082, 10086, 10370, 11257, 11516, 3035, 11785, 10923, 6134, 11718, 4779, 9733, 7844, 12112, 11853, 11139, 11047, 4206, 7977, 8032, 8254, 6101, 9920, 12097, 8597, 9418, 11232, 6309, 4517, 12228, 9191, 6592, 5979, 11357, 8600, 11828, 6857, 3507, 5223, 9421, 6529, 6012, 10534, 4905, 3855, 12092, 12202, 7401, 4135, 11568, 5191, 10382, 9726, 10595, 8212, 4329, 9977, 10849, 9381, 6470, 6958, 5765, 19660, 10477, 5932, 7564, 2664, 11639, 9167, 9603, 9683, 10192, 7062, 9753, 6720, 3845, 4629, 11401, 10467, 6248, 9984, 9078, 11662, 11998, 6595, 9491, 7905, 10657, 10298, 5991, 9252, 7160, 6102, 6216, 10679, 9932, 9183, 7937, 4489, 7668, 9298, 11224, 12076, 10705, 7823, 12312, 7340, 6824, 9484, 10331, 10537, 10407, 8631, 5357, 8735, 9821, 11898, 4150, 12065, 7559, 6584, 10342, 5103, 10791, 12319, 10352, 7676, 5130, 1543, 11421, 11164, 9041, 7627, 8490, 10297, 3676, 7861, 5599, 3024, 8275, 10745, 7215, 4235, 8884, 12096, 12093, 10867, 12069, 11664, 11179, 9448, 8152, 6569, 4941, 8094, 6960, 8415, 9141, 10026, 21529, 5167, 10257, 7168, 7579, 9253, 12257, 3843, 12335, 10621, 10920, 7235, 9051, 9630, 4974, 5842, 7086, 3462, 9975, 7725, 6932, 11247, 4527, 7116, 9282, 11397, 7398, 10091, 8174, 4795, 6034, 9564, 8896, 9890, 10085, 6215, 4845, 10328, 10634, 11544, 10744, 11249, 2679, 3470, 10549, 4568, 6113, 8569, 4512, 8262, 10465, 11875, 7744, 13970, 16396, 17514, 2479, 12730, 18807, 20943, 22202, 22896, 11920, 8051, 8160, 6566, 10030, 5226, 11217, 11396, 3562, 9561, 12216, 11169, 12181, 12022, 11627, 9976, 11042, 11262, 7384, 3978, 9978, 12166, 11116, 12742, 11647, 1881, 5073, 6119, 8446, 6596, 12273, 8649, 10131, 3411, 5231, 4296, 7115, 10516, 10406, 5345, 8694, 4881, 9478, 9125, 2152, 3792, 5693, 4661, 9204, 12182, 2981, 7181, 9251, 12337, 9148, 8210, 7389, 6838, 11434, 9151, 6735, 12177, 10512, 5116, 10709, 7897, 10293, 2667, 6928, 9344, 4365, 11988, 11730, 6612, 4098, 8109, 5614, 5516, 3687, 10322, 4099, 12336, 6688, 4821, 5601, 4878, 5706, 11943, 5036, 14818, 5134, 10685, 8553, 8636, 6985, 7754, 12165, 2163, 5806, 12110, 8281, 10305, 6131, 11144, 11512, 11538, 8421, 5674, 2974, 5317, 7761, 5378, 9883, 8116, 8486, 3372, 4604, 11613, 8382, 9449, 3455, 9974, 10154, 8658, 3699, 8955, 11275, 10000, 3762, 7989, 11897, 6561, 6384, 8434, 9287, 4575, 4844, 3509, 6437, 6542, 6642, 7903, 11867, 10569, 6840, 3030, 6716, 9992, 9018, 11106, 3813, 5600, 4859, 10455, 8326, 8861, 11210, 9650, 11162, 19383, 8747, 3395, 7077, 5940, 9931, 11668, 9574, 4396, 7868, 11163, 8773, 11965, 6659, 6010, 12229, 6817, 3446, 8182, 6755, 8022, 6741, 9908, 9601, 6187, 11088, 7245, 4879, 5675, 5504, 7516, 8191, 9886, 5156, 11873, 8674, 10360, 7560, 5812, 11697, 11892, 12020, 5001, 11554, 11610, 4428, 12070, 10570, 7397, 4868, 6500, 5632, 11440, 11676, 9188, 11968, 12333, 5022, 14344, 9510, 11177, 9285, 7227, 9109, 7461, 5254, 11570, 11590, 7866, 3794, 5295, 4986, 11504, 11403, 3896, 4113, 12119, 7331, 3192, 5251, 11967, 11870, 5292, 10833, 7255, 4614, 12236, 9754, 7789, 10528, 7354, 2157, 8825, 7008, 7670, 8378, 11680, 10741, 11052, 6983, 5694, 7838, 5258, 8506, 6479, 4725, 8267, 4793, 6378, 11484, 12139, 8513, 8117, 3480, 8347, 11713, 10162, 5154, 5610, 7065, 5577, 7763, 11020, 7454, 12252, 5779, 8192, 11533, 10571, 11463, 8237, 4889, 11574, 11712, 10933, 7178, 10112, 8930, 6727, 9451, 6728, 9106, 4621, 3484, 10466, 5646, 7601, 12164, 10497, 12168, 6489, 9746, 11310, 10638, 11929, 10800, 10100, 4160, 14120, 11910, 14615, 20526, 20901, 20390, 8299, 4984, 6269, 10219, 5101, 10083, 6585, 7158, 8841, 4405, 11746, 6812, 6225, 3475, 10051, 7803, 8876, 9511, 10832, 4607, 6811, 9805, 11375, 8337, 10404, 4719, 6036, 11294, 2131, 10462, 6881, 8274, 7119, 8676, 4593, 4854, 11489, 7988, 3350, 11863, 11417, 3979, 3492, 4623, 13185, 3504, 4679, 5308, 5473, 11149, 8258, 8665, 7948, 12196, 7155, 11633, 4372, 7353, 11688, 6686, 7068, 12074, 9243, 4774, 10711, 3889, 8190, 6478, 10550, 7117, 8461, 6954, 3677, 11354, 11090, 4358, 8927, 9250, 12286, 11286, 3452, 6952, 7867, 5976, 5266, 11987, 11790, 8507, 6833, 12238, 11793, 11303, 11305, 4487, 10580, 4927, 7919, 11371, 11488, 6273, 4996, 5220, 5470, 1983, 11109, 3129, 7323, 8343, 15115, 10561, 11113, 5466, 5076, 11660, 9795, 8991, 9915, 10453, 11495, 11918, 11726, 11236, 5146, 8595, 9961, 12745, 7858, 6339, 8921, 9987, 10543, 7338, 11542, 11338, 10127, 4587, 5863, 6490, 7293, 4695, 3844, 11778, 6856, 6946, 6740, 8663, 16206, 12728, 23147, 3487, 8189, 11928, 7212, 11719, 10866, 4531, 5623, 11107, 9119, 5628, 5871, 11733, 6559, 10572, 6240, 7788, 12191, 12334, 9468, 4073, 7007, 4925, 9117, 10639, 12000, 10468, 4435, 8466, 9554, 9539, 4480, 5018, 6864, 9093, 10588, 6683, 7148, 8037, 9132, 4406, 7890, 10212, 9768, 9171, 10478, 9016, 9383, 10142, 7184, 7985, 9562, 11315, 5946, 7085, 9567, 3596, 9575, 10822, 3810, 8993, 5522, 9520, 7818, 6327, 11646, 10269, 9566, 8371, 3383, 9019, 12075, 11805, 3714, 12289, 12105, 12158, 11545, 5816, 1968, 11945, 7723, 8756, 8044, 9692, 8220, 12066, 6679, 5300, 5379, 7883, 5198, 11964, 9402, 7311, 4109, 10813, 4833, 10321, 4341, 10371, 9500, 14915, 11552, 11675, 6658, 7156, 9633, 12339, 11044, 4668, 12163, 7012, 10058, 10123, 4887, 8978, 3466, 9873, 11865, 7887, 9081, 6562, 3143, 8436, 3432, 8487, 11827, 5240, 10380, 6223, 8119, 8585, 9948, 6909, 11300, 4978, 7793, 9110, 6794, 7522, 9828, 5052, 9840, 10147, 4947, 3739, 7546, 8740, 10799, 6684, 11278, 4667, 5980, 10575, 8549, 11028, 5347, 11285, 10110, 8183, 9988, 4332, 2799, 3693, 7043, 6797, 4728, 12206, 6781, 4722, 3503, 7376, 7321, 8272, 10804, 6201, 11515, 8541, 7661, 6492, 2133, 6103, 8552, 5560, 9900, 11860, 4357, 4797, 12009, 12179, 10400, 17953, 22291, 4456, 6513, 8855, 8607, 8228, 5439, 7999, 10664, 4319, 3685, 4976, 6816, 12010, 8229, 11601, 10442, 4891, 2151, 10706, 4693, 6111, 7157, 9656, 8531, 6441, 5386, 3389, 11594, 4338, 9403, 11904, 8286, 12224, 6880, 2159, 8161, 10829, 2134, 4364, 11777, 7540, 6338, 7252, 5679, 4687, 12259, 5582, 6878, 8133, 11118, 7458, 8170, 6744, 5794, 9550, 4143, 7233, 8021, 5811, 8575, 11367, 4152, 6567, 3459, 7494, 12067, 3712, 6365, 6031, 9637, 2989, 6497, 5400, 9088, 3777, 11903, 10074, 7163, 11558, 11699, 5420, 6511, 9892, 3443, 11053, 11829, 10180, 7644, 10010, 4449, 6777, 5476, 9705, 9911, 3386, 11585, 11607, 5442, 8970, 11883, 6315, 9954, 4381, 5797, 4262, 11212, 6451, 3516, 9259, 11876, 5920, 10121, 11157, 11894, 7161, 10663, 6721, 5990, 8723, 4980, 10363, 4437, 4510, 7474, 9571, 7095, 10535, 3447, 3463, 7324, 5884, 15045, 20788, 20806, 20934, 21965, 6912, 7154, 7430, 6558, 9707, 3483, 4120, 7078, 8388, 10038, 12084, 6901, 7753, 11280, 4367, 5529, 9718, 6392, 5257, 11287, 5301, 12314, 6136, 12161, 11500, 10387, 10564, 1875, 4422, 9703, 11462, 3688, 7935, 9581, 4002, 6722, 11787, 7865, 3690, 7390, 5860, 10405, 3729, 8681, 4377, 10160, 5117, 5705, 4708, 5359, 4080, 9354, 5925, 9572, 11203, 8951, 11840, 10821, 11924, 9993, 9999, 3927, 5079, 8372, 10265, 3738, 12021, 6702, 3683, 3557, 11604, 7431, 9357, 8981, 4858, 7031, 6206, 5761, 11034, 4826, 4942, 3416, 5583, 11649, 7348, 6887, 11753, 11376, 10765, 8624, 8817, 5808, 4994, 9355, 5792, 12235, 4822, 6821, 10332, 6241, 4124, 11360, 5953, 8829, 4796, 9304, 9996, 6563, 6312, 10662, 7382, 8453, 8590, 8947, 5524, 5926, 10284, 8571, 3471, 7272, 19719, 6877, 8463, 5886, 7414, 5213, 7467, 8261, 9416, 12255, 11296, 9729, 10482, 10865, 10483, 10401, 8266, 6367, 11623, 6889, 8502, 11208, 11847, 7476, 6349, 10601, 8483, 10433, 3943, 9970, 6858, 11614, 11616, 3768, 4146, 8657, 3542, 6291, 4952, 11798, 11636, 6122, 11122, 3679, 10938, 10129, 7593, 7111, 4998, 1169, 8533, 4207, 6286, 11368, 10894, 12173, 4255, 9802, 11912, 5377, 7906, 12050, 9629, 6630, 11378, 8974, 4685, 10125, 5595, 10164, 3759, 10598, 5207, 7703, 9551, 5270, 7236, 6779, 5380, 5402, 7015, 7280, 14758, 14857, 7581, 9422, 9959, 7418, 7486, 11872, 11067, 4333, 8140, 12242, 4513, 8448, 8734, 9758, 5102, 6854, 11438, 4561, 12338, 8193, 9875, 3858, 5734, 12365, 10823, 12269, 5576, 27103, 10802, 9008, 4462, 4229, 1975, 8201, 9239, 12221, 5306, 12063, 4100, 3850, 4141, 7955, 5004, 6145, 9189, 5544, 14778, 9328, 8510, 17761, 2367, 20032, 5037, 5059, 8684, 9779, 7069, 9642, 8090, 9305, 5208, 5039, 10108, 7009, 5849, 6114, 5171, 6757, 7756, 8215, 6643, 7567, 10501, 10936, 6934, 6498, 9815, 10811, 5555, 11671, 9049, 4295, 11729, 10519, 11062, 8049, 6277, 10057, 11881, 5408, 8790, 12140, 7900, 6177, 5355, 11282, 12167, 10464, 4920, 10566, 6900, 10917, 11058, 3536, 11284, 6120, 11154, 6557, 6436, 6533, 4051, 5384, 8886, 9956, 8365, 17459, 18984, 20601, 21244, 21510, 22335, 7920, 11970, 11706, 3477, 7635, 5255, 7020, 6300, 9505, 4647, 7760, 6588, 6250, 4951, 7408, 10775, 7050, 10502, 9926, 11182, 4563, 8942, 9790, 4270, 1544, 10625, 8980, 5998, 3713, 6699, 6745, 7851, 9495, 5416, 9838, 3938, 4559, 9983, 7864, 10667, 8406, 11329, 6160, 10116, 5974, 4429, 5526, 11984, 12125, 6680, 9853, 7234, 9844, 7517, 10001, 7228, 11670, 6112, 8758, 6899, 4454, 10410, 9525, 3541, 11455, 10954, 11957, 3561, 7869, 4340, 1848, 11780, 4419, 7808, 10073, 3485, 5796, 8047, 6581, 5498, 12205, 10755, 10084, 11935, 8804, 7231, 9302, 7979, 7895, 8775, 6843, 11060, 4988, 11971, 5140, 4397, 8992, 4386, 7729, 9095, 10132, 11087, 11548, 9893, 4264, 6903, 8409, 9432, 12169, 8998, 3966, 11299, 3734, 3049, 5753, 11836, 2791, 8203, 7439, 12141, 11832, 5823, 12313, 9211, 11265, 8462, 7622, 6377, 5630, 8972, 6301, 7563, 11204, 11419, 11130, 8969, 9202, 9532, 4265, 8240, 8973, 7070, 6311, 5462, 8335, 9569, 8115, 8983, 11939, 9596, 8076, 6776, 5189, 12320, 4323, 9901, 9958, 8300, 5186, 11775, 11277, 11394, 10484, 6996, 5650, 12174, 12279, 8292, 11880, 11960, 7718, 4114, 8593, 8211, 831, 21531, 21011, 20575, 10991, 5131, 4507, 5703, 5960, 12220, 8563, 11108, 4389, 11893, 11887, 4745, 4856, 6193, 5988, 5972, 9476, 10903, 8847, 7929, 6763, 5358, 10115, 8127, 5415, 12280, 10386, 6230, 5661, 8525, 11686, 5691, 6164, 10434, 3965, 8950, 9176, 10259, 3347, 10262, 9392, 10258, 8168, 11944, 1984, 4811, 12276, 6869, 10562, 11792, 9839, 6356, 11099, 10003, 11982, 1963, 5195, 11038, 6587, 9796, 6709, 6582, 4273, 4298, 9541, 10445, 10044, 4598, 3841, 9776, 4898, 5626, 12328, 4343, 5455, 5553, 5945, 10674, 3901, 11408, 4813, 10144, 2654, 2993, 9455, 4039, 11288, 10838, 7634, 7663, 6366, 7167, 11922, 4286, 9107, 7539, 4174, 4361, 4686, 5465, 12346, 6737, 3717, 5409, 8383, 6124, 4404, 4636, 11547, 10241, 3428, 8106, 5858, 10420, 5906, 11635, 9559, 3526, 5738, 6107, 5010, 11485, 3529, 7577, 8489, 11151, 8788, 11057, 7118, 12217, 11324, 6782, 8368, 11399, 11181, 12129, 11531, 5252, 12282, 4261, 5303, 9778, 11461, 6571, 6079, 3523, 4886, 6853, 8766, 4830, 2136, 7136, 10847, 10602, 17488, 3228, 2285, 20538, 4218, 5612, 6372, 4846, 9918, 9128, 5776, 11133, 3558, 11728, 10584, 9982, 7322, 5077, 11184, 11070, 10078, 11989, 10542, 7120, 4729, 11465, 4630, 7475, 8591, 7499, 11248, 11373, 11059, 9306, 11467, 11061, 3790, 10133, 9254, 2160, 5545, 5471, 7392, 8592, 12192, 10475, 12051, 4997, 10921, 7214, 8243, 5259, 9903, 5411, 8338, 4741, 6213, 4957, 6923, 6217, 9966, 7347, 11714, 4481, 4820, 11794, 8893, 12243, 8349, 7051, 11171, 8800, 9133, 6073, 10732, 11916, 10730, 7180, 8309, 10816, 8526, 7193, 4334, 6061, 7766, 14014, 7403, 10361, 7696, 6689, 6876, 4876, 10128, 4387, 7617, 12006, 6517, 4452, 8126, 4392, 6764, 4253, 8967, 4307, 9780, 7108, 10062, 12375, 6125, 6636, 10072, 7940, 22968, 22965, 22967, 4380, 4908, 7386, 4447, 9612, 7545, 3198, 5574, 7067, 8403, 11812, 6205, 10748, 4251, 4040, 9494, 5556, 9874, 10707, 10763, 5997, 5804, 3105, 7976, 8188, 6035, 8219, 6750, 8534, 13684, 14450, 20401, 7780, 5472, 5419, 5256, 5291, 5199, 8849, 3964) 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