Logo Čtenářský-deník.cz

  • V naší databázi je nyní 4 586 obsahů děl, životopisů a slohovek ke stažení.
  • Z toho je 2754 prací zdarma.

Poradíme vám

Ctenarsky-denik.cz > Podrobné vyhledávání
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(895, 920, 976, 1057, 1197, 1211, 1913, 1914, 3273, 3578, 3705, 6129, 6212, 7132, 7134, 7682, 7810, 7901, 7956, 8426, 8544, 8947, 10562, 10607, 10608, 10609, 10611, 11680, 11716, 12032, 12393, 12533, 12535, 13274, 13615, 13616, 14299, 14386, 14826, 14962, 15361, 15362, 15363, 15366, 15387, 15512, 15896, 16520, 16521, 16523, 17098, 17100, 17270, 17967, 18125, 18592, 18713, 18715, 18716, 18745, 18746, 18747, 18748, 18760, 19512, 19700, 21037, 21039, 21040, 21041, 21619, 22566, 23145, 23182, 23185, 23203, 23421, 23434, 23435, 23439, 23521, 23680, 23686, 23745, 23912, 23971, 24064, 24150, 24257, 24339, 24439, 25275, 25276, 25277, 26010, 27889, 28377, 28434, 28958, 28959, 29168, 29169, 29171, 29561, 29562, 29563, 29564, 29565, 29585, 29586, 29587, 29588, 29589, 29620, 29622, 29623, 29629, 29685, 29686, 29689, 30198, 30267, 30333, 30989, 30991, 31007, 31008, 31744, 32453, 32454, 32455, 32700, 32701, 32702, 32703) 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