0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-05-19'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/38'
ORDER BY `views` DESC

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/38', 1, '2024-05-19')

0.0003 SECONDS: 
SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, 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.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 `tour_stop_blogs`.`id` = '38'

0.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '38'

0.0208 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0041 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '136'
AND `published` = 1

0.0206 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` = '139'
AND `published` = 1

0.0052 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.0050 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.0049 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.0085 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.0044 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.0042 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.0048 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.0049 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.0043 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.0043 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.0042 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.0043 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.0042 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.0191 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.0087 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.0086 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.0084 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.0080 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.0084 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.0076 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.0044 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.0041 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.0043 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.0043 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.0043 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.0041 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.0041 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.0043 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.0041 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.0164 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.0084 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.0085 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.0084 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.0086 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.0081 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.0048 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.0042 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.0047 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.0039 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.0044 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.0042 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.0041 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.0041 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.0042 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.0166 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.0081 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.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` = '6119'
ORDER BY `chip_change` DESC, `busted` ASC

0.0076 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.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` = '6100'
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` = '6095'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 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.0042 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.0041 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.0042 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.0044 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.0041 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.0042 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.0043 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.0041 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.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` = '6060'
ORDER BY `chip_change` DESC, `busted` ASC

0.0173 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.0079 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.0075 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.0079 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.0077 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.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` = '6040'
ORDER BY `chip_change` DESC, `busted` ASC

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` = '6032'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 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.0042 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.0043 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.0041 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.0043 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.0042 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.0043 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.0048 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.0003 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143

    

Open Modal

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.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

Translate

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Eesti
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Nederlands
• Ελληνικά
• Русский

WSOPC Tallinn Event #11: €3,000 No-Limit Hold'em 6 Handed Live Reporting - Day 2

WSOPC Tallinn - Live Reporting Event #1: €555 No-Limit Hold'em (Estonian) Event #3: €350 WSOPC Tallinn Ring Event (Estonian) Event #1: €555 No-Limit Hold'em Event #2: €1,100 No-Limit Hold'em Event #3: €350 No-Limit Hold'em Event #4: €555 Pot-Limit 2-7 Triple Draw Event #5: €660 No-Limit Hold'em Mystery Bounty Event #6: €1,500 WSOPC Tallinn Main Event Event #8: €1,100 PLO / PLO5 Event #9: €660 Pot-Limit Omaha Hi/Lo Event #11: €3,000 No-Limit Hold'em 6 Handed Event #12: €660 No-Limit Hold'em Progressive Bounty Event #6: €1,500 WSOPC Tallinn Main Event (Estonian)

---

Current Level 28 Current Day 2

---

Blinds 60,000/120,000 Ante 120,000

Entries 97 Remaining 1

---

Prize Pool (EUR) €260,736 First Prize (EUR) €78,280

Chip Leaders Day 2

1

Roope Tarmi

7,255,000

Day 1 Day 2

Live Updates Chip Counts Structure Gallery Payouts

1 New Update - Click to refresh

Live Updates - Day 2

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. 

Watch it all go down here in Tallinn at OlyBet.tv

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