Naše služby

Vystúpenia vojakov Reprezentácia Workshop

Vystúpenia vojakov

Rímski vojaci preslávili Rímske impérium svojou zručnosťou a obratnosťou v boji a umožňovali tak cisárom rozširovať svoju ríšu napriek odporu nepriateľa o nové územia. Ukážky tohto vojenského umu ponúka naša skupina vo svojich divadelno-šermiarskych predstaveniach, vojenských cvičeniach a odborným výkladom s informáciami o živote vojakov a ich vybavení v programe, ktorého dĺžka závisí od vašej objednávky.

Objednať
vystúpenie

Reprezentácia

Rímske pomocné zbory (auxilie) boli často najímané úradníkmi a hodnostármi ako osobná ochrana počas ich ciest po provincii, alebo do vzdialenejších krajov. I my prenajímame rímskych vojakov pre potreby čestnej stráže, osobnej ochrany, prípadne pre edukačné účely počas výučby dejepisu na školách, alebo v detských táboroch.

Objednať

Workshop

Poznávanie minulosti na vlastnej koži je niečo, s čím sa nestretávate príliš často v živote. Ponúkame osvojovanie si vedomostí a znalostí z oblasti doby rímskej formou stánku, pri ktorom zoznamujeme záujemcov s predmetmi dennej potreby starých Rimanov, s výzbrojou rímskych vojakov a vysvetľujeme a ukazujeme ich funkciu v praxi. Záujemcovia si môžu vyskúšať narábanie so zbraňou, zahrať si rímske hry, vykresať si oheň a mnohé iné aktivity, ktoré kedysi vykonávali rímski vojaci a obyvatelia provincie.

Pod túto kategóriu našej ponuky spadá aj prezentácia rímskej kuchyne a varenie rímskych jedál na rímskej prenosnej piecke zvanej craticula.

Objednať

S.C.E.A.R.

Nadšenie pre históriu, bojové umenie a túžba spoznávať niečo nové, dosiaľ neznáme spojila skupinku mladých ľudí. Občianske združenie, ktoré sa zápisom do registra Ministerstva vnútra SR dňa 11.5. 2009 stalo oficiálnou organizáciou združujúcou ľudí, ktorí svojou kreativitou a aktivitou majú záujem nadobúdať znalosti o rímskom vojenstve, kultúre a živote starých Rimanov. Názov organizácie, S.C.E.A.R. je odvodenou skratkou od lat. prekladu názvu nášho združenia, Societas civilis exercitus auxiliorumque Romanorum, t.j. Občianske združenie rímskeho vojska a pomocných zborov. V našom združení nadobúdajú členovia zručnosti s rôznymi zbraňami, ktoré vedia následne zužitkovať v boji muž proti mužovi, alebo v hromadnej bitke. Nadobúdajú tiež odborné vedomosti o Rimanoch, a do istej miery aj remeselnú zručnosť pri zhotovovaní niektorých súčastí kostýmov a výzbroje.
Za dobu svojho pôsobenia sa naše združenie, ktoré je historicko-vojenskou skupinou, podieľalo na mnohých prestížnych podujatiach doma i v zahraničí. Máme za sebou dvojnásobnú návštevu Ríma a účasť na oslavách založenia mesta Rím v Taliansku, dvojnásobnú účasť na protohistorickom festivale Keltský deň na Liptove, spoluprácu s tromi múzeami na západnom Slovensku, vytvorenie kultúrneho programu pre odbornú medzinárodnú konferenciu (DANUBE LIMES BRAND) a mnoho menších podujatí doma a v zahraničí.

Viac o nás

Zobraziť všetky

Foto / video

Kalendár podujatí

