Nakladatelství J. Otto

Název Autor Rok Nakladatel Ed. Ilus. Kategorie Cena
Havrlík, Svatopluk: Lidové umění na Příbramsku Havrlík Svatopluk 1945 J. Otto Podpisy a dedikace, Výtvarné umění 290 Kč Koupit
Heyduk, Adolf: Ptačí motivy 6 Heyduk Adolf 0 J. Otto Spisy Adolfa Heyduka Česká poezie 50 Kč Koupit
Heyduk, Adolf: Ptačí motivy 7 Heyduk Adolf 0 J. Otto Spisy Adolfa Heyduka Česká poezie 50 Kč Koupit
Heyduk, Adolf: Ptačí motivy 8 Heyduk Adolf 0 J. Otto Spisy Adolfa Heyduka Česká poezie 50 Kč Koupit
Heyduk, Adolf: Ptačí motivy 9, Sekerník 1 Heyduk Adolf 0 J. Otto Spisy Adolfa Heyduka Česká poezie 50 Kč Koupit
Heyduk, Adolf: Sekerník 2 Heyduk Adolf 0 J. Otto Spisy Adolfa Heyduka Česká poezie 50 Kč Koupit
Heyduk, Adolf: Nové cigánské melodie 3 Heyduk Adolf 0 J. Otto Spisy Adolfa Heyduka Česká poezie 50 Kč Koupit
Heyduk, Adolf: Nové cigánské melodie 4, Ptačí motivy 1 Heyduk Adolf 0 J. Otto Spisy Adolfa Heyduka Česká poezie 50 Kč Koupit
Heyduk, Adolf: Ptačí motivy 2 Heyduk Adolf 0 J. Otto Spisy Adolfa Heyduka Česká poezie 50 Kč Koupit
Heyduk, Adolf: Ptačí motivy 5 Heyduk Adolf 0 J. Otto Spisy Adolfa Heyduka Česká poezie 50 Kč Koupit
Heyduk, Adolf: Nové cigánské melodie 2 Heyduk Adolf 0 J. Otto Spisy Adolfa Heyduka Česká poezie 50 Kč Koupit
Lejkin, Nikolaj Aleksandrovič: Pod jižním nebem: Humoristický popis cesty manželů Nikolaje Ivanoviče a Glafiry Semenovny Ivanových do Biarritze a Madridu Lejkin Nikolaj Aleksandrovič 0 J. Otto Ottova laciná knihovna národní Světová próza 190 Kč Koupit
Shakespeare, William: Makbeth Shakespeare William 1901 J. Otto Divadelní hry 90 Kč Koupit
Shakespeare, William: Julius Caesar Shakespeare William 0 J. Otto Divadelní hry 90 Kč Koupit
Schulz, Ferdinand: Zlatá Praha - Obrazový týdenník pro zábavu a poučení, ročník XII (1895) Schulz Ferdinand 1895 J. Otto Pragensie, Časopisy 490 Kč Koupit
Komenský, Jan Amos: Labyrint světa a ráj srdce Komenský Jan Amos 1906 J. Otto Pedagogika 190 Kč Koupit
Heyduk, Adolf: Co hlavou táhlo Heyduk Adolf 1910 J. Otto Spisy Adolfa Heyduka Česká poezie 150 Kč Koupit
Komenský, Jan Amos: Labyrint světa Komenský Jan Amos 1906 J. Otto Světová knihovna Pedagogika 190 Kč Koupit
Wilde, Oscar: Básně Wilde Oscar 0 J. Otto Světová knihovna Světová poezie 190 Kč Koupit
Winter, Zikmund: Krátký jeho svět Winter Zikmund 0 J. Otto Světová knihovna Česká próza 50 Kč Koupit
Němcová, Božena: Babička: Obrazy venkovského života Němcová Božena 0 J. Otto Česká próza 250 Kč Koupit
kolektiv, autorů: Ze staré čínské poezie (VII.-IX. stol. po Kr.) 0 J. Otto Světová knihovna Světová poezie 90 Kč Koupit
Shakespeare, William: Julius Caesar Shakespeare William 0 J. Otto Divadelní hry 190 Kč Koupit
Dostojevskij, Fjodor Michajlovič: Věčný muž, Zimní poznámky o letních dojmech, Strýčínkův sen, Bílé noci, Doplňky Dostojevskij Fjodor Michajlovič 19221 J. Otto Spisy F. M. Dostojevského Světová próza 120 Kč Koupit
Čelakovský, František Ladislav: Ohlasy: Ohlas písní ruských - Ohlas písní českých Čelakovský František Ladislav 0 J. Otto Bibliofilie a krásné vazby 390 Kč Koupit
Bláha, František: Zločin a trest Bláha František 1946 J. Otto Ohlasy války Česká próza 190 Kč Koupit
Tegnér, Asaias: Píseň o Frithiofovi Tegnér Asaias 1891 J. Otto Světová poezie 190 Kč Koupit
Turgeněv, Ivan Sergejevič: Hamlet a Don Quijote Turgeněv Ivan Sergejevič 1917 J. Otto Světová próza 150 Kč Koupit
Vrba, Jan: Les Vrba Jan 1926 J. Otto Bibliofilie a krásné vazby 490 Kč Koupit
Jirásek, Alois: Na dvoře vévodském, Ráj světa Jirásek Alois 1923 J. Otto Bibliofilie a krásné vazby 490 Kč Koupit
Ibsen, Henrik: Paní z námoří Ibsen Henrik 1906 J. Otto Divadelní hry 50 Kč Koupit
Hoffmann, Ernst Theodor Amadeus: Slečna de Scuderi Hoffmann Ernst Theodor Amadeus 0 J. Otto Světová knihovna Světová próza 50 Kč Koupit
Hálek, Vítězslav: Večerní písně Hálek Vítězslav 1905 J. Otto Bibliofilie a krásné vazby 350 Kč Koupit
Prášek, Justin V.: Babylonie kolébkou dějin, Egypt za slavných dob faraonův Prášek Justin V. 0 J. Otto Světová knihovna Historie 150 Kč Koupit
Prášek, Justin V.: Foiničané: Obraz národního života z antické minulosti, Assyrie a dávný orient Prášek Justin V. 0 J. Otto Světová knihovna Historie 150 Kč Koupit
Tolstoj, Lev Nikolajevič: O smysle života Tolstoj Lev Nikolajevič 0 J. Otto Náboženství 150 Kč Koupit
Pazourek, Josef: Ottův obchodní slovník I, II-1, II-2 Pazourek Josef 0 J. Otto Encyklopedie 990 Kč Koupit
Stránská, Drahomíra: Lidové kroje v Československu díl I. - Čechy Stránská Drahomíra 1949 J. Otto Místopis 1490 Kč Koupit
Toman, Karel: Člověk a básník Toman Karel 1947 J. Otto Malá Ottova knihovna Literární věda 70 Kč Koupit
Tyl, Josef Kajetán: Strakonický dudák Tyl Josef Kajetán 0 J. Otto Divadelní hry 90 Kč Koupit
Palacký, František: Doba Husova Palacký František 0 J. Otto Historie 90 Kč Koupit
Vrba, Jan: Chodsko: Průvodce krajem, dějinami jeho lidu a komentář k "chodským rebeliím" Vrba Jan 1928 J. Otto Sebrané spisy Jana Vrby Česká próza 90 Kč Koupit
Tilschová, Anna Maria: Hříšnice a jiná próza Tilschová Anna Maria 1940 J. Otto Česká próza 90 Kč Koupit
Preissová, Gabriela: Povídky Preissová Gabriela 1926 J. Otto Česká próza 90 Kč Koupit
Seton, Ernest Thompson: O veveřici Seton Ernest Thompson 1927 J. Otto Knihovna Walden Dobrodružná próza, Dětská literatura 190 Kč Koupit
Jerome, Jerome Klapka: Tommy a spol. Jerome Jerome Klapka 1912 J. Otto Světová próza 190 Kč Koupit
Vrchlický, Jaroslav: Vrchlického spisy básnické XXV.-XXVIII.: Nové básně epické, Duch a svět, Zlomky epopeje, Motýli všech barev Vrchlický Jaroslav 0 J. Otto Česká poezie 350 Kč Koupit
Moučka, Josef: Zpěvník pro školy obecné a měšťanské z písní národních díl I, II, III, IV pro 1. a 2., 3. a 4., 5. a 6., 7. a 8. školní rok; Zpěvník pro první třídu školy měšťasnké a Zpěvník pro druhou a třetí třídu školy měšťanské Moučka Josef 1901 J. Otto Noty 490 Kč Koupit
Meyer, M. W.: Svět planet Meyer M. W. 0 J. Otto Světová knihovna Astronomie 150 Kč Koupit
Aleš, Mikoláš: Synek zachovalý Aleš Mikoláš 1906 J. Otto Aleš Mikoláš Výtvarné umění 150 Kč Koupit
(default) 21 queries took 20 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `CmsLanguage`.`id`, `CmsLanguage`.`parent_id`, `CmsLanguage`.`cms_navigation_root_id`, `CmsLanguage`.`template`, `CmsLanguage`.`image`, `CmsLanguage`.`title`, `CmsLanguage`.`description`, `CmsLanguage`.`gravity`, `CmsLanguage`.`cms_navigation_group_id`, `CmsLanguage`.`slug`, `CmsLanguage`.`redirect`, `CmsLanguage`.`protected`, `CmsLanguage`.`created`, `CmsLanguage`.`updated` FROM `d203837_antik`.`cms_navigations` AS `CmsLanguage` WHERE `CmsLanguage`.`slug` = 'cze' AND `parent_id` IS NULL ORDER BY `gravity` ASC LIMIT 1110
2SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`slug` = 'cze' AND `CmsNavigation`.`parent_id` IS NULL ORDER BY `gravity` ASC LIMIT 1110
3SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`slug` = 'nakladatelstvi' AND `CmsNavigation`.`parent_id` = 1 ORDER BY `gravity` ASC LIMIT 1110
4SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`slug` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`id` = 1 ORDER BY `gravity` ASC LIMIT 1110
5SELECT `CmsLanguage`.`id`, `CmsLanguage`.`parent_id`, `CmsLanguage`.`cms_navigation_root_id`, `CmsLanguage`.`template`, `CmsLanguage`.`image`, `CmsLanguage`.`title`, `CmsLanguage`.`description`, `CmsLanguage`.`gravity`, `CmsLanguage`.`cms_navigation_group_id`, `CmsLanguage`.`slug`, `CmsLanguage`.`redirect`, `CmsLanguage`.`protected`, `CmsLanguage`.`created`, `CmsLanguage`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsLanguage` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsLanguage`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `parent_id` IS NULL ORDER BY `gravity` ASC110
6SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 1 AND `CmsNavigation`.`cms_navigation_group_id` = 1 ORDER BY `gravity` ASC330
7SELECT `CmsNavigationStub`.`id`, `CmsNavigationStub`.`cms_navigation_id`, `CmsNavigationStub`.`template`, `CmsNavigationStub`.`title`, `CmsNavigationStub`.`description`, `CmsNavigationStub`.`content_short`, `CmsNavigationStub`.`content`, `CmsNavigationStub`.`gravity`, `CmsNavigationStub`.`created`, `CmsNavigationStub`.`updated` FROM `d203837_antik`.`cms_navigation_stubs` AS `CmsNavigationStub` WHERE `CmsNavigationStub`.`cms_navigation_id` = 16110
8SELECT `Publisher`.`id`, `Publisher`.`book_count`, `Publisher`.`name`, `Publisher`.`created`, `Publisher`.`updated` FROM `d203837_antik`.`publishers` AS `Publisher` WHERE `Publisher`.`id` = 527 ORDER BY `Publisher`.`name` ASC LIMIT 1111
9SELECT `Book`.`id`, `Book`.`binding_id`, `Book`.`series_id`, `Book`.`illustrator_id`, `Book`.`director_id`, `Book`.`publisher_id`, `Book`.`quantity`, `Book`.`published_year`, `Book`.`price`, `Book`.`name`, `Book`.`image`, `Book`.`authors`, `Book`.`description`, `Book`.`description_long`, `Book`.`created`, `Book`.`updated` FROM `d203837_antik`.`books` AS `Book` WHERE `Book`.`publisher_id` = (527)3733737
10SELECT `Book`.`id`, `Book`.`binding_id`, `Book`.`series_id`, `Book`.`illustrator_id`, `Book`.`director_id`, `Book`.`publisher_id`, `Book`.`quantity`, `Book`.`published_year`, `Book`.`price`, `Book`.`name`, `Book`.`image`, `Book`.`authors`, `Book`.`description`, `Book`.`description_long`, `Book`.`created`, `Book`.`updated`, `Series`.`id`, `Series`.`book_count`, `Series`.`name`, `Series`.`description`, `Series`.`created`, `Series`.`updated`, `Illustrator`.`id`, `Illustrator`.`book_count`, `Illustrator`.`first_name`, `Illustrator`.`last_name`, `Illustrator`.`created`, `Illustrator`.`updated`, (CONCAT(`Illustrator`.`last_name`, " ", `Illustrator`.`first_name`)) AS `Illustrator__name`, `Director`.`id`, `Director`.`book_count`, `Director`.`first_name`, `Director`.`last_name`, `Director`.`created`, `Director`.`updated`, (CONCAT(`Director`.`last_name`, " ", `Director`.`first_name`)) AS `Director__name`, `Publisher`.`id`, `Publisher`.`book_count`, `Publisher`.`name`, `Publisher`.`created`, `Publisher`.`updated`, `Binding`.`id`, `Binding`.`name`, `Binding`.`created`, `Binding`.`updated`, `FulltextBook`.`book_id`, `FulltextBook`.`book_text` FROM `d203837_antik`.`books` AS `Book` LEFT JOIN `d203837_antik`.`series` AS `Series` ON (`Book`.`series_id` = `Series`.`id`) LEFT JOIN `d203837_antik`.`illustrators` AS `Illustrator` ON (`Book`.`illustrator_id` = `Illustrator`.`id`) LEFT JOIN `d203837_antik`.`directors` AS `Director` ON (`Book`.`director_id` = `Director`.`id`) LEFT JOIN `d203837_antik`.`publishers` AS `Publisher` ON (`Book`.`publisher_id` = `Publisher`.`id`) LEFT JOIN `d203837_antik`.`bindings` AS `Binding` ON (`Book`.`binding_id` = `Binding`.`id`) LEFT JOIN `d203837_antik`.`fulltext_books` AS `FulltextBook` ON (`FulltextBook`.`book_id` = `Book`.`id`) WHERE `Book`.`quantity` > 0 AND `Book`.`publisher_id` = 527 ORDER BY `Book`.`created` DESC LIMIT 5050506
11SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`mode`, `Category`.`promoted`, `Category`.`name`, `Category`.`icon`, `Category`.`description`, `Category`.`created`, `Category`.`updated`, `BooksCategory`.`book_id`, `BooksCategory`.`category_id` FROM `d203837_antik`.`categories` AS `Category` JOIN `d203837_antik`.`books_categories` AS `BooksCategory` ON (`BooksCategory`.`book_id` IN (91799, 91767, 91768, 91769, 91770, 91771, 91763, 91764, 91765, 91766, 91762, 91750, 91726, 91727, 91555, 91338, 91109, 91106, 91107, 91108, 91095, 91080, 91070, 91053, 91042, 91028, 90823, 90789, 90784, 90783, 90673, 90156, 89635, 89418, 89416, 89417, 89309, 89257, 88782, 88719, 88490, 88352, 88291, 88292, 87346, 87323, 87166, 86859, 86185, 86064) AND `BooksCategory`.`category_id` = `Category`.`id`) 53532
12SELECT `Author`.`id`, `Author`.`hidden`, `Author`.`first_name`, `Author`.`last_name`, `Author`.`created`, `Author`.`updated`, (CONCAT(`Author`.`last_name`, " ", `Author`.`first_name`)) AS `Author__name`, `AuthorsBook`.`author_id`, `AuthorsBook`.`book_id` FROM `d203837_antik`.`authors` AS `Author` JOIN `d203837_antik`.`authors_books` AS `AuthorsBook` ON (`AuthorsBook`.`book_id` IN (91799, 91767, 91768, 91769, 91770, 91771, 91763, 91764, 91765, 91766, 91762, 91750, 91726, 91727, 91555, 91338, 91109, 91106, 91107, 91108, 91095, 91080, 91070, 91053, 91042, 91028, 90823, 90789, 90784, 90783, 90673, 90156, 89635, 89418, 89416, 89417, 89309, 89257, 88782, 88719, 88490, 88352, 88291, 88292, 87346, 87323, 87166, 86859, 86185, 86064) AND `AuthorsBook`.`author_id` = `Author`.`id`) 50502
13SELECT COUNT(*) AS `count` FROM `d203837_antik`.`books` AS `Book` LEFT JOIN `d203837_antik`.`series` AS `Series` ON (`Book`.`series_id` = `Series`.`id`) LEFT JOIN `d203837_antik`.`illustrators` AS `Illustrator` ON (`Book`.`illustrator_id` = `Illustrator`.`id`) LEFT JOIN `d203837_antik`.`directors` AS `Director` ON (`Book`.`director_id` = `Director`.`id`) LEFT JOIN `d203837_antik`.`publishers` AS `Publisher` ON (`Book`.`publisher_id` = `Publisher`.`id`) LEFT JOIN `d203837_antik`.`bindings` AS `Binding` ON (`Book`.`binding_id` = `Binding`.`id`) LEFT JOIN `d203837_antik`.`fulltext_books` AS `FulltextBook` ON (`FulltextBook`.`book_id` = `Book`.`id`) WHERE `Book`.`quantity` > 0 AND `Book`.`publisher_id` = 527111
14SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 1 AND `CmsNavigation`.`cms_navigation_group_id` = 2 ORDER BY `gravity` ASC110
15SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`slug` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`id` = 1 ORDER BY `gravity` ASC LIMIT 1110
16SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 18 AND `CmsNavigation`.`cms_navigation_group_id` = 1 ORDER BY `gravity` ASC330
17SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`slug` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` WHERE `CmsNavigation`.`id` = 18 ORDER BY `gravity` ASC LIMIT 1110
18SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 24 AND `CmsNavigation`.`cms_navigation_group_id` = 1 ORDER BY `gravity` ASC000
19SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 26 AND `CmsNavigation`.`cms_navigation_group_id` = 1 ORDER BY `gravity` ASC000
20SELECT `CmsNavigation`.`id`, `CmsNavigation`.`parent_id`, `CmsNavigation`.`cms_navigation_root_id`, `CmsNavigation`.`template`, `CmsNavigation`.`image`, `CmsNavigation`.`title`, `CmsNavigation`.`description`, `CmsNavigation`.`gravity`, `CmsNavigation`.`cms_navigation_group_id`, `CmsNavigation`.`slug`, `CmsNavigation`.`redirect`, `CmsNavigation`.`protected`, `CmsNavigation`.`created`, `CmsNavigation`.`updated`, `CmsNavigationGroup`.`id`, `CmsNavigationGroup`.`name`, `CmsNavigationGroup`.`description` FROM `d203837_antik`.`cms_navigations` AS `CmsNavigation` LEFT JOIN `d203837_antik`.`cms_navigation_groups` AS `CmsNavigationGroup` ON (`CmsNavigation`.`cms_navigation_group_id` = `CmsNavigationGroup`.`id`) WHERE `CmsNavigation`.`parent_id` = 19 AND `CmsNavigation`.`cms_navigation_group_id` = 1 ORDER BY `gravity` ASC000
21SELECT `Publisher`.`name` FROM `d203837_antik`.`publishers` AS `Publisher` WHERE `Publisher`.`id` = 527 ORDER BY `Publisher`.`name` ASC LIMIT 1111