0.0005 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0075 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/tallinn_summer_showdown_555championship_2023/1C/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0039 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'tallinn_summer_showdown_555championship_2023'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '24'
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0063 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '76'
AND `published` = 1
0.0296 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0063 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '77'
AND `published` = 1
0.0276 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0062 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '78'
AND `published` = 1
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '79'
AND `published` = 1
0.0276 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0055 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '80'
AND `published` = 1
0.0273 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0053 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '81'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '24'
AND `name` = '1C'
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '78'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '78'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3532'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3531'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3530'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3529'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3528'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3527'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3526'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3525'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3524'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3523'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3522'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3521'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3520'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3519'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3518'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3517'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3516'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3515'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3514'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3511'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3510'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3509'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3508'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3507'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3506'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3505'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3504'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3503'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3502'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3500'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3499'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '78'
ORDER BY `busted` ASC, `current_chips` DESC
0.0058 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '78'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3532'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3531'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3530'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3529'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3528'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3527'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3526'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3525'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3524'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3523'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3522'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3521'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3520'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3519'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3518'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3517'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3516'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3515'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3514'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3511'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3510'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3509'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3508'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3507'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3506'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3505'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3504'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3503'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3502'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3500'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3499'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '81'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Napel Leads the €555 Championship Posted Monday 24th July, 2023 at 22:51(UTC+2) by Jason Glatzer
Tobias Napel (pictured above) snagged the chip lead midway through Day 1c and never looked back. His 211 big blind stack by far leads the way not only among the 63 survivors from the 198 entries from the Day 1c field but also catapulted him into the overall chip lead with Simon Forendal's ending stack on his second bullet of Day 1c of 264,000 placing him in second place overall.
Here is a look at all of the final chip counts from Day 1c.
Name
Chips
Big Blinds
Tobias Napel
338,000
211
Simon Forendal
264,000
165
Raffael Wadl
255,500
160
Raivo Pinsel
226,500
142
Taago Tamm
212,000
133
Ivar Simmer
191,500
120
Juan Carlos Vecino Duenas
185,000
116
Michailas Miserkejevas
184,500
115
Nick Penning
172,500
108
James Noonan
172,000
108
Mario Colavita
171,500
107
Maksim Petrov
169,500
106
Tomas Mickus
165,000
103
Yvonne Stiedl
148,000
93
Saulius Tumosa
144,000
90
Maikel Homin
140,000
88
Jarkko Suokas
135,500
85
Endre Oren
118,000
74
Julian Herold
111,000
69
Miko Ylikoski
104,500
65
Igor Pihela Jr.
92,500
58
Marko Vartinen
91,000
57
Joacim Blom
90,500
57
Pertti Salakari
90,500
57
Indre Martoviciute
87,500
55
Joel Lehtinen
78,500
49
Guillermo Cifuentes
77,500
48
Tarjei Forus
75,500
47
Anna-Mari Hursti
74,000
46
Joonas Siren
71,500
45
Samuli Hietala
69,500
43
Janne Nevalainen
69,000
43
Kristjan Maasalu
68,000
43
Tomi Arponen
66,000
41
Maria Heilala
65,000
41
Jonatan Fors
62,500
39
Jari Karkkainen
62,500
39
Knut Trulsen
57,000
36
Jani Tuovinen
56,500
35
Priit Oja
55,500
35
Peep Kivistik
55,000
34
Mikael Haapaniemi
47,500
30
Alenas Pelegrimas
47,500
30
Kristjan Kuning
46,500
29
Alberto Gonzalez
45,000
28
Mark Metsla
44,000
28
Johan Ekdahl
43,500
27
Jonas Lapinskas
41,500
26
Jordi Baixas
39,500
25
Markus Isosalo
39,000
24
Nils Linden
36,500
23
Riku Koivurinne
36,000
23
Stefan Bittger
32,000
20
Miika Samuli Töyräs
32,000
20
Tero Laurila
31,500
20
Stefan Schrittwieser
31,000
19
Marko Vest
29,000
18
Donatas Pilinkus
27,000
17
Jaakko Tirkkonen
26,500
17
Anders Christiansen
25,500
16
Eimantas Venckus
24,000
15
Peter Wieczorek
19,000
12
Anu Lilja
14,500
9
Pihela Jr. Runs Into Quads Posted Monday 24th July, 2023 at 21:39(UTC+2) by Jason Glatzer
A few hands before the end of the night, Igor Pihela Jr. (pictured above) ran into a monster with his full house on his second bullet of the day after check-jamming the river on an already big pot with the on the board.
He rivered a full house with for the second nuts on the board. Normally this would be scoop city. Instead, Pihela Jr. ran into quads with his opponent holding the to win the big pot in a rare case of getting paid after flopping quads.
Pihela Jr. had around 130,000 after the hand and it wasn't as bad as it could have been as he still ended the day with 92,500.
Player
Chips
Progress
Igor Pihela Jr.
92,500
74,500
Bagging & Tagging Posted Monday 24th July, 2023 at 20:04(UTC+2) by Jason Glatzer
Players have begun to bag and tag chips with 66 players remaining out of the 198-player field. A few of the tables are still playing their final few hands, so expect one or two less to advance to Day 2 from the Day 1c field.
Final Day 1c Blind Level Begins Posted Monday 24th July, 2023 at 19:44(UTC+2) by Jason Glatzer
Players are close to bagging up their stacks for Day 1c with the field at 198 entries with 76 players remaining near the start of Level 11. After this hand, players will bag and tag their stacks into tomorrow's Day 2.
As a reminder, a turbo Day 1d will take place tonight as well. We will update the chip counts of the final flight and the seat draw for tomorrow later in the evening.
19:42 (UTC+2)
Start of Level 11 Blinds: 700/1,400 Ante: 1,400
Napel & Colavito With Huge Stacks Posted Monday 24th July, 2023 at 19:38(UTC+2) by Jason Glatzer
Level 10: 600/1,200 (1,200) Entries: 80/198
Tobias Napel and Mario Colavito are sitting side-by-side at Table 10 with nearly half a million chips between them and haven't been afraid to go after each other.
Napel was near 300,000 in chips and some of that came from Colavito's stack when his cowboys held against ace-king in a big pot.
If Napel can end the day without bleeding a chunk of his stack, he will be the overall chip leader. That honor leading into today belongs to Day 1a chip leader Roope Tarmi.
Player
Chips
Progress
Tobias Napel
270,000
170,000
Mario Colavito
170,000
140,000
Cooler for Bezdek Posted Monday 24th July, 2023 at 19:01(UTC+2) by Jason Glatzer
Level 10: 600/1,200 (1,200) Entries: 97/196
There isn't a major festival in Tallinn that Anne Bezdek hasn't been at in recent memory. She has managed to run deep in several big events over the years but will need to re-enter to do the same in the €555 Championship.
Bezdek open-jammed for a little less than the pot for 12,900. Samuli Hietala quickly called and another player in the hand quickly folded.
Anne Bezdek: Samuli Hietala:
Bezdek was ahead on the flop but Hietala hit gin on the turn to get ahead of Bezdek's two pair with a set of nines. No miracle two outer came on the river as Bezdek was out of chips, at least on this bullet, with the river completing the board.
Player
Chips
Progress
Samuli Hietala
115,000
85,000
Anne Bezdek
0
0
18:50 (UTC+2)
Start of Level 10 Blinds: 600/1,200 Ante: 1,200
Break Time Posted Monday 24th July, 2023 at 18:35(UTC+2) by Jason Glatzer
Players are on a quick break and will return to play two more blind levels before bagging and tagging chips for tomorrow's Day 2.
Tamm Completes Flush Draw Posted Monday 24th July, 2023 at 18:30(UTC+2) by Jason Glatzer
Level 9: 500/1,000 (1,000) Entries: 101/191
There was a massive pile of chips already in the pot with the on the board after the turn when Johannes Tobbe open-jammed for 23,800. Taago Taam, who had Tobbe well-covered, called and another player folded.
Johannes Tobbe: Taago Taam:
Although Tobbe was ahead, any heart, any aces, or any eight would change that on the river. It was the flush draw that was completed after the river paired the board to eliminate Tobbe and grow his stack to more than four times the 30,000 starting stack.
We have gotten to know Taam's great sense of humor over the years. We asked if the jam was for 23,000 to Taam. The dealer, who we also have seen in Tallinn over the past few stops, quickly corrected us to 23,800 before Taam had some fun with us.
"Put down it was 13K," Taam joked with a huge smile.
Taam has had some nice results over the years and we wish him the best over the next few days with his hunt for the €555 Championship.
Player
Chips
Progress
Taago Tamm
130,000
100,000
Johannes Tobbe
0
0
18:13 (UTC+2)
Start of Level 9 Blinds: 500/1,000 Ante: 1,000
Great Decision by Leknes Posted Monday 24th July, 2023 at 17:37(UTC+2) by Jason Glatzer
Level 8: 400/800 (800) Entries: 115/185
The title of this post might seem deceiving but it really isn't. Norwegian poker baller Tobias Leknes (pictured below) is a poker beast regardless of the game and certainly can hold his own in hold'em tournaments even though he is better known as a mixed-game guru.
He busted out of the €555 Championship. Sad times, you might be thinking. While it is sad to some degree, Leknes made a great decision right after.
With Day 1d still to begin and late registration still available during the first blind level of tomorrow's Day 2, Leknes thought twice about re-entering on Day 1c and instead entered the €250 NLH Knockout which not only will have a big prize pool but also awards €50 bounties. Late registration is still open and players can buy in for 40 big blinds at the time of this post, yet somehow Leknes already accumulated five bounties worth €250. In other words, he is on a pure freeroll!
Leknes is also an amazing backgammon player and will be breaking out the set later in the week. He also is very influential in the Norwegian poker community where he acts as the President of the Norwegian Poker Federation and a true ambassador to the game we all know and love.
Best of luck to Leknes in his quest for Kings of Tallinn Summer Showdown glory.
Player
Chips
Progress
Tobias Leknes
0
0
17:11 (UTC+2)
Start of Level 8 Blinds: 400/800 Ante: 800
Norwegians Tangle Posted Monday 24th July, 2023 at 17:05(UTC+2) by Jason Glatzer
Level 7: 300/600 (600) Entries: 122/183
Ole Hov three-bet jammed the button for 12,600 and was called by Knut Trulsen from the hijack.
Ole Hov: Knut Trulsen:
Hov's king-queen was dominated by Trulsen's ace-queen and he was on the rail after getting no love on the runout.
Player
Chips
Progress
Knut Trulsen
50,000
20,000
Ole Hov
0
0
Roed Gets Value From Second Pair Posted Monday 24th July, 2023 at 16:43(UTC+2) by Jason Glatzer
Level 7: 300/600 (600) Entries: 125/178
Kent Roed is a familiar face in Tallinn and was on a starting stack before he got some value on the turn against Spain's Jordi Baixas, who has called Tallinn his home for a number of years.
Baixas check-called a bet of around half the pot of 3,300 with the on the board after the turn before both players checked the river.
Meanwhile, our friend Vytautas Kacerauskas just passed the media desk and shared he will try again on Day 1d after running his tens into an opponent's queens.
Player
Chips
Progress
Kent Roed
35,000
5,000
Jordi Baixas
25,000
5,000
Vytautas Kacerauskas
0
0
16:38 (UTC+2)
Start of Level 7 Blinds: 300/600 Ante: 600
Various Big Stacks at Break Posted Monday 24th July, 2023 at 16:26(UTC+2) by Jason Glatzer
Name
Chips
Big Blinds
Vasilij Barna
115,000
192
Raivo Pinsel
110,000
183
Saulius Tumosa
105,000
175
Tobias Napel
100,000
167
Michailas Miserkejevas
85,000
142
Mario Colavito
80,000
133
Martin Muller
75,000
125
Player
Chips
Progress
Vasilij Barna
115,000
15,000
Raivo Pinsel
110,000
80,000
Saulius Tumosa
105,000
75,000
Tobias Napel
100,000
70,000
Michailas Miserkejevas
85,000
55,000
Mario Colavita
80,000
50,000
Martin Muller
75,000
0
Second Break Posted Monday 24th July, 2023 at 16:21(UTC+2) by Jason Glatzer
Players are on their second break. We will update some of the biggest stacks from around the room during the break. Blinds will increase to 300/600 with a 600 big blind ante when the action resumes.
Frolovs Dusts It Off With Ducks Posted Monday 24th July, 2023 at 15:55(UTC+2) by Jason Glatzer
Level 6: 200/500 (500) Entries: 119/161
A player opened and two other players called including Aleksejs Frolovs from the button before Martin Muller three-bet from the big blind. Two players folded before Frolovs jammed for more than 10,000. Muller snap-called and Frolovs immediately got out of his chair.
Aleksejs Frolovs: Martin Muller:
Things went from bad to worse for Frolovs after Muller improved to the top set on the flop. Frolovs took a step back from the table after he was drawing dead on the turn and left the tournament arena at least for now after the river completed the board.
Player
Chips
Progress
Martin Muller
75,000
45,000
Aleksejs Frolovs
0
0
15:42 (UTC+2)
Start of Level 6 Blinds: 200/500 Ante: 500
Luhakooder Wins Blind vs. Blind Battle Against Borkvik Posted Monday 24th July, 2023 at 15:42(UTC+2) by Jason Glatzer
Level 5: 200/400 (400) Entries: 122/156
It was a bloated pot of 17,000 in the middle from the preflop action with both Stein Borkvik (pictured below) from the small blind and Jaagup Luhakooder big blind still in the hand to see the flop.
Borkvik fired out for 3,500. Luhakooder paused for a few moments before he raised to 8,000. Borkvik nearly folded as soon as the raise was made for Luhakooder to win the pot in a blind vs. blind battle just before the blinds increased.
Player
Chips
Progress
Jaagup Luhakooder
35,000
5,000
Stein Borkvik
25,000
5,000
Barna Snags a Big Pot Off Pihela Jr. Posted Monday 24th July, 2023 at 15:25(UTC+2) by Jason Glatzer
Level 5: 200/400 (400) Entries: 121/148
Vasilij Barna is the clear early chip leader and just won the pot against local favorite Igor Pihela Jr.
Pihela Jr. fired out for 10,000 into a pot of more than double that on the turn with the on the board. Barna snap-called before the completed the board on the river.
After a short pause, Pihela Jr. bet 5,000. Barna snap-called that as well. Pihela Jr. turned over for a bricked flush draw but a rivered second pair. Barna quickly showed his for the top pair to win the pot and add to his already healthy chip stack.
Meanwhile, Tero Kilkanen was noticed walking out of the tournament room with the dealer announcing 'seat open' and will need to re-enter for a chance to win the trophy.
Player
Chips
Progress
Vasilij Barna
130,000
55,000
Igor Pihela Jr.
18,000
12,000
Tero Kilkanen
0
0
15:02 (UTC+2)
Start of Level 5 Blinds: 200/400 Ante: 400
"Nice River" Posted Monday 24th July, 2023 at 15:00(UTC+2) by Jason Glatzer
Level 4: 100/300 (300) Entries: 123/142
Johan Ekdahl called a bet of 4,000 by Steponas Venckus into a pot of a bit more with the on the board on the river.
Venckus turned over the for Broadway and Ekdahl sighed. Ekdahl flashed the to the table showing his lower straight.
"Nice river," said Ekdahl as the next hand was being dealt.
Meanwhile, we noticed the smiles of several players including Ant Gokcek, Georgina "GJReggie" James, Jari Porkka, Tero Kilkanen, and the formidable Anthony Kauzloric.
Player
Chips
Progress
Johan Ekdahl
35,000
5,000
Steponas Venckus
35,000
5,000
Jari Porkka
30,000
0
Ant Gokcek
30,000
0
Georgina James
30,000
0
Tero Kilkanen
25,000
5,000
Lampinen Flips Well to Felt Forendal Posted Monday 24th July, 2023 at 14:44(UTC+2) by Jason Glatzer
Level 4: 100/300 (300) Entries: 117/131
We caught up to table five with Jyrki Lampinen three-betting the button and the initial raiser Simon Forendal (pictured below) four-bet jamming for 17,000 from middle position. Lampinen snapped it off and the duo were off to the races with Forendal at risk.
Simon Forendal: Jyrki Lampinen:
It was a classic coin flip but not a classic runout. Forendal took a huge lead in the hand after his king found a partner to improve to top pair on the flop. It wasn't just a two-outer that Forendal needed to fade after the backdoor flush came alive on the turn.
"Yes!" Lampinen said after the river completed his flush to win Forendal's stack.
Player
Chips
Progress
Jyrki Lampinen
50,000
20,000
Simon Forendal
0
0
Barna Honest About His Cowboys Posted Monday 24th July, 2023 at 14:32(UTC+2) by Jason Glatzer
Level 4: 100/300 (300) Entries: 117/131
There were approximately 14,000 in chips in a multiway pot on the turn with the on the board when Vasilij Barna bet 2,000. Pertti Salakari called before Aleksandr Jelpidiforov quickly raised to 10,000. Barna snap-jammed and Salakari quickly folded before Jelpidiforov went into the tank for more than a minute.
"Kings," said Barna while his opponent was deliberating before repeating himself about 20 seconds later.
Jelpidiforov folded and Barna was telling the truth by tabling the for the top set as the dealer was pushing him the pot.
Player
Chips
Progress
Vasilij Barna
75,000
45,000
Pertti Salakari
45,000
15,000
Aleksandr Jelpidiforov
12,000
18,000
14:18 (UTC+2)
Start of Level 4 Blinds: 100/300 Ante: 300
First Break Posted Monday 24th July, 2023 at 14:07(UTC+2) by Jason Glatzer
Day 1c is on its first 15-minute break. Blinds will increase to 100/300 with a big blind ante of 300 when the action resumes.
Unfortunately, Ronnie Albrigtsen will have to fire again if he wishes to advance in Day 1c after running into a massive cooler with an ace-high flush with on a flop only to run into the straight flush held by Maria Heilala with .
Player
Chips
Progress
Maria Heilala
60,000
30,000
Igor Pihela Jr.
30,000
0
Tobias Leknes
30,000
0
Ronny Albrigtsen
0
0
13:53 (UTC+2)
Start of Level 3 Blinds: 100/200 Ante: 200
Field More Than 100 Entries Posted Monday 24th July, 2023 at 13:53(UTC+2) by Jason Glatzer
While our blog will begin after the break, the Day 1c field appears on track to be the biggest opening flight of them all with already more than 100 entries.
13:50 (UTC+2)
Start of Level 2 Blinds: 100/100 Ante: 100
Day 1c Begins Posted Monday 24th July, 2023 at 12:15(UTC+2) by Jason Glatzer
Welcome to the third and final opening flight of the €555 Championship. Today's action kicked off at noon with a field of 34 entries to bring the field up to 251 entries and counting with the prize pool already at €117,970.
Unlimited re-entries are permitted throughout the day and players can late register and re-enter until the end of the first blind level of Day 2.
Players start with a stack of 30,000 in chips with blinds increasing every 40 minutes. After 11 blind levels, players will bag their stacks and battle against the Day 1a and Day 1b survivors for two more days until a winner is crowned with blinds starting at 800/1,600 with a 1,600 big blind ante to start Day 2.
Our coverage will begin shortly after the first break of Day 1c and continue until a winner is crowned.
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.
on the board.
for the second nuts on the board. Normally this would be scoop city. Instead, Pihela Jr. ran into quads with his opponent holding the 
to win the big pot in a rare case of getting paid after flopping quads.
river completing the board.
on the board after the turn when Johannes Tobbe open-jammed for 23,800. Taago Taam, who had Tobbe well-covered, called and another player folded.
river paired the board to eliminate Tobbe and grow his stack to more than four times the 30,000 starting stack.
on the board after the turn before both players checked the 
river.
flop. Frolovs took a step back from the table after he was drawing dead on the 
completed the board on the river.
for a bricked flush draw but a rivered second pair. Barna quickly showed his 
for the top pair to win the pot and add to his already healthy chip stack.
on the board on the river.
river completed his flush to win Forendal's stack.
£ GBP
$ USD
€ EUR
