Notice (8): Undefined index: requested [APP/controllers/articles_controller.php, line 45]
A je vylosované / Devils cup - florbalový turnaj v Čadci

Devils cup

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 turnaja do 4 skupín. Priebeh losovania si pozrite na videu.

 

Skupina A

  1. FBC Coyotes Jablubkov
  2. Potheads
  3. HUE Team

Skupina B

  1. Válec Team
  2. FBC 11 Trnava
  3. FBC Hunters KNM

Skupina C

  1. FBC Demons Třinec
  2. Villanova
  3. JSC HTM Devils Čadca

Skupina D

  1. Slovan Havířov "C"
  2. Tučniaci
  3. Galaxy Stars

Rozpis zápasov nájdete tu.

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) 49 queries took 57 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`552
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 337
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 `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`.`seo_link` = 'a-je-vylosovane' ORDER BY `Article`.`date` DESC, `Category`.`id` DESC LIMIT 1112
33SELECT `Attachment`.`id`, `Attachment`.`file`, `Attachment`.`article_id`, `Attachment`.`model` FROM `fantom_attachments` AS `Attachment` WHERE `Attachment`.`model` = 'Article' AND `Attachment`.`article_id` = (11) 001
34SELECT COUNT(*) AS `count` FROM `fantom_articles` AS `Article` WHERE `Article`.`id` = 11 111
35SELECT COUNT(*) AS `count` FROM `fantom_articles` AS `Article` WHERE `Article`.`title` = 'A je vylosované' AND `Article`.`id` != 11 111
36SELECT `Article`.`user_id`, `Article`.`category_id` FROM `fantom_articles` AS `Article` WHERE `id` = 11 ORDER BY `Article`.`date` DESC LIMIT 1110
37SELECT COUNT(*) AS `count` FROM `fantom_articles` AS `Article` WHERE `Article`.`id` = 11 110
38UPDATE `fantom_articles` SET `id` = 11, `seo_link` = 'a-je-vylosovane', `title` = 'A je vylosované', `text` = '<p>Dnes prebehlo losovanie základných skupín. Do turnaja sa zapojí <a href=\"http://devilscup.freshidea.sk/en/turnaj/prihlasene-timy.html\"><strong>12 florbalových tímov</strong></a>, ktoré budú rozdelené v základnej časti turnaja do <strong>4 skupín</strong>. Priebeh losovania si pozrite na videu.</p>\r\n\r\n<div class=\"youtube-embed-wrapper\" style=\"position:relative;padding-bottom:56.25%;padding-top:30px;height:0;overflow:hidden;\"><iframe allowfullscreen=\"\" frameborder=\"0\" height=\"360\" src=\"//www.youtube.com/embed/TFtfE9Fs2yc?rel=0\" style=\"position: absolute;top: 0;left: 0;width: 100%;height: 100%;\" width=\"640\"></iframe></div>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<h2>Skupina A</h2>\r\n\r\n<ol>\r\n <li>FBC Coyotes Jablubkov</li>\r\n <li>Potheads</li>\r\n <li>HUE Team</li>\r\n</ol>\r\n\r\n<h2>Skupina B</h2>\r\n\r\n<ol>\r\n <li>Válec Team</li>\r\n <li>FBC 11 Trnava</li>\r\n <li>FBC Hunters KNM</li>\r\n</ol>\r\n\r\n<h2>Skupina C</h2>\r\n\r\n<ol>\r\n <li>FBC Demons Třinec</li>\r\n <li>Villanova</li>\r\n <li>JSC HTM Devils Čadca</li>\r\n</ol>\r\n\r\n<h2>Skupina D</h2>\r\n\r\n<ol>\r\n <li>Slovan Havířov \"C\"</li>\r\n <li>Tučniaci</li>\r\n <li>Galaxy Stars</li>\r\n</ol>\r\n\r\n<p>Rozpis zápasov nájdete <strong><a href=\"http://devilscup.freshidea.sk/en/turnaj/rozpis-zapasov.html\">tu</a></strong>.</p>\r\n', `date` = '2017-06-14 17:30:00', `user_id` = 1, `published` = 1, `priority` = 1, `category_id` = 6, `show_author` = 1, `show_created` = 1, `show_all` = 0, `comment_count` = 0, `thumbnail` = '1497704032.jpg', `gallery_id` = 12, `description` = NULL, `seo_description` = '', `featured` = 0, `visitors` = 116 WHERE `fantom_articles`.`id` = 1112
39SELECT COUNT(*) AS `count` FROM `fantom_articles` AS `Article` WHERE `Article`.`category_id` = 6 111
40UPDATE `fantom_categories` AS `Category` SET `Category`.`article_count` = 4 WHERE `Category`.`id` = 601
41SHOW FULL COLUMNS FROM `fantom_search_index`661
42SELECT `SearchIndex`.`id` FROM `fantom_search_index` AS `SearchIndex` WHERE `model` = 'Article' AND `association_key` = '11' LIMIT 1111
43SELECT COUNT(*) AS `count` FROM `fantom_search_index` AS `SearchIndex` WHERE `SearchIndex`.`id` = 36 110
44SELECT COUNT(*) AS `count` FROM `fantom_search_index` AS `SearchIndex` WHERE `SearchIndex`.`id` = 36 110
45UPDATE `fantom_search_index` SET `id` = 36, `model` = 'Article', `association_key` = '11', `data` = 'a je vylosovane A je vylosovane Dnes prebehlo losovanie zakladnych skupin Do turnaja sa zapoji 12 florbalovych timov ktore budu rozdelene v zakladnej casti turnaja do 4 skupin Priebeh losovania si pozrite na videu   Skupina A FBC Coyotes Jablubkov Potheads HUE Team Skupina B Valec Team FBC 11 Trnava FBC Hunters KNM Skupina C FBC Demons Trinec Villanova JSC HTM Devils Cadca Skupina D Slovan Havirov C Tucniaci Galaxy Stars Rozpis zapasov najdete tu 1497704032 jpg', `modified` = '2021-10-27 22:21:11' WHERE `fantom_search_index`.`id` = 3612
46SELECT `Category`.`lft`, `Category`.`rght` FROM `fantom_categories` AS `Category` WHERE `Category`.`id` = 6 ORDER BY `Category`.`id` DESC LIMIT 1111
47SELECT `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
48SELECT `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`.`id` !=11 AND `Article`.`category_id` = 6 ORDER BY `Article`.`date` DESC, `Category`.`id` DESC LIMIT 3332
49SELECT `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, 5) 000