0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0070 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event10/2/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.0003 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.0004 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.0003 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0005 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0004 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.0003 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0005 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.0006 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.0004 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.0066 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.0008 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` = 'wsopctallinn_2023_event10'
0.0005 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '38'
0.0325 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` = '136'
AND `published` = 1
0.0277 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '139'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '38'
AND `name` = '2'
0.0063 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '139'
ORDER BY `busted` ASC, `current_chips` DESC
0.0063 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` = '139'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0078 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` = '6175'
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` = '6143'
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` = '6137'
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` = '6127'
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` = '6140'
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` = '6122'
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` = '6113'
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` = '6119'
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` = '6104'
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` = '6100'
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` = '6095'
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` = '6102'
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` = '6091'
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` = '6084'
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` = '6082'
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` = '6087'
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` = '6063'
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` = '6077'
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` = '6072'
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` = '6064'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 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` = '6060'
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` = '6058'
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` = '6070'
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` = '6050'
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` = '6044'
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` = '6053'
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` = '6040'
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` = '6032'
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` = '6041'
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` = '6024'
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` = '6023'
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` = '6017'
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` = '6016'
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` = '6013'
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` = '6012'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '139'
ORDER BY `busted` ASC, `current_chips` DESC
0.0061 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` = '139'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0070 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` = '6175'
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` = '6143'
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` = '6137'
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` = '6127'
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` = '6140'
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` = '6122'
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` = '6113'
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` = '6119'
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` = '6104'
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` = '6100'
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` = '6095'
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` = '6102'
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` = '6091'
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` = '6084'
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` = '6082'
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` = '6087'
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` = '6063'
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` = '6077'
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` = '6072'
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` = '6064'
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` = '6060'
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` = '6058'
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` = '6070'
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` = '6050'
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` = '6044'
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` = '6053'
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` = '6040'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 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` = '6032'
ORDER BY `chip_change` DESC, `busted` ASC
0.0096 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` = '6041'
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` = '6024'
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` = '6023'
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` = '6017'
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` = '6016'
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` = '6013'
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` = '6012'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '139'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
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.
Roope Tarmi Finally Takes a Ring for Finland as Taking Down the €3,000 Event #11 Posted Sunday 24th September, 2023 at 17:00(UTC+0) by Lina Olofsson
We are on the finishing line of the WSOP Circuit here in the Estonian Capital and on the last and final day, there was not only the €1,500 €1 Million Guaranteed Main Event up on the feature stage. Right next to it, we had the final table of Event #11 - the €3,000 NLHE - that started yesterday with a huge field of 97 entries creating a prize pool of an impressive €260,736. The winner in the event would walk away with almost a third of that with €78,280 alongside the golden WSOP Circuit ring.
As the game started yesterday we had so many notable players in the field and a ton of action which you can catch up on from our live coverage from day 1. Just before midnight last night the bubble burst in this event leaving the remaining 11 players cashing in at least €6,400. An hour later we were playing for the final table bubble with eight players remaining but after Yi-Zhan Peng was eliminated from the outer table we had the final seven players who could bag their chips before the final starting today right after noon and the announcements of both the Main Event finalists and the lucky number seven players who were in it to win that 10th ring out of the 12 up for grabs.
As the final table kicked off we had Elias Suhonen at the top of the leaderboard but for the first time it was actually very close between the players at the top and we all know that everything can happen in poker so it was still anyone's game as the tournament director Teresa Nousiainen announced the final table and said the well-known words: "Shuffle up and Deal".
Nikiforov Won't Work 9 to 5
Ilya Nikiforov came into today's final as the short stack and needed a double up or two to be in the hunt for the win as the blinds would eat his stack pretty quickly in this shorthanded tournament. But sadly for the Estonian player, his ace-king didn't hold up against the chip-leading Suhonen with nine-five as Suhonen caught a five on the flop sending Nikiforov to the cashier desk in seventh place for €10,750.
Another player who needed to work a bit on his stack was Lithuanian Deividas Butnoras coming into the final as second last in chips. After losing a bit of it he found a neat double up but even so, with several aggressors at the table he would get a lot of pressure on him and when looking down on ace-nine he decided it was good to go. Sadly he ran into Markku Koplimaa with the dominating ace-queen. However, on the way to the final card, it looked like it would be a chopped pot with two aces and two nines on the board but a queen on the river wasn't good for the Lithuanian Deividas Butnoras who was off to the rail for a €14,000 as consolation.
Going to the first break of the day the dynamic had changed drastically on the table and we had a new chief of command as Markku Koplimaa had put a lot of pressure on his opponents from the start and built his stack well. As soon as they were back in action he would take on another big pot as he eliminated Tommi Lankinen after they got all the chips in with a top pair for Koplimaa and a flush draw for Lankinen. No flush for Finlands Tommi Lankinen and he was eliminated in fifth (€18,450).
15 minutes later it was time again for Markku Koplimaa to put a player at risk as he got his fellow countrymen Mauri Dorbek all-in before the flop in a classic coin flip situation with jacks versus ace-queen which couldn't pair on the board sending Dorbek out for €25,050 as the fourth place finished.
The Three Final Musketeers
Down to the final three players, Koplimaa had a nice lead with 2,6 million in his stack, Roope Tarmi from Finland had 1,6 and our former chip leader going into today's action Elias Suhonen was the shortest one of the three with 800K. And after losing almost half of that to Tarmi he was down to only five big blinds which went in the hand after. For his tournament life, Suhonen was in good shape for a double-up with ace-king versus ace-four against Koplimaa. It all looked good until a four on the river hit and Elias Suhonen was out as our third-place finisher for €34,550.
Two-to-one Advantage Heads-Up
As the heads-up began not much had gone wrong for the Estonian Markku Koplimaa who now had a two-to-one chip lead against his opponent Roope Tarmi from Finland but it was going to be a tense match between the two last-standing players where they'd soon be even in stacks. After a hand where both players flopped a flush draw and Roope Tarmi also flopped a pair to his he took over the lead from Koplimaa.
In the final hand of the tournament Markko Koplimaa pushed his chips in from small blind with king-queen getting called by Roope Tarmi with ace-six and after another ace on the flop and no other help to our player at risk it was all over and Markko Koplimaa had to settle for a second-place finish worth €50,450.
Finally A Golden Ring for Finland
Over the past nine final tables in these circuit events, we've had a majority of Finns on there but they still haven't been able to take that golden ring back to The Land of the Mumin Trolls today, on the final day, they finally had a Finnish flag at the top of the result thanks to Roope Tarmi for his amazing performance at this final table. Alongside the €78,280 he could also try out the ring size for that stunning golden WSOPC ring which will have his name on hit.
Event #11: €3,000 NLHE Final Table Results
Place
Name
Country
Prize
1
Roope Tarmi
Finland
€78,280
2
Markku Koplimaa
Estonia
€50,450
3
Elias Suhonen
Finland
€34,550
4
Mauri Dorbek
Estonia
€25,050
5
Tommi Lankinen
Finland
€18,450
6
Deividas Butnoras
Lithuania
€14,000
7
Ilya Nikiforov
Estonia
€10,750
Author: Lina Olofsson Photos: Elena & Tambert Kask
Roope Tarmi Wins Event #11 €3,000 No-Limit Hold'em 6 Handed (€78,280) Posted Sunday 24th September, 2023 at 15:15(UTC+0) by Frank Visser
Finland's Roope Tarmi (pictured) has won a coveted WSOPC Ring by defeating Estonian Markku Koplimaa heads-up in Event #11 €3,000 No-Limit Hold'em 6 Handed at WSOPC Tallinn.
He took home the first prize of €78,280, while Koplimaa had to take comfort in his second prize worth €50,450.
Markko Koplimaa Eliminated in 2nd Place (€50,450) Posted Sunday 24th September, 2023 at 15:09(UTC+0) by Frank Visser
Level 28: 50,000/125,000 (125,000) Entries: 1/97
Markko Koplimaa jammed his button for his final million chips and Roope Tarmi made the call from the big blind.
Markko Koplimaa: Roope Tarmi:
Tarmi paired his ace on and Koplimaa was drawing dead on the turn. The river was the last card of the tournament as Tarmi was announced the victor.
Koplimaa joined his friends on the rail, taking solace in the more than €50,000 he received for taking second.
Player
Chips
Progress
Roope Tarmi
4,850,000
1,360,000
Markku Koplimaa
0
0
Tarmi Takes Over Chip Lead Posted Sunday 24th September, 2023 at 14:50(UTC+0) by Frank Visser
Level 28: 50,000/125,000 (125,000) Entries: 2/97
Roope Tarmi limped his button before Markku Koplimaa raised to 375,000 from the big blind. Tarmi made the call and the pair saw a flop of .
Koplimaa continuation-bet for 375,000 and Tarmi called once more. Both the turn and river then checked through. Koplimaa tabled for a missed flush draw while Tarmi showed for the flush draw to the same suit, but with a pair to go with it.
He raked in the pot and took over the chip lead for the first time since the heads-up began.
Player
Chips
Progress
Roope Tarmi
3,250,000
2,405,000
Markku Koplimaa
1,600,000
850,000
14:48 (UTC+0)
Start of Level 28 Blinds: 60,000/120,000 Ante: 120,000
Tarmi Back Over Two Million Posted Sunday 24th September, 2023 at 14:40(UTC+0) by Frank Visser
Level 26: 50,000/100,000 (100,000) Entries: 2/97
Roopte Tarmi limped his button and Markku Koplimaa decided to check back from the big blind. Koplimaa then check-called a 150,000 bet from Koplimaa on the flop before check-folding to a 450,000 bet on the turn.
Player
Chips
Progress
Markku Koplimaa
2,550,000
1,570,000
Roope Tarmi
2,300,000
2,645,000
Tarmi Claws Back Posted Sunday 24th September, 2023 at 14:19(UTC+0) by Frank Visser
Level 27: 50,000/100,000 (100,000) Entries: 2/97
Markku Koplimaa raised to 200,000 from the button and Roope Tarmi called from the big blind. The flop was dealt and Tarmi check-called a 130,000 bet from Koplimaa.
The turn then was checked through before Tarmi promptly shoved all in on the river for a huge overbet. Koplimaa quickly folded, granting the pot to his opponent.
Player
Chips
Progress
Markku Koplimaa
2,900,000
3,370,000
Roope Tarmi
1,950,000
1,190,000
14:11 (UTC+0)
Start of Level 27 Blinds: 50,000/100,000 Ante: 100,000
Elias Suhonen Eliminated in 3rd Place (€34,550) Posted Sunday 24th September, 2023 at 14:03(UTC+0) by Frank Visser
Level 26: 40,000/80,000 (80,000) Entries: 2/97
Elias Suhonen jammed from the small blind for 640,000 and Markku Koplimaa made the call from the big blind.
Elias Suhonen: Markku Koplimaa:
Suhonen stayed in the lead on the board, but the river gave Koplimaa the only pair, resulting in the elimination of Suhonen in third place.
Player
Chips
Progress
Markku Koplimaa
3,170,000
2,150,000
Roope Tarmi
1,680,000
230,000
Elias Suhonen
0
0
Tarmi Leaves Suhonen Short Posted Sunday 24th September, 2023 at 13:58(UTC+0) by Frank Visser
Level 26: 40,000/80,000 (80,000) Entries: 3/97
Roope Tarmi limped his small blind and Elias Suhonen checked the big blind. The flop of saw Tarmi bet the minimum of 80,000 and Suhonen made the call.
The turn then was checked by Tarmi, which made Suhonen put out a bet of 130,000. Tarmi called before both players checked the river.
Tarmi showed his and his rivered top pair won him the pot, leaving Suhonen with five big blinds.
Player
Chips
Progress
Roope Tarmi
1,875,000
875,000
Elias Suhonen
440,000
80,000
Koplimaa Solidifying the Lead Posted Sunday 24th September, 2023 at 13:52(UTC+0) by Frank Visser
Player
Chips
Progress
Markku Koplimaa
2,400,000
950,000
Roope Tarmi
1,600,000
1,150,000
Elias Suhonen
835,000
315,000
13:36 (UTC+0)
Start of Level 26 Blinds: 40,000/80,000 Ante: 80,000
Koplimaa Takes From Tarmi Posted Sunday 24th September, 2023 at 13:32(UTC+0) by Frank Visser
Level 24: 30,000/60,000 (60,000) Entries: 3/97
Markku Koplimaa limped his small blind and Roope Tarmi checked the big blind. The flop of then checked through before Koplimaa bet out 60,000 on the turn.
Tarmi responded with a raise to 210,000 and Koplimaa made the call. The river then was checked again by both players and Koplimaa tabled for the winner.
Player
Chips
Progress
Markku Koplimaa
2,100,000
2,010,000
Roope Tarmi
1,910,000
840,000
Mauri Dorbek Eliminated in 4th Place (€25,050) Posted Sunday 24th September, 2023 at 13:28(UTC+0) by Frank Visser
Level 25: 30,000/60,000 (60,000) Entries: 3/97
Mauri Dorbek raised to 300,000 from under the gun, leaving himself only 250,000 chips behind. The action then folded to Markku Koplimaa in the small blind, who went all-in with the covering stack. The big blind was folded before Dorbek made the call.
Mauri Dorbek: Markku Koplimaa:
The board ran out low with , and Koplimaa scored a second elimination in quick succession, sending Dorbek to the rail in fourth place.
Player
Chips
Progress
Markku Koplimaa
1,950,000
1,860,000
Mauri Dorbek
0
0
Tommi Lankinen Eliminated in 5th Place (€18,450) Posted Sunday 24th September, 2023 at 13:15(UTC+0) by Frank Visser
Level 25: 30,000/60,000 (60,000) Entries: 4/97
Markku Koplimaa raised to 120,000 from the cutoff and Tommi Lankinen took a while before eventually putting in the extra chips from the big blind.
The flop was dealt and Koplimaa put in a bet of 60,000 after a check from Lankinen. Lankinen then responded by shoving all in for 340,000, receiving an instant call from his opponent.
Tommi Lankinen: Markku Koplimaa:
Koplimaa had to fade spades to secure the knock-out, and he did so when the board ran out . Lankinen was eliminated in fifth place and the other four players battle on.
Player
Chips
Progress
Markku Koplimaa
1,450,000
1,360,000
Tommi Lankinen
0
0
13:05 (UTC+0)
Start of Level 25 Blinds: 30,000/60,000 Ante: 60,000
Toomas "Stablecoinflip" Orm Wins OnlyBet Online Event #10 (€9,087) Posted Sunday 24th September, 2023 at 13:02(UTC+0) by Lina Olofsson
On Friday, Event #10: €350 NLH OlyBet Online Event was held here in WSOPC Tallinn but this time it wasn't at the Olympic Casino. It was actually online at OlyBet making it possible for players not to be able to attend this fantastic festival to compete and lay their hand on one of these beauties.
The €50,000 Guaranteed Online Event kicked off at 8 p.m. Friday night and attracted 124 entrants with 20 players cashing in this event. Up to this date, this is the single biggest prize in the OlyBet-exclusive tournament.
One hour into the tournament Toomas "Stablecoinflip" Orm decided to join the action and registered and this would turn out to be a very good decision as he ended up winning the whole thing. We got a chance to sit down and have a little chat with our latest Ring Event winner as he came into the Hilton Park and Olympic Casino to take his winning shot.
Great Start of Turning Pro - Again
Toomas Orm used to play professionally up until ten years ago but after a few hard years, he decided to stop and took a job as a salesman. It wasn't until the end of last year as he had a good run he decided it was time to give it another shot going pro again.
"I have two daughters and that makes you think differently at these things but as this year started I had built my bankroll up and felt comfortable to do this as a profession again," Orm explained.
This was the second €350 buy-in ring event he played during the WSOPC Tallinn as he also entered another event live here at the Olympic Casino. Even though Orm mostly plays no-limit hold'em tournaments online, he has $12,745 in live tournament winnings according to The Hendon Mob and one of his biggest tournament cash wasn't in a hold'em but instead in a pot-limit Omaha event in Malta earlier this year.
"I never play PLO but it was the very last day and I was bored so I took a shot in the very last tournament they had," Orm shared. "That was a Pot Limit Omaha and that was the first time I ever played it. When we were at the final table I started to feel a bit stressed though since it was really late and I had a flight to catch at seven in the morning."
Orm thought he'd have to book another flight back home to Estonian but eventually, they decided to make an ICM chop of the remaining prize money with five players left giving him the most money for €1,800, and as soon as he cashed out he ran off to the hotel, picked up his bag and took a cab to the airport where he came to the gate three minutes before the boarding closed.
But it's safe to say that playing on home soil is where he has his best track record with two big live cashes here from February earlier this year in the Main Event of the Estonian Championship finishing fifth for €3,600 and being runner up in the same championship in a Shootout tournament for another €2,278.
Five Bet Jam on Kosk Took Orm to the Lead
Back to the Online Ring Event the other night he started rocky and thought his days were counted but after first a double up and then a triple up he described the rest of the tournament as very smooth sailing. As he ended up at the table with his fellow Estonian countryman Ermo Kosk the latter tried to push him around but after a hand where Orm five-bet jammed against Kosk with only queen-jack suited and got away with it, he knew this was his tournament.
"I had some really nice rivers," shared Orm. "I was such an underdog and didn't even look at the screen as the board ran out several times but each time I looked up and magically survived. I screamed so many times so I was really happy my family wasn't home."
Loves to play Small Ball Poker
When half the field remained in the tournament Orm amassed a massive lead and as they entered the final table he still had a huge advantage. When the action whittled down to the last five players he had half the chips in play and then he was certain he would take it down as the others only had around ten big blinds each.
But when they started playing heads-up he was actually for the first time giving up his lead a few times but managed to get back up on the horse and when they were even in chips the two players decided to make a deal where they secured €9K each, left the ring and the WSOP Freeroll in Vegas up for grabs.
Even though the deal was made the Heads-up would last for an hour.
"I love playing small ball poker and that's exactly what we did," Orm shared.
At three o'clock in the morning his experience and his strategy with the small balling paid off as he was crowned as the winner.
It's safe to say that Orm has had a very nice return to the poker scene since he decided to take it up and make it a living again and now he has a trip to Vegas to look forward to next summer.
€350 WSOP Circuit Tallinn Online Ring Event top four:
Place
Name
Country
Prize
1
Toomas Orm
Estonia
€9,087 + WSOPC Ring
2
Stanislav S.
Estonia
€9,176
3
Kaspars Butans
Latvia
€6,020
4
Giedre Valgemae
Lithuania
€4,588
The First Break Posted Sunday 24th September, 2023 at 12:46(UTC+0) by Frank Visser
The 5 remaining players are now on a 20-minute break.
Deividas Butnoras Eliminated in 6th Place (€14,000) Posted Sunday 24th September, 2023 at 12:44(UTC+0) by Frank Visser
Level 24: 20,000/50,000 (50,000) Entries: 5/97
Deividas Butnoras open-jammed for 340,000 from under the gun. Markku Koplimaa sat in the cutoff and asked for a count once the action was on him. Once the correct number was said, he made the call and the rest of the table got out of the way.
Deividas Butnoras: Markku Koplimaa:
Butnoras was behind, but he flopped a full house on to jump in the lead. "Nice flop," Koplimaa sarcastically remarked.
The turn then fell the and Koplimaa complimented the card in a noticeably less sarcastic tone as he was now chopping with his opponent.
"And now a queen!" Koplimaa requested. His wish was granted when the river completed the board, giving him the higher full house and sending Butnoras to the rail in sixth place.
Player
Chips
Progress
Markku Koplimaa
1,125,000
705,000
Deividas Butnoras
0
0
Suhonen Suddenly Doubles Posted Sunday 24th September, 2023 at 12:35(UTC+0) by Frank Visser
Level 24: 20,000/50,000 (50,000) Entries: 6/97
After a period with little action, Elias Suhonen got all of his 425,000 chips in the middle from the hijack against Tommi Lankinen in the big blind.
Elias Suhonen: Tommi Lankinen:
Only numbers appeared on the board, and Suhonen's eights remained best to rake in the double, leaving his opponent with a mere ten big blinds.
Player
Chips
Progress
Elias Suhonen
920,000
20,000
Tommi Lankinen
510,000
295,000
Koplimaa Gets One Through Posted Sunday 24th September, 2023 at 12:30(UTC+0) by Frank Visser
Level 24: 20,000/50,000 (50,000) Entries: 6/97
Roope Tarmi raised to 100,000 from under the gun and the action folded to Markku Koplimaa in the big blind. He went all-in for 400,000 and received a fold from the initial raiser, chipping up nicely in the process.
Player
Chips
Progress
Roope Tarmi
1,900,000
200,000
Markku Koplimaa
570,000
395,000
The Current Chip Distribution Posted Sunday 24th September, 2023 at 12:26(UTC+0) by Frank Visser
Player
Chips
Progress
Roope Tarmi
1,900,000
200,000
Tommi Lankinen
1,050,000
245,000
Mauri Dorbek
580,000
110,000
Deividas Butnoras
550,000
230,000
Elias Suhonen
500,000
400,000
Markku Koplimaa
325,000
640,000
12:18 (UTC+0)
Start of Level 24 Blinds: 20,000/50,000 Ante: 50,000
The Rare Sight of a Flop Posted Sunday 24th September, 2023 at 12:05(UTC+0) by Frank Visser
Level 23: 20,000/40,000 (40,000) Entries: 6/97
Roope Tarmi raised to 80,000 from under the gun and Markku Koplimaa called from the big blind. The flop fell and saw Tarmi continue for 40,000 after a check from Koplimaa.
A quick fold followed and Tarmi scooped the only flop the table has seen in quite a while, with almost all of the pots being concluded preflop at this stage and Tarmi being the victor in the majority of them
Player
Chips
Progress
Roope Tarmi
2,000,000
650,000
Markku Koplimaa
420,000
545,000
Butnoras Binks a Double-Up Posted Sunday 24th September, 2023 at 11:52(UTC+0) by Frank Visser
Level 23: 20,000/40,000 (40,000) Entries: 6/97
Mauri Dorbek opened his button and Deividas Butnoras went all-in from the big blind for only 130,000, receiving an immediate call from Dorbek.
Deividas Butnoras: Mauri Dorbek:
Butnoras paired his king on , but Dorbek now had a gutshot straight draw. However, it did not come in on the turn and river, securing the double-up for Butnoras, who nevertheless remains the short stack on the table.
Player
Chips
Progress
Mauri Dorbek
525,000
195,000
Deividas Butnoras
320,000
120,000
11:46 (UTC+0)
Start of Level 23 Blinds: 20,000/40,000 Ante: 40,000
Tarmi Keeps Up the Pressure Posted Sunday 24th September, 2023 at 11:42(UTC+0) by Frank Visser
Level 22: 15,000/30,000 (30,000) Entries: 6/97
Elais Suhonen raised to 60,000 from under the gun and Markku Koplimaa called in the next seat over.
Roope Tarmi then three-bet to 210,000 from the cutoff, getting folds from the rest of the table. He has been winning the majority of pots so far at the final table, and just added some more uncontested chips to his double-average stack.
Player
Chips
Progress
Roope Tarmi
1,700,000
350,000
Tarmi Comes Out Firing Posted Sunday 24th September, 2023 at 11:27(UTC+0) by Frank Visser
Level 22: 15,000/30,000 (30,000) Entries: 6/97
Roope Tarmi opened to 60,000 from under the gun and Mauri Dorbek flatted from the hijack. Tarmi then slowed down and check-called Dorbek's 40,000 bet on the flop.
Tarmi checked again on the turn, but this time he raised Dorbek's 65,000 bet to 250,000, eventually garnering a fold from his opponent.
Player
Chips
Progress
Roope Tarmi
1,350,000
310,000
Mauri Dorbek
665,000
55,000
11:16 (UTC+0)
Start of Level 22 Blinds: 15,000/30,000 Ante: 30,000
Ilya Nikiforov Eliminated in 7th Place (€10,750) Posted Sunday 24th September, 2023 at 11:05(UTC+0) by Frank Visser
Level 21: 10,000/25,000 (25,000) Entries: 6/97
Ilya Nikiforov was down to his last 70,000 chips, and he put them in from the small blind once the action folded to him. Elias Suhonen sat in the big blind and reluctantly made the call after getting confirmation of the amount.
Ilya Nikiforov: Elias Suhonen:
Suhonen's outs were live, and he hit one on the flop. Nikiforov could not hit an ace, king, or ten on the subsequent runout and he was the first player to leave the final table.
Player
Chips
Progress
Elias Suhonen
900,000
90,000
Ilya Nikiforov
0
0
Tarmi Puts Butnoras to the Test Posted Sunday 24th September, 2023 at 11:01(UTC+0) by Frank Visser
Level 21: 10,000/25,000 (25,000) Entries: 7/97
Roope Tarmi opened for 50,000 from the cutoff and big blind Deividas Butnoras defended.
The flop fell a triplet of threes: graced the felt. Butnoras checked and subsequently called a 25,000 bet from Tarmi. Tarmi then upped his sizing on the turn to 65,000 chips, and again Butnoras check-called.
On the river, Butnoras checked for the third time and was met with a bet that would put him all-in for 200,000 chips this time. After some thinking time, Butnoras elected to let his hand go and save himself those few big blinds behind.
Player
Chips
Progress
Roope Tarmi
1,040,000
165,000
Markku Koplimaa
965,000
0
Deividas Butnoras
200,000
175,000
Final Table Underway , Reporting on Delay Posted Sunday 24th September, 2023 at 10:21(UTC+0) by Frank Visser
Level 21: 10,000/25,000 (25,000) Entries: 7/97
With a bit of a delay due to final table pictures for both the Main Event and this event, the seven remaining players have taken their seats and the clock is running with 24 minutes left in Level 21. The final table of Event #11: €3,000 No Limit Hold'em 6 Handed has officially begun.
In order to not spoil the live stream on OlyBet.tv, live reporting will take place on a 30-minute delay.
30 Minute Delay Posted Sunday 24th September, 2023 at 10:10(UTC+0) by Lina Olofsson
To not give away any spoilers as this final table is on the secondary feature table the updates will be with a 30-minute delay.
Welcome to the Final Table Action! Posted Sunday 24th September, 2023 at 09:35(UTC+0) by Lina Olofsson
Welcome to the final table coverage from the €3,300 NLHE Event #11. The game resumes at noon local time as the last seven players in the tournament is playing until a new winner is crowned in this event and yet another golden ring has it's owner.
The play continues where they quit last night on level 21 with the blinds of 10,000/25,000 and a BBA of 25,000.
Seatdraw:
Seat
Name
Country
Chips
1
Elias Suhonen
Finland
990,000
2
Markku Koplimaa
Estonia
965,000
4
Tommi Lankinen
Finland
805,000
5
Roope Tarmi
Finland
875,000
6
Deividas Butnoras
Lithuania
375,000
7
Ilya Nikiforov
Estonia
120,000
As you can follow the Main Event Final Table on the Main Feature Table this one will be streamed on the secondary Feature Table. Watch them both on OlyBet.tv and read all the big hands in our live coverage here from Tallinn.
09:32 (UTC+0)
Day 2 of WSOPC Tallinn Started Level: 21 Blinds: 10,000/25,000 Ante: 25,000
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.