0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0070 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event9'
ORDER BY `views` DESC
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 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.0002 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.0001 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.0002 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.0058 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.0109 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` = '2024_wsop_tallinn_event9'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '146'
0.0794 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0045 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '373'
AND `published` = 1
0.0001 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '373'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '146'
AND `name` = 'FINAL'
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '373'
ORDER BY `busted` ASC, `current_chips` DESC
0.0042 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` = '373'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0058 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` = '16178'
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` = '16118'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 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` = '16115'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 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` = '16112'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 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` = '16106'
ORDER BY `chip_change` DESC, `busted` ASC
0.0954 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` = '16098'
ORDER BY `chip_change` DESC, `busted` ASC
0.0641 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` = '16095'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 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` = '16093'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 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` = '16088'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 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` = '16096'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 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` = '16084'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 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` = '16082'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 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` = '16080'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 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` = '16074'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 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` = '16069'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 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` = '16059'
ORDER BY `chip_change` DESC, `busted` ASC
0.0469 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '373'
ORDER BY `busted` ASC, `current_chips` DESC
0.0048 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` = '373'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0054 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` = '16178'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 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` = '16118'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 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` = '16115'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 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` = '16112'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 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` = '16106'
ORDER BY `chip_change` DESC, `busted` ASC
0.0170 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` = '16098'
ORDER BY `chip_change` DESC, `busted` ASC
0.0524 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` = '16095'
ORDER BY `chip_change` DESC, `busted` ASC
0.0145 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` = '16093'
ORDER BY `chip_change` DESC, `busted` ASC
0.0208 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` = '16088'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 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` = '16096'
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` = '16084'
ORDER BY `chip_change` DESC, `busted` ASC
0.0489 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` = '16082'
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` = '16080'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 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` = '16074'
ORDER BY `chip_change` DESC, `busted` ASC
0.0239 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` = '16069'
ORDER BY `chip_change` DESC, `busted` ASC
0.0550 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` = '16059'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '373'
ORDER BY `busted` ASC, `current_chips` DESC
0.0026 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553
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 Crowned WSOPC €3,000 NLH 6-Max Champion Two Years In A Row Posted Sunday 28th July, 2024 at 22:29(UTC+2) by Alaxandar Georgiev
Last September Roope Tarmi Managed to win the same event and got his first ring and the prize of €78,200 - this year the Finn managed to defend his title and win it once again for €64,000. What an amazing accomplishment this is, beating the toughest field two years in a row and both golden rings.
Roope was chip-leading by a bit when it was down to 4 people and somehow knocked them out in 3 hands in a row. The action was crazy, he made a massive cooler against the other big stack and he won two flips to secure himself the victory at the end. Tarmi played brilliantly in the tournament and he was also very close to winning another ring two days ago when he came 3rd in the €555 NLH.
Place
Player
Country
Prize + Bounties
1
Roope Tarmi
Finland
€64,000
2
Erik Lindqwist
Sweden
€44,500
3
Paulius Vaitiekunas
Lithuania
€33,500
4
Ekrem Atush
Finland
€25,700
5
Luka Sorainen
Finland
€19,900
6
Janne Nevalainen
Finland
€15,400
7
Elias Suhonen
Finland
€12,400
Roope Tarmi Wins The Highroller Gold In Just Three Hands (€64,000) Posted Sunday 28th July, 2024 at 14:48(UTC+2) by Alaxandar Georgiev
Roope Tarmi is the WSOPC €3,000 NLH 6-Max Ring Event #9 Champion !!! He managed to win the Highroller in just three huge hands in a row. First, he cracked Ekrem Atush's pocket Kings with his sevens in a post-flop action. Then he won a flip with his against Paulius Vaitiekunas's pocket tens and next he won the reverse flip against Erik Lindqwist's with his pocket sevens.
This is Roope's second big finish this year in the WSOP Circuit here in Tallinn. He also finished 3rd in the 555 NLH Ring Event.
This time he wins it all, the Finn gets the big prize of €64,000 and of course the wanted-by-many Highroller WSOPC Golden Ring.
2nd Place For Erik Lindqwist (€44,500) Posted Sunday 28th July, 2024 at 14:28(UTC+2) by Alaxandar Georgiev
Level 24: 20,000/40,000 (40,000) Entries 2/100
Roope Tarmi limped from the small blind and got raised to 125,000 from Erik Lindqwist, Tarmi then put him all-in and Lindqwist quickly called. Roope had just busted two players in the last two hands and the third hand was already an all-in. Lindqwist had roughly 700,000 while his Finnish opponent had slightly more than four million chips.
Erik Lindqwist: Roope Tarmi:
Once again Tarmi had his lucky sevens and he got a pretty good flop. Lindqwist's hopes of winning the WSOPC Highroller Golden Ring shrank a little further on the turn.
Lindqwist needed only an Ace or a King to stay in the heads-up and the river came brick.
The Swede started the day as the big chip leader but finished just short of the golden prize. Erik Lindqwist will take €44,500 for his 2nd place.
Player
Chips
Progress
Roope Tarmi
5,000,000
600,000
Erik Lindqwist
0
0
3rd Place Finish For Paulius Vaitiekunas (€33,500) Posted Sunday 28th July, 2024 at 14:13(UTC+2) by Alaxandar Georgiev
Level 24: 20,000/40,000 (40,000) Entries 3/100
The action started with an 80,000 raise from Erik Lindqwist and a three-bet by Paulius Vaitiekunas to 375,000 from the small blind. Roope Tarmi then put them both all in to call with his massive stack. Lindqwist folded and the Lithuanian called off for his remaining 350,000.
Paulius Vaitiekunas: Roope Tarmi:
There we go another flip on the final table, very important for both players. The flop came in Tarmi's way as he hit a pair of Kings. Nobody had a flush draw and the popped on the turn.
The river was the and it was over for the Lithuanian, he busts too close to the golden ring and will take a payout of €33,500 for his 3rd place finish.
Player
Chips
Progress
Roope Tarmi
4,400,000
900,000
Paulius Vaitiekunas
0
0
Ekrem Atush Goes Out In 4th place (€25,700) After Losing A Massive Pot Posted Sunday 28th July, 2024 at 13:59(UTC+2) by Alaxandar Georgiev
Level 24: 20,000/40,000 (40,000) Entries 4/100
Roope Tarmi opened the action and Ekrem Atush three-bet him to 200,000 - the shorter stacks on the blinds folded and the two chip leaders went to the flop.
Tarmi checked first and his opponent bet another 200,000 which he called. The turn was the and this is where things got heated. Another check from Tarmi and a huge 550,000 bet from Atush, followed by an all-in and a call for about a million chips on the turn.
This was a massive pot worth over 3,000,000 chips.
Ekrem Atush: Roope Tarmi:
Tarmi had it almost locked in with his flopped full-house, he had hit one of the other two sevens in the deck and had Atush's Kings cracked. The river was and Roope Tarmi Scoops the massive pot. He now has almost 80% of the chips in play.
Ekrem Atush left the table seemingly disappointed after the bad beat and collected €25,700. fo
Player
Chips
Progress
Roope Tarmi
3,500,000
2,100,000
Ekrem Atush
0
0
13:33 (UTC+2)
Start of Level 24 Blinds: 20,000/40,000 Ante: 40,000
Sorainen Is Eliminated in 5th place (€19,900) Posted Sunday 28th July, 2024 at 13:28(UTC+2) by Alaxandar Georgiev
Level 23: 15,000/30,000 (30,000) Entries 5/100
Luka Sorainen opened the pot to 60,000 and Roope Tarmi defended his big blind. The flop came ace high and Sorainen continued for another 60,000 after a check from his opponent.
The turn was the on which both players checked. And the river was another small card - Roope Tarmi tanked for a while before announcing that he was all-in, a few moments later Sorainen flicked in the call.
Luka Sorainen: Roope Tarmi:
Sorainen had a pretty good hand, but his top pair was no bueno against Tarmi's two pair. He is eliminated in 5th place with a payout of €19,900.
Player
Chips
Progress
Roope Tarmi
1,400,000
500,000
Luka Soralnen
0
0
Chip Count Update In Top 5 Posted Sunday 28th July, 2024 at 13:21(UTC+2) by Alaxandar Georgiev
Level 23: 15,000/30,000 (30,000) Entries 5/100
Only five are left to play for the big money up top and the WSOPC Golden Ring. Check out their respective stacks down below.
Name
Country
Stack
Erik Lindqwist
Sweden
1,600,000
Ekrem Atush
Finland
1,400,000
Roope Tarmi
Finland
775,000
Paulius Vaitiekunas
Lithuania
680,000
Luka Sorainen
Finland
670,000
Nevalainen Finishes In 6th Place (€15,400) Posted Sunday 28th July, 2024 at 13:12(UTC+2) by Alaxandar Georgiev
Level 22: 10,000/25,000 (25,000) Entries 6/100
Janne Nevalainen jammed for about 450,000 and Roope Tarmi Isolated. It was a big pot for both and the winner would be amongst the chip leaders.
Janne Nevalainen: Roope Tarmi:
The flop created some tension as Nevalainen was now drawing to a flush as well. The turn was revealed shortly and didn't change much.
No luck on the fifth card for Nevalainen and he busts in 6th place.
A good run in the Highroller for Janne Nevalainen, he will be taking home a €15,400 payout.
Player
Chips
Progress
Roope Tarmi
900,000
380,000
Janne Nevalainen
0
0
13:05 (UTC+2)
Start of Level 23 Blinds: 15,000/30,000 Ante: 30,000
Elias Suhonen is Eliminated in 7th place (€12,400) Posted Sunday 28th July, 2024 at 12:57(UTC+2) by Alaxandar Georgiev
Level 22: 10,000/25,000 (25,000) Entries 7/100
Elias Suhonen was down to his last five blind and put three of them as a raise, he got caled by Ekrem Atush on the button and the other players folded.
The flop came - Suhonen checked and called off his last 2 blinds and they went to showdown.
Elias Suhonen: Ekrem Atush:
Suhonen was dominated and needed to hit one of his queens to stay in the tournament. The turn and river both bricked for him and his hopes of wining the Highroller ring were finished.
Elias Suhonen finishes in 7th place and will take home a payout of €12,400.
Player
Chips
Progress
Ekrem Atush
1,200,000
640,000
Elias Suhonen
0
0
Big Double Up For Sorainen Posted Sunday 28th July, 2024 at 12:50(UTC+2) by Alaxandar Georgiev
Level 22: 10,000/25,000 (25,000) Entries 7/100
Luka Sorainen raised first to 50,000 off from a short stack and got called by Roope Tarmi on the big blind, flop came and Sorainen continued for 40,000 after a check. Tarmi put a big pile of chips in the middle and put him all in - snap call and we went to showdown:
Luka Sorainen: Roope Tarmi:
Sorainen hit his set on the turn and his opponent started counting chips for the payout. Sorainen had 230,000 behind and is now up to 595,000 chips.
Player
Chips
Progress
Luka Soralnen
595,000
329,000
Roope Tarmi
520,000
235,000
Shuffle Up And Deal Posted Sunday 28th July, 2024 at 12:29(UTC+2) by Alaxandar Georgiev
Level 21: 10,000/20,000 (20,000) Entries 7/100
The last seven players took their seats and their names and chip counts were announced by our tournament director. It is time to start the battle for the Highroller golden ring. The average stack on the final table is 714,000 and the next pay jump is a nice sum of €3,000.
Erik Lindqwist from Sweden leads the way with over two million chips, let's see if he can use this to his advantage and take the jewelry.
12:13 (UTC+2)
Day FINAL of Olympic Park Casino Started Level: 21 Blinds: 10,000/20,000 Ante: 20,000
Welcome to Day 2 Of The #9 WSOPC €3,000 NLH Ring Event Posted Sunday 28th July, 2024 at 11:20(UTC+2) by Alaxandar Georgiev
The WSOPC €3,000 NLH Ring Event #9 got a total of 100 entries yesterday and it played down to the final table. The 6-max event has only 7 players left and they will battle it out for the glory, the money and of course the golden ring that comes with taking the first place.
Here is the final table seat draw and chip counts.
Seat
Name
Country
Chips
Big Blinds
1
Roberto Olsen
Finland
560,000
46
2
Luka Sorainen
Finland
266,000
23
3
Erik Lindqwist
Sweden
2,134,000
22
4
Paulius Vaitiekunas
Lithuania
714,000
13
5
Janne Nevalainen
Finland
380,000
13
6
Roope Tarmi
Finland
755,000
79
7
Elias Suhonen
Finland
192,000
47
Sweden's Erik Lindqwist is leading the way with a massive stack of over two million. He has to fight for the ring with not one, but five Finns and Lithuania's Paulius Vaitiekunas who already has three rings and he just won a tournament in the Triton series this year.
Roope Tarmi is also in the house, he finished 3rd in Ring Event #3: €555 NLH and took down a score of €25,100. He is now on his second final table for the series and hunting another ring.
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.