0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0067 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event4/2/updates'
ORDER BY `views` DESC
0.0098 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event4/2/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.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.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.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.0071 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.0006 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_event4'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '31'
0.0265 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` = '100'
AND `published` = 1
0.0262 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0048 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '120'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '31'
AND `name` = '2'
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '120'
ORDER BY `busted` ASC, `current_chips` DESC
0.0052 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` = '120'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '5124'
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` = '5111'
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` = '5109'
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` = '5108'
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` = '5107'
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` = '5104'
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` = '5102'
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` = '5100'
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` = '5088'
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` = '5087'
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` = '5082'
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` = '5080'
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` = '5075'
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` = '5072'
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` = '5068'
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` = '5060'
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` = '5057'
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` = '5048'
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` = '5039'
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` = '5037'
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` = '5034'
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` = '5032'
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` = '5024'
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` = '5021'
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` = '5017'
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` = '5016'
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` = '5011'
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` = '5007'
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` = '5006'
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` = '4999'
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` = '4977'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '120'
ORDER BY `busted` ASC, `current_chips` DESC
0.0048 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '120'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '5124'
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` = '5111'
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` = '5109'
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` = '5108'
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` = '5107'
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` = '5104'
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` = '5102'
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` = '5100'
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` = '5088'
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` = '5087'
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` = '5082'
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` = '5080'
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` = '5075'
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` = '5072'
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` = '5068'
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` = '5060'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5057'
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` = '5048'
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` = '5039'
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` = '5037'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5034'
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` = '5032'
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` = '5024'
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` = '5021'
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` = '5017'
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` = '5016'
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` = '5011'
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` = '5007'
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` = '5006'
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` = '4999'
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` = '4977'
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` = '120'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Martin Lategui Wins Event #4: €555 Pot-Limit Deuce to Seven Triple Draw (€6,300) Posted Monday 18th September, 2023 at 16:51(UTC+0) by Jason Glatzer
Uruguay's Martin Lategui (pictured above) crossed continents in order for a chance to win a World Series of Poker Circuit (WSOPC) gold ring at the 2023 World Series of Poker Circuit Tallinn at Olympic Park Casino and the Hilton Tallinn Park from Sept. 14-24.
On Monday afternoon, Lategui accomplished just that in the unique Event #4: €555 Pot-Limit Deuce to Seven Triple Draw. He agreed to a heads-up deal with Estonia's Aleksandr Arutjunov awarding each player €5,800 with still €500 to play for in addition to the coveted gold ring and an invitation to the $1 million Tournament of Champions Freeroll bracelet event during the 2024 WSOP in Las Vegas.
Lategui, who had the lead nearly from the start, nearly lost the heads-up battle but came from behind after dominating all day long to win the €6,300 top prize.
"The WSOP Circuit ring was important," Lategui said to OlyBet after his victory. "It was the most important part of the tournament. I love it. It was my first hope but hopefully not my last one."
This lowball affair is a popular event in Tallinn but relatively new to the World Series of Poker as this appears to be the first one of its kind for a WSOP Circuit ring event, especially in a pot-limit variety. The event attracted 45 runners for a €21,600 prize pool. Finland's Jari Lehtonen bubbled the event in seventh place before the start of the day with all final table members locking up a €1,300 payout.
Event #4: €555 PL 2-7 Triple Draw Final Table Results
Place
Player
Country
Prize
1
Martin Lategui
Uruguay
€6,300*
2
Aleksandr Arutjunov
Estonia
€5,800*
3
Petteri Kalenius
Finland
€3,650
4
Kimmo Kurko
Finland
€2,700
5
Juho Heiska
Finland
€1,850
6
Janne Nevalainen
Finland
€1,300
*Reflects heads-up deal.
Final Day Action
At the start of the day, it appeared that a player from Finland would win the title in front of a live-streamed audience at OlyBet.tv with four Finnish players out of the six final tablists including chip leader Juho Heiska (pictured below). However, as we are about to learn, the four Finns were the first four players to hit the rail.
Lategui, who began the day not too far behind Heiska, took the chip lead nearly straight out of the gate when his nine-high was better than ten-high to eliminate Janne Nevalainen in sixth place for €1,300.
The chip lead for Lategui was secure until heads-up play but the same wasn't the case for the start of the day chip leader Heiska who lost most of his stack playing aggressively against Arutjunov before dusting off the rest shortly after to hit the rail in fifth place for €1,850.
Two of the shorter-stack Finnish players faced off with Petteri Kalenius eliminating Kimmo Kurko in fourth place for €2,300 when his eight-high was stronger than his opponent's nine-high.
Lategui continued to build his chip lead until Kalenius fell into the opposite situation he had in eliminating Kurko. This time, it was Kalenius with the nine-high losing his entire stack to Arutjunov's eight-high.
Arutjunov (pictured above) inched up close to Lategui's stack for the lead after eliminating Kalenius. Originally, the winner was slated to go home with €7,350 with the runner-up banking €4,750. A deal was quickly made where each player was guaranteed at least €5,800 with the winner taking down €6,300, the coveted gold ring, and the $1 million Tournament of Champions Freeroll invitation.
The action was slow to start during the heads-up affair with both players adopting a limping strategy, which led to a couple of small lead changes. But that soon changed and Arutjunov managed to double up to a nearly 3:1 chip advantage before things began to fall apart.
Arutjunov lost back-to-back all-in pots with nine-high against eight-high and fell one player shy of WSOP glory.
Congratulations to Uruguay's Martin Lategui for becoming the latest ring winner at the 2023 World Series of Poker Circuit Tallinn. Stay tuned at OlyBet.tv as we cover all the ring events throughout the week.
Article author: Jason Glatzer Photo credits: Elena Kask
Aleksandr Arutjunov Eliminated in 2nd Place (€5,800) Posted Monday 18th September, 2023 at 15:32(UTC+0) by Jason Glatzer
Level 21: 10,000/25,000 Entries: 2/45
There were 220,000 in chips already in the pot preflop when Aleksandr Arutjunov (pictured below) drew one card to improve to off his ten-high and Martin Lategui held an even stronger hand in after drawing two cards.
Arutjunov fired out for 100,000. Lategui jammed his stack in. Arutjunov called off his stack of 451,000 and was eliminated in second place for €5,800 after both players checked the rest of the way down.
Massive congratulations to Uruguay's Martin Lategui for crossing continents to win a coveted WSOP Circuit gold ring along with the €6,300 top prize. Lategui will also have a chance to add a bracelet to his hardware collected thanks to earning an invitation to the $1 million Tournament of Champions Freeroll held in Las Vegas during the 2024 WSOP.
Stay tuned for a recap within the hour and check out the final table results below:
Place
Player
Country
Prize
1
Martin Lategui
Uruguay
€6,300*
2
Aleksandr Arutjunov
Estonia
€5,800
3
Jari Kalenius
Finland
€3,650
4
Kimmo Kurko
Finland
€2,700
5
Juho Heiska
Finland
€1,850
6
Janne Nevalainen
Finland
€1,300
*Reflects heads-up deal.
Player
Chips
Progress
Martin Lategui
1,125,000
511,000
Aleksandr Arutjunov
0
0
Lategui Doubles Into the Lead Posted Monday 18th September, 2023 at 15:23(UTC+0) by Jason Glatzer
Level 21: 10,000/25,000 Entries: 2/45
Aleksandr Arutjunov opened for 60,000 from the button with a beautiful starting hand . Martin Lategui (pictured below) woke up with an even more beautiful and three-bet to 180,000 from the big blind.
Both players stood pat before Lategui jammed his remaining 127,000 and Arutjunov called.
No cards were drawn the rest of the way by either player and Lategui doubled back into the chip lead.
Player
Chips
Progress
Martin Lategui
614,000
312,000
Aleksandr Arutjunov
511,000
312,000
Arutjunov Takes Big Lead Posted Monday 18th September, 2023 at 15:06(UTC+0) by Jason Glatzer
Level 20: 10,000/20,000 Entries: 2/45
Aleksandr Arutjunov limped the button before he called a raise to 60,000 by Martin Lategui from the big blind.
Both players exchanged two cards before Lategui continued for 60,000. Arutjunov called and both players exchanged one card. Lategui bet nearly the pot for 200,000. Arutjunov shoved over the top for 383,000.
Lategui tanked for a few minutes with . Eventually, Lategui folded. We might never know if he had the best hand as Arutjunov didn't show his cards and he had before drawing one card.
Player
Chips
Progress
Aleksandr Arutjunov
823,000
360,000
Martin Lategui
302,000
360,000
Lategui Back on Top Posted Monday 18th September, 2023 at 14:53(UTC+0) by Jason Glatzer
Level 20: 10,000/20,000 Entries: 2/45
In another limped pot, Martin Lategui drew three from the big blind before Aleksandr Arutjunov drew one from the button.
Lategui fired out for 20,000 and Arutjunov called before both players drew one card. A bigger bet of 60,000 followed.
Arutjunov called and exchanged one card after standing pat. Both players checked and Lategui was back with the chip lead after his proved to be good with Arutjunov mucking his hand.
Player
Chips
Progress
Martin Lategui
662,000
120,000
Aleksandr Arutjunov
463,000
120,000
Arutjunov Takes the Lead Posted Monday 18th September, 2023 at 14:42(UTC+0) by Jason Glatzer
Level 20: 10,000/20,000 Entries: 2/45
It shouldn't be a surprise if we have several heads-up lead changes with both players with nearly the same stack. Aleksandr Arutjunov (pictured below) did just that simply by taking down a couple of small limped pots to snag the chip lead for the first time at the final table.
Player
Chips
Progress
Aleksandr Arutjunov
583,000
40,000
Martin Lategui
542,000
40,000
Heads-Up Deal Agreed Posted Monday 18th September, 2023 at 14:38(UTC+0) by Jason Glatzer
Level 20: 10,000/20,000 Entries: 2/45
The final two players quickly agreed to a heads-up deal awarding each of them €5,800 with €500 and the coveted World Series of Poker Circuit gold ring still on the line.
Place
Old Payout
New Payout
1
€7,350
€6,300
2
€4,750
€5,800
Petteri Kalenius Eliminated in 3rd Place (€3,850) Posted Monday 18th September, 2023 at 14:35(UTC+0) by Jason Glatzer
Level 20: 10,000/20,000 Entries: 2/45
Petteri Kalenius opened with a pot-sized bet of 70,000 off a stack of 89,000. Aleksandr Arutjunov called from the small blind before drawing one card. Kalenius drew two cards and the rest of the chips went in.
Arutjunov stood pat with and Kalenius had a decision to make with his relatively strong before standing pat again.
Both players opted against drawing a card during the third draw hand. Arutjunov's eight-high was good and he was near even with chips with Uruguay's Martin Lategui entering heads-up action.
Meanwhile, congrats to Kalenius for an impressive third-place podium performance for €3,650.
Player
Chips
Progress
Martin Lategui
582,000
33,000
Aleksandr Arutjunov
543,000
118,000
Petteri Kalenius
0
0
Second Break Posted Monday 18th September, 2023 at 14:02(UTC+0) by Jason Glatzer
The final three players are on a 20-minute break. Blinds will increase to 10,000/20,000 when the action resumes.
Player
Chips
Progress
Martin Lategui
615,000
12,000
Aleksandr Arutjunov
425,000
66,000
Petteri Kalenius
85,000
54,000
Nine-Low Beast Ten-Low for Arutjunov Posted Monday 18th September, 2023 at 14:00(UTC+0) by Jason Glatzer
Level 19: 10,000/15,000 (15,000) Entries: 3/45
It has been entirely small ball during Level 19 including the following hand:
Petteri Kalenius limped from the small blind and drew two cards after Aleksandr Arutjunov (pictured below) checked back his option from the big blind before exchanging one card.
Both players drew one card on the second draw after checking. Kalenius check-called a min-bet of 15,000.
Arutjunov stood pat while Kalenius drew one card on the final draw. Kalenius maybe got away cheaply if he was willing to call a bet by Arutjunov as both players checked it down.
Arutjunov won the hand with the to win the pot with Kalenius falling a little shy of the best low hand with his .
Player
Chips
Progress
Martin Lategui
627,000
5,000
Aleksandr Arutjunov
359,000
40,000
Petteri Kalenius
139,000
45,000
Updated Chip Counts Posted Monday 18th September, 2023 at 13:47(UTC+0) by Jason Glatzer
Player
Chips
Progress
Martin Lategui
622,000
45,000
Aleksandr Arutjunov
319,000
73,000
Petteri Kalenius
184,000
60,000
Lategui Extends Lead Posted Monday 18th September, 2023 at 13:40(UTC+0) by Jason Glatzer
Level 18: 6,000/12,000 (12,000) Entries: 3/45
Petteri Kalenius opened for 25,000 from the button. Martin Lategui (pictured below) three-bet to 75,000 from the big blind and Kalenius called.
Lategai changed one while Kalenius stood pat. Kalenius with bet 75,000 before Lategui with check-jammed for the entire 199,000 Kalenius had in his stack.
Kalenius tanked for a minute before he laid down the best hand with two draws to go.
Player
Chips
Progress
Martin Lategui
667,000
194,000
Petteri Kalenius
124,000
89,000
Meet Ant Gokcek at the WSOPC Tallinn Posted Monday 18th September, 2023 at 13:33(UTC+0) by Jason Glatzer
Kimmo Kurko Eliminated in 4th Place (€2,700) Posted Monday 18th September, 2023 at 13:28(UTC+0) by Jason Glatzer
Level 18: 6,000/12,000 (12,000) Entries: 3/45
Petteri Kalenius limped from the small blind before the short-stacked Kimmo Kurko (pictured below) checked back his option from the big blind.
Both players drew two cards. Kalenius checked before he called a min-bet of 12,000 by Kurko.
Players requested one new card each. Kalenius led out for 22,000. Kurko went into the tank with 52,000 in his hand before he called. Both players stood pat on the final draw before Kalenius jammed. Kurko quickly called off his stack of 30,000.
Kurko turned over the nine-high with . Kalenius turned over a better eight-high with to win the pot and eliminate Kurko in fourth place for €2,700.
Player
Chips
Progress
Petteri Kalenius
213,000
76,000
Kimmo Kurko
0
0
Kurko in Jeopardy Posted Monday 18th September, 2023 at 13:18(UTC+0) by Jason Glatzer
Level 17: 5,000/10,000 (10,000) Entries: 4/45
Kimmo Kurko (pictured below) opened for 25,000 from under the gun. Aleksandr Arutjunov, who lost a few small pots leading up to this hand, called from the button as did Petteri Kalenius from the big blind.
Kalenius and Kurko drew two cards on the first draw while Arutjunov opted to exchange one card. Kalenius and Kurko checked before Arutjunov fired a pot-sized bet of 81,000 and won some chips back after both of his opponents folded.
Meanwhile, Kimmo Kurko is in jeopardy as the blinds went up shortly after this hand leaving him with just a six big blind stack.
Player
Chips
Progress
Aleksandr Arutjunov
246,000
63,000
Petteri Kalenius
137,000
62,000
Kimmo Kurko
76,000
32,000
Nine-High for Lategui Posted Monday 18th September, 2023 at 12:48(UTC+0) by Jason Glatzer
Level 16: 4,000/8,000 (8,000) Entries: 4/45
Aleksandr Arutjunov opened a few pots recently and went uncontested. Recently, he opened for 20,000 from under the gun and was called by Martin Lategui from the button.
Arutjunov drew one while Lategui opted to take two cards on the first draw. Both players checked before drawing one card each on the second draw. Arutjunov checked again with with one draw to come and Lategui with a stronger fired out for 40,000. Arutjunov went into the tank before he folded.
Player
Chips
Progress
Martin Lategui
473,000
16,000
Aleksandr Arutjunov
309,000
20,000
Meet Veikka Keto-Tokoi at the WSOPC Tallinn Posted Monday 18th September, 2023 at 12:42(UTC+0) by Jason Glatzer
Juho Heiska Eliminated in 5th Place (€1,850) Posted Monday 18th September, 2023 at 12:32(UTC+0) by Jason Glatzer
Level 16: 4,000/8,000 (8,000) Entries: 4/45
Aleksandr Arutjunov limped from the small blind before Juho Heiska jammed for 28,500 from the big blind. Arutjunov called and both players drew two cards on the first draw.
Arutjunov drew one card on the second draw and Heiska drew two cards. Arutjunov opted to stand pat and Heiska winced before exchanging two cards on the final draw.
Heiska drew well on his final draw and turned over . However, the start of the final table chip leader had to settle for the fifth-place prize of €1,850 after Arutjunov had a perfect eight with to take down the hand.
Player
Chips
Progress
Aleksandr Arutjunov
329,000
28,000
Juho Heiska
0
0
Video Recap From Day 4 Posted Monday 18th September, 2023 at 12:06(UTC+0) by Jason Glatzer
First Break Posted Monday 18th September, 2023 at 12:04(UTC+0) by Jason Glatzer
Players are on a 20-minute break. Blinds will increase to 4,000/8,000 when the action resumes.
Check out the chip counts of the final five below:
Player
Chips
Progress
Martin Lategui
489,000
1,000
Aleksandr Arutjunov
301,000
2,000
Jari Kalenius
199,000
0
Kimmo Kurko
108,000
1,000
Juho Heiska
28,500
0
Arutjunov Doubles Through Heiska Posted Monday 18th September, 2023 at 12:01(UTC+0) by Jason Glatzer
Level 15: 3,000/6,000 (6,000) Entries: 5/45
Juho Heiska opened for a min-raise from under the gun. Aleksandr Arutjunov three-bet to 39,000 and Heiska called.
Arutjunov stood pat while Heiska exchanged two cards on the first draw. About 30 seconds later, Arutjunov bet 45,000. Heiska tanked for close to a minute before he jammed for 138,000. Arutjunov called and players were freerolling two draws before the cards would be shown.
Heiska drew one after Arutjunov stood pat on the second draw and the second pattern took place on the final draw.
Unfortunately for Heiska, his last card wasn't a good one and his showdown hand would only be good against a bluff. Arutjunov wasn't snowing and won the hand with to double his stack and leave the start-of-the-day chip leader Heiska on fumes.
Heiska shared his thoughts in a playful manner that Arutjunov was happy with his nine-eight.
"Horrible hand, horrible hand, horrible hand," Heiska told Arutjunov after the hand. "You play tight for two days then you go after me with that. I draw one and you stand pat with that shit."
Player
Chips
Progress
Aleksandr Arutjunov
299,000
169,000
Juho Heiska
28,500
98,500
Eight-High for Kalenius Posted Monday 18th September, 2023 at 11:53(UTC+0) by Jason Glatzer
Level 15: 3,000/6,000 (6,000) Entries: 5/45
Juho Heiska opened for 15,000 from the cutoff and was called by Petteri Kalenius (pictured below) from the small blind.
Kalenius he drew one card and Heiska opted to take three new cards. Heiska continued his pre-draw aggression with a bet of 20,000 and Kalenius check-called.
Both players checked after exchanging one card each. Kalenius stood pat with while Heiska exchanged one card off his . Kalenius bet 50,000 and Heiska folded. While we didn't see Heiska's final hand he shared that his hand was "somthing medium."
Player
Chips
Progress
Jari Kalenius
249,000
88,000
Juho Heiska
127,000
102,000
Lategui Improves to the Nuts Posted Monday 18th September, 2023 at 11:29(UTC+0) by Jason Glatzer
Level 14: 2,000/5,000 (5,000) Entries: 5/45
Shortly after the start-of-the-day chip leader Juho Heiska narrowed the gap against current chip leader Martin Lategui (pictured below), and the duo recently got tangled up again in another sizeable pot.
The action began simply enough with Aleksandr Arutjunov opened for 11,000 with both Juho Heiska and Martin Lategui calling from the blind.
All three players drew two cards. Heiska led out with a donk-bet of 15,000. Lategui called and Arutjunov quickly folded.
Heiska drew one card and Lategui opted to take two cards on the second draw. Heiska bet 25,000 and Lategui snap-called. Heiska stood pat and Lategui opted to draw one card.
Lategui bet 60,000 after Heiska checked and his opponent went into the tank before tossing in a chip to call.
Heiska showed the but it didn't really matter at the end what he had as Lategui improved to the nuts on the final draw to win the pot with to win a juicy pot and extend his chip lead.
Player
Chips
Progress
Martin Lategui
490,000
126,000
Juho Heiska
229,000
113,000
Aleksandr Arutjunov
130,000
20,000
Queen on Final Draw Good Enough for Heiska Posted Monday 18th September, 2023 at 11:21(UTC+0) by Jason Glatzer
Level 14: 2,000/5,000 Entries: 5/45
Martin Lategui opened for 12,000 from under the gun and was called by Juho Heiska (pictured below) from the big blind. Heiska tossed away three broadway cards while Lategui drew one.
Heiska check-called a bet of 15,000 by Lategui before drawing two cards. Lategui drew one and bet 40,000. Heiska check-called and both players drew one card.
Both players checked. Lategui showed the for a bad final draw card. Heiska's final draw card was slightly better and he took down the pot to get back near the chip lead after his got the job done.
Player
Chips
Progress
Martin Lategui
364,000
49,000
Juho Heiska
342,000
47,000
Updated Chip Counts Posted Monday 18th September, 2023 at 11:14(UTC+0) by Jason Glatzer
Player
Chips
Progress
Martin Lategui
413,000
0
Juho Heiska
295,000
16,000
Jari Kalenius
161,000
12,000
Aleksandr Arutjunov
150,000
0
Kimmo Kurko
107,000
17,500
Janne Nevalainen Eliminated in 6th Place (€1,300) Posted Monday 18th September, 2023 at 11:10(UTC+0) by Jason Glatzer
Level 13: 2,000/4,000 (4,000) Entries: 5/45
Juho Heiska opened for 10,000 from the hijack before Janne Nevalainen (pictured below) three-bet to 36,000 from the cutoff. Martin Lategui called from the button and the rest of the table folded including Heiska.
Both players drew two cards before Nevalainen shoved his stack of 80,500. Lategui called and unlike hold'em and other flop games, there was no showdown yet as players still had two draws to go.
Nevalainen drew two while Lategui drew one on the second draw with one more draw to go. A minute or so passed by before Nevalainen stood pat. Lategui drew one card and it was a good one.
The Nevalainen stood pat with wasn't good enough as Lateguy drew to an eight to take the chip lead with .
Meanwhile, Nevalainen was the first player out at the final table and will go home with a min-cash of €1,300.
Player
Chips
Progress
Martin Lategui
413,000
127,000
Juho Heiska
311,000
6,000
Janne Nevalainen
0
0
Second Draw Does the Job for Arutjunov Posted Monday 18th September, 2023 at 10:58(UTC+0) by Jason Glatzer
Level 13: 2,000/4,000 Entries: 6/45
Martin Lategui was dealt a beautiful hand with and opened for 10,000 from under the gun. Aleksandr Arutjunov called from the button with and the rest of the table folded.
Despite his strong hand, Lategui opted to draw one and Arutjunov did the same. Both players checked and both drew one card on the second draw.
Arutjunov was ahead with and bet 20,000 after Lategui with checked. Lategui, who would have had one draw left if he called gave up on the hand and the sole Estonian remaining in Arutjunov took down the pot.
Player
Chips
Progress
Martin Lategui
286,000
8,000
Aleksandr Arutjunov
150,000
14,000
Final Table Photo by Elena Kask Posted Monday 18th September, 2023 at 10:53(UTC+0) by Jason Glatzer
Kalenius Draws to a Nine Posted Monday 18th September, 2023 at 10:52(UTC+0) by Jason Glatzer
Level 13: 2,000/4,000 Entries: 6/45
Juho Heiska opened from under the gun to 12,000 and was called by Petteri Kalenius (pictured below) from the button and Aleksandr Arutjunov from the big blind.
Heiska after drawing one card fired out for 25,000 with a king-high. Kalenius improved to a nine-high after his draw and jammed for 85,500. Arutjunov folded and Heiska went into the tank before also laying down his hand.
Player
Chips
Progress
Juho Heiska
305,000
24,500
Jari Kalenius
149,000
53,500
Aleksandr Arutjunov
136,000
13,000
Action Begins Posted Monday 18th September, 2023 at 10:39(UTC+0) by Jason Glatzer
Level 13: 2,000/4,000 Entries: 6/45
Cards are in the air on the stream for the final table of Event #4: €555 Pot-Limit Deuce to Seven Triple Draw.
You can follow all of the biggest hands in our blog while also watching the action play out at OlyBet.tv.
Best of luck for the final six for the coveted WSOP Circuit gold ring.
Welcome to the Final Table of Event #4: €555 Deuce to Seven Triple Draw Posted Monday 18th September, 2023 at 07:55(UTC+0) by Jason Glatzer
Welcome back to our coverage of the 2023 World Series of Poker Circuit (WSOPC) Tallinn at Olympic Park Casino and the adjoining Hilton Tallinn Park.
After the first two WSOPC gold rings were awarded on Sunday, two more will be earned on Monday including in the two-day Event #4: €555 Pot-Limit Deuce to Seven Triple Draw. This was a rare chance for mixed-game enthusiasts to earn a WSOPC ring.
Sunday witnessed 45 runners get into the action to create a €21,600 prize pool. The Day 1 action on Sunday played down to the money after Finland's Jari Lehtonen hit the rail on the bubble in a hand against fellow Finn and occasionally streaming buddy Juho Heiska (pictured above) to end the day.
The remaining six players are in the money for at least a €1,300 min-cash with a €7,350 top prize on the line when the action resumes at 12 p.m. on Monday. The action will be live-streamed at OlyBet.tv with hole cards exposed giving you an excellent chance to see how this game is played firsthand. Of course, we will also be updating the biggest hands and action in our blog throughout the final day.
The tournament boasts 25-minute blind levels throughout the event with the action on Day 2 starting at Level 16 with blinds at 4,000/8,000. Heiska leads the way entering the final day after parlaying his initial 25,000 chip stack into 329,500. Three other Finnish players are also in contention in Janne Nevalainen (132,500), Kimmo Kurko (124,500), and Jari Kalenius (95,500).
Uruguay's Martin Lategui (pictured below) enters the final table in second place with 294,000, while Estonia has a shot at winning its second title on home soil with Aleksandr Arutjunov in the middle of the pack with 149,000.
Event #3 Final Table Seat Draw
Seat
Player
Country
Chips
Big Blinds
1
Juho Heiska
Finland
329,500
41
2
Janne Nevalainen
Finland
132,500
17
3
Martin Lategui
Uruguay
294,000
37
4
Petteri Kalenius
Finland
95,500
12
5
Kimmo Kurko
Finland
124,500
16
6
Aleksandr Arutjunov
Estonia
149,000
19
Event #3 Final Table Payouts
Place
Prize
1
€7,350
2
€4,750
3
€3,650
4
€2,700
5
€1,850
6
€1,300
Basic Rules to Deuce to Seven Triple Draw
Duece to seven triple draw is just how it sounds. It is a lowball game where players can draw cards three times.
Players are dealt five cards. A round of betting takes place with more rounds of betting occurring after each round of discards. The players with the best low hand wins with flushes and straights counting as high with an ace also being high.
The best possible hand is with at least more than one suit with coming in as the second best hand.
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.