Devils cup

Devils cup
Poďakovanie sponzorom Devils cupu
Poďakovanie sponzorom Devils cupu
Aj touto cestou by sme radi poďakovali partnerom turnaja. Bez ich podpory, či už finančnej alebo materiálnej, by bolo veľ...
Devils cup
O Devils cupe v médiách
O Devils cupe v médiách
O našom turnaji sa písalo v niekoľkých novinách a portáloch. Odkazy na články nájdete nižšie. info.sk Medzinárodný tu...
Devils cup
A je vylosované
A je vylosované
Dnes prebehlo losovanie základných skupín. Do turnaja sa zapojí 12 florbalových tímov, ktoré budú rozdelené v základnej časti ...
Devils cup
História Devils Cupu
História Devils Cupu
Turnaj vznikol v roku 2012 ako jednorazová záležitosť. Založili ho Miroslav Michalina a Peter Jurga. Po dobrej odozve hráčov n...

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 48 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `fantom_articles`19192
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_slovak_ci';112
3SHOW FULL COLUMNS FROM `fantom_users`10102
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 1112
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 6662
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` = 'devils-cup' ORDER BY `Category`.`id` DESC LIMIT 1111
33SELECT `Category`.`lft`, `Category`.`rght` FROM `fantom_categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 6 ORDER BY `Category`.`id` DESC LIMIT 1111
34SELECT `Category`.`id` FROM `fantom_categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 7 AND `Category`.`lft` > 6 ORDER BY `Category`.`lft` asc 001
35SELECT `Category`.`lft`, `Category`.`rght` FROM `fantom_categories` AS `Category` WHERE `Category`.`id` = 6 ORDER BY `Category`.`id` DESC LIMIT 1111
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` <= 6 AND `Category`.`rght` >= 7 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` = (6) 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` = (6) AND `Article`.`published` = 1 ORDER BY `Article`.`date` DESC, `Category`.`id` DESC LIMIT 10442
39SELECT `Attachment`.`id`, `Attachment`.`file`, `Attachment`.`article_id`, `Attachment`.`model` FROM `fantom_attachments` AS `Attachment` WHERE `Attachment`.`model` = 'Article' AND `Attachment`.`article_id` IN (13, 7, 11, 5) 001