Rozhovor

Rozhovor
Rozhovor s Lukášom Imrišíkom z JSC HTM Devils Čadca
Rozhovor s Lukášom Imrišíkom z JSC HTM Devils Čadca
Jeden z domácich tímov je JSC HTM Devils Čadca. Lukáš nám prezradil, že poskladali nový tím, ktorý má ambíciu hrať v tret...
Rozhovor
FBC 11 Trnava o tom ako sa bavia florbalom
FBC 11 Trnava o tom ako sa bavia florbalom
Florbalisti z Trnavy sú pravidelným účastníkom. Turnaj vyhrali v roku 2013, o rok neskôr boli tretí a ďalsí rok druhí. Je vidi...
Rozhovor
Nováčikom turnaja český Slovan Havířov
Nováčikom turnaja český Slovan Havířov
Nováčikom bude tím z Havířova. Chalani prezradili, že je to ich prvá sezóna a chcú sa zohrať. Uvidíme ako im to pôjde. Te...
Rozhovor
FBC Coyotes Jablunkov oslovila kvalita turnaja
FBC Coyotes Jablunkov oslovila kvalita turnaja
Na turnaji máme aj florbalistov z Českej republiky čomu sa veľmi tešíme. Oslovili sme chalanov z FBC Coyotes Jablunkov. ...
Rozhovor
GALAXY Stars pôsobí iba na Devils Cupe
GALAXY Stars pôsobí iba na Devils Cupe
Trošku sme vyspovedali chalanov z Trenčína, ktorí sa už tešia na turnaj. Sme presvedčení, že je to dobrý spôsob ako predstaviť...

Notice (8): Undefined index: partneri [APP/views/themed/default/layouts/default.ctp, line 164]