(default) 20 queries took 570 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Setting`.`key`, `Setting`.`value` FROM `2sqepkn8`.`settings` AS `Setting` WHERE 1 = 1	30	30	4
2	SELECT `Page`.`id`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__menutitle`.`content`) AS `Page__i18n_menutitle` FROM `2sqepkn8`.`pages` AS `Page` LEFT JOIN `2sqepkn8`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__menutitle` ON (`Page`.`id` = `I18n__menutitle`.`foreign_key` AND `I18n__menutitle`.`model` = 'Page' AND `I18n__menutitle`.`field` = 'menutitle' AND `I18n__menutitle`.`locale` = 'slk') WHERE `Page`.`showinmenu` = '1' AND `Page`.`status` = 1 ORDER BY `Page`.`menusort` asc	25	25	7
3	SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, (`I18n__title`.`content`) AS `Category__i18n_title` FROM `2sqepkn8`.`categories` AS `Category` INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Category`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Category' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') WHERE `Category`.`status` != 3	10	10	1
4	SELECT `Page`.`id`, `Page`.`title`, `Page`.`menutitle`, `Page`.`menusort`, `Page`.`menuicon`, `Page`.`category_id` FROM `2sqepkn8`.`pages` AS `Page` WHERE `Page`.`showinmenu` = '1' AND `Page`.`status` != 3 AND `Page`.`category_id` IN (1, 8, 9, 10, 11, 12, 13, 14, 15, 16)	26	26	1
5	SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `2sqepkn8`.`menus` AS `Menu` WHERE `Menu`.`status` != 3	2	2	0
6	SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified` FROM `2sqepkn8`.`menuitems` AS `Menuitem` WHERE `Menuitem`.`menu_id` IN (1, 3) ORDER BY `Menuitem`.`sort` asc	14	14	0
7	SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified`, (`I18n__title`.`content`) AS `Menuitem__i18n_title`, (`I18n__href`.`content`) AS `Menuitem__i18n_href`, `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `2sqepkn8`.`menuitems` AS `Menuitem` LEFT JOIN `2sqepkn8`.`menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Menuitem`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Menuitem' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__href` ON (`Menuitem`.`id` = `I18n__href`.`foreign_key` AND `I18n__href`.`model` = 'Menuitem' AND `I18n__href`.`field` = 'href' AND `I18n__href`.`locale` = 'slk') WHERE `Menuitem`.`menu_id` = 1 ORDER BY `Menuitem`.`sort` asc	9	9	3
8	SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified`, (`I18n__title`.`content`) AS `Menuitem__i18n_title`, (`I18n__href`.`content`) AS `Menuitem__i18n_href`, `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `2sqepkn8`.`menuitems` AS `Menuitem` LEFT JOIN `2sqepkn8`.`menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Menuitem`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Menuitem' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__href` ON (`Menuitem`.`id` = `I18n__href`.`foreign_key` AND `I18n__href`.`model` = 'Menuitem' AND `I18n__href`.`field` = 'href' AND `I18n__href`.`locale` = 'slk') WHERE `Menuitem`.`menu_id` = 3 ORDER BY `Menuitem`.`sort` asc	0	0	2
9	SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`title`, `Page`.`showinmenu`, `Page`.`menutitle`, `Page`.`content_top`, `Page`.`content_top_more`, `Page`.`content`, `Page`.`content_additional`, `Page`.`content_add_bg`, `Page`.`content_add_color`, `Page`.`content_add_class`, `Page`.`menusort`, `Page`.`status`, `Page`.`menuicon`, `Page`.`gallery_id`, `Page`.`imgname`, `Page`.`created`, `Page`.`modified`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__menutitle`.`content`) AS `Page__i18n_menutitle`, (`I18n__content_top`.`content`) AS `Page__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Page__i18n_content_top_more`, (`I18n__content`.`content`) AS `Page__i18n_content`, (`I18n__content_additional`.`content`) AS `Page__i18n_content_additional`, `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified` FROM `2sqepkn8`.`pages` AS `Page` LEFT JOIN `2sqepkn8`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__menutitle` ON (`Page`.`id` = `I18n__menutitle`.`foreign_key` AND `I18n__menutitle`.`model` = 'Page' AND `I18n__menutitle`.`field` = 'menutitle' AND `I18n__menutitle`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Page`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Page' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Page`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Page' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Page`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Page' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_additional` ON (`Page`.`id` = `I18n__content_additional`.`foreign_key` AND `I18n__content_additional`.`model` = 'Page' AND `I18n__content_additional`.`field` = 'content_additional' AND `I18n__content_additional`.`locale` = 'slk') WHERE `Page`.`id` IN (66, 67, 68)	3	3	25
10	SELECT `Post`.`id`, `Post`.`title`, `Post`.`content`, `Post`.`status`, `Post`.`created`, `Post`.`modified`, (`I18n__title`.`content`) AS `Post__i18n_title`, (`I18n__content`.`content`) AS `Post__i18n_content` FROM `2sqepkn8`.`posts` AS `Post` INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Post`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Post`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Post' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') WHERE 1 = 1 ORDER BY `Post`.`modified` desc LIMIT 3	2	2	2
11	SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, (`I18n__title`.`content`) AS `Category__i18n_title` FROM `2sqepkn8`.`categories` AS `Category` INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Category`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Category' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') WHERE `Category`.`id` IN (2, 3)	0	0	2
12	SELECT `Slider`.`id`, `Slider`.`title`, `Slider`.`status`, `Slider`.`created`, `Slider`.`modified` FROM `2sqepkn8`.`sliders` AS `Slider` WHERE `Slider`.`id` = 1 LIMIT 1	1	1	0
13	SELECT `Slide`.`id`, `Slide`.`slider_id`, `Slide`.`sort`, `Slide`.`title`, `Slide`.`content`, `Slide`.`imgext`, `Slide`.`created`, `Slide`.`modified` FROM `2sqepkn8`.`slides` AS `Slide` WHERE `Slide`.`slider_id` = (1) ORDER BY `Slide`.`sort` asc	1	1	1
14	SELECT `Experience`.`id`, `Experience`.`difficulty_id`, `Experience`.`duration`, `Experience`.`price`, `Experience`.`imgname`, `Experience`.`gallery_id`, `Experience`.`status`, `Experience`.`display`, `Experience`.`created`, `Experience`.`modified`, (`I18n__title`.`content`) AS `Experience__i18n_title`, (`I18n__tile_content`.`content`) AS `Experience__i18n_tile_content`, (`I18n__btncontent`.`content`) AS `Experience__i18n_btncontent`, (`I18n__content_top`.`content`) AS `Experience__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Experience__i18n_content_top_more`, (`I18n__content`.`content`) AS `Experience__i18n_content`, (`I18n__skills_needed`.`content`) AS `Experience__i18n_skills_needed`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified`, `Difficulty`.`id`, `Difficulty`.`title` FROM `2sqepkn8`.`experiences` AS `Experience` LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Experience`.`gallery_id` = `Gallery`.`id`) LEFT JOIN `2sqepkn8`.`difficulties` AS `Difficulty` ON (`Experience`.`difficulty_id` = `Difficulty`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Experience`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Experience' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__tile_content` ON (`Experience`.`id` = `I18n__tile_content`.`foreign_key` AND `I18n__tile_content`.`model` = 'Experience' AND `I18n__tile_content`.`field` = 'tile_content' AND `I18n__tile_content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__btncontent` ON (`Experience`.`id` = `I18n__btncontent`.`foreign_key` AND `I18n__btncontent`.`model` = 'Experience' AND `I18n__btncontent`.`field` = 'btncontent' AND `I18n__btncontent`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Experience`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Experience' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Experience`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Experience' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Experience`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Experience' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__skills_needed` ON (`Experience`.`id` = `I18n__skills_needed`.`foreign_key` AND `I18n__skills_needed`.`model` = 'Experience' AND `I18n__skills_needed`.`field` = 'skills_needed' AND `I18n__skills_needed`.`locale` = 'slk') WHERE `Experience`.`status` = 1 AND `Experience`.`display` = '1' ORDER BY rand() ASC LIMIT 1	1	1	476
15	SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`title`, `Page`.`showinmenu`, `Page`.`menutitle`, `Page`.`content_top`, `Page`.`content_top_more`, `Page`.`content`, `Page`.`content_additional`, `Page`.`content_add_bg`, `Page`.`content_add_color`, `Page`.`content_add_class`, `Page`.`menusort`, `Page`.`status`, `Page`.`menuicon`, `Page`.`gallery_id`, `Page`.`imgname`, `Page`.`created`, `Page`.`modified`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__menutitle`.`content`) AS `Page__i18n_menutitle`, (`I18n__content_top`.`content`) AS `Page__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Page__i18n_content_top_more`, (`I18n__content`.`content`) AS `Page__i18n_content`, (`I18n__content_additional`.`content`) AS `Page__i18n_content_additional`, `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified` FROM `2sqepkn8`.`pages` AS `Page` LEFT JOIN `2sqepkn8`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__menutitle` ON (`Page`.`id` = `I18n__menutitle`.`foreign_key` AND `I18n__menutitle`.`model` = 'Page' AND `I18n__menutitle`.`field` = 'menutitle' AND `I18n__menutitle`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Page`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Page' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Page`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Page' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Page`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Page' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_additional` ON (`Page`.`id` = `I18n__content_additional`.`foreign_key` AND `I18n__content_additional`.`model` = 'Page' AND `I18n__content_additional`.`field` = 'content_additional' AND `I18n__content_additional`.`locale` = 'slk') WHERE `Page`.`status` = 1 AND `Page`.`category_id` = 9 ORDER BY rand() ASC LIMIT 1	0	0	23
16	SELECT `Gallery`.`id` FROM `2sqepkn8`.`galleries` AS `Gallery` WHERE `Gallery`.`status` = 1 AND `Gallery`.`visible` = 1	11	11	0
17	SELECT `Picture`.`id`, `Picture`.`gallery_id`, `Picture`.`title`, `Picture`.`saved_filename`, `Picture`.`original_filename`, `Picture`.`video_url`, `Picture`.`filesize`, `Picture`.`sort`, `Picture`.`created`, `Picture`.`modified` FROM `2sqepkn8`.`pictures` AS `Picture` WHERE `Picture`.`gallery_id` IN (22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32) ORDER BY rand() ASC LIMIT 3	3	3	12
18	SELECT `Post`.`id`, `Post`.`title`, `Post`.`content`, `Post`.`status`, `Post`.`created`, `Post`.`modified`, (`I18n__title`.`content`) AS `Post__i18n_title`, (`I18n__content`.`content`) AS `Post__i18n_content` FROM `2sqepkn8`.`posts` AS `Post` INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Post`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Post`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Post' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') WHERE `Post`.`status` = 1 ORDER BY `Post`.`modified` desc LIMIT 3	0	0	2
19	SELECT `Experience`.`id`, `Experience`.`difficulty_id`, `Experience`.`duration`, `Experience`.`price`, `Experience`.`imgname`, `Experience`.`gallery_id`, `Experience`.`status`, `Experience`.`display`, `Experience`.`created`, `Experience`.`modified`, (`I18n__title`.`content`) AS `Experience__i18n_title`, (`I18n__tile_content`.`content`) AS `Experience__i18n_tile_content`, (`I18n__btncontent`.`content`) AS `Experience__i18n_btncontent`, (`I18n__content_top`.`content`) AS `Experience__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Experience__i18n_content_top_more`, (`I18n__content`.`content`) AS `Experience__i18n_content`, (`I18n__skills_needed`.`content`) AS `Experience__i18n_skills_needed`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified`, `Difficulty`.`id`, `Difficulty`.`title` FROM `2sqepkn8`.`experiences` AS `Experience` LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Experience`.`gallery_id` = `Gallery`.`id`) LEFT JOIN `2sqepkn8`.`difficulties` AS `Difficulty` ON (`Experience`.`difficulty_id` = `Difficulty`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Experience`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Experience' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__tile_content` ON (`Experience`.`id` = `I18n__tile_content`.`foreign_key` AND `I18n__tile_content`.`model` = 'Experience' AND `I18n__tile_content`.`field` = 'tile_content' AND `I18n__tile_content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__btncontent` ON (`Experience`.`id` = `I18n__btncontent`.`foreign_key` AND `I18n__btncontent`.`model` = 'Experience' AND `I18n__btncontent`.`field` = 'btncontent' AND `I18n__btncontent`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Experience`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Experience' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Experience`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Experience' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Experience`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Experience' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__skills_needed` ON (`Experience`.`id` = `I18n__skills_needed`.`foreign_key` AND `I18n__skills_needed`.`model` = 'Experience' AND `I18n__skills_needed`.`field` = 'skills_needed' AND `I18n__skills_needed`.`locale` = 'slk') WHERE `Experience`.`status` = 1 AND `Experience`.`id` = 12 LIMIT 1	1	1	6
20	SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`title`, `Page`.`showinmenu`, `Page`.`menutitle`, `Page`.`content_top`, `Page`.`content_top_more`, `Page`.`content`, `Page`.`content_additional`, `Page`.`content_add_bg`, `Page`.`content_add_color`, `Page`.`content_add_class`, `Page`.`menusort`, `Page`.`status`, `Page`.`menuicon`, `Page`.`gallery_id`, `Page`.`imgname`, `Page`.`created`, `Page`.`modified`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__menutitle`.`content`) AS `Page__i18n_menutitle`, (`I18n__content_top`.`content`) AS `Page__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Page__i18n_content_top_more`, (`I18n__content`.`content`) AS `Page__i18n_content`, (`I18n__content_additional`.`content`) AS `Page__i18n_content_additional`, `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified` FROM `2sqepkn8`.`pages` AS `Page` LEFT JOIN `2sqepkn8`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__menutitle` ON (`Page`.`id` = `I18n__menutitle`.`foreign_key` AND `I18n__menutitle`.`model` = 'Page' AND `I18n__menutitle`.`field` = 'menutitle' AND `I18n__menutitle`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Page`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Page' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Page`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Page' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Page`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Page' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_additional` ON (`Page`.`id` = `I18n__content_additional`.`foreign_key` AND `I18n__content_additional`.`model` = 'Page' AND `I18n__content_additional`.`field` = 'content_additional' AND `I18n__content_additional`.`locale` = 'slk') WHERE `Page`.`id` = 19 LIMIT 1	1	1	3

(default) 20 queries took 570 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Setting`.`key`, `Setting`.`value` FROM `2sqepkn8`.`settings` AS `Setting` WHERE 1 = 1

SELECT `Page`.`id`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__menutitle`.`content`) AS `Page__i18n_menutitle` FROM `2sqepkn8`.`pages` AS `Page` LEFT JOIN `2sqepkn8`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__menutitle` ON (`Page`.`id` = `I18n__menutitle`.`foreign_key` AND `I18n__menutitle`.`model` = 'Page' AND `I18n__menutitle`.`field` = 'menutitle' AND `I18n__menutitle`.`locale` = 'slk') WHERE `Page`.`showinmenu` = '1' AND `Page`.`status` = 1 ORDER BY `Page`.`menusort` asc

SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, (`I18n__title`.`content`) AS `Category__i18n_title` FROM `2sqepkn8`.`categories` AS `Category` INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Category`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Category' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') WHERE `Category`.`status` != 3

