0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0062 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1'
ORDER BY `views` DESC
0.0085 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1'
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.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` = 'page'
0.0064 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_event1'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '28'
0.0255 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '97'
AND `published` = 1
0.0261 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` = '106'
AND `published` = 1
0.0253 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0051 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '111'
AND `published` = 1
0.0253 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '112'
AND `published` = 1
0.0320 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0050 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '113'
AND `published` = 1
0.0257 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` = '115'
AND `published` = 1
0.0001 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '115'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '28'
AND `name` = '3'
0.0056 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '115'
ORDER BY `busted` ASC, `current_chips` DESC
0.0053 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` = '115'
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` = '4912'
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` = '4904'
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` = '4902'
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` = '4901'
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` = '4900'
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` = '4898'
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` = '4892'
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` = '4887'
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` = '4885'
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` = '4883'
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` = '4873'
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` = '4872'
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` = '4870'
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` = '4868'
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` = '4864'
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` = '4862'
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` = '4861'
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` = '4857'
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` = '4854'
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` = '4851'
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` = '4848'
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` = '4847'
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` = '4846'
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` = '4843'
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` = '4838'
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` = '4835'
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` = '4834'
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` = '4831'
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` = '4830'
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` = '4827'
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` = '4824'
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` = '4815'
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` = '4814'
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` = '115'
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_id` = '115'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '4912'
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` = '4904'
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` = '4902'
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` = '4901'
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` = '4900'
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` = '4898'
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` = '4892'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4887'
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` = '4885'
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` = '4883'
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` = '4873'
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` = '4872'
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` = '4870'
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` = '4868'
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` = '4864'
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` = '4862'
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` = '4861'
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` = '4857'
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` = '4854'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4851'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4848'
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` = '4847'
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` = '4846'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4843'
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` = '4838'
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` = '4835'
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` = '4834'
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` = '4831'
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` = '4830'
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` = '4827'
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` = '4824'
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` = '4815'
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` = '4814'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '115'
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.
Viacheslav Sultanov Wins Event #1: €555 No-Limit Hold'em (€34,435) Posted Sunday 17th September, 2023 at 15:19(UTC+0) by Jason Glatzer
The first of 12 gold rings of the inaugural World Series of Poker Circuit (WSOPC) Tallinn was awarded on Sunday afternoon after Ukraine's Viacheslav Sultanov (pictured above) won all the chips in Event #1: €555 No-Limit Hold'em.
Sultanov, who took a huge bad beat near the end of Day 2 when his aces got in against kings and jacks only for the kings improved to trips, began the live-streamed final table at OlyBet.tv with GGPoker Ambassador Anatoly Filatov firmly on the rail in the middle of the pack but had a short lead when agreeing to a heads-up deal with Lukasz Fraczek with €3,500 left to play for along with the ring resulting in Sultanov earning €34,435 and Frazcek €29,825.
Event #1: €555 No-Limit Hold'em Final Table Results
Event #1: €555 No-Limit Hold'em attracted 382 entries to create a €183,360 prize pool. Check out all of the final table results below:
Place
Player
Country
Prize
1
Viacheslav Sultanov
Ukraine
€34,435*
2
Lukasz Fraczek
Poland
€29,825*
3
Torbjorn Larsen
Norway
€17,750
4
Rasmus Lundstrom
Finland
€12,650
5
Georgios Skarparis
Cyprus
€9,300
6
Aleksi Naski
Finland
€7,100
7
Charles-Eric Benoit
Canada
€5,800
8
Rimantas Boguzas
Lithuania
€4,900
9
Ryan Mandara
United Kingdom
€4,150
Final Day Action
The final day began with Finland's Rasmus Lundstrom and Torbojn Larsen on the top of the pack with eventual winner Sultanov in the thick of things.
Sultanov was at it right away by eliminating the shortest stack at the table in United Kingdom's Ryan Mandara (pictured below) in ninth place for €4,150 when his king-ten won a flip against sixes.
Not too much later, Sultanov was back at it again. Lithuania's Rimantas Boguzas (eighth - €4,900) effectively jammed a short stack with king-ten and was called by Sultanov with queen-jack suited. Boguzas flopped the top two pair but didn't improve further against Sultanov's flopped straight.
During this time, the lead was bouncing back and forth between Lundstrom and Larsen until the duo collided in a big pot to give Lundstrom a clear chip lead. Larsen got some chips back when his ace-jack proved to be good against ace-nine suited to oust Canada's Charles-Eric Benoit in seventh place for €5,800.
Finland's Aleksi Naski's impressive run was over in sixth place for €7,100 when he unsuccessfully jammed jack-nine suited into Fraczek's queens. Fraczek was near the chip lead after the hand but it was Lundstrom who came storming back by cracking the aces held by Cyprus' Georgios Skarparis before getting a bluff through against Larsen.
Sultanov was back at it again by eliminating his third short stack at the final table. This time around he won a flip with ace-five against deuces to send Skarparis to the showers in fifth place for €9,300.
The dynamics of the final table quickly changed after that. Fraczek three-bet shoved his queens. Lundstrom had a huge decision to make for a lion's share of his stack with king-queen and found a call. The queens held and Fraczek took his first lead at the final table.
Lundstrom (pictured below) then went from hero to zero as shortly after losing most of his stack he lost the rest to hit the rail in fourth place for €12,650 when his jack-nine didn't get there against Sultanov's ace-ten suited.
It didn't take long to get to the heads-up action from there as just a few hands later Fraczek eliminated Larsen in third place for €17,750 when Larsen's short-stacked shove with ace-ten didn't hold against eight-seven.
Sultanov had a marginal lead to start heads-up play and the duo agreed to a deal just a few hands into the action to reduce heads-up variance.
The action resumed and before long a monster pot developed that more-or-less determined the winner. Fraczek (pictured above) opened with ace-queen and Sultanov defended his big blind with king-jack. Sultanov flopped the top two pair and called a bet by Fraczek. Fraczek still didn't connect with the board and committed himself to an untimely overjam. A brick came on the river and Sultanov was crowned the champion.
Congratulations to Ukraine's Viacheslav Sultanov for becoming the first 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
Meet Kelly Kellner Posted Sunday 17th September, 2023 at 14:16(UTC+0) by Jason Glatzer
Kelly Kellner traveled from Western Canada to attend the WSOP Circuit Tallinn. Check out what he had to say in the video below:
Final Table Payouts Posted Sunday 17th September, 2023 at 14:12(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
Viacheslav Sultanov
Ukraine
€34,435*
2
Lukasz Fraczek
Poland
€29,825*
3
Torbjorn Larsen
Norway
€17,750
4
Rasmus Lundstrom
Finland
€12,650
5
Georgios Skarparis
Cyprus
€9,300
6
Aleksi Naski
Finland
€7,100
7
Charles-Eric Benoit
Canada
€5,800
8
Rimantas Boguzas
Lithuania
€4,900
9
Ryan Mandara
United Kingdom
€4,150
*Reflects heads-up deal at the final table.
Lukasz Fraczek Eliminated in 2nd Place (€29,825) Posted Sunday 17th September, 2023 at 14:11(UTC+0) by Jason Glatzer
Level 31: 75,000/150,000 (150,000) Entries: 2/382
Just after Lukasz Fraczek (pictured below) doubled, Viacheslav Sultanov (pictured above with GGPoker Ambassador Anatoly Filatov) jammed the button. Fraczek called off his stack of seven big blinds and was at risk.
Lukasz Fraczek: Viacheslav Sultanov:
Fraczek was behind but still had some hope with two live cards. However, most of his hopes and prayers were dashed after Sultanov nailed two pair on the flop. Fraczek was drawing dead on the turn and hit the rail in second place for €29,825.
Meanwhile, a huge congrats to Viacheslav Sultanov for winning WSOP Circuit Tallinn Event #1: €555 No-Limit Hold'em.
Stay tuned for the recap of the final day of Event #1 and in the meantime check out our coverage of the final table of Event #2: €1,100 No-Limit Hold'em.
Fraczek Doubles His Short Stack Posted Sunday 17th September, 2023 at 14:03(UTC+0) by Jason Glatzer
Level 31: 75,000/150,000 (150,000) Entries: 2/382
Lukasz Fraczek (pictured below) jammed the button for 500,000 and Viacheslav Sultanov called from the big blind.
Lukasz Fraczek: Viacheslav Sultanov:
Fraczek was ahead when the chips were committed and pulled far ahead after his king connected on the flop. The turn and river completed the board for Fraczek to double his short stack.
Player
Chips
Progress
Viacheslav Sultanov
10,300,000
700,000
Lukasz Fraczek
1,200,000
700,000
Sultanov Takes Massive Lead With Two Pair Posted Sunday 17th September, 2023 at 14:00(UTC+0) by Jason Glatzer
Level 31: 75,000/150,000 (150,000) Entries: 2/382
Viacheslav Sultanov (pictured below) opened for a min-raise on the button. Lukasz Fraczek, who recently took a small chip lead, three-bet to 1,150,000 from the big blind and Sultanov called.
Fraczek paused for a couple of minutes on the flop before continuing for 700,000 and Sultanov called. More tanking by Fraczek came on the turn before he opted to jam his 4,100,000 stack. Sultanov made the call and Fraczek was in a bit of trouble.
Lukasz Fraczek: Viacheslav Sultanov:
Sultanov slow-played his two-pair and got Fraczek to get his stack in thin for the majority of the chips in play. The river paired the board and Sultanov had the majority of chips in play after the hand.
Player
Chips
Progress
Viacheslav Sultanov
11,000,000
5,100,000
Lukasz Fraczek
500,000
5,100,000
Wheel for Fraczek Posted Sunday 17th September, 2023 at 13:48(UTC+0) by Jason Glatzer
Level 31: 75,000/150,000 (150,000) Entries: 2/382
Viacheslav Sultanov won a few uncontested pots before he opened for 300,000 with from the button. Lukasz Fraczek defended with from the big blind.
Fraczek improved to the nuts with the flop improving him to a wheel and check-called a bet of 250,000 by Sultanov.
The turn improved Sultanov to a pair and Fraczek checked again. Sultanov fired out for 700,000 and Fraczek tanked for about a minute before he called. The river completed the board. Both players checked and Fraczek managed to gain some chips back.
Player
Chips
Progress
Viacheslav Sultanov
5,900,000
200,000
Lukasz Fraczek
5,600,000
200,000
Video Highlights From Day 3 Posted Sunday 17th September, 2023 at 13:37(UTC+0) by Jason Glatzer
Check out the highlights of the 2023 WSOPC Tallinn at Olympic Park Casino and the Hilton Tallinn Park below:
Deal Agreed Posted Sunday 17th September, 2023 at 13:34(UTC+0) by Jason Glatzer
Level 31: 75,000/150,000 (150,000) Entries: 2/382
Both players locked up €25,750 and were playing for €38,510. Viacheslav Sultanov and Lukasz Fraczek played a few heads-up hands before they discussed a deal.
A couple of minutes later, the duo agreed to a deal guaranteeing Sultanov €30,395 and Fraczek €29,825 with still €3,500 to and the coveted WSOP Circuit gold ring to be played for.
Player
Chips
Progress
Viacheslav Sultanov
6,100,000
100,000
Lukasz Fraczek
5,400,000
100,000
Torbjorn Larsen Eliminated in 3rd Place (€17,750) Posted Sunday 17th September, 2023 at 13:30(UTC+0) by Jason Glatzer
Level 31: 75,000/150,000 (150,000) Entries: 2/382
Torbjorn Larsen (pictured below) jammed his four big blind stack from the small blind and was called by Lukasz Fraczek from the big blind.
Torbjorn Larsen: Lukasz Fraczek:
Larsen stayed ahead on the flop. However, Fraczek paired up on the turn to take the lead and won the hand with an even better pair after his eight found a friend on the river.
It was a great run for Larsen who began the day inches behind Rasmus Lundstrom for the chip lead. While he won't earn a coveted WSOPC gold ring, he will go home with a healthy third-place podium prize of €17,750.
Meanwhile, both Viacheslav Sultanov and Fraczek are just a handful of big blinds apart to start the heads-up battle.
Player
Chips
Progress
Viacheslav Sultanov
6,000,000
800,000
Lukasz Fraczek
5,500,000
300,000
Torbjorn Larsen
0
0
First Break Posted Sunday 17th September, 2023 at 12:58(UTC+0) by Jason Glatzer
Players are on a 20-minute break. The blinds will increase to 100,000/200,000 with a 200,000 big blind ante when the action resumes. In the meantime, check out the final table payouts as they stand at the break below.
Place
Player
Country
Prize
1
€38,510
2
€25,750
3
€17,750
4
Rasmus Lundstrom
Finland
€12,650
5
Georgios Skarparis
Cyprus
€9,300
6
Aleksi Naski
Finland
€7,100
7
Charles-Eric Benoit
Canada
€5,800
8
Rimantas Boguzas
Lithuania
€4,900
9
Ryan Mandara
United Kingdom
€4,150
Tens Good for Sultanov Posted Sunday 17th September, 2023 at 12:58(UTC+0) by Jason Glatzer
Level 30: 50,000/125,000 (125,000) Entries: 3/382
Viacheslav Sultanov (pictured below) opened for a min-raise from the button with and was called by Lukasz Fraczek with from the big blind.
Fraczek flopped top pair but was still behind when he check-called a bet by Sultanov on the flop with an overpair for 400,000.
Both players checked the turn and again on the river for Sultanov to win the hand just before the first break.
After the hand, Fraczek and Sultanov were tied for the chip lead.
Player
Chips
Progress
Viacheslav Sultanov
5,200,000
700,000
Lukasz Fraczek
5,200,000
500,000
Rasmus Lundstrom Eliminated in 4th Place (€12,650) Posted Sunday 17th September, 2023 at 12:53(UTC+0) by Jason Glatzer
Level 30: 50,000/125,000 (125,000) Entries: 3/382
Rasmus Lundstrom (pictured below) was the hero most of the final day but just hit the rail at the final table in fourth place for €12,650.
Lundstrom jammed for 1.4 million from the small blind and was called by Viacheslav Sultanov from the big blind.
Rasmus Lundstrom: Viacheslav Sultanov:
Lundstrom had two live cards but needed some help. None was on the way with the completing the board.
Player
Chips
Progress
Viacheslav Sultanov
4,500,000
2,200,000
Rasmus Lundstrom
0
0
Fraczek Takes Huge Lead After Doubling Through Lundstrom Posted Sunday 17th September, 2023 at 12:43(UTC+0) by Jason Glatzer
Level 30: 50,000/125,000 (125,000) Entries: 4/382
Rasmus Lundstrom held the chip lead but after the following hand was down to just a little more than a dozen big blinds while handing Lukasz Fraczek (pictured below) a huge chip lead.
Lundstrom opened from under the gun for a min-raise before Fraczek three-bet shoved from the big blinds. Lundstrom tanked for more than a minute before he found a call.
Rasmus Lundstrom: Lukasz Fraczek:
Fraczek was at risk but in good shape to double his stack. It was over before it began after the case queen improved Fraczek to a set on the flop. Lundstrom was drawing dead on the turn and Fraczek catapulted into the chip lead after the river completed the board.
Player
Chips
Progress
Lukasz Fraczek
5,700,000
2,700,000
Rasmus Lundstrom
1,900,000
2,800,000
Georgios Skarparis Eliminated in 5th Place (€9,300) Posted Sunday 17th September, 2023 at 12:36(UTC+0) by Jason Glatzer
Level 30: 50,000/125,000 (125,000) Entries: 4/382
Georgios Skarparis (pictured below) jammed his short stack of 665,000 from under the gun and was called by Viacheslav Sultanov for nearly half his stack from the big blind.
Georgios Skarparis: Viacheslav Sultanov:
Skarparis was ahead on the flip after both the flop and the turn. However, the river put a straight on the board. Unfortunately for Skarparis, there was no chop as Sultanov improved to an even better straight to Broadway and eliminated Skarparis in fifth place for €9,300.
Player
Chips
Progress
Viacheslav Sultanov
2,300,000
300,000
Georgios Skarparis
0
0
Lundstrom Steals One From Larsen to Extend Lead Posted Sunday 17th September, 2023 at 12:32(UTC+0) by Jason Glatzer
Level 30: 50,000/125,000 (125,000) Entries: 5/382
Torjborn Larsen opened for a min-raise from the button with and was called by Rasmus Lundstrom (pictured below) with from the big blind.
Neither player found love on the flop. Larsen still with the best hand bet 325,000 after Lundstrom checked. Lundstrom called to see the turn.
Both players checked and the river paired the board. Larsen quickly reached for chips and bet 550,000. Larsen tanked for a few moments before folding the best hand for Lundstrom to extend his chip lead.
Player
Chips
Progress
Rasmus Lundstrom
4,700,000
1,000,000
Torbjorn Larsen
1,700,000
1,100,000
12:28 (UTC+0)
Start of Level 30 Blinds: 60,000/120,000 Ante: 120,000
Lundstrom Cracks Skarparis's Rockets Posted Sunday 17th September, 2023 at 12:22(UTC+0) by Jason Glatzer
Level 29: 50,000/100,000 (100,000) Entries: 5/382
Ryan Lundstrom min-raised the button with and was called by Georgios Skarparis with from the big blind. Both players checked the flop before some action came on after Lundstrom improved to a full house on the turn.
Skarparis led out for 135,000 and Lundstrom called. The river completed the board. Both players checked again and Lundstrom took down the pot to extend the chip lead.
Despite the bad beat, Skarparis staved off elimination as he could have easily three-bet preflop or driven more action postflop with the best starting hand in poker.
Player
Chips
Progress
Rasmus Lundstrom
3,700,000
500,000
Georgios Skarparis
1,200,000
200,000
Skarparis Doubles Through Sultanov Posted Sunday 17th September, 2023 at 12:17(UTC+0) by Jason Glatzer
Level 29: 50,000/100,000 (100,000) Entries: 5/382
Viacheslav Sultanov opened from under the gun with a min-raise. Georgios Skarparis (pictured below), who was easily the short stack with just 5.5 big blinds, three-bet shoved from the cutoff for 550,000. Sultanov called and Skarparis was in decent shape to double his stack.
Georgios Skarparis: Viacheslav Sultanov:
There was no drama early on with Skarparis nailing a set on the flop. However, there was a small possibility he could be eliminated after the turn gave Sultanov a gutshot to the wheel.
The blank river completed the board and for Skarparis to stay alive and double his stack.
Player
Chips
Progress
Viacheslav Sultanov
2,000,000
100,000
Georgios Skarparis
1,400,000
600,000
Aleksi Naski Eliminated in 6th Place (€7,100) Posted Sunday 17th September, 2023 at 12:09(UTC+0) by Jason Glatzer
Level 29: 50,000/100,000 (100,000) Entries: 5/382
Aleksi Naski (pictured below) open-jammed for 525,000 from the button. Lukasz Fraczek tanked for a minute before he three-bet shoved for 1,700,000 from the small blind. Rasmus Lundstrom folded in the big blind before Naski and Fraczek turned over their cards with Naski at risk and in for a world of hurt.
Aleksi Naski: Lukasz Fraczek:
Naski had a sliver of hope after the flop as an eight would improve him to a straight. Neither the turn nor the river did the job for Naski and he was eliminated by Fraczek in sixth place for €7,100.
Player
Chips
Progress
Rasmus Lundstrom
3,200,000
100,000
Lukasz Fraczek
3,000,000
900,000
Aleksi Naski
0
0
12:03 (UTC+0)
Start of Level 29 Blinds: 50,000/100,000 Ante: 100,000
Updated Payouts Posted Sunday 17th September, 2023 at 12:02(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
€38,510
2
€25,750
3
€17,750
4
€12,650
5
€9,300
6
€7,100
7
Charles-Eric Benoit
Canada
€5,800
8
Rimantas Boguzas
Lithuania
€4,900
9
Ryan Mandara
United Kingdom
€4,150
Charles-Eric Benoit Eliminated in 7th Place (€5,800) Posted Sunday 17th September, 2023 at 11:56(UTC+0) by Jason Glatzer
Level 28: 40,000/80,000 (80,000) Entries: 6/382
Shortly after coughing up the chip lead, Torjborn Larsen woke up with a hand and min-raised from the cutoff. Day 1c chip leader Charles-Eric Benoit (pictured below) three-bet shoved for 1,135,000. Larsen tanked for a few moments before he called.
Charles-Eric Benoit: Torjborn Larsen:
Benoit needed some help to get his ace-nine suited ahead of Larsen's ace-jack. The flop made matters worse for Benoit with Larsen improving to a pair. Benoit was drawing dead after the turn and officially hit the rail in seventh place for €5,800 after the river completed the board.
Player
Chips
Progress
Torbjorn Larsen
2,800,000
1,200,000
Charles-Eric Benoit
0
0
Lundstrom Regains the Chip Lead Posted Sunday 17th September, 2023 at 11:51(UTC+0) by Jason Glatzer
Level 28: 40,000/80,000 (80,000) Entries: 7/382
Rasmus Lundstrom min-raised with from the button and was called by Torjborn Larsen with from the big blind.
Lundstrom pulled out ahead in the flip after connecting with his king for a better two-pair than Larsen.
Both players checked and Lundstrom improved to an even better two-pair on the turn. Larsen checked again but this time Lundstrom fired out 255,000. Larsen called to see the river.
Larsen checked again before Lundstrom bet 425,000. Larsen paused for a few moments before he called. Lindstrom regained the chip lead after the hand.
Player
Chips
Progress
Rasmus Lundstrom
3,300,000
700,000
Torbjorn Larsen
1,600,000
1,100,000
Rimantas Boguzas Eliminated in 8th Place (€4,900) Posted Sunday 17th September, 2023 at 11:42(UTC+0) by Jason Glatzer
Level 28: 40,000/80,000 (80,000) Entries: 7/382
Former Lithuanian goalkeeper Rimantas Boguzas bet 250,000 leaving just 80,000 behind from early position. Viacheslav Sultanov put Boguzas in for the rest from the big blind and the cards were turned over.
Rimantas Boguzas: Viacheslav Sultanov:
The landed on the flop giving a huge cooler to Boguzas who would have likely gotten more chips in if he had them with top two pair. The problem was, the Sultanov flopped the stone-cold nuts with a straight.
Neither the turn nor the river saved Boguzas and he exited in eighth place for €4,900.
Player
Chips
Progress
Viacheslav Sultanov
1,900,000
300,000
Rimantas Boguzas
0
0
11:37 (UTC+0)
Start of Level 28 Blinds: 40,000/80,000 Ante: 80,000
Fraczek Turns the Nuts Posted Sunday 17th September, 2023 at 11:36(UTC+0) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 8/382
The hand began simply enough with Lukasz Fraczek (pictured below) limping from the small blind with and Charles-Eric Benoit with opting to check back his option from the big blind.
Both players snagged something on the flop. Fraczek min-bet his open-ended straight draw for 60,000 and Benoit called with an open-ended straight draw.
"This can be ugly," the commentators said after the turn as this gave Benoit an open-ender but he was drawing only to a chop against Fraczek's made straight.
Fraczek bet out for 125,000 and Benoit called. The blank river completed the board. Fraczek held the nuts and fired out for 400,000. Benoit tanked for about a minute before he called only to get the bad news.
Player
Chips
Progress
Lukasz Fraczek
2,100,000
700,000
Charles-Eric Benoit
695,000
705,000
Larsen Snags the Chip Lead Posted Sunday 17th September, 2023 at 11:28(UTC+0) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 8/382
Rasmus Lundstrom and Torjborn Larsen entered the final table just a few big blinds apart. Therefore it didn't take much for Larsen to take the chip lead for the first lead change at the final table.
Lundstrom opened for 120,000 with from the hijack and was called by Georgios Skarparis from the button with before Larsen three-bet to 355,000 with from the big blind. Both players folded and that is all it took for Larsen to snag the chip lead.
Player
Chips
Progress
Torbjorn Larsen
2,700,000
255,000
Rasmus Lundstrom
2,600,000
45,000
Viacheslav Sultanov
1,600,000
200,000
Charles-Eric Benoit
1,400,000
0
Lukasz Fraczek
1,400,000
240,000
Aleksi Naski
875,000
120,000
Georgios Skarparis
800,000
120,000
Rimantas Boguzas
185,000
30,000
Skarparis Cracks Boguzas's Big Slick Posted Sunday 17th September, 2023 at 11:17(UTC+0) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 8/382
Georgios Skarparis (pictured below) jammed for 430,000 from the small blind and was snap-called by Rimantas Bogus from the big blind.
Georgios Skarparis: Rimantas Boguzas:
Skarparis was behind but did have two live cards with queen-five against Boguzas’s big slick.
A five connected with Skarparis straight away on the flop but he wasn’t out of the woods yet especially after the turn gave Boguzas more outs to a flush.
However, the river was blank for Boguzas and he was short on chips after doubling up Skarparis.
Player
Chips
Progress
Georgios Skarparis
920,000
370,000
Rimantas Boguzas
215,000
340,000
Ryan Mandara Eliminated in 9th Place (€4,150) Posted Sunday 17th September, 2023 at 11:05(UTC+0) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 9/382
Viacheslav Sultanov opened for a min-raise from the hijack before the short-stacked Ryan Mandara (pictured below) jammed his three big blinds from the cutoff.Sultanov called for one big blind more and the cards were turned over.
Ryan Mandara: Viacheslav Sultanov:
Mandara was flipping for his tournament life. It was looking grim for Mandara after Sultanov connected with his ten on the flop. Neither the turn nor the river helped Mandara while Sultanov improved even further to an unnecessary two-pair. Although Mandara didn’t last long today, he will notch a decent cash in his first WSOP Circuit Tallinn event after collecting the ninth-place prize of €4,150 just a few hands into the action.
Player
Chips
Progress
Viacheslav Sultanov
1,400,000
285,000
Ryan Mandara
0
0
Action About to Begin Posted Sunday 17th September, 2023 at 10:51(UTC+0) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 9/382
Cards are about to be in the air for the final table of Event #1: €555 No-Limit Hold'em. Tournament Director Teresa Nousiainen (pictured below) was announcing the players with the action beginning with Level 27 with blinds at 30,000/60,000 along with a 60,000 big blind ante.
Event #1 Final Table Begins at 12 p.m. Posted Sunday 17th September, 2023 at 07:52(UTC+0) by Jason Glatzer
Sunday will be a huge day for the World Series of Poker Circuit (WSOPC) Tallinn as the festival will be awarding the first two gold rings of the festival.
Both Event #1: €555 No-Limit Hold'em and Event #2: €1,100 No-Limit Hold'em are both down to their final tables. You will be able to follow the action on the live stream on a 30-minute delay. The main focus will be Event #1 which we will also be covering the biggest final table hands in this blog as the winner will be crowned at the televised feature table exclusively at OlyBet.tv. The final table for Event #2 will also be covered in detail in our other blog for the day. While no hole cards will be shown early on, you will also get some snippets from this event on the live stream as well.
Torbjorn Larsen (pictured above) will kick off the final table of nine players in Event #1 as the table captain with 2,445,000 in chips. Larsen will be joined by Lukasz Fraczek (1,640,000), Day 1c chip leader Charles-Eric Benoit (1,400,000), Viacheslav Sultanov (1,115,000), Aleksi Naski (995,000), Rimantas Boguzas (555,000), Rasmus Lundstrom (555,000), Georgios Skarparis (550,000), and Ryan Mandara (210,000) in the quest for the title and the €38,510 top prize with at least the ninth-place prize of €4,150 already locked up.
As a cool twist, all nine final table members are from eight different countries. And this is without the home country of Estonia having a single representative at the table. Time will tell which of these players will win the coveted first WSOPC gold ring in what promises to be an exciting conclusion.
Blinds will start at 30,000/60,000 with a 60,000 big blind ante when the final table commences at noon on Sunday and increase every 30 minutes until a winner is crowned.
Check out the final table seat draw and the final table payouts below:
Final Table Seat Draw
Seat
Player
Country
Chips
Big Blinds
1
Aleksi Naski
Finland
995,000
17
2
Lukasz Fraczek
Poland
1,640,000
27
3
Charles-Eric Benoit
Canada
1,400,000
23
4
Rasmus Lundstrom
Finland
555,000
9
5
Viacheslav Sultanov
Ukraine
1,115,000
19
6
Ryan Mandara
United Kingdom
210,000
4
7
Georgios Skarparis
Cyprus
550,000
9
8
Rimantas Boguzas
Lithuania
555,000
9
9
Torbjorn Larsen
Norway
2,445,000
41
Final Table Payouts
Place
Prize
1
€38,510
2
€25,750
3
€17,750
4
€12,650
5
€9,300
6
€7,100
7
€5,800
8
€4,900
9
€4,150
07:36 (UTC+0)
Day 3 of WSOPC Tallinn Started Level: 27 Blinds: 30,000/60,000 Ante: 60,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.