Nakladatelství Jos. R. Vilímek

Název Autor Rok Nakladatel Ed. Ilus. Kategorie Cena
Verne, Jules (Julius): Plující ostrov Verne Jules (Julius) 1923 Jos. R. Vilímek Romány Jul. Vernea, Benett Léon Dobrodružná próza 490 Kč Koupit
Verne, Jules (Julius): Dvacet tisíc mil pod mořem Verne Jules (Julius) 0 Jos. R. Vilímek Dobrodružná próza 490 Kč Koupit
Marden, Orison Swett: Klid, síla, blahobyt Marden Orison Swett 0 Jos. R. Vilímek Knihy života Psychologie 90 Kč Koupit
Marden, Orison Swett: Život dílo mistrovské Marden Orison Swett 1924 Jos. R. Vilímek Filosofie 90 Kč Koupit
Verne, Julius: Dva roky prázdnin Verne Julius 1923 Jos. R. Vilímek Benett Léon Dobrodružná próza 490 Kč Koupit
Doyle, Sir Arthur Conan: Plukovníkův hřích - Paměti detektiva Sherlocka Holmese Doyle Sir Arthur Conan 1906 Jos. R. Vilímek Detektivní romány a novelly, Paget Sidney Detektivky 1990 Kč Koupit
Prévost, Marcel: Petr a Tereza Prévost Marcel 0 Jos. R. Vilímek Světová próza 90 Kč Koupit
Arcybašev, Michail Petrovič: Žena otrokyně Arcybašev Michail Petrovič 1925 Jos. R. Vilímek Spisy M. Arcybaševa Světová próza 90 Kč Koupit
Arcybašev, Michail Petrovič: Hříšná žena Arcybašev Michail Petrovič 1925 Jos. R. Vilímek Spisy M. Arcybaševa Světová próza 90 Kč Koupit
Couperus, Louis: Hora světla Couperus Louis 1922 Jos. R. Vilímek Světová próza 90 Kč Koupit
Arcybašev, Michail Petrovič: Sanin Arcybašev Michail Petrovič 0 Jos. R. Vilímek Spisy M. Arcybaševa Světová próza 90 Kč Koupit
Arcybašev, Michail Petrovič: Žárlivost, Konec Landeho Arcybašev Michail Petrovič 1925 Jos. R. Vilímek Spisy M. Arcybaševa Světová próza 40 Kč Koupit
Haggard, H. Rider: Černý Napoleon Haggard H. Rider 0 Jos. R. Vilímek Spisy H. R. Haggarda, Černý Věnceslav Světová próza 70 Kč Koupit
Hloucha, Joe: Dopisy neznámého Hloucha Joe 1923 Jos. R. Vilímek Česká próza 100 Kč Koupit
Dumas, Alexander: Josef Balsamo I-V Dumas Alexander 1929 Jos. R. Vilímek Světová próza 290 Kč Koupit
Dumas, Alexander: Královna Margot I-II Dumas Alexander 1927 Jos. R. Vilímek Hudeček Stanislav Světová próza 220 Kč Koupit
Dumas, Alexander: Hrabě de Monte Cristo I-VI Dumas Alexander 1929 Jos. R. Vilímek Hudeček Stanislav Světová próza 390 Kč Koupit
Balzac, Honoré de: Lesk a bída kurtisan I-II Balzac Honoré de 1926 Jos. R. Vilímek Světová próza 190 Kč Koupit
Zola, Emil: Plodnost Zola Emil 0 Jos. R. Vilímek Světová próza 290 Kč Koupit
Zola, Emil: Zabiják Zola Emil 0 Jos. R. Vilímek Světová próza 390 Kč Koupit
Zola, Emil: Lidská bestie Zola Emil 0 Jos. R. Vilímek Hudeček Stanislav Světová próza 190 Kč Koupit
Machard, Alfred: Cvrček detektiv Machard Alfred 1928 Jos. R. Vilímek Ulrich Josef Detektivky 50 Kč Koupit
Wallace, Edgar: Dveře se sedmi zámky Wallace Edgar 1928 Jos. R. Vilímek Vilímkova knihovna Detektivky 80 Kč Koupit
Verne, Julius: Do měsíce Verne Julius 0 Jos. R. Vilímek Dobrodružná próza 390 Kč Koupit
Verne, Julius: Plovoucí město, Blokadou Verne Julius 0 Jos. R. Vilímek Dobrodružná próza 390 Kč Koupit
kolektiv, autorů: Nová Česká poesie 0 Jos. R. Vilímek Česká poezie 990 Kč Koupit
Scott, Walter: Kenilworth Scott Walter 0 Jos. R. Vilímek Spisy Waltera Scotta Světová próza 690 Kč Koupit
Verne, Julius: Nový hrabě Monte Kristo Verne Julius 0 Jos. R. Vilímek Bennett Louis Dobrodružná próza 490 Kč Koupit
kolektiv, autorů: Krkonoše, rozvrh pro kratší i delší cesty krkonošské, pro turisty a cyklisty 0 Jos. R. Vilímek Vilímkův cestovní a výletní rádce Turistika 390 Kč Koupit
Dostál, Alois: Za vlasť Dostál Alois 0 Jos. R. Vilímek Černý Věnceslav Česká próza 50 Kč Koupit
Weinfurter, Karel: Věděním a životem 1-10: Divy a kouzla indických fakírů Weinfurter Karel 1923 Jos. R. Vilímek Alternativa 990 Kč Koupit
Sílová, Bohumila: Čertík Mičula Sílová Bohumila 1934 Jos. R. Vilímek Scheiner Artuš Pohádky 350 Kč Koupit
Wenig, Adolf: Náš hrad Wenig Adolf 1938 Jos. R. Vilímek Pragensie 150 Kč Koupit
Hromádko, František: Z přírody Poučné čtení z různých odborů přírodních věd Hromádko František 1898 Jos. R. Vilímek Příroda 990 Kč Koupit
Marden, Orison Swett: Radostný život Marden Orison Swett 1924 Jos. R. Vilímek Filosofie 290 Kč Koupit
Hamza, František: Želivské romance: Cestopis duší lidu neznámé země Hamza František 1926 Jos. R. Vilímek Vilímkova knihovna Česká próza 80 Kč Koupit
kolektiv, autorů: Vilímkův kalendář českých stavitelů 1914 Jos. R. Vilímek Kalendáře 390 Kč Koupit
Beach, Rex: Stříbrná záplava Beach Rex 1925 Jos. R. Vilímek Vilímkova knihovna Dobrodružná próza, Dětská literatura 50 Kč Koupit
Stevenson, Robert Louis: Zlatý ostrov Stevenson Robert Louis 1924 Jos. R. Vilímek Světová próza 290 Kč Koupit
Loti, Pierre: Harémy, kouzla zbavené Loti Pierre 0 Jos. R. Vilímek Sex a erotika 290 Kč Koupit
Malý, Jaromír, Melichar, Josef: Dachau, symbol české síly, vzdoru a oběti: Novinářský dokument českých politických vězňů z doby od 29. dubna 1945 do 21. května 1945 Malý Jaromír, Melichar Josef 1945 Jos. R. Vilímek 2. světová válka 250 Kč Koupit
Beach, Rex: Železná stopa Beach Rex 1927 Jos. R. Vilímek Dobrodružná próza, Dětská literatura 50 Kč Koupit
Beach, Rex: Stříbrná záplava Beach Rex 1925 Jos. R. Vilímek Dobrodružná próza, Dětská literatura 90 Kč Koupit
Beach, Rex: Zlatý proud Beach Rex 1926 Jos. R. Vilímek Dobrodružná próza, Dětská literatura 50 Kč Koupit
Milbauer, Jaroslav: O vlastnostech a praktické ceně barev Milbauer Jaroslav 0 Jos. R. Vilímek Za vzdělnáním: Knížky pro každého Chemie 90 Kč Koupit
Musil-Daňkovský, E.: Nový Robinson 1-2 Musil-Daňkovský E. 1900 Jos. R. Vilímek Vilímkova knihovna Malého čtenáře Dobrodružná próza, Dětská literatura 490 Kč Koupit
Maupassant, Guy de: Marná krása Maupassant Guy de 1925 Jos. R. Vilímek Světová próza 90 Kč Koupit
Dumas, Alexander: Tři mušketýři 1-2 Dumas Alexander 1925 Jos. R. Vilímek Světová próza 250 Kč Koupit
Arcybašev, M.: Sanin Arcybašev M. 1925 Jos. R. Vilímek Světová próza 50 Kč Koupit
Maupassant, Guy de: Slučí hody Maupassant Guy de 1933 Jos. R. Vilímek Barbut Em. Světová próza 90 Kč Koupit
(default) 21 queries took 10 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` = 7778 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` = (7778)1221223
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` = 7778 ORDER BY `Book`.`created` DESC LIMIT 5050503
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 (91801, 91802, 91760, 91729, 91490, 91055, 91056, 91047, 91048, 91050, 91045, 91046, 91026, 91021, 90821, 90817, 90818, 90733, 90727, 90728, 90709, 90660, 90614, 90157, 90158, 90151, 89805, 89724, 89624, 89606, 89117, 89023, 89005, 88871, 88854, 88733, 88570, 87754, 87749, 87704, 87465, 87340, 87341, 87342, 87333, 87310, 87299, 87300, 87302, 87298) AND `BooksCategory`.`category_id` = `Category`.`id`) 55551
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 (91801, 91802, 91760, 91729, 91490, 91055, 91056, 91047, 91048, 91050, 91045, 91046, 91026, 91021, 90821, 90817, 90818, 90733, 90727, 90728, 90709, 90660, 90614, 90157, 90158, 90151, 89805, 89724, 89624, 89606, 89117, 89023, 89005, 88871, 88854, 88733, 88570, 87754, 87749, 87704, 87465, 87340, 87341, 87342, 87333, 87310, 87299, 87300, 87302, 87298) AND `AuthorsBook`.`author_id` = `Author`.`id`) 51511
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` = 7778111
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` = 7778 ORDER BY `Publisher`.`name` ASC LIMIT 1110