SELECT `Page`.`id`, `Page`.`title`, `Page`.`menutitle`, `Page`.`menusort`, `Page`.`menuicon`, `Page`.`category_id` FROM `2sqepkn8`.`pages` AS `Page` WHERE `Page`.`showinmenu` = '1' AND `Page`.`status` != 3 AND `Page`.`category_id` IN (1, 8, 9, 10, 11, 12, 13, 14, 15, 16)

SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `2sqepkn8`.`menus` AS `Menu` WHERE `Menu`.`status` != 3

SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified` FROM `2sqepkn8`.`menuitems` AS `Menuitem` WHERE `Menuitem`.`menu_id` IN (1, 3) ORDER BY `Menuitem`.`sort` asc

SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified`, (`I18n__title`.`content`) AS `Menuitem__i18n_title`, (`I18n__href`.`content`) AS `Menuitem__i18n_href`, `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `2sqepkn8`.`menuitems` AS `Menuitem` LEFT JOIN `2sqepkn8`.`menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Menuitem`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Menuitem' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__href` ON (`Menuitem`.`id` = `I18n__href`.`foreign_key` AND `I18n__href`.`model` = 'Menuitem' AND `I18n__href`.`field` = 'href' AND `I18n__href`.`locale` = 'slk') WHERE `Menuitem`.`menu_id` = 1 ORDER BY `Menuitem`.`sort` asc

SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`title`, `Page`.`showinmenu`, `Page`.`menutitle`, `Page`.`content_top`, `Page`.`content_top_more`, `Page`.`content`, `Page`.`content_additional`, `Page`.`content_add_bg`, `Page`.`content_add_color`, `Page`.`content_add_class`, `Page`.`menusort`, `Page`.`status`, `Page`.`menuicon`, `Page`.`gallery_id`, `Page`.`imgname`, `Page`.`created`, `Page`.`modified`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__menutitle`.`content`) AS `Page__i18n_menutitle`, (`I18n__content_top`.`content`) AS `Page__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Page__i18n_content_top_more`, (`I18n__content`.`content`) AS `Page__i18n_content`, (`I18n__content_additional`.`content`) AS `Page__i18n_content_additional`, `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified` FROM `2sqepkn8`.`pages` AS `Page` LEFT JOIN `2sqepkn8`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__menutitle` ON (`Page`.`id` = `I18n__menutitle`.`foreign_key` AND `I18n__menutitle`.`model` = 'Page' AND `I18n__menutitle`.`field` = 'menutitle' AND `I18n__menutitle`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Page`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Page' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Page`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Page' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Page`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Page' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_additional` ON (`Page`.`id` = `I18n__content_additional`.`foreign_key` AND `I18n__content_additional`.`model` = 'Page' AND `I18n__content_additional`.`field` = 'content_additional' AND `I18n__content_additional`.`locale` = 'slk') WHERE `Page`.`id` IN (66, 67, 68)

SELECT `Post`.`id`, `Post`.`title`, `Post`.`content`, `Post`.`status`, `Post`.`created`, `Post`.`modified`, (`I18n__title`.`content`) AS `Post__i18n_title`, (`I18n__content`.`content`) AS `Post__i18n_content` FROM `2sqepkn8`.`posts` AS `Post` INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Post`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Post`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Post' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') WHERE 1 = 1 ORDER BY `Post`.`modified` desc LIMIT 3

SELECT `Slider`.`id`, `Slider`.`title`, `Slider`.`status`, `Slider`.`created`, `Slider`.`modified` FROM `2sqepkn8`.`sliders` AS `Slider` WHERE `Slider`.`id` = 1 LIMIT 1

SELECT `Slide`.`id`, `Slide`.`slider_id`, `Slide`.`sort`, `Slide`.`title`, `Slide`.`content`, `Slide`.`imgext`, `Slide`.`created`, `Slide`.`modified` FROM `2sqepkn8`.`slides` AS `Slide` WHERE `Slide`.`slider_id` = (1) ORDER BY `Slide`.`sort` asc

SELECT `Experience`.`id`, `Experience`.`difficulty_id`, `Experience`.`duration`, `Experience`.`price`, `Experience`.`imgname`, `Experience`.`gallery_id`, `Experience`.`status`, `Experience`.`display`, `Experience`.`created`, `Experience`.`modified`, (`I18n__title`.`content`) AS `Experience__i18n_title`, (`I18n__tile_content`.`content`) AS `Experience__i18n_tile_content`, (`I18n__btncontent`.`content`) AS `Experience__i18n_btncontent`, (`I18n__content_top`.`content`) AS `Experience__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Experience__i18n_content_top_more`, (`I18n__content`.`content`) AS `Experience__i18n_content`, (`I18n__skills_needed`.`content`) AS `Experience__i18n_skills_needed`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified`, `Difficulty`.`id`, `Difficulty`.`title` FROM `2sqepkn8`.`experiences` AS `Experience` LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Experience`.`gallery_id` = `Gallery`.`id`) LEFT JOIN `2sqepkn8`.`difficulties` AS `Difficulty` ON (`Experience`.`difficulty_id` = `Difficulty`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Experience`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Experience' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__tile_content` ON (`Experience`.`id` = `I18n__tile_content`.`foreign_key` AND `I18n__tile_content`.`model` = 'Experience' AND `I18n__tile_content`.`field` = 'tile_content' AND `I18n__tile_content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__btncontent` ON (`Experience`.`id` = `I18n__btncontent`.`foreign_key` AND `I18n__btncontent`.`model` = 'Experience' AND `I18n__btncontent`.`field` = 'btncontent' AND `I18n__btncontent`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Experience`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Experience' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Experience`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Experience' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Experience`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Experience' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__skills_needed` ON (`Experience`.`id` = `I18n__skills_needed`.`foreign_key` AND `I18n__skills_needed`.`model` = 'Experience' AND `I18n__skills_needed`.`field` = 'skills_needed' AND `I18n__skills_needed`.`locale` = 'slk') WHERE `Experience`.`status` = 1 AND `Experience`.`display` = '1' ORDER BY rand() ASC LIMIT 1

476

SELECT `Gallery`.`id` FROM `2sqepkn8`.`galleries` AS `Gallery` WHERE `Gallery`.`status` = 1 AND `Gallery`.`visible` = 1

SELECT `Picture`.`id`, `Picture`.`gallery_id`, `Picture`.`title`, `Picture`.`saved_filename`, `Picture`.`original_filename`, `Picture`.`video_url`, `Picture`.`filesize`, `Picture`.`sort`, `Picture`.`created`, `Picture`.`modified` FROM `2sqepkn8`.`pictures` AS `Picture` WHERE `Picture`.`gallery_id` IN (22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32) ORDER BY rand() ASC LIMIT 3