Notice (8): Undefined index: partneri [APP/views/themed/default/layouts/default.ctp, line 165]
Sponzori turnaja
(production) 39 queries took 44 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `fantom_articles`19191
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_slovak_ci';111
3SHOW FULL COLUMNS FROM `fantom_users`10101
4SHOW FULL COLUMNS FROM `fantom_groups`551
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';111
6SHOW FULL COLUMNS FROM `fantom_categories`16161
7SHOW FULL COLUMNS FROM `fantom_static_contents`10101
8SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
9SHOW FULL COLUMNS FROM `fantom_galleries`881
10SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_czech_ci';111
11SHOW FULL COLUMNS FROM `fantom_pictures`551
12SHOW FULL COLUMNS FROM `fantom_attachments`441
13SHOW FULL COLUMNS FROM `fantom_files`661
14SHOW FULL COLUMNS FROM `fantom_texts`771
15SHOW FULL COLUMNS FROM `fantom_settings`15151
16SELECT `Setting`.`id`, `Setting`.`dateshort`, `Setting`.`datelong`, `Setting`.`homepagearticles`, `Setting`.`pagetitle`, `Setting`.`googleanalytics`, `Setting`.`email`, `Setting`.`wysiwyg`, `Setting`.`imgbigscale`, `Setting`.`imgsmallscale`, `Setting`.`breadcrumbs`, `Setting`.`pagination`, `Setting`.`advanced_search`, `Setting`.`captcha`, `Setting`.`description` FROM `fantom_settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1111
17SELECT `Text`.`id`, `Text`.`name`, `Text`.`content`, `Text`.`seo_link`, `Text`.`category_id`, `Text`.`file`, `Text`.`priority`, `Category`.`id`, `Category`.`name`, `Category`.`seo_link`, `Category`.`article_count`, `Category`.`rght`, `Category`.`lft`, `Category`.`parent_id`, `Category`.`model`, `Category`.`static_content_count`, `Category`.`download_count`, `Category`.`product_count`, `Category`.`priority`, `Category`.`description`, `Category`.`seo_description`, `Category`.`gallery_count`, `Category`.`thumbnail` FROM `fantom_texts` AS `Text` LEFT JOIN `fantom_categories` AS `Category` ON (`Text`.`category_id` = `Category`.`id`) WHERE 1 = 1 331
18SELECT `Category`.`id`, `Category`.`name`, `Category`.`seo_link`, `Category`.`article_count`, `Category`.`rght`, `Category`.`lft`, `Category`.`parent_id`, `Category`.`model`, `Category`.`static_content_count`, `Category`.`download_count`, `Category`.`product_count`, `Category`.`priority`, `Category`.`description`, `Category`.`seo_description`, `Category`.`gallery_count`, `Category`.`thumbnail` FROM `fantom_categories` AS `Category` WHERE `Category`.`model` = 'Text' ORDER BY `Category`.`id` DESC 001
19SELECT `Category`.`id`, `Category`.`name`, `Category`.`seo_link`, `Category`.`article_count`, `Category`.`rght`, `Category`.`lft`, `Category`.`parent_id`, `Category`.`model`, `Category`.`static_content_count`, `Category`.`download_count`, `Category`.`product_count`, `Category`.`priority`, `Category`.`description`, `Category`.`seo_description`, `Category`.`gallery_count`, `Category`.`thumbnail` FROM `fantom_categories` AS `Category` WHERE `Category`.`id` = 1 ORDER BY `Category`.`id` DESC LIMIT 1111
20SELECT `StaticContent`.`id`, `StaticContent`.`name`, `StaticContent`.`seo_link`, `StaticContent`.`user_id`, `StaticContent`.`category_id`, `StaticContent`.`text`, `StaticContent`.`gallery_id`, `StaticContent`.`priority`, `StaticContent`.`seo_description`, `StaticContent`.`template` FROM `fantom_static_contents` AS `StaticContent` WHERE `StaticContent`.`category_id` = 1 ORDER BY `StaticContent`.`priority` desc 552
21SELECT `Category`.`id`, `Category`.`name`, `Category`.`seo_link`, `Category`.`article_count`, `Category`.`rght`, `Category`.`lft`, `Category`.`parent_id`, `Category`.`model`, `Category`.`static_content_count`, `Category`.`download_count`, `Category`.`product_count`, `Category`.`priority`, `Category`.`description`, `Category`.`seo_description`, `Category`.`gallery_count`, `Category`.`thumbnail` FROM `fantom_categories` AS `Category` WHERE `Category`.`id` = 2 ORDER BY `Category`.`id` DESC LIMIT 1111
22SELECT `StaticContent`.`id`, `StaticContent`.`name`, `StaticContent`.`seo_link`, `StaticContent`.`user_id`, `StaticContent`.`category_id`, `StaticContent`.`text`, `StaticContent`.`gallery_id`, `StaticContent`.`priority`, `StaticContent`.`seo_description`, `StaticContent`.`template` FROM `fantom_static_contents` AS `StaticContent` WHERE `StaticContent`.`id` = 6 ORDER BY `StaticContent`.`priority` desc LIMIT 1111
23SELECT `StaticContent`.`id`, `StaticContent`.`name`, `StaticContent`.`seo_link`, `StaticContent`.`user_id`, `StaticContent`.`category_id`, `StaticContent`.`text`, `StaticContent`.`gallery_id`, `StaticContent`.`priority`, `StaticContent`.`seo_description`, `StaticContent`.`template` FROM `fantom_static_contents` AS `StaticContent` WHERE `StaticContent`.`id` = 7 ORDER BY `StaticContent`.`priority` desc LIMIT 1111
24SELECT `Article`.`id`, `Article`.`seo_link`, `Article`.`title`, `Article`.`text`, `Article`.`date`, `Article`.`user_id`, `Article`.`published`, `Article`.`priority`, `Article`.`category_id`, `Article`.`show_author`, `Article`.`show_created`, `Article`.`show_all`, `Article`.`comment_count`, `Article`.`thumbnail`, `Article`.`gallery_id`, `Article`.`description`, `Article`.`seo_description`, `Article`.`featured`, `Article`.`visitors`, `User`.`name`, `User`.`username`, `User`.`email`, `User`.`avatar`, `Category`.`id`, `Category`.`name`, `Category`.`seo_link`, `Category`.`article_count`, `Category`.`rght`, `Category`.`lft`, `Category`.`parent_id`, `Category`.`model`, `Category`.`static_content_count`, `Category`.`download_count`, `Category`.`product_count`, `Category`.`priority`, `Category`.`description`, `Category`.`seo_description`, `Category`.`gallery_count`, `Category`.`thumbnail`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`description`, `Gallery`.`public`, `Gallery`.`seo_link`, `Gallery`.`picture_count`, `Gallery`.`category_id`, `Gallery`.`seo_description` FROM `fantom_articles` AS `Article` LEFT JOIN `fantom_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) LEFT JOIN `fantom_categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `fantom_galleries` AS `Gallery` ON (`Article`.`gallery_id` = `Gallery`.`id`) WHERE `Article`.`featured` = 1 ORDER BY `Article`.`date` DESC, `Category`.`id` DESC 333
25SELECT `Attachment`.`id`, `Attachment`.`file`, `Attachment`.`article_id`, `Attachment`.`model` FROM `fantom_attachments` AS `Attachment` WHERE `Attachment`.`model` = 'Article' AND `Attachment`.`article_id` IN (12, 8, 3) 001
26SELECT `Category`.`lft`, `Category`.`rght` FROM `fantom_categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 2 ORDER BY `Category`.`id` DESC LIMIT 1111
27SELECT `Category`.`id` FROM `fantom_categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 8 AND `Category`.`lft` > 3 ORDER BY `Category`.`lft` asc 221
28SELECT `Article`.`id`, `Article`.`seo_link`, `Article`.`title`, `Article`.`text`, `Article`.`date`, `Article`.`user_id`, `Article`.`published`, `Article`.`priority`, `Article`.`category_id`, `Article`.`show_author`, `Article`.`show_created`, `Article`.`show_all`, `Article`.`comment_count`, `Article`.`thumbnail`, `Article`.`gallery_id`, `Article`.`description`, `Article`.`seo_description`, `Article`.`featured`, `Article`.`visitors`, `User`.`name`, `User`.`username`, `User`.`email`, `User`.`avatar`, `Category`.`id`, `Category`.`name`, `Category`.`seo_link`, `Category`.`article_count`, `Category`.`rght`, `Category`.`lft`, `Category`.`parent_id`, `Category`.`model`, `Category`.`static_content_count`, `Category`.`download_count`, `Category`.`product_count`, `Category`.`priority`, `Category`.`description`, `Category`.`seo_description`, `Category`.`gallery_count`, `Category`.`thumbnail`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`description`, `Gallery`.`public`, `Gallery`.`seo_link`, `Gallery`.`picture_count`, `Gallery`.`category_id`, `Gallery`.`seo_description` FROM `fantom_articles` AS `Article` LEFT JOIN `fantom_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) LEFT JOIN `fantom_categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `fantom_galleries` AS `Gallery` ON (`Article`.`gallery_id` = `Gallery`.`id`) WHERE `Article`.`published` = 1 AND `Article`.`featured` != 1 AND `Category`.`id` IN (5, 6, 2) ORDER BY `Article`.`date` DESC, `Category`.`id` DESC LIMIT 6663
29SELECT `Attachment`.`id`, `Attachment`.`file`, `Attachment`.`article_id`, `Attachment`.`model` FROM `fantom_attachments` AS `Attachment` WHERE `Attachment`.`model` = 'Article' AND `Attachment`.`article_id` IN (13, 9, 7, 6, 11, 5) 001
30SELECT `Article`.`id`, `Article`.`seo_link`, `Article`.`title`, `Article`.`text`, `Article`.`date`, `Article`.`user_id`, `Article`.`published`, `Article`.`priority`, `Article`.`category_id`, `Article`.`show_author`, `Article`.`show_created`, `Article`.`show_all`, `Article`.`comment_count`, `Article`.`thumbnail`, `Article`.`gallery_id`, `Article`.`description`, `Article`.`seo_description`, `Article`.`featured`, `Article`.`visitors`, `User`.`name`, `User`.`username`, `User`.`email`, `User`.`avatar`, `Category`.`id`, `Category`.`name`, `Category`.`seo_link`, `Category`.`article_count`, `Category`.`rght`, `Category`.`lft`, `Category`.`parent_id`, `Category`.`model`, `Category`.`static_content_count`, `Category`.`download_count`, `Category`.`product_count`, `Category`.`priority`, `Category`.`description`, `Category`.`seo_description`, `Category`.`gallery_count`, `Category`.`thumbnail`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`description`, `Gallery`.`public`, `Gallery`.`seo_link`, `Gallery`.`picture_count`, `Gallery`.`category_id`, `Gallery`.`seo_description` FROM `fantom_articles` AS `Article` LEFT JOIN `fantom_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) LEFT JOIN `fantom_categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `fantom_galleries` AS `Gallery` ON (`Article`.`gallery_id` = `Gallery`.`id`) WHERE `Article`.`date` > DATE(NOW()) - INTERVAL 7 DAY ORDER BY `Article`.`visitors` DESC, `Category`.`id` DESC LIMIT 3001
31SELECT `Category`.`id`, `Category`.`name`, `Category`.`seo_link`, `Category`.`article_count`, `Category`.`rght`, `Category`.`lft`, `Category`.`parent_id`, `Category`.`model`, `Category`.`static_content_count`, `Category`.`download_count`, `Category`.`product_count`, `Category`.`priority`, `Category`.`description`, `Category`.`seo_description`, `Category`.`gallery_count`, `Category`.`thumbnail` FROM `fantom_categories` AS `Category` WHERE `Category`.`model` = 'Article' ORDER BY `Category`.`id` DESC 331
32SELECT `Category`.`id`, `Category`.`name`, `Category`.`seo_link`, `Category`.`article_count`, `Category`.`rght`, `Category`.`lft`, `Category`.`parent_id`, `Category`.`model`, `Category`.`static_content_count`, `Category`.`download_count`, `Category`.`product_count`, `Category`.`priority`, `Category`.`description`, `Category`.`seo_description`, `Category`.`gallery_count`, `Category`.`thumbnail` FROM `fantom_categories` AS `Category` WHERE `Category`.`seo_link` = 'rozhovor' ORDER BY `Category`.`id` DESC LIMIT 1111
33SELECT `Category`.`lft`, `Category`.`rght` FROM `fantom_categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 5 ORDER BY `Category`.`id` DESC LIMIT 1111
34SELECT `Category`.`id` FROM `fantom_categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 5 AND `Category`.`lft` > 4 ORDER BY `Category`.`lft` asc 001
35SELECT `Category`.`lft`, `Category`.`rght` FROM `fantom_categories` AS `Category` WHERE `Category`.`id` = 5 ORDER BY `Category`.`id` DESC LIMIT 1110
36SELECT `Category`.`id`, `Category`.`name`, `Category`.`seo_link`, `Category`.`article_count`, `Category`.`rght`, `Category`.`lft`, `Category`.`parent_id`, `Category`.`model`, `Category`.`static_content_count`, `Category`.`download_count`, `Category`.`product_count`, `Category`.`priority`, `Category`.`description`, `Category`.`seo_description`, `Category`.`gallery_count`, `Category`.`thumbnail` FROM `fantom_categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 4 AND `Category`.`rght` >= 5 ORDER BY `Category`.`lft` asc 221
37SELECT COUNT(*) AS `count` FROM `fantom_articles` AS `Article` LEFT JOIN `fantom_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) LEFT JOIN `fantom_categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `fantom_galleries` AS `Gallery` ON (`Article`.`gallery_id` = `Gallery`.`id`) WHERE `Article`.`category_id` = (5) AND `Article`.`published` = 1 ORDER BY `Category`.`id` DESC 111
38SELECT `Article`.`id`, `Article`.`seo_link`, `Article`.`title`, `Article`.`text`, `Article`.`date`, `Article`.`user_id`, `Article`.`published`, `Article`.`priority`, `Article`.`category_id`, `Article`.`show_author`, `Article`.`show_created`, `Article`.`show_all`, `Article`.`comment_count`, `Article`.`thumbnail`, `Article`.`gallery_id`, `Article`.`description`, `Article`.`seo_description`, `Article`.`featured`, `Article`.`visitors`, `User`.`name`, `User`.`username`, `User`.`email`, `User`.`avatar`, `Category`.`id`, `Category`.`name`, `Category`.`seo_link`, `Category`.`article_count`, `Category`.`rght`, `Category`.`lft`, `Category`.`parent_id`, `Category`.`model`, `Category`.`static_content_count`, `Category`.`download_count`, `Category`.`product_count`, `Category`.`priority`, `Category`.`description`, `Category`.`seo_description`, `Category`.`gallery_count`, `Category`.`thumbnail`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`description`, `Gallery`.`public`, `Gallery`.`seo_link`, `Gallery`.`picture_count`, `Gallery`.`category_id`, `Gallery`.`seo_description` FROM `fantom_articles` AS `Article` LEFT JOIN `fantom_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) LEFT JOIN `fantom_categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) LEFT JOIN `fantom_galleries` AS `Gallery` ON (`Article`.`gallery_id` = `Gallery`.`id`) WHERE `Article`.`category_id` = (5) AND `Article`.`published` = 1 ORDER BY `Article`.`date` DESC, `Category`.`id` DESC LIMIT 10552
39SELECT `Attachment`.`id`, `Attachment`.`file`, `Attachment`.`article_id`, `Attachment`.`model` FROM `fantom_attachments` AS `Attachment` WHERE `Attachment`.`model` = 'Article' AND `Attachment`.`article_id` IN (12, 8, 9, 6, 3) 001