0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0061 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/4/updates'
ORDER BY `views` DESC
0.0002 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.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.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'wsopctallinn_2023_event6'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'
0.0259 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '102'
AND `published` = 1
0.0254 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0053 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '125'
AND `published` = 1
0.0257 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0047 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '129'
AND `published` = 1
0.0252 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` = '130'
AND `published` = 1
0.0253 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0047 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '132'
AND `published` = 1
0.0254 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0049 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '135'
AND `published` = 1
0.0252 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0046 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '138'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'
AND `name` = '4'
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '138'
ORDER BY `busted` ASC, `current_chips` DESC
0.0049 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` = '138'
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` = '6215'
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` = '6197'
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` = '6193'
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` = '6192'
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` = '6190'
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` = '6185'
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` = '6182'
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` = '6178'
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` = '6186'
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` = '6172'
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` = '6209'
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` = '6169'
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` = '6167'
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` = '6164'
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` = '6162'
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` = '6160'
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` = '6159'
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` = '6157'
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` = '6156'
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` = '6149'
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` = '6147'
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` = '6142'
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` = '6139'
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` = '6135'
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` = '6130'
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` = '6128'
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` = '6126'
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` = '6120'
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` = '6118'
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` = '6106'
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` = '6107'
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` = '6103'
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` = '6093'
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` = '6101'
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` = '6089'
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` = '6085'
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` = '6075'
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` = '6066'
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` = '6068'
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` = '6062'
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` = '6056'
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` = '6057'
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` = '6055'
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` = '6049'
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` = '6046'
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` = '6042'
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` = '6037'
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` = '6036'
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` = '6035'
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` = '6029'
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` = '6028'
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` = '6021'
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` = '6011'
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` = '6009'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '138'
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_id` = '138'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '6215'
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` = '6197'
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` = '6193'
ORDER BY `chip_change` DESC, `busted` ASC
0.0102 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` = '6192'
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` = '6190'
ORDER BY `chip_change` DESC, `busted` ASC
0.0093 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` = '6185'
ORDER BY `chip_change` DESC, `busted` ASC
0.0092 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` = '6182'
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` = '6178'
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` = '6186'
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` = '6172'
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` = '6209'
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` = '6169'
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` = '6167'
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` = '6164'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 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` = '6162'
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` = '6160'
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` = '6159'
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` = '6157'
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` = '6156'
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` = '6149'
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` = '6147'
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` = '6142'
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` = '6139'
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` = '6135'
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` = '6130'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 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` = '6128'
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` = '6126'
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` = '6120'
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` = '6118'
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` = '6106'
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` = '6107'
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` = '6103'
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` = '6093'
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` = '6101'
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` = '6089'
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` = '6085'
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` = '6075'
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` = '6066'
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` = '6068'
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` = '6062'
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` = '6056'
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` = '6057'
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` = '6055'
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` = '6049'
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` = '6046'
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` = '6042'
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` = '6037'
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` = '6036'
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` = '6035'
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` = '6029'
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` = '6028'
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` = '6021'
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` = '6011'
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` = '6009'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '138'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 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.
Ignacio Garrido Gonzalez Wins WSOPC Tallinn €1,500 Main Event (€100,350) Posted Sunday 24th September, 2023 at 20:06(UTC+0) by Jason Glatzer
Spain's Ignacio Garrido Gonzalez made history on Sunday after winning the inaugural Event #6: WSOP Circuit Tallinn €1,500 Main Event for €100,350 after defeating Sweden's Emil Hovmark heads-up at the plush surroundings of Olympic Park Casino and the adjoining Hilton Tallinn Park.
The stacks began to become short with six players remaining with the initial final table leader Akseli Paalanen still holding the lead when they agreed to a deal with €5,100 left to play for along with the coveted WSOPC Tallinn gold ring and an invitation to the $1 million guaranteed 2024 WSOP Tournament of Champions freeroll in Las Vegas.
Everything began to go Gonzalez's way after the deal as from that point forward, it was relatively smooth sailing en route to the title as he eliminated each of his final five opponents.
"I feel very happy," Gonzalez said after the win to OlyBet.tv. "It was a complicated tournament but after the deal it was easy... I ran very good. The flips came to me and now I am the winner."
Gonzalez has called Tallinn his home for quite some time and is part of a budding Spanish expat poker community which also includes the likes of two others at the final table in Adria Comas I Roura and Jesus Ucero.
The €1 million guaranteed WSOPC Tallinn Main Event was a grand success with 719 entries battling it out for four days. The top 87 players cashed for at least a min-cash of €3,050 for more than double the €1,500 buy-in.
2023 WSOP Circuit Tallinn Main Event Final Table Results
Place
Player
Country
Prize
1
Ignacio Garrido Gonzalez
Spain
€100,350*
2
Emil Hovmark
Sweden
€75,100*
3
Artur Kulanurk
Estonia
€84,050*
4
Akseli Paalanen
Finland
€141,850*
5
Mairo Tori
Estonia
€92,050*
6
Adria Comas I Roura
Spain
€86,550*
7
Jesus Martinez Ucero
Spain
€26,150
8
Mario Linno
Estonia
€21,550
9
Jun Beum Chun
South Korea
€17,700
*Reflects six-way deal at the final table.
Final Day Action
Finland's Akseli Paalanen (pictured above) began the final table of nine players with a substantial chip lead with the eventual winner Ignacio Garrido Martinez near the bottom of the pack.
Paalanen maintained his composure and never let go of the chip lead as he sent Jesus Martinez Ucero (seventh - €26,150), Mario Linno (eighth - €21,550), and Jun Beum Chun (ninth - €17,700) to the rail in succession to start the day.
Blinds were getting shallow during six-handed play and all six players agreed to discuss a deal. Paalanen was the clear chip leader at this point and asked for €1,000 more from each player. After that, the deal was agreed and the action moved on with still plenty to play for including the prestige of winning the first-ever WSOPC Tallinn title.
Paalanen's stack began to fall apart very soon after the deal was agreed. He first doubled up Adria Comas I Roura when his ace-jack didn't hold against ace-six. This hand will be remembered by many for a while as three sixes flashed their way onto the board for Roura to snag the first lead change at the final table.
Roura's good fortunes were short-lasted as he soon went from hero to zero. Artur Kulanurk delivered a bad beat for his tournament life when his deuces pulled ahead of Roura's cowboys. Kulanurk helped himself to the rest of Roura's stack when his ace-queen suited held against ace-eight for Roura's day to end in sixth place for €86,550.
Kulanurk's day in the sun was also short-lived. Gonzalez soon took a huge chip lead and never looked back when Kulanurk committed with ten-six with an open-ender on the turn and doubled up his opponent with Gonzalez holding aces.
Gonzalez was the new table terminator as shortly after he eliminated Mairo Tori (fifth - €92,050) when his ace-four held against queen-jack.
A rare double elimination took place shortly after. Paalanen jammed his crumbs with nine-six before Kulanurk came in over the top with king-ten suited. Gonzalez woke up with ace-queen and took out both players. While Kulanurk finished in the higher spot of third place for €84,050, it was Paalanen who had even more reasons to celebrate as he won the most money in the event thanks to the deal with an impressive €141,850 prize.
Martinez held more than double the stack of his opponent Emil Hovmark, who was unable to get anything going. Hovmark eventually three-bet jammed his king-jack suited and settled for finishing one player shy of winning the event along with a healthy €75,010 prize after not pulling ahead of Martinez's queens.
Congrats to Ignacio Garrido Gonzalez for his epic victory in the 2023 WSOP Circuit Tallinn Main Event. Thank you for joining us and see you next time at Olympic Park Casino.
Author: Jason Glatzer Photos: Tambet Kask and Elena Kask
Full Main Event Payouts Posted Sunday 24th September, 2023 at 17:25(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
Ignacio Gonzalez Garrido
Spain
€100,350*
2
Emil Hovmark
Sweden
€75,100*
3
Artur Kulanurk
Estonia
€84,050*
4
Akseli Paalanen
Finland
€141,850*
5
Mairo Tori
Estonia
€92,050*
6
Adria Comas I Roura
Spain
€86,550*
7
Jesus Martinez Ucero
Spain
€26,150
8
Mario Linno
Estonia
€21,550
9
Jun Beum Chun
South Korea
€17,700
10
Pekka Ikonen
Finland
€14,550
11
Antti Eeva
Finland
€11,800
12
Max Rotko
Finland
€9,600
13
Jon Ander Martinez
Spain
€9,600
14
Hendrik Uibo
Estonia
€7,750
15
Anders Hansson
Sweden
€7,750
16
Martin Piik
Estonia
€6,000
17
Tomasz Mroz
Poland
€6,000
18
Andrius Bielskis
Lithuania
€6,000
19
Samuel Richards
United Kingdom
€6,000
20
Anna-Mari Hursti
Finland
€6,000
21
Henri Antkainen
Finland
€6,000
22
Maciej Komorowski
Poland
€6,000
23
Maruen Zormati
Finland
€6,000
24
Jimi Koponen
Finland
€5,250
25
Seppo Parkkinen
Finland
€5,250
26
Kevin Karinius
Finland
€5,250
27
David Asqino
Italy
€5,250
28
Vu Hoang Vuong
Finland
€5,250
29
Marko Harkonen
Finland
€5,250
30
Jari-Pekka Juhola
Finland
€5,250
31
Kyosti Isberg
Finland
€5,250
32
Kris Tikka
Finland
€4,750
33
Bartlomiej Kijak
Poland
€4,750
34
Hannes Praks
Estonia
€4,750
35
Deividas Butnoras
Lithuania
€4,750
36
Stanislavas Macugins
Latvia
€4,750
37
Ekrem Esker
Finland
€4,750
38
Steponas Venckus
Lithuania
€4,750
39
Karl Relander
Finland
€4,750
40
Aleksandr Arutjunov
Estonia
€4,250
41
Jose Larios Domene
Spain
€4,250
42
Remigijus Dzerva
Lithuania
€4,250
43
Luca Beretta
Italy
€4,250
44
Emanuele Mari
Italy
€4,250
45
Joni Rantamaki
Finland
€4,250
46
Adrians Imsa
Latvia
€4,250
47
Andzej Zinkevic
Lithuania
€4,250
48
Gilles Simon
Netherlands
€3,750
49
Amanullah Tahiri
Finland
€3,750
50
Juho Suutari
Finland
€3,750
51
Igor Yaroshevskyy
Ukraine
€3,750
52
Toms Civcs
Latvia
€3,750
53
Aigars Tuakacs
Latvia
€3,750
54
Alger Pissarev
Estonia
€3,750
55
Kasper Mellanen
Finland
€3,750
56
Youngseo Yoon
United Kingdom
€3,300
57
Urmo Velvelt
Estonia
€3,300
58
Sebastian Wahl
Finland
€3,300
59
Ermo Kosk
Estonia
€3,300
60
Tornike Tchitadze
Georgia
€3,300
61
Mauri Dorbek
Estonia
€3,300
62
Rasmus Sepping
Estonia
€3,300
63
Paulius Mikaliunas
Lithuania
€3,300
64
Tarmo Tammel
Estonia
€3,300
65
Andrey Koks
Estonia
€3,300
66
Kert Hallik
Estonia
€3,300
67
Priit Vallap
Estonia
€3,300
68
Tomi Hietala
Finland
€3,300
69
Jonatan Fors
Finland
€3,300
70
Karlis Kreslins
Latvia
€3,300
71
Mark Metsla
Estonia
€3,300
72
Egon Kaljulaid
Estonia
€3,050
73
Keito Kaljulaid
Estonia
€3,050
74
Priit Parmasto
Estonia
€3,050
75
Roope Holma
Finland
€3,050
76
Vidar Assersen
Norway
€3,050
77
Steven Seller
Estonia
€3,050
78
Peng Yi-Zhan
Taiwan
€3,050
79
Herli Olop
Estonia
€3,050
80
Sergei Aleksejev
Estonia
€3,050
81
Markuss Rukkalns
Latvia
€3,050
82
Mohammed Al-Khazraji
Finland
€3,050
83
Agnius Ismailovas
Lithuania
€3,050
84
Jon Kyte
Norway
€3,050
85
Kare Hallamaa
Finland
€3,050
86
Johan Martinsen
Finland
€3,050
87
Mikko Ylamaki
Finland
€3,050
*Reflects a six-way deal with €5,100 extra to the winner along with the gold ring and invite to the 2024 WSOP Tournament of Champions freeroll
Emil Hovmark Eliminated in 2nd Place (€75,100) Posted Sunday 24th September, 2023 at 17:21(UTC+0) by Jason Glatzer
Ignacio Garrido Gonzalez jammed the button for more than the 9.2 million Emil Hovmark (pictured below) had in his stack. Hovmark quickly called and needed some help.
Emil Hovmark: Ignacio Garrido Gonzalez:
King-jack suited is a tasty heads-up hand but he ran into a monster. Normally the flop would have been a monster. Gonzalez though improved to a full house to eliminate most of those outs to a flush or a straight but there was still a sweat for both players with Hovmark drawing to two outs to a straight flush or royal flush with two cards to come.
Neither the turn nor the river provided any magic for Hovmark and he was eliminated one player shy of the title in second place for €75,100 as part of the six-way deal instead of the originally scheduled €137,250.
Meanwhile, Gonzalez managed to collect the extra €5,100 to bring his total haul to €100,350. While this is not as much as fourth-place finisher Akseli Paalanen collected with a €141,850 prize, he still made out well and in addition to the prize will forever be known as the player to win the inaugural WSOP Circuit Tallinn Main Event gold ring.
This is not all, as Gonzalez also will be invited to battle it out for a bracelet for free at the 2024 WSOP Tournament of Champions freeroll with $1 million in prizes on the line.
Congrats to Gonzalez and all of the final table players. Stay tuned for a recap of the Main Event.
Player
Chips
Progress
Ignacio Garrido Gonzalez
36,000,000
11,000,000
Emil Hovmark
0
0
17:12 (UTC+0)
Start of Level 35 Blinds: 300,000/600,000 Ante: 600,000
Artur Kulanurk Eliminated in 3rd Place (€84,050); Akseli Paalanen Eliminated in 4th Place (€141,850) Posted Sunday 24th September, 2023 at 17:10(UTC+0) by Jason Glatzer
Ignacio Garrido Gonzalez eliminated two players coming into the following hand. He doubled that with four eliminations by taking out both Artur Kularuk (pictured above) in third place and Akseli Paalanen (pictured below) in fourth place.
Paalanen jammed for 675,000 from under the gun. Gonzalez called from the button before Kulanurk three-bet shoved for 3,300,000. Gonzalez called that as well and put two players at risk.
Akseli Paalanen: Artur Kulanurk: Ignacio Garrido Gonzalez:
Gonzalez was already ahead but further improved to two pair on the ran out on the board to eliminate Kulanurk in third place for €84,050 for slightly less than the pre-deal third-place prize of €84,200 and Paalanen in fourth place.
Paalanen will be the big money winner collecting €141,850 instead of the €64,100 thanks to previously agreeing to a six-way deal.
Meanwhile, Gonzalez will kick off heads-up action with more than double the stack of Emil Hovmark in the hunt for the coveted ring, the invitation to the $1 million guaranteed 2024 WSOP Tournament of Champions bracelet event freeroll, and the €5,100 in cash left to play for.
Player
Chips
Progress
Ignacio Garrido Gonzalez
25,000,000
7,000,000
Emil Hovmark
11,000,000
0
Akseli Paalanen
0
0
Artur Kulanurk
0
0
Hovmark Leaves Paalanen With Crumbs Posted Sunday 24th September, 2023 at 16:58(UTC+0) by Jason Glatzer
Akseli Paalanen was dominating until a deal was made. His stack began to fall apart and now it has crumbled into crumbs after losing the following hand to Emil Hovmark (pictured below).
Paalanen jammed for 5.8 million from the button before Emil Hovmark called off his stack of 5.2 million.
Emil Hovmark: Akseli Paalanen:
Paalenen was still alive after the flop and the turn was a Yahtzee card as it gave him both a flush draw and a gutshot to the straight on top of his jack still being alive. The river was safe for Hovmark but disastrous for Paalanen who will have some work cut out for him to get the coveted ring that he earlier appeared destined to earn.
Player
Chips
Progress
Emil Hovmark
11,000,000
5,100,000
Akseli Paalanen
675,000
6,625,000
Updated Chip Counts Posted Sunday 24th September, 2023 at 16:52(UTC+0) by Jason Glatzer
Player
Chips
Progress
Ignacio Garrido Gonzalez
18,000,000
1,000,000
Akseli Paalanen
7,300,000
1,000,000
Emil Hovmark
5,900,000
2,500,000
Artur Kulanurk
5,000,000
1,300,000
Mairo Tori Eliminated in 5th Place (€92,050) Posted Sunday 24th September, 2023 at 16:44(UTC+0) by Jason Glatzer
Ignacio Garrido Gonzalez has become the new table terminator as he just eliminated back-to-back Estonian players. This time, Mairo Tori (pictured below) hit the rail in fifth place for €92,050 thanks to the six-handed deal agreed an hour ago instead of the €48,750 prize that would have been awarded if no deal had been agreed.
Gonzalez jammed from the small blind and Tori called off his stack of 3.8 million from the big blind.
Mairo Tori: Ignacio Garrido Gonzalez:
Gonzalez was ahead and improved to a full house on the board to eliminate Tori and extend his chip lead to more than half the chips in play with four players remaining.
Player
Chips
Progress
Ignacio Garrido
19,000,000
4,000,000
Mairo Tori
0
0
16:40 (UTC+0)
Start of Level 34 Blinds: 250,000/500,000 Ante: 500,000
Garrido Blasts Off to the Lead With Rockets Posted Sunday 24th September, 2023 at 16:37(UTC+0) by Jason Glatzer
Artur Kulanurk min-raised from the button with before Ignacio Garrido Gonzalez opted to simply call with his from the big blind.
Gonzalez check-called a bet of 1,000,000 on the flop. Kulanurk didn't complete his open-ender on the turn and Gonzalez checked again with the best hand. Kulanurk bet 2,800,000. Gonzalez jammed for 5,200,000 and Kulanurk went into the tank.
Eventually, Kulanurk called and Gonzalez needed to fade just six outs with only two aces and four nines to stop him from doubling his stack.
The blank river completed the board and Gonzalez doubled into the chip lead.
Player
Chips
Progress
Ignacio Garrido
15,000,000
8,500,000
Artur Kulanurk
6,300,000
4,900,000
Welcome to Queens of Tallinn Posted Sunday 24th September, 2023 at 16:33(UTC+0) by Lina Olofsson
After all of the successful festivals over the years with the Kings of Tallinn, it's now announced by the tournament organizers that we will have The Queens of Tallinn in late November. A festival series for only women with a €350 Main Event and several other events to go along with it.
Just like the Kings of Tallinn, the WSOP Circuit has been beyond anyone's expectations with stunning branding all over Hilton Park and Olympic Casino. The Queens of Tallinn will bring exact same feeling to the players who attend with a streamed final table from the Main Event and world-class tournament staff like it always is with this organization with the well-renowned Tournament Director Teresa Nousiainen in charge.
Together with Teresa, and Christer Larsson who's the Olympic Entertainment Group's Poker Director, they are just finishing all the details for this festival. We got to have a talk with Christer as the Festival was announced during the Ladies Event here in the WSOPC on Saturday.
Christer Larsson and Teresa Nousiainen
"It's about time someone does something like this. It feels nice to give something back to all the fantastic women in this industry and to create a festival for them," Christer said after receiving a big round of applause from everyone in the grand ballroom as the two made the announcement.
The Queens of Tallinn Festival will be held here at Olympic Casino and Hilton Park from November 30th to December 3rd and will be just as fantastic as all the festivals we've had here for a number of years now. There will be a €350 Main Event with a live-streamed final table alongside three or four side events. All Events will be for women only but for the gentlemen who want to come along there will be a €60 side event and also a cash game weekend down in the casino.
Ave Lepik who won the Queens of Tallinn here during the WSOPC
It's fair to say that we already know this will be a one-of-a-kind experience for everyone who decides to join as both Christer and Teresa are two of the best in the world when it comes to arranging festivals that give it's players that little bit of extra from the minute they enter the building until they leave.
Author: Lina Olofsson Photos: Elena & Tambert Kask
Break Time Posted Sunday 24th September, 2023 at 16:29(UTC+0) by Jason Glatzer
The final five players went on a 20-minute break. With stacks short, get ready for an action-packed finish.
Adria Comas I Roura Eliminated in 6th Place (€86,550) Posted Sunday 24th September, 2023 at 16:28(UTC+0) by Jason Glatzer
Spain's Adria Comas I Roura had the chip lead just moments ago. He took a horrific bad beat against Estonia's Artur Kulanurk when his kings were no good against deuces before dusting off the rest to the Estonian to give him his first chip lead.
Roura jammed from the cutoff for 5,300,000 and was called by Kulanurk from the big blind.
Adria Comas I Roura: Artur Kulanurk:
Roura didn't get any help from the board and was eliminated in sixth place. Despite the dramatic hero-to-zero finish, Roura should sleep well as he banked €86,550 thanks to the three-way deal instead of the €34,110 that was scheduled for sixth place before the deal.
Player
Chips
Progress
Akseli Paalanen
8,300,000
0
Ignacio Garrido
6,500,000
0
Mairo Tori
4,300,000
0
Emil Hovmark
3,400,000
200,000
Artur Kulanurk
1,400,000
6,700,000
Adria Comas I Roura
0
0
Lucky Ducks for Kulanurk Posted Sunday 24th September, 2023 at 16:16(UTC+0) by Jason Glatzer
Artur Kulanurk (pictured below) jammed for 3,500,000 from under the gun. Roura three-bet his chip-leading stack from the button and Kulanurk needed some help after the cards were turned over.
Artur Kulanurk: Adria Comas I Roura:
The poker gods saved the day as his two connected on the flop and eventually cracked Roura's cowboys with a full house after the turn and river completed the board.
By default, Akseli Paalanen was back with the chip lead after the hand.
Player
Chips
Progress
Akseli Paalanen
8,300,000
0
Artur Kulanurk
8,100,000
4,600,000
Ignacio Garrido
6,500,000
600,000
Adria Comas I Roura
5,300,000
3,700,000
Mairo Tori
4,300,000
3,000,000
Emil Hovmark
3,600,000
400,000
Quads for Roura to Snag the Lead Posted Sunday 24th September, 2023 at 16:08(UTC+0) by Jason Glatzer
Until the deal was made, Akseli Paalanen stayed as the chip leader throughout the final table and also was the "table terminator" after ousting the first three players.
That trend unfortunately for the Finn ended on a bad beat as Adria Comas I Roura (pictured below) nearly hit the rail but instead took the chip lead.
Paalanen min-raised from the button. Roura three-bet jammed for 4,200,000 and Paalanen called.
Adria Comas I Roura: Akseli Paalanen:
The runout not only got Roura's ace-six suited ahead of ace-jack suited but in supreme style with the board improving Roura to four of a kind.
Player
Chips
Progress
Adria Comas I Roura
9,000,000
4,400,000
Akseli Paalanen
8,300,000
4,900,000
Updated Chip Counts Posted Sunday 24th September, 2023 at 15:58(UTC+0) by Jason Glatzer
Player
Chips
Progress
Akseli Paalanen
13,000,000
200,000
Ignacio Garrido
6,700,000
400,000
Mairo Tori
5,300,000
2,000,000
Adria Comas I Roura
4,600,000
0
Artur Kulanurk
3,500,000
2,800,000
Emil Hovmark
3,400,000
200,000
Six-Way Deal Agreed! Posted Sunday 24th September, 2023 at 15:56(UTC+0) by Jason Glatzer
The final six players have agreed to a deal to reduce some variance. Akseli Paalanen is guaranteed to be the biggest cash winner in the event even if he doesn't win the coveted ring or the €5,100 they left to play for.
Here is a look at what each player locked up thus far:
Player
Country
Prize
Akseli Paalanen
Finland
€141,850
Ignacio Gonzalez Garrido
Spain
€95,250
Mairo Tori
Estonia
€92,050
Adria Comas I Roura
Spain
€86,550
Artur Kulanurk
Estonia
€84,050
Emil Hovmark
Sweden
€75,100
Deal Discussion Posted Sunday 24th September, 2023 at 15:46(UTC+0) by Jason Glatzer
The clock has been stopped with 14:48 left on the clock in Level 31 as the final six players stepped aside to chat about a potential deal.
Stay tuned to see if a deal was made or if they will keep playing for the payouts already on tap.
Rockets for Garrido Posted Sunday 24th September, 2023 at 15:46(UTC+0) by Jason Glatzer
Akseli Paalanen min-raised from under the gun. Ignacio Gonzalez Garrido three-bet shoved for 2,800,000 from the hijack. Paalanen tanked for about a minute before he called.
Ignacio Garrido: Akseli Paalanen:
Garrido's well-timed rockets held for a full double-up after the ran out on the board.
Player
Chips
Progress
Ignacio Garrido
6,300,000
3,500,000
Akseli Paalanen
1,300,000
200,000
Hovmark Doubles With Sevens Posted Sunday 24th September, 2023 at 15:25(UTC+0) by Jason Glatzer
Adria Comas I Roura jammed the button for 6.1 million. Emil Hovmark had less than four big blinds in his stack when he called off from the big blind.
Emil Hovmark: Adria Comas I Roura:
Roura, who just doubled through Tori, wasn't able to continue the momentum by winning the flip and instead doubled up Hovmark after he failed to improve on the board.
Player
Chips
Progress
Adria Comas I Roura
4,600,000
4,125,000
Emil Hovmark
3,600,000
800,000
Roura Doubles Through Tori Posted Sunday 24th September, 2023 at 15:20(UTC+0) by Jason Glatzer
Adria Comas I Roura jammed for 2.9 million from the small blind. Mairo Tori went into the tank for a few minutes before he called.
The red lights went off at the tv table as the cards were turned over.
Mairo Tori: Adria Comas I Roura:
Roura was behind but pulled ahead after his nine paired up on the flop. Tori bricked both the turn and river for Roura to stay alive and double his stack.
Player
Chips
Progress
Artur Kulanurk
6,300,000
1,625,000
Adria Comas I Roura
6,100,000
2,625,000
Adria Comas I Roura
6,100,000
1,100,000
Mairo Tori
3,500,000
3,075,000
Akseli Paalanen
1,500,000
11,500,000
Emil Hovmark
0
1,325,000
15:09 (UTC+0)
Start of Level 33 Blinds: 200,000/400,000 Ante: 400,000
Second Break Posted Sunday 24th September, 2023 at 14:54(UTC+0) by Jason Glatzer
The final six players are on their second break of the final table. Check out the chip counts below:
Player
Chips
Progress
Akseli Paalanen
9,475,000
3,525,000
Mairo Tori
6,575,000
575,000
Artur Kulanurk
4,675,000
3,025,000
Emil Hovmark
4,125,000
2,025,000
Adria Comas I Roura
3,475,000
225,000
Ignacio Garrido
725,000
2,875,000
Better Kicker for Roura Posted Sunday 24th September, 2023 at 14:45(UTC+0) by Jason Glatzer
It was mostly small ball, during which time Akseli Paalanen was able to extend his chip lead to 14 million chips. Despite the smooth sailing most of the day for Paalanen including eliminating the first three players at the final table, Adria Comas I Roura was able to make a small dent into his stack.
Paalanen jammed from the hijack before Roura called off his stack of 1,500,000 from the button.
Adria Comas I Roura: Akseli Paalanen:
Both players held suited aces. Roura had the better kick which helped him double his stack with both players bricking the runout.
Player
Chips
Progress
Akseli Paalanen
13,000,000
1,000,000
Artur Kulanurk
7,700,000
900,000
Mairo Tori
6,000,000
300,000
Adria Comas I Roura
3,700,000
1,200,000
Ignacio Garrido
3,600,000
800,000
Emil Hovmark
2,100,000
600,000
Updated Chip Counts Posted Sunday 24th September, 2023 at 14:29(UTC+0) by Jason Glatzer
Player
Chips
Progress
Akseli Paalanen
12,000,000
0
Artur Kulanurk
8,600,000
200,000
Mairo Tori
5,700,000
0
Ignacio Garrido
4,400,000
0
Emil Hovmark
2,700,000
1,200,000
Adria Comas I Roura
2,500,000
800,000
Garrido Lays Down Top Pair Posted Sunday 24th September, 2023 at 14:25(UTC+0) by Jason Glatzer
Artur Kulanurk (pictured below) opened the button for 600,000 with and was called by Ignacio Garrido with from the big blind.
Both players improved to top pair on the flop. Garrido, who had some kicker issues, check-called a bet of 900,000 by Kulanurk.
Kulanurk jammed the turn. Garrido had 4,400,000 behind and was covered. Despite holding top pair, Garrido didn't waste any time in giving up on the hand.
Player
Chips
Progress
Artur Kulanurk
8,400,000
2,700,000
Ignacio Garrido
4,400,000
700,000
Final Table Payouts Thus Far Posted Sunday 24th September, 2023 at 14:19(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
€211,500
2
€137,250
3
€84,200
4
€64,100
5
€48,750
6
€34,150
7
Jesus Martinez Ucero
Spain
€26,150
8
Mario Linno
Estonia
€21,550
9
Jun Beum Chun
South Korea
€17,700
14:13 (UTC+0)
Start of Level 32 Blinds: 150,000/300,000 Ante: 300,000
Jesus Martinez Ucero Eliminated in 7th Place (€26,150) Posted Sunday 24th September, 2023 at 14:03(UTC+0) by Jason Glatzer
Akseli Paalanen just eliminated the third straight player at the final table. This time, the final table chip lead and table terminator sent Jesus Martinez Ucero (pictured below) to the showers in seventh place for €26,150.
Paalanen opened for 500,000 from under the gun before Jesus Martinez Ucero three-bet shoved for 2,300,000. Paalanen went into the tank before he found a call.
Jesus Martinez Ucero: Akseli Paalanen:
Ucero was flipping for his tournament life and things were looking grim after Paalanen pulled ahead with a pair of jacks after connecting with the flop. Neither the turn nor the river provided the miracle two-outer Ucero needed to stay alive and double. Instead, his impressive run in the Main Event is history.
Player
Chips
Progress
Akseli Paalanen
12,000,000
1,000,000
Artur Kulanurk
5,700,000
900,000
Mairo Tori
5,700,000
400,000
Ignacio Garrido
5,100,000
1,300,000
Emil Hovmark
3,900,000
600,000
Adria Comas I Roura
3,300,000
1,000,000
Jesus Ucero
0
0
Nines Good for Hovmark Posted Sunday 24th September, 2023 at 13:43(UTC+0) by Jason Glatzer
Mairo Tori opened for a min-raise from the cutoff. Emil Hovmark (pictured below) three-bet shoved for 2,000,000 and Tori called off for another 1.5 million with Hovmark at risk.
Emil Hovmark: Mairo Tori:
Hovmark had a huge edge to win the hand but nearly sealed the deal after nailing a set on the flop. Tori was drawing dead on the turn and Hovmark doubled through his opponent after the river further improved him to an unnecessary full house.
Player
Chips
Progress
Mairo Tori
6,100,000
1,100,000
Emil Hovmark
4,500,000
1,900,000
13:42 (UTC+0)
Start of Level 31 Blinds: 125,000/250,000 Ante: 250,000
Updated Chip Counts Posted Sunday 24th September, 2023 at 13:37(UTC+0) by Jason Glatzer
Player
Chips
Progress
Akseli Paalanen
13,000,000
1,000,000
Mairo Tori
7,200,000
600,000
Artur Kulanurk
4,800,000
500,000
Adria Comas I Roura
4,300,000
0
Emil Hovmark
2,600,000
500,000
Jesus Ucero
2,500,000
1,500,000
Ignacio Garrido
1,800,000
1,075,000
No Race Needed for Roura Posted Sunday 24th September, 2023 at 13:27(UTC+0) by Jason Glatzer
Mario Linno (pictured below) jammed for 1.3 million from the button over the min-raise open by Akseli Paalanen from the hijack. Paalanen paused for a moment before he called.
Mario Linno: Akseli Paalanen:
Linno nailed top two pair on the runout. However, Paalanen improved to a flush to send Linno to the rail in eighth place for €21,550.
Player
Chips
Progress
Akseli Paalanen
12,000,000
10,900,000
Mario Linno
0
0
Jun Beum Chun Eliminated in 9th Place (€17,700) Posted Sunday 24th September, 2023 at 13:06(UTC+0) by Jason Glatzer
Jun Beum Chun (pictured below) came into today with the second biggest stack but was the first player to hit the rail at the final table in ninth place for €17,700.
Chun jammed for 675,000 from early positon and was called by Akseli Paalanen from one seat over.
Jun Beum Chun: Akseli Paalanen:
Chun needed help and appeared some was on the way after his ten connected on the flop. However, the turn changed everything as Paalanen improved to Broadway and Chun was only drawing thin for a chop.
The river paired the board and Chun was on the rail after an impressive run in the Main Event.
12:59 (UTC+0)
Start of Level 30 Blinds: 100,000/200,000 Ante: 200,000
Break Time Posted Sunday 24th September, 2023 at 12:32(UTC+0) by Jason Glatzer
The final nine players are on the first break of the final table. Blinds will increase to 100,000/200,000 with a 200,000 big blind ante when the action resumes in 20 minutes.
Player
Chips
Progress
Akseli Paalanen
11,000,000
1,100,000
Mairo Tori
6,600,000
0
Jesus Ucero
5,500,000
200,000
Artur Kulanurk
4,300,000
0
Adria Comas I Roura
3,400,000
800,000
Emil Hovmark
3,100,000
1,100,000
Mario Linno
1,800,000
700,000
Ignacio Garrido
725,000
375,000
Jun Beum Chun
675,000
425,000
Toomas "Stablecoinflip" Orm Wins OnlyBet Online Event #10 (€9,087) Posted Sunday 24th September, 2023 at 12:20(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
Aggression Pays Off for Hovmark Posted Sunday 24th September, 2023 at 12:15(UTC+0) by Jason Glatzer
Level 29: 75,000/150,000 (150,000) Entries: 9/719
Akseli Paalanen min-raised with from early position. Mario Linno called from middle position with with before the action paused on Emil Hovmark who three-bet to 900,000 from the button.
Artur Kulanurk woke up with from the big blind and opted to lay it down with all of the action in front of him. Both Paalanen, who would have been in good shape with the three other players blocking each other to some degree, folded. Linno also opted to save his short stack for another time for Hovmark to take down the pot preflop.
Player
Chips
Progress
Akseli Paalanen
9,900,000
100,000
Mairo Tori
6,600,000
300,000
Jesus Ucero
5,300,000
0
Artur Kulanurk
4,300,000
400,000
Emil Hovmark
4,200,000
1,300,000
Adria Comas I Roura
2,600,000
0
Jun Beum Chun
1,100,000
0
Ignacio Garrido
1,100,000
0
Mario Linno
1,100,000
300,000
Tori Flops Top Two Pair Posted Sunday 24th September, 2023 at 12:04(UTC+0) by Jason Glatzer
Level 29: 75,000/150,000 (150,000) Entries: 9/719
Akseli Paalanen opened for a min-raise from the hijack with and was called by Mairo Tori with from the big blind.
Tori checked after improving to top two pair on the flop. Paalanen bet 200,000 with his middle pair and Tori called.
Both players checked the turn before the river paired the board. Tori bet 400,000 and wasn't able to get more value from his hand after Paalanen folded.
Player
Chips
Progress
Akseli Paalanen
10,000,000
1,000,000
Mairo Tori
6,900,000
600,000
Chun Doubles Short Stack Against Garrido Posted Sunday 24th September, 2023 at 11:55(UTC+0) by Jason Glatzer
Level 29: 75,000/150,000 (150,000) Entries: 9/719
Perhaps the Cinderella story for South Korea's Jun Beum Chun has begun as he just doubled up through Ignacio Garrido as follows with a timely hand from the big blind where he was likely pot committed to call with any two cards.
Garrido jammed 1,600,000 from early position. Chun, who only had one big blind behind after posting the big blind and ante, made the quick call.
Jun Beum Chun: Ignacio Garrido:
The only saving grace here for Garrido is that he is fortunate stacks weren't deeper with both players improving to trips on the flop. The turn and river allowed Chun's queen kicker to come into play to win the hand and double his stack.
Player
Chips
Progress
Jun Beum Chun
1,100,000
500,000
Ignacio Garrido
1,100,000
500,000
11:54 (UTC+0)
Start of Level 29 Blinds: 75,000/150,000 Ante: 150,000
Tori Rivers Flush to Leave Chun With Crumbs Posted Sunday 24th September, 2023 at 11:50(UTC+0) by Jason Glatzer
Level 28: 50,000/125,000 (125,000) Entries: 9/719
Jun Beum Chun min-raised with from under the gun and was called by Mairo Tori with from the cutoff.
Chun bet 400,000 with his overpair for two pair on the flop. The flop was tasty for Tori as well and he called with a flush draw.
The turn was safe for Chun and he fired out for 800,000. Tori went into the tank with his flush draw and overcards. A couple of minutes went by before he called.
The river completed Tori's flush. Chun jammed and Tori checked his cards before he called.
It has been a great start for Tori who despite losing some of his short stack early on rebounded with two big double-ups to just be behind Akseli Paalanen for the chip lead.
Meanwhile, fortunes were reversed for Chun who began the day in second place. He ran an unsuccessful bluff against Jesus Ucero to go down to the middle of the pack. Now, he will need a Cinderella story as he only has crumbs in his stack after an untimely river against Tori.
Player
Chips
Progress
Akseli Paalanen
11,000,000
0
Mairo Tori
6,300,000
3,000,000
Jesus Ucero
5,300,000
700,000
Artur Kulanurk
4,700,000
0
Emil Hovmark
2,900,000
300,000
Adria Comas I Roura
2,600,000
300,000
Ignacio Garrido
1,600,000
300,000
Mario Linno
1,400,000
0
Jun Beum Chun
600,000
2,700,000
Tori Doubles Through Paalanen With Cowboys Posted Sunday 24th September, 2023 at 11:38(UTC+0) by Jason Glatzer
Level 28: 50,000/125,000 (125,000) Entries: 9/719
Mairo Tori min-raised from middle position before Akseli Paalanen three-bet jammed his chip leading stack from the small blind. Tori found the call and was more than a 2:1 favorite to win the hand after the cards were turned over.
Mairo Tori: Akseli Paalanen:
Paalanen wasn't just drawing to an ace after the flop also provided him a gutshot to the wheel. However, Tori's odds of winning the hand increased significantly after spiking the on the turn to improve to a set. The miracle trey didn't appear on the river for Paalanen and he instead doubled up Tori after the blank river completed the board.
Player
Chips
Progress
Akseli Paalanen
11,000,000
1,000,000
Jesus Ucero
6,000,000
0
Mairo Tori
3,300,000
2,375,000
Jun Beum Chun
3,300,000
100,000
Emil Hovmark
3,200,000
100,000
Adria Comas I Roura
2,300,000
0
Mario Linno
1,400,000
0
Ignacio Garrido
1,300,000
300,000
Paalanen Takes Chips Off Garrido Posted Sunday 24th September, 2023 at 11:31(UTC+0) by Jason Glatzer
Level 28: 50,000/125,000 (125,000) Entries: 9/719
Ignacio Garrido min-raised from under the gun with before Akseli Paalanen with defended his big blind.
Paalanen check-called a bet of 200,000 by Garrido on the flop after improving to the bottom pair.
Paalanen was still ahead on the turn and now also had chances to improve to a straight with an open-ended. He opted to bet 300,000 and took down the pot after Garrido folded.
Player
Chips
Progress
Akseli Paalanen
12,000,000
0
Ignacio Garrido
1,600,000
400,000
Ucero Picks Off Massive Bluff By Chun Posted Sunday 24th September, 2023 at 11:21(UTC+0) by Jason Glatzer
Level 28: 50,000/125,000 (125,000) Entries: 9/719
Jesus Ucero (pictured below) limped from the small blind with before he called a raise to 500,000 by Jun Beum Chun from the big blind with .
The flop improved Ucero to top pair. However, it was Chun continuing for 225,000 with air after Ucero checked.
Chun didn't slow down on the blank turn. Ucero checked and Chun fired out for 800,000. About a minute went by before Ucero called.
The river completed the board. Ucero checked and Chun fearlessly jammed for more than the 1.4 million Ucero had in his stack. It was a scary board for top pair but Ucero found a call to double his stack.
Player
Chips
Progress
Jesus Ucero
6,000,000
2,800,000
Jun Beum Chun
3,400,000
3,000,000
Updated Chip Counts Posted Sunday 24th September, 2023 at 11:13(UTC+0) by Jason Glatzer
Player
Chips
Progress
Akseli Paalanen
12,000,000
700,000
Jun Beum Chun
6,400,000
300,000
Artur Kulanurk
4,700,000
400,000
Emil Hovmark
3,300,000
200,000
Jesus Ucero
3,200,000
250,000
Adria Comas I Roura
2,300,000
25,000
Ignacio Garrido
2,000,000
0
Mario Linno
1,400,000
100,000
Mairo Tori
925,000
475,000
11:09 (UTC+0)
Start of Level 28 Blinds: 50,000/125,000 Ante: 125,000
Paalanen Turns a Straight Posted Sunday 24th September, 2023 at 11:09(UTC+0) by Jason Glatzer
Level 27: 50,000/100,000 (100,000) Entries: 9/719
Mairo Tori limped from early position with and was called by Akseli Paalanen from the button with and Ignacio Garrido with from the small blind before Mario Linno with checked back his option from the big blind.
Three players checked before Paalanen bet 150,000 with his open-ended straight draw. Garrido called with top pair and the two short-stacked Estonians got out of the way.
"He improves to the stone nuts," George Sandford said on the live stream after the turn completed Paalanen's straight.
Garrido checked again before Paalanen fired out for 550,000. A good read was made by Garrido who correctly saved some chips as he was drawing dead with his top pair.
Player
Chips
Progress
Akseli Paalanen
11,300,000
650,000
Ignacio Garrido
2,000,000
200,000
Mario Linno
1,500,000
325,000
Mairo Tori
1,400,000
100,000
Final Table Photo by Elena Kask Posted Sunday 24th September, 2023 at 10:57(UTC+0) by Jason Glatzer
Tens Good for Hovmark Posted Sunday 24th September, 2023 at 10:54(UTC+0) by Jason Glatzer
Level 27: 50,000/100,000 (100,000) Entries: 9/719
Jun Beum Chun opened for a min-raise from early position wtih and was called by Emil Hovmark with and Artur Kularnurk with from the big blind.
All three players checked down the entire way on the runout for Hovmark to pick up an early pot with tens.
Player
Chips
Progress
Jun Beum Chun
6,700,000
175,000
Artur Kulanurk
4,300,000
250,000
Emil Hovmark
3,500,000
250,000
30-Minute Delay Posted Sunday 24th September, 2023 at 10:32(UTC+0) by Jason Glatzer
The players were introduced by WSOPC Tallinn Tournament Director Teresa Nousiainen and shortly after cards were in the air.
We will be reporting on a 30-minute delay to not give away any spoilers to those also following along via the live stream at OlyBet.tv.
Best of luck to the final nine!
Who Will Win the €1 Million Guaranteed WSOPC Tallinn Main Event? Posted Sunday 24th September, 2023 at 08:58(UTC+0) by Jason Glatzer
The time is here and the mission is clear. Nine players from five different countries all with one goal in mind as the day we have all been waiting for is here with the final table of the 2023 WSOPC Tallinn €1,500 Main Event set to kick off on Sunday at noon at Olympic Park Casino and the Hilton Tallinn Park.
Despite many deep runs by players from Finland including final tables where the majority of the players were Finns, they have noticeably failed to win a ring. While three rings will be awarded today, the Finnish poker community and players from around the world will be keeping their eyes on the sole Finn remaining in the Main Event Akseli Paalanen (pictured aboe), who dominated yesterday's Day 3 to position himself as the clear chip leader at the final table with 10,675,000.
South Korea's Jun Bum Chun should bring some viewers to the live stream of the final table from a continent away as he is just behind Paalanen with 6,875,000.
The home country of Estonia could prove to be a lively rail with three local players including Artur Kulanurk (4,550,000), Mairo Tori (1,500,000), and Mario Linno (1,175,000).
The local community is not only represented by players from Estonia as three players from the sizeable Spanish expat poker community living in Tallinn also found their way to the final table including Jesus Martinez Ucero (3,450,000), Adria Comas I Roura (2,275,000), and Ignacio Gonzalez Garrido (2,200,000).
Sweden's Emil Hovmark (3,250,000) rounds out the final table in what promises to provide some great action with an average big blind stack of around 40 big blinds.
Final Table Seat Draw
Seat
Player
Country
Chips
Big Blinds
1
Emil Hovmark
Sweden
3,250,000
33
2
Artur Kulanurk
Estonia
4,550,000
46
3
Jesus Martinez Ucero
Spain
3,450,000
35
4
Jun Beum Chun
South Korea
6,875,000
69
5
Akseli Paalanen
Finland
10,650,000
107
6
Ignacio Gonzalez Garrido
Spain
2,200,000
22
7
Mario Linno
Estonia
1,175,000
12
8
Adria Comas I Roura
Spain
2,275,000
23
9
Mairo Tori
Estonia
1,500,000
15
Final Table Payouts
The final nine players each secured a minimum of a €17,700 payday on Sunday with the payouts going up quickly from there until the eventual winner collects a massive €211,500 top prize.
Check out all of the payouts below:
Place
Prize
1
€211,500
2
€137,250
3
€84,200
4
€64,100
5
€48,750
6
€34,150
7
€26,150
8
€21,550
9
€17,700
08:48 (UTC+0)
Day 4 of WSOPC Tallinn Started Level: 27 Blinds: 50,000/100,000 Ante: 100,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.