Notice (8): Undefined index: requested [APP/controllers/articles_controller.php, line 45]
Nováčikom turnaja český Slovan Havířov / Devils cup - florbalový turnaj v Čadci

Rozhovor

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šíme sa, že si vybrali náš turnaj a rovnako aj z prípadného prekvapenia :)

Ako dlho sa venujete florbalu? 

Letos to bude naše první sezona za klub Slovan Havířov ale máme několik bývalých hráčů, kteří se florbalu věnovali od žákovských kategorií až do mužských.

V ktorých ligách hráte?

Letos budeme hrát v Moravskoslezské soutěži mužů.

Florbalové osobnosti vo vašom tíme?

Žádné.

Ste pravidelným účastníkom nášho turnaja. Čo vás k nám privádza aj tento rok? 

Přihlásili jsme se poprvé na váš turnaj a moc se těšíme. Hledali jsme na internetu různé turnaje a ten váš nás nadchl nejvíce.

Plány vášho tímu do budúcna?

Sehrát se, jelikož spolu začínáme první sezonu. Stmelit kolektiv a ukázat, že na to herně máme.

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 60 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 1112
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 3002
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` = 'novacikom-turnaja-cesky-slovan-havirov' 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` = (9) 001
34SELECT COUNT(*) AS `count` FROM `fantom_articles` AS `Article` WHERE `Article`.`id` = 9 111
35SELECT COUNT(*) AS `count` FROM `fantom_articles` AS `Article` WHERE `Article`.`title` = 'Nováčikom turnaja český Slovan Havířov' AND `Article`.`id` != 9 111
36SELECT `Article`.`user_id`, `Article`.`category_id` FROM `fantom_articles` AS `Article` WHERE `id` = 9 ORDER BY `Article`.`date` DESC LIMIT 1111
37SELECT COUNT(*) AS `count` FROM `fantom_articles` AS `Article` WHERE `Article`.`id` = 9 111
38UPDATE `fantom_articles` SET `id` = 9, `seo_link` = 'novacikom-turnaja-cesky-slovan-havirov', `title` = 'Nováčikom turnaja český Slovan Havířov', `text` = '<p>Nováčikom bude tím z Havířova.&nbsp;Chalani prezradili, že je to ich prvá sezóna a chcú sa zohrať. Uvidíme ako im to pôjde. Tešíme sa, že si vybrali náš turnaj a rovnako aj z prípadného prekvapenia&nbsp;:)</p>\r\n\r\n<h2>Ako dlho sa venujete florbalu?&nbsp;</h2>\r\n\r\n<p>Letos to bude naše <strong>první sezona za klub</strong> Slovan Havířov ale máme několik bývalých hráčů, kteří se florbalu věnovali <strong>od žákovských kategorií až do mužských</strong>.</p>\r\n\r\n<h2>V ktorých ligách hráte?</h2>\r\n\r\n<p>Letos budeme hrát v <strong>Moravskoslezské soutěži mužů</strong>.</p>\r\n\r\n<h2>Florbalové osobnosti vo vašom tíme?</h2>\r\n\r\n<p>Žádné.</p>\r\n\r\n<h2>Ste pravidelným účastníkom nášho turnaja. Čo vás k nám privádza aj tento rok?&nbsp;</h2>\r\n\r\n<p>Přihlásili jsme se <strong>poprvé</strong> na váš turnaj a moc se těšíme. Hledali jsme na internetu různé turnaje a ten váš nás nadchl nejvíce.</p>\r\n\r\n<h2>Plány vášho tímu do budúcna?</h2>\r\n\r\n<p>Sehrát se, jelikož spolu začínáme první sezonu. <strong>Stmelit kolektiv a ukázat, že na to herně máme</strong>.</p>\r\n', `date` = '2017-06-15 10:00:00', `user_id` = 1, `published` = 1, `priority` = 1, `category_id` = 5, `show_author` = 1, `show_created` = 1, `show_all` = 0, `comment_count` = 0, `thumbnail` = '1497892457.jpg', `gallery_id` = 9, `description` = NULL, `seo_description` = '', `featured` = 0, `visitors` = 112 WHERE `fantom_articles`.`id` = 912
39SELECT COUNT(*) AS `count` FROM `fantom_articles` AS `Article` WHERE `Article`.`category_id` = 5 110
40UPDATE `fantom_categories` AS `Category` SET `Category`.`article_count` = 5 WHERE `Category`.`id` = 501
41SHOW FULL COLUMNS FROM `fantom_search_index`662
42SELECT `SearchIndex`.`id` FROM `fantom_search_index` AS `SearchIndex` WHERE `model` = 'Article' AND `association_key` = '9' LIMIT 1111
43SELECT COUNT(*) AS `count` FROM `fantom_search_index` AS `SearchIndex` WHERE `SearchIndex`.`id` = 31 111
44SELECT COUNT(*) AS `count` FROM `fantom_search_index` AS `SearchIndex` WHERE `SearchIndex`.`id` = 31 110
45UPDATE `fantom_search_index` SET `id` = 31, `model` = 'Article', `association_key` = '9', `data` = 'novacikom turnaja cesky slovan havirov Novacikom turnaja cesky Slovan Havirov Novacikom bude tim z Havirova  Chalani prezradili ze je to ich prva sezona a chcu sa zohrat Uvidime ako im to pojde Tesime sa ze si vybrali nas turnaj a rovnako aj z pripadneho prekvapenia  Ako dlho sa venujete florbalu   Letos to bude nase prvni sezona za klub Slovan Havirov ale mame nekolik byvalych hracu kteri se florbalu venovali od zakovskych kategorii az do muzskych V ktorych ligach hrate Letos budeme hrat v Moravskoslezske soutezi muzu Florbalove osobnosti vo vasom time Zadne Ste pravidelnym ucastnikom nasho turnaja Co vas k nam privadza aj tento rok   Prihlasili jsme se poprve na vas turnaj a moc se tesime Hledali jsme na internetu ruzne turnaje a ten vas nas nadchl nejvice Plany vasho timu do buducna Sehrat se jelikoz spolu zaciname prvni sezonu Stmelit kolektiv a ukazat ze na to herne mame 1497892457 jpg', `modified` = '2021-10-27 22:29:23' WHERE `fantom_search_index`.`id` = 3112
46SELECT `Category`.`lft`, `Category`.`rght` FROM `fantom_categories` AS `Category` WHERE `Category`.`id` = 5 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` <= 4 AND `Category`.`rght` >= 5 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` !=9 AND `Article`.`category_id` = 5 ORDER BY `Article`.`date` DESC, `Category`.`id` DESC LIMIT 3333
49SELECT `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, 6) 001