0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0064 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/3/updates'
ORDER BY `views` DESC

0.0775 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/3/updates'

0.0004 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'

0.0003 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'

0.0003 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'

0.0003 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'

0.0004 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.0003 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0007 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0005 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.0004 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0020 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.0006 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.0070 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.0007 SECONDS: 
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'wsopctallinn_2023_event6'

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

0.0282 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0608 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '102'
AND `published` = 1

0.0950 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0090 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '125'
AND `published` = 1

0.0234 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` = '129'
AND `published` = 1

0.0743 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` = '130'
AND `published` = 1

0.0233 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0053 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '132'
AND `published` = 1

0.0798 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0106 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '135'
AND `published` = 1

0.0831 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` = '138'
AND `published` = 1

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'
AND `name` = '3'

0.0055 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '135'
ORDER BY `busted` ASC, `current_chips` DESC

0.0055 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` = '135'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

0.0559 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5955'
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` = '5952'
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` = '5941'
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` = '5946'
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` = '5932'
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` = '5943'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5929'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5940'
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` = '5923'
ORDER BY `chip_change` DESC, `busted` ASC

0.0563 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5921'
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` = '5925'
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` = '5914'
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` = '5915'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5909'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5903'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5910'
ORDER BY `chip_change` DESC, `busted` ASC

0.0049 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5907'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5906'
ORDER BY `chip_change` DESC, `busted` ASC

0.0559 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5894'
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` = '5892'
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` = '5897'
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` = '5887'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5884'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5879'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5878'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5875'
ORDER BY `chip_change` DESC, `busted` ASC

0.0671 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5873'
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` = '5871'
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` = '5870'
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` = '5867'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5863'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5860'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5857'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5854'
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` = '5849'
ORDER BY `chip_change` DESC, `busted` ASC

0.0568 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5846'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5844'
ORDER BY `chip_change` DESC, `busted` ASC

0.0109 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5843'
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` = '5839'
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` = '5835'
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` = '5833'
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` = '5832'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5829'
ORDER BY `chip_change` DESC, `busted` ASC

0.0564 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5828'
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` = '5827'
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` = '5826'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5825'
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` = '5822'
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` = '5819'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5818'
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` = '5814'
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` = '5812'
ORDER BY `chip_change` DESC, `busted` ASC

0.0564 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5804'
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` = '5802'
ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '135'
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_id` = '135'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0055 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5975'
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` = '5955'
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` = '5952'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5941'
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` = '5946'
ORDER BY `chip_change` DESC, `busted` ASC

0.0570 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5932'
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` = '5943'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5929'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5940'
ORDER BY `chip_change` DESC, `busted` ASC

0.0049 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5923'
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` = '5921'
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` = '5925'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5914'
ORDER BY `chip_change` DESC, `busted` ASC

0.0570 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5915'
ORDER BY `chip_change` DESC, `busted` ASC

0.0069 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5909'
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` = '5903'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5910'
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` = '5907'
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` = '5906'
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` = '5894'
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` = '5892'
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` = '5897'
ORDER BY `chip_change` DESC, `busted` ASC

0.0586 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5887'
ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5884'
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` = '5879'
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` = '5878'
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` = '5875'
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` = '5873'
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` = '5871'
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` = '5870'
ORDER BY `chip_change` DESC, `busted` ASC

0.0575 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5867'
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` = '5863'
ORDER BY `chip_change` DESC, `busted` ASC

0.0129 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5860'
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` = '5857'
ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5854'
ORDER BY `chip_change` DESC, `busted` ASC

0.0077 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5849'
ORDER BY `chip_change` DESC, `busted` ASC

0.0571 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5846'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5844'
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` = '5843'
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` = '5839'
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` = '5835'
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` = '5833'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5832'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5829'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5828'
ORDER BY `chip_change` DESC, `busted` ASC

0.0569 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5827'
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` = '5826'
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` = '5825'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5824'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5822'
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` = '5819'
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` = '5818'
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` = '5814'
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` = '5812'
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` = '5805'
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` = '5804'
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` = '5802'
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` = '138'
ORDER BY `busted` ASC, `current_chips` DESC

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

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

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(2)
  • 888poker UK Poker League(3)
  • APAT(6)
  • APPT(3)
  • Aria Resort & Casino(0)
  • Asian Poker Tour(1)
  • Aspers Casino Westfield Stratford City(5)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(0)
  • British Poker Series(4)
  • BSOP(3)
  • Circuito Nacional De Poker(1)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(9)
  • EAPT(1)
  • EPT(3)
  • Estrellas Poker Tour(1)
  • Eureka Poker Tour(2)
  • France Poker Series(1)
  • Gift Voucher(1)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Casino Coventry(4)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(30)
  • Grosvenor UK Poker Open(0)
  • Grosvenor's Summer Fest(0)
  • GUKPT Grosvenor(3)
  • Hippodrome Casino(2)
  • IPO(1)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(9)
  • Kings of Tallinn(0)
  • LAPT(3)
  • London Poker Festival(1)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(0)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(9)
  • Moneymaker Tour(5)
  • North American Poker Tour(1)
  • Olympic Park Casino(1)
  • Orleans Summer Open(0)
  • Poker GO Tour(0)
  • Poker Skills Events(0)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(1)
  • Queens of Tallinn(0)
  • RDS (Royal Dublin Society)(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(2)
  • The Caribbean Poker Series(1)
  • The Casino at Portomaso(4)
  • The Festival(2)
  • The Poker Room(0)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • UKIPT(2)
  • Unibet DeepStack Open(8)
  • Unibet Open(0)
  • Venetian Deepstack Extravaganza(1)
  • Women's Winter Festival(1)
  • WPT(4)
  • WPT Alpha 8(0)
  • WPT Prime(5)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(13)
  • WSOP International Circuit(5)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(0)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Flight FAQs
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF
  • Main Event Travel Gift Vouchers
  • Goliath FinalTableFreeroll
  • London Poker Festival FinalTableFreeroll
  • LIVE Goliath Travel Credit Giveaway

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

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

• £   GBP
• $   USD
• €   EUR

WSOPC Tallinn Event #6: €1,500 WSOPC Tallinn Main Event Live Reporting - Day 4

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

---

Current Level 35 Current Day 4

---

Blinds 300,000/600,000 Ante 600000

Entries 719 Remaining 1

---

Prize Pool (EUR) €1,000,000 First Prize (EUR) €211,500

Chip Leaders Day 4

1

Ignacio Garrido Gonzalez

35,900,000

Day 1A Day 1B Day 1C Day 1D Day 2 Day 3 Day 4

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 3

Akseli Paalanen Leads Final 9 in WSOPC Tallinn Main Event Posted Saturday 23rd September, 2023 at 19:51(UTC+0) by Jason Glatzer

The 2023 World Series of Poker Circuit (WSOPC) Tallinn Main Event has witnessed the field of 719 entries whittled down to just a final table of nine on the third and penultimate day at Olympic Park Casino and the Hilton Tallinn Park.

Finland's Akseli Paalanen (pictured above) was easily the star of the day by bagging more than double the average stack at the final table with 10,650,000 in chips good for a whopping 107 big blinds when the action resumes on Sunday at noon under the lights and cameras of the live stream at OlyBet.tv.

Paalanen began the day in second place with just 60 players remaining just behind Estonia's Hendrik Uibo and managed to stay at the top of the chip leaderboard throughout the day.  With just 15 players left, Paalanen began to separate himself from the rest of the pack. He first doubled through another big stack at his table in Max Rotko.

"This is going to be a big pot," Rotko said after committing his tens against Paalanen's jacks.

Not only did Paalanen's jacks hold, but he won another big pot soon to send Pekka Ikonen out of the tournament in 10th place for €14,550 to end the day. Ikonen was in great shape after flopping the top set with jacks. However, Paalanen had ten-deuce suited and the chips went in on the turn after improving to a flush. Ikonen had outs to a full house or quads but he was instead out of chips after he bricked the river.

Final Table Seat Draw

Seat	Player	Country	Chips	Big Blinds
1	Emil Hovmark	Sweden	3,250,000	33
2	Artur Kulanurk	Estonia	4,550,000	46
3	Jesus Martinez Ucero	Spain	3,450,000	35
4	Jun Beum Chun	South Korea	6,875,000	69
5	Akseli Paalanen	Finland	10,650,000	107
6	Ignacio Gonzalez Garrido	Spain	2,200,000	22
7	Mario Linno	Estonia	1,175,000	12
8	Adria Comas I Roura	Spain	2,275,000	23
9	Mairo Tori	Estonia	1,500,000	15

While Paalanen is certainly in the captain's chair to commence the final table, he will still have plenty of other players equally eager to win the coveted WSOP gold ring, an invite to the $1 million guaranteed 2024 WSOP Tournament of Champions bracelet freeroll event, and the €211,500 top prize on tap for the last player standing.

Despite the gap, it is anyone's game with players from five different countries including one player from South Korea in Jun Beum Chun (6,875,000), and one player from Sweden in Emil Hovmark (3,250,000).  The final table also boasts three players from the Spanish poker community living in Tallinn in Jesus Martinez Ucero (3,450,000), Adria Comas I Roura (2,275,000), and Ignacio Gonzalez Garrido (2,200,000). 

Of course, the local community will have a chance to root on the home team. However, the two Estonians at the table have their work cut out for them coming in with the shortest stacks with Mairo Tomi ending Day 2 with 1,500,000 and Mario Linno with 1,175,000. Meanwhile, Estonia's Artur Kulanurk is in a bit of better shape as he will start in third place with 4,550,000.

Final Table Payouts

The final nine players each secured a minimum of a €17,700 payday on Sunday with the payouts going up quickly from there until the eventual winner collects a massive €211,500 top prize.

Check out all of the payouts below:

Place	Prize
1	€211,500
2	€137,250
3	€84,200
4	€64,100
5	€48,750
6	€34,150
7	€26,150
8	€21,550
9	€17,700

Cards will be in the air for the final table on Sunday at noon with our coverage beginning 30 minutes later to not give away spoilers for the stream. Be sure to tune back into OlyBet.tv for both the live stream hosted by Andreas Hoglund and George Sandford while also following along with our coverage of the biggest hands of the day. 

Author: Jason Glatzer and Frank Visser
Photos: Elena Kask and Tambet Kask

Final Table Seat Draw Posted Saturday 23rd September, 2023 at 16:44(UTC+0) by Jason Glatzer

1	Emil Hovmark	Sweden	3,250,000	33
2	Artur Kulanurk	Estonia	4,550,000	46
3	Jesus Martinez Ucero	Spain	3,450,000	35
4	Jun Beum Chun	South Korea	6,875,000	69
5	Akseli Paalanen	Finland	10,650,000	107
6	Ignacio Gonzalez Garrido	Spain	2,200,000	22
7	Mario Linno	Estonia	1,175,000	12
8	Adria Comas I Roura	Spain	2,275,000	23
9	Mairo Tori	Estonia	1,500,000	15

Player		Chips	Progress
Akseli Paalanen		10,650,000	150,000
Jun Beum Chun		6,875,000	75,000
Artur Kulanurk		4,550,000	1,875,000
Jesus Ucero		3,450,000	50,000
Emil Hovmark		3,250,000	50,000
Adria Comas I Roura		2,275,000	25,000
Ignacio Garrido		2,200,000	400,000
Mairo Tori		1,500,000	475,000
Mario Linno		1,175,000	250,000

Main Event Payouts Posted Saturday 23rd September, 2023 at 16:29(UTC+0) by Jason Glatzer

Place	Player	Country	Prize
1			€211,500
2			€137,250
3			€84,200
4			€64,100
5			€48,750
6			€34,150
7			€26,150
8			€21,550
9			€17,700
10	Pekka Ikonen	Finland	€14,550
11	Antti Eeva	Finland	€11,800
12	Max Rotko	Finland	€9,600
13	Jon Ander Martinez	Spain	€9,600
14	Hendrik Uibo	Estonia	€7,750
15	Anders Hansson	Sweden	€7,750
16	Martin Piik	Estonia	€6,000
17	Tomasz Mroz	Poland	€6,000
18	Andrius Bielskis	Lithuania	€6,000
19	Samuel Richards	United Kingdom	€6,000
20	Anna-Mari Hursti	Finland	€6,000
21	Henri Antkainen	Finland	€6,000
22	Maciej Komorowski	Poland	€6,000
23	Maruen Zormati	Finland	€6,000
24	Jimi Koponen	Finland	€5,250
25	Seppo Parkkinen	Finland	€5,250
26	Kevin Karinius	Finland	€5,250
27	David Asqino	Italy	€5,250
28	Vu Hoang Vuong	Finland	€5,250
29	Marko Harkonen	Finland	€5,250
30	Jari-Pekka Juhola	Finland	€5,250
31	Kyosti Isberg	Finland	€5,250
32	Kris Tikka	Finland	€4,750
33	Bartlomiej Kijak	Poland	€4,750
34	Hannes Praks	Estonia	€4,750
35	Deividas Butnoras	Lithuania	€4,750
36	Stanislavas Macugins	Latvia	€4,750
37	Ekrem Esker	Finland	€4,750
38	Steponas Venckus	Lithuania	€4,750
39	Karl Relander	Finland	€4,750
40	Aleksandr Arutjunov	Estonia	€4,250
41	Jose Larios Domene	Spain	€4,250
42	Remigijus Dzerva	Lithuania	€4,250
43	Luca Beretta	Italy	€4,250
44	Emanuele Mari	Italy	€4,250
45	Joni Rantamaki	Finland	€4,250
46	Adrians Imsa	Latvia	€4,250
47	Andzej Zinkevic	Lithuania	€4,250
48	Gilles Simon	Netherlands	€3,750
49	Amanullah Tahiri	Finland	€3,750
50	Juho Suutari	Finland	€3,750
51	Igor Yaroshevskyy	Ukraine	€3,750
52	Toms Civcs	Latvia	€3,750
53	Aigars Tuakacs	Latvia	€3,750
54	Alger Pissarev	Estonia	€3,750
55	Kasper Mellanen	Finland	€3,750
56	Youngseo Yoon	United Kingdom	€3,300
57	Urmo Velvelt	Estonia	€3,300
58	Sebastian Wahl	Finland	€3,300
59	Ermo Kosk	Estonia	€3,300
60	Tornike Tchitadze	Georgia	€3,300
61	Mauri Dorbek	Estonia	€3,300
62	Rasmus Sepping	Estonia	€3,300
63	Paulius Mikaliunas	Lithuania	€3,300
64	Tarmo Tammel	Estonia	€3,300
65	Andrey Koks	Estonia	€3,300
66	Kert Hallik	Estonia	€3,300
67	Priit Vallap	Estonia	€3,300
68	Tomi Hietala	Finland	€3,300
69	Jonatan Fors	Finland	€3,300
70	Karlis Kreslins	Latvia	€3,300
71	Mark Metsla	Estonia	€3,300
72	Egon Kaljulaid	Estonia	€3,050
73	Keito Kaljulaid	Estonia	€3,050
74	Priit Parmasto	Estonia	€3,050
75	Roope Holma	Finland	€3,050
76	Vidar Assersen	Norway	€3,050
77	Steven Seller	Estonia	€3,050
78	Peng Yi-Zhan	Taiwan	€3,050
79	Herli Olop	Estonia	€3,050
80	Sergei Aleksejev	Estonia	€3,050
81	Markuss Rukkalns	Latvia	€3,050
82	Mohammed Al-Khazraji	Finland	€3,050
83	Agnius Ismailovas	Lithuania	€3,050
84	Jon Kyte	Norway	€3,050
85	Kare Hallamaa	Finland	€3,050
86	Johan Martinsen	Finland	€3,050
87	Mikko Ylamaki	Finland	€3,050

Pekka Ikonen Eliminated in 10th Place (€14,550) Posted Saturday 23rd September, 2023 at 16:22(UTC+0) by Frank Visser

Level 27: 50,000/100,000 (100,000)
Entries: 9/719

Akseli Paalanen open-raised from the cutoff and Pekka Ikonen defended his big blind.

The flop fanned out and Paalanen continuation-bet after a check from Ikonen. Ikonen flat-called and did so as well when another bet came from Paalanen on the turn. 

The river then fell the and Ikonen checked again. This time, Paalanen went all-in covering his opponent by a significant margin. A quick call followed from Ikonen, and he tabled his when the other table finished their ongoing hand.

However, his flopped set of jacks was no good against the turned flush of Paalanen, who played . Ikonen disappeared from the table in disbelief, and play was then paused as only nine players remained, marking the end of Day 3 as the final table had been reached.

Player		Chips	Progress
Akseli Paalanen		10,800,000	3,850,000
Pekka Ikonen		0	0

Antti Eeva Eliminated in 11th Place (€11,800) Posted Saturday 23rd September, 2023 at 16:20(UTC+0) by Jason Glatzer

Level 27: 50,000/100,000 (100,000)
Entries: 12/719

Emil Hovmark opened for 250,000 from the small blind. Antti Eeva jammed for 1.5 million from the big blind and Hovmark called.

Antti Eeva:
Emil Hovmark:

Hovmark had Eeva covered by one chip and his king kicker came into play to eliminate Eeva in 11th place for €11,800 after the improved both players to the same two pair.

Player		Chips	Progress
Emil Hovmark		3,200,000	1,425,000
Antti Eeva		0	0

Max Rotko Eliminated in 12th Place (€9,600) Posted Saturday 23rd September, 2023 at 16:19(UTC+0) by Frank Visser

Level 27: 50,000/100,000 (100,000)
Entries: 11/719

Jesus Ucero opened his button and Max Rotko put in his final three blinds from the big blind.

Max Rotko:
Jesus Ucero:

Rotko sighed as he saw he was only drawing to three direct outs, and none of them came on the board. He took his exit in 12th place as the WSOPC Tallinn Main Event draws closer and closer to a final table.

Player		Chips	Progress
Jesus Ucero		3,500,000	825,000
Max Rotko		0	0

Martinez Correctly Folds Top Pair Posted Saturday 23rd September, 2023 at 16:11(UTC+0) by Jason Glatzer

Level 27: 50,000/100,000 (100,000)
Entries: 13/719

Ignacio Garrido (pictured below) min-raised from the cutoff with on the live stream before Jon Anders Martinez with defended his big blind.

The flop paired up both players' queens with Martinez with some obvious kicker issues. Garrido continued for 150,000 and Martinez check-called.

Martinez checked again. Garrido fired out for half the pot for 450,000 and Martinez went into the tank before finding a fold.

 

Player		Chips	Progress
Ignacio Garrido		2,600,000	650,000
Jon Ander Martinez		1,400,000	850,000

Anders Hansson Eliminated in 14th Place (€7,750) Posted Saturday 23rd September, 2023 at 16:00(UTC+0) by Frank Visser

Level 27: 50,000/100,000 (100,000)
Entries: 13/719

The action folded to Anders Hansson (pictured) in the small blind, who raised to 300,000. Pekka Ikonen was in the big blind and thought his options over for a while before putting in calling chips.

The flop was then dealt and Hansson went all-in for an additional 900,000. Ikonen took a quick peek at his cards before calling and the two players tabled their hands

Anders Hansson:
Pekka Ikonen:

Ikonen's top pair was in the lead but Hansson had plenty of outs with his open-ended straight draw. However, it would not arrive on the runout and Hansson would be the next player eliminated.

Player		Chips	Progress
Pekka Ikonen		3,600,000	1,660,000
Anders Hansson		0	0

Hendrik Uibo Eliminated in 15th Place (€7,750) Posted Saturday 23rd September, 2023 at 15:59(UTC+0) by Jason Glatzer

Level 27: 50,000/100,000 (100,000)
Entries: 12/719

Ignacio Garrido opened for a min-raise before Hendrik Uibo three-bet jammed for 1.5 million. Jun Beum Chun four-bet shoved over the top for 5 million. Garrido went into the tank with before he folded.

Hendrik Uibo:
Jun Beum Chun:

Uibo, who qualified for just €11 at OlyBet Poker had some hope on the as any club would improve him to a flush while a non-club deuce would give both players a wheel. However, he bricked both the turn and river to hit the rail in 13th place for €7,750.

Player		Chips	Progress
Jun Beum Chun		6,800,000	1,750,000
Hendrik Uibo		0	0

Break for Final 15 Posted Saturday 23rd September, 2023 at 15:35(UTC+0) by Frank Visser

The last 15 remaining players are sent on a 20-minute break while a chip race is undertaken by the tournament staff.

Player		Chips	Progress
Akseli Paalanen		6,930,000	3,705,000
Max Rotko		640,000	3,630,000

Paalanen Scores Huge Double-Up Posted Saturday 23rd September, 2023 at 15:24(UTC+0) by Frank Visser

Level 26: 40,000/80,000 (80,000)
Entries: 15/719

The action folded to Akseli Paalanen in the cutoff, and he open-raised to 160,000. Max Rotko then responded with a three-bet to 640,000 from the small blind before Paalanen four-bet jammed his stack of 3,385,000 chips in the middle.

Rotko went into the tank for a bit before announcing a call, slightly covering his opponent.

Akseli Paalanen:
Max Rotko:

"This is a big pot boys," Rotko exclaimed before the flop fell. Paalanen's higher pocket pair still had an overwhelming lead, and when no ten appeared on the runout, he scored a huge double-up.

Meanwhile, Rotko was left with only 640,000 chips, equating to eight big blinds.

Player		Chips	Progress
Akseli Paalanen		6,930,000	3,705,000
Max Rotko		640,000	3,630,000

Martin Piik Eliminated in 16th Place (€6,000) Posted Saturday 23rd September, 2023 at 15:22(UTC+0) by Jason Glatzer

Level 26: 40,000/80,000 (80,000)
Entries: 15/719

In the past, Estonia's Martin Piik was one of the men behind the scenes at OlyBet Poker. He left this behind and has been crushing at the live and online tables ever since.

Unfortunately, we will not witness Piik win a Main Event ring this time around. He was the short-stack at the feature table when he jammed 530,000 from early position and was looked up by Ignacio Garrido.

Martin Piik:
Ignacio Garrido:

Piik ran into the best preflop hand in poker. Piik had some hope after connecting with his queen on the flop but was on the rail in 16th place for €6,000 after the turn and river completed the board.

Player		Chips	Progress
Ignacio Garrido		1,850,000	665,000
Martin Piik		0	0

Hansson Can't Force a Fold Posted Saturday 23rd September, 2023 at 15:15(UTC+0) by Frank Visser

Level 26: 40,000/80,000 (80,000)
Entries: 15/719

The action folded to Anders Hansson in the small blind, and he opted to limp in. Big blind Pekka Ikonen checked and the two saw a flop of .

Hansson fired a big bet of 200,000 chips, which was met with a call from Ikonen. The turn saw another bet from Hansson, this time for 400,000. Again, Ikonen did not have to think long before putting in a call.

The river then was quickly checked by both players, and Hansson shook his head before tabling for bottom pair.

Ikonen easily bested that with his for top pair and raked in the blind-on-blind pot.

Player		Chips	Progress
Pekka Ikonen		2,550,000	610,000
Anders Hansson		1,650,000	735,000

14:53 (UTC+0)

Start of Level 26
Blinds: 40,000/80,000     Ante: 80,000

Mroz Eliminated as Final Player before Two Table Redraw Posted Saturday 23rd September, 2023 at 14:40(UTC+0) by Frank Visser

Level 26: 40,000/80,000 (80,000)
Entries: 16/719

Jon Ander Martinez opened the action with a raise from the hijack before Tomasz Mroz shipped in 900,000 chips from the small blind for an all-in bet.

Martinez quickly called to put Mroz at risk and a showdown was had.

Tomasz Mroz:
Jon Ander Martinez:

Mroz already stood up when the flop fell , and his gut feeling turned out to be correct when the board completed with the turn and river.

He left the tournament area while the remaining 16 players are taking a small break as they will redraw for the final two tables.

Player		Chips	Progress
Jon Ander Martinez		2,050,000	1,150,000
Tomasz Mroz		0	0

Bielskis Bows Out Posted Saturday 23rd September, 2023 at 14:31(UTC+0) by Frank Visser

Level 26: 30,000/60,000 (60,000)
Entries: 17/719

Max Rotko open-raised from the hijack and Andrius Bielskis (pictured) three-bet jammed his 550,000 stack from the button. The action folded back to Rotko, who called with the covering stack.

Andrius Bielskis:
Max Rotko:

It was a classic flip, which would fall in Rotko's favor when only undercards appeared on the board, resulting in Bielskis' elimination from the tournament.

Player		Chips	Progress
Max Rotko		3,800,000	1,150,000
Andrius Bielskis		0	0

Linno Takes Out Richards Posted Saturday 23rd September, 2023 at 14:30(UTC+0) by Jason Glatzer

Level 26: 30,000/60,000 (60,000)
Entries: 18/719

Samuel Richards jammed from early position and was called by Mario Linno from the blinds.

Samuel Richards:
Mario Linno:

For the second time in a row at the feature table, Linno eliminated a player, this time Richards went out in 19th place after Linno improved to a better full house on the board.

Player		Chips	Progress
Mario Linno		2,300,000	700,000
Samuel Richards		0	0

Hursti Loses Flip to Linno Posted Saturday 23rd September, 2023 at 14:24(UTC+0) by Jason Glatzer

Level 26: 30,000/60,000 (60,000)
Entries: 19/719

Mario Linno jammed the button for 765,000. Anna-Mari Hursti called off for slightly less and both players were more or less flipping for their tournament lives.

Anna-Mari Hursti:
Mario Linno:

Hursti nailed top pair on the but despite that was far behind Linno's flopped set of sixes. There was thin hope for Hursti after improving to two pair on the turn with four outs to a boat. However, the blank river completed the board and Hurst was eliminated in 19th place.

Player		Chips	Progress
Mario Linno		1,600,000	905,000
Anna-Mari Hursti		0	0

Kicker Issues for Antikainen Posted Saturday 23rd September, 2023 at 14:18(UTC+0) by Jason Glatzer

Level 26: 30,000/60,000 (60,000)
Entries: 20/719

Henri Antikainen jammed at the feature table for 790,000 from the button and was called by Pekka Ikonen.

Henri Antikainen:
Pekka Ikonen:

Both players hit two pair on the flop. Antikainen had some kicker issues that weren't resolved on either the turn or river to hit the rail in 21st place.

Player		Chips	Progress
Pekka Ikonen		3,700,000	1,975,000
Henri Antikainen		0	0

Martinez Cracks Komorowski's Rockets Posted Saturday 23rd September, 2023 at 14:10(UTC+0) by Frank Visser

Level 26: 30,000/60,000 (60,000)
Entries: 21/719

Maciej Komorowski was left short-stacked after a previous bluff attempt failed. He then got his remaining 300,000 or so chips in from the small blind, and Jon Ander Martinez made the call from the big blind.

Maciej Komorowski:
Jon Ander Martinez:

Komorowski immediately saw his aces being cracked when Martinez flopped a straight on , bu the brought some outs. However, the river blanked and Komorowski was seen leaving the tournament area with a grimace on his face.

Player		Chips	Progress
Jon Ander Martinez		900,000	170,000
Maciej Komorowski		0	0

Zormati Flips to His Demise Posted Saturday 23rd September, 2023 at 14:09(UTC+0) by Frank Visser

Level 26: 30,000/60,000 (60,000)
Entries: 22/719

Maruen Zormatti was all-in for his final 600,000 chips and he was looked up by Antti Eeva with the covering stack.

Maruen Zormatti:
Anti Eeva:

Eeva flopped a set on and left his opponent drawing dead on the turn. Zormatti said his goodbyes as the river completed the board and left to collect his winnings.

Player		Chips	Progress
Antti Eeva		1,550,000	560,000
Maruen Zormati		0	0

13:56 (UTC+0)

Start of Level 25
Blinds: 30,000/60,000     Ante: 60,000

Koponen First to Leave Final Three Tables Posted Saturday 23rd September, 2023 at 13:55(UTC+0) by Frank Visser

Level 25: 25,000/50,000 (50,000)
Entries: 23/719

Max Rotko raised from early position and the short-stacked Jimi Koponen three-bet all-in from the big blind. Rotko put in the extra chips and the cards were tabled.

Jimi Koponen:
Max Rotko:

The board ran out and Rotko's pair of eights would win him the pot and eliminate Koponen in 24th place.

Player		Chips	Progress
Max Rotko		2,650,000	205,000
Jimi Koponen		0	0

Hovmark Flips and Doubles Posted Saturday 23rd September, 2023 at 13:51(UTC+0) by Frank Visser

Level 25: 25,000/50,000 (50,000)
Entries: 24/719

Emil Hovmark and Andrius Bielskis had an all-in confrontation preflop, with Hovmark's 840,000 stack being at risk.

Emil Hovmark:
Andrius Bielskis:

Hovmark would win the flip when the board gave him two aces on and he raked in a nice double-up

Player		Chips	Progress
Emil Hovmark		1,780,000	660,000
Andrius Bielskis		715,000	855,000

Reports on 30-Minute Delay Posted Saturday 23rd September, 2023 at 13:12(UTC+0) by Jason Glatzer

In order not to give away any spoilers for those watching the stream, our reporting will be on the same 30-minute delay until a winner is crowned tomorrow.

Bielskis Books a Three-Way Victory Posted Saturday 23rd September, 2023 at 13:11(UTC+0) by Frank Visser

Level 25: 25,000/50,000 (50,000)
Entries: 24/719

Max Rotko raised to 100,000 from the hijack and received calls from Andrius Bielskis (pictured below) on the button and Jimi Koponen in the big blind.

The flop of checked through before the action checked to Bielskis once more on the turn. This time, he bet for 130,000 and that was enough to let both of his opponents forfeit their hands.

Player		Chips	Progress
Andrius Bielskis		1,580,000	340,000
Max Rotko		1,375,000	970,000
Jimi Koponen		800,000	220,000

Final Three Table Seat Draw Posted Saturday 23rd September, 2023 at 13:04(UTC+0) by Jason Glatzer

Table	Seat	Player	Chips	Big Blinds
1	1	Samuel Richards	1,150,000	23
1	2	Henri Antikainen	1,160,000	23
1	3	Pekka Ikonen	1,725,000	35
1	4	Mario Linno	695,000	14
1	5	Anna-Mari Hursti	800,000	16
1	6	Hendrik Uibo	3,870,000	77
1	7	Adria Comas I Roura	1,135,000	23
1	8	Tori Mairo	1,790,000	36
2	1	Maruen Zormati	1,175,000	24
2	2	Emil Hovmark	1,120,000	22
2	3	Max Rotko	1,475,000	30
2	4	Jesus Ucero	2,415,000	48
2	5	Andrius Bielskis	1,230,000	25
2	6	Antti Eeva	990,000	20
2	7	Jimi Koponen	950,000	19
2	8	Akseli Paalanen	3,350,000	67
3	1	Artur Kulanurk	2,295,000	46
3	2	Anders Hansson	1,610,000	32
3	3	Tomasz Mroz	1,500,000	30
3	4	Martin Piik	590,000	12
3	5	Jun Beum Chun	1,200,000	24
3	6	Ignacio Garrido	2,220,000	44
3	7	Maciej Komorowski	435,000	9
3	8	Jon Ander Martinez	1,070,000	21

Action Resumed Posted Saturday 23rd September, 2023 at 13:03(UTC+0) by Frank Visser

All players have taken their seats and play is now back underway.

A Small Break; Live Report on Delay Posted Saturday 23rd September, 2023 at 12:53(UTC+0) by Frank Visser

The final 24 players are now enjoying a small break while everything is being made ready for the live stream.

In order to not spoil the stream, the live report will also operate with a 30-minute delay from now on.

Parkkinen Eliminated; Final Three Tables Reached Posted Saturday 23rd September, 2023 at 12:50(UTC+0) by Frank Visser

Level 25: 25,000/50,000 (50,000)
Entries: 24/719

Jun Beum Chun raised to 100,000 from the cutoff and the short-stacked Seppo Parkkinen called all-in for less than that from the button. The blinds folded and the two players showed down.

Seppo Parkkinen:
Jun Beum Chun:

Parkkinen flopped a set on and Chun was left to a runner-runner runout to still win the pot. Miraculously enough, it came in when the turn and river gave him a better full house than Parkkinen.

Parkkinen left the tournament area dejected while the 24 remaining players headed to the TV area to converge into three final tables.

Player		Chips	Progress
Jun Beum Chun		0	25,000
Seppo Parkkinen		0	0

Rapid-Fire Eliminations Continue Posted Saturday 23rd September, 2023 at 12:36(UTC+0) by Frank Visser

Level 25: 25,000/50,000 (50,000)
Entries: 25/719

Vu Hoang Vuong (pictured below) open-jammed for 415,000 chips from the hijack and Andrius Bielskis asked for a count from the small blind. After receiving the correct amount, he made the call with the covering stack.

Vu Hoang Vuong:
Andrius Bielskis:

Bielskis flopped a set on but Vuong still had hope with his flopped gutshot. However, the turn upgraded Bielskis to a full house and thus sealed Vuong's fate. He said his goodbyes as the meaningless river was dealt out.

On another table, Kevin Karenius had all of his chips in the middle and Ignacio Garrido was trying to score another knock-out. The board read , and Garrido's outkicked Karenius' for another elimination.

On yet another table, David Asqino was also eliminated in an unwitnessed hand.

Only 25 players now remain in contention for the WSOPC Tallinn Main Event title.

Player		Chips	Progress
Ignacio Garrido		1,825,000	425,000
Andrius Bielskis		1,240,000	430,000
Kevin Karenius		0	0
Vu Hoang Vuong		0	0

12:24 (UTC+0)

Start of Level 24
Blinds: 20,000/50,000     Ante: 50,000

First Break of the Day Posted Saturday 23rd September, 2023 at 12:04(UTC+0) by Frank Visser

The remaining 28 players are now sent on a 20-minute break. Just before the break, three more players were eliminated from the WSOPC Tallinn Main Event.

Player		Chips	Progress
Marko Harkonen		0	0
Jari-Pekka Juhola		0	0
Kyosti Isberg		0	0

Players Cashing for €4,750 Posted Saturday 23rd September, 2023 at 11:59(UTC+0) by Jason Glatzer

The following players cashed for €4,750 in the Main Event. The final 31 players each locked up at least a €5,250 payout.

Place	Player	Prize
32	Kris Tikka	€4,750
33	Bartlomiej Kijak	€4,750
34	Hannes Praks	€4,750
35	Deividas Butnoras	€4,750
36	Stanislavas Macugins	€4,750
37	Ekrem Esker	€4,750
38	Steponas Venckus (below)	€4,750
39	Karl Relander	€4,750

Kijak Last to Leave Before Final Four Tables Posted Saturday 23rd September, 2023 at 11:50(UTC+0) by Frank Visser

Level 24: 20,000/40,000 (40,000)
Entries: 31/719

Akseli Paalanen raised to 80,000 from the cutoff and the action folded to Bartlomiej Kijak in the big blind. He then announced his all-in and Paalanen asked for a count.

The total amounted to 865,000 and after taking a quick glance at the clock, Paalanen made the call to put his opponent at risk.

Bartlomiej Kijak:
Akseli Paalanen:

Paalanen held the superior pair and thus was in great shape to score an elimination. No six arrived on the board, and the final 31 players converged onto four tables while Kijak left to collect his payout.

Player		Chips	Progress
Akseli Paalanen		2,925,000	1,625,000
Bartlomiej Kijak		0	0

Garrido Gets More Chips by Eliminating Relander Posted Saturday 23rd September, 2023 at 11:36(UTC+0) by Frank Visser

Level 24: 20,000/40,000 (40,000)
Entries: 35/719

When the action was caught, all of Karl Relander's 550,000 chips already went into the 250,000 chip pot in the middle on a board of . Ignacio Garrido was on the other end of the action with the covering stack and the two were ordered to show down.

Karl Relander:
Ignacio Garrido:

Relander was already drawing dead and complimented his opponent's hand while the inconsequential river completed the board. He joined the many players who have been eliminated in the early levels of Day 3 so far.

Player		Chips	Progress
Ignacio Garrido		2,250,000	1,600,000
Karl Relander		0	0

Payouts for €4,250 Posted Saturday 23rd September, 2023 at 11:30(UTC+0) by Jason Glatzer

The following players cashed for €4,250 with the remaining 39 players locking up at least €4,750.

Place	Player	Prize
40	Aleksandr Arutjunov (below)	€4,250
41	Jose Larios Domene	€4,250
42	Remigijus Dzerva	€4,250
43	Luca Beretta	€4,250
44	Emanuele Mari	€4,250
45	Joni Rantamaki	€4,250
46	Adrians Imsa	€4,250
47	Andzej Zinkevic	€4,250

Player		Chips	Progress
Andzej Zinkevic		0	0
Adrians Imsa		0	0
Joni Rantamaki		0	0
Emanuele Mari		0	0
Luca Beretta		0	0
Jose Larios Domene		0	0
Aleksandr Arutjunov		0	0

11:22 (UTC+0)

Start of Level 23
Blinds: 20,000/40,000     Ante: 40,000

Dzerva Downed by Chun Posted Saturday 23rd September, 2023 at 11:22(UTC+0) by Frank Visser

Level 23: 15,000/30,000 (30,000)
Entries: 41/719

Jun Beum Chun raised to 60,000 from the hijack and subsequently faced an all-in for 295,000 from Remigijus Dzerva. Chun mulled it over for a while before asking for a count and making the call not long thereafter, putting Dzerva at risk.

Remigijus Dzerva:
Jun Beum Chun:

It was looking good for Dzerva, who was holding the superior ace, but the flop saw Chun shoot in the lead. Neither the turn or river did anything to change that, and Dzerva was eliminated just before the final five tables.

Player		Chips	Progress
Jun Beum Chun		1,025,000	425,000
Remigijus Dzerva		0	0

Zinkevic's Kings Cracked by Big Blind Special Posted Saturday 23rd September, 2023 at 11:07(UTC+0) by Frank Visser

Level 23: 15,000/30,000 (30,000)
Entries: 45/719

Andzej Zinkevic was sitting on a stack of 275,000 chips when he raised to 75,000 from early position. The action folded to David Asqino in the big blind, who made the call.

The flop then fell and Zinkevic put in the rest of his chips after a check from Asqino. No time passed before the latter made the call and both players' cards were tabled.

Andzej Zinkevic:
David Asqino:

Zinkevic could not believe his eyes when he saw that his opponent flopped two pair. The board brought him no help on the  runout and Zinkevic had no other option than to leave the tournament area, while Asqino raked in the pot.

Player		Chips	Progress
David Asqino		715,000	130,000
Andzej Zinkevic		0	0

Players Cashing for €3,750 Posted Saturday 23rd September, 2023 at 10:59(UTC+0) by Jason Glatzer

The following players cashed for €3,750 in the Main Event. The final 47 players each locked up another €500 as they are now guaranteed at least a €4,250 payout.

Place	Player	Prize
48	Gilles Simon	€3,750
49	Amanullah Tahiri	€3,750
50	Juho Suutari	€3,750
51	Igor Yaroshevskyy	€3,750
52	Toms Civcs	€3,750
53	Aigars Tuakacs	€3,750
54	Alger Pissarev	€3,750
55	Kasper Mellanen	€3,750

Simon Bluffs It Off Posted Saturday 23rd September, 2023 at 10:56(UTC+0) by Frank Visser

Level 22: 10,000/25,000 (25,000)
Entries: 47/719

On a completed board of , a pot of roughly 400,000 chips had gathered when Jesus Ucero checked from the big blind. Gilles Simon was sitting under the gun and decided to go all-in for 250,000.

An instantaneous call followed from the Spaniard and Simon knocked the table while he showed his for just ace-high. Ucero then showed his for two pair and sent the Dutchman home early on Day 3.

Player		Chips	Progress
Jesus Ucero		1,700,000	600,000
Gilles Simon		0	0

Koponen Doubles With Big Slick Posted Saturday 23rd September, 2023 at 10:54(UTC+0) by Jason Glatzer

Level 22: 15,000/30,000 (30,000)
Entries: 48/719

Jun Beum Chun opened for a min-raise from middle position. Maruen Zormati called from the small blind before Jimi Koponen three-bet jammed for 230,000 from the big blind. Chun tanked for a few moments before he folded, while Zormati found a snap-call.

Jimi Koponen:
Maruen Zormati:

Koponen's big slick remained ahead on the board to double his short stack through Zormati.

Player		Chips	Progress
Maruen Zormati		1,500,000	635,000
Jun Beum Chun		600,000	155,000
Jimi Koponen		580,000	100,000
Igor Yaroshevskyy		0	0
Juho Suutari		0	0
Amanullah Tahiri		0	0

10:43 (UTC+0)

Start of Level 22
Blinds: 15,000/30,000     Ante: 30,000

Eeva Doubles Up in Preflop Clash Posted Saturday 23rd September, 2023 at 10:43(UTC+0) by Frank Visser

Level 21: 10,000/25,000 (25,000)
Entries: 50/719

Emil Hovmark and Antti Eeva got all of their chips in preflop from the hijack and button respectively. Eeva was the at-risk player with a stack of 250,000 chips.

Antti Eeva:
Emil Hovmark:

It was a sweaty board for Eeva's aces as he saw his opponent turn a flush draw on . However, the river gave him a full house and he cheerfully wiped the sweat off his brow.

Hovmark, meanwhile, was left very short with only 80,000 chips left to play with.

Player		Chips	Progress
Antti Eeva		560,000	420,000
Emil Hovmark		80,000	475,000

Players Cashing for €3,300 Posted Saturday 23rd September, 2023 at 10:41(UTC+0) by Jason Glatzer

The following players banked €3,300 in the Main Event with the remaining field of 55 players locking up at least €3,750.

Place	Player	Prize
56	Youngseo Yoon (photo below)	€3,300
57	Urmo Velvelt	€3,300
58	Sebastian Wahl	€3,300
59	Ermo Kosk	€3,300
60	Tornike Tchitadze	€3,300
61	Mauri Dorbek	€3,300
62	Rasmus Sepping	€3,300
63	Paulius Mikaliunas	€3,300
64	Tarmo Tammel	€3,300
65	Andrey Koks	€3,300
66	Kert Hallik	€3,300
67	Priit Vallap	€3,300
68	Tomi Hietala	€3,300
69	Jonatan Fors	€3,300
70	Karlis Kreslins	€3,300
71	Mark Metsla	€3,300

Recent Eliminations Posted Saturday 23rd September, 2023 at 10:35(UTC+0) by Jason Glatzer

Player		Chips	Progress
Alger Pissarev		0	0
Sebastian Wahl		0	0
Youngseo Yoon		0	0
Kasper Mellanen		0	0
Aigars Taukacs		0	0
Toms Civcs		0	0

Mellanen Shoves Into Trips Posted Saturday 23rd September, 2023 at 10:34(UTC+0) by Frank Visser

Level 21: 10,000/25,000 (25,000)
Entries: 54/719

Kasper Mellanen and Artur Kulanurk were heads up on a completed board of . Mellanen was seen shoving his last chips in the middle and received a quick call from his opponent.

Mellanen could only show for a bluff while Kulanurk tabled for a comfortable call with turned trips, resulting in the elimination of Mellanen.

Player		Chips	Progress
Artur Kulanurk		1,625,000	540,000
Kasper Mellanen		0	0

Esker Doubles Through Mari Posted Saturday 23rd September, 2023 at 10:27(UTC+0) by Jason Glatzer

Level 21: 10,000/25,000 (25,000)
Entries: 55/719

Ekrem Esker just got some chips back from Emanuele Mari and gained some breathing room.

Mari opened for 55,000 from early position before Ekrem Esker three-bet shoved for 225,000 from the hijack. Mari called and Esker was flipping for his tournament life.

Ekrem Esker:
Emanuele Mari:

Esker pulled ahead straight out of the gate after his queen connected on the flop. Neither the turn nor the river changed the outcome for Esker to double through Mari.

Player		Chips	Progress
Emanuele Mari		1,200,000	75,000
Ekrem Esker		610,000	295,000

Trip Jacks for Mari Posted Saturday 23rd September, 2023 at 10:16(UTC+0) by Jason Glatzer

Level 21: 10,000/25,000 (25,000)
Entries: 58/719

Emanuele Mari fired out 225,000 into a pot of a bit more with the on the board when Ekrem Esker went into the tank.

"How much do you have?" asked Esker.

Rather than just showing the chips, Mari counted his stack and shared it was 350,000 left behind. Esker tanked for a couple more minutes before he called.

Mari turned over the for trip jacks and won the hand after Atush mucked his cards.

Meanwhile, local hero Ermo Kosk hit the rail around the same time in 59th place.

Player		Chips	Progress
Emanuele Mari		1,275,000	480,000
Ekrem Atush		315,000	465,000
Ermo Kosk		0	0

Tchitadze One of the First to Leave on Day 3 Posted Saturday 23rd September, 2023 at 10:13(UTC+0) by Frank Visser

Level 21: 10,000/25,000 (25,000)
Entries: 59/719

The board read  when small blind Andrius Bielskis checked to Tornike Tchitadze in the big blind. Tchitadze then bet out 75,000 into the pot of 225,000 and Bielskis made the call.

The river of completed the board and this time Tchitadze went all-in for his final 200,000 or so chips after another check from Bielskis. The latter then snap-called and Tchitadze tried to muck his cards but was forced to show his failed bluff with . 

Meanwhile, Bielskis made the comfortable call with for turned trips, and increased his stack to an above-average one.

Player		Chips	Progress
Andrius Bielskis		810,000	305,000
Tornike Tchitadze		0	0

Cards in the Air Posted Saturday 23rd September, 2023 at 10:02(UTC+0) by Jason Glatzer

Level 21: 10,000/25,000 (25,000)
Entries: 60/719

Cards are in the air to start Day 2. Best of luck to the final 60 players!

Day 3 Begins at Noon Posted Saturday 23rd September, 2023 at 08:36(UTC+0) by Jason Glatzer

Welcome back to what promises to be an exciting day with the €1 million guaranteed Event #6: WSOPC Tallinn €1,500 Main Event reaching its penultimate day.

The action kicks off at noon with 60 hopefuls from the original field of 719 entries, each locking up €3,300 for a slight increase over the €3,050 the top 87 players were guaranteed as a min-cash. They will be playing for much more today as the action will continue until a final table of nine players remains with €17,700 secured along with hopes alive for the gold ring, the invite to the $1 million guaranteed Tournament of Champions bracelet event freeroll, and the massive €211,500 top prize.

Estonia's Hendrik Uibo (pictured above) kicks off Day 3 with a chip-leading stack of 1,765,000, good for 71 big blinds with blinds starting off at 10,000/25,000 along with a 25,000 big blind ante. The Finnish duo of Akseli Paalanen and Marko Harkonen are just behind Uibo with Luca Beretta and Vu Hoang Vuong rounding out the top five.

Start of Day 3 Top 10 Leaderboard

Place	Name	Chips	Big Blinds
1	Hendrik Uibo	1,765,000	71
2	Akseli Paalanen	1,300,000	52
3	Marko Harkonen	1,205,000	48
4	Luca Beretta	1,155,000	46
5	Vu Hoang Vuong	1,135,000	45
6	Jesus Ucero	1,100,000	44
7	Artur Kulanurk	1,085,000	43
8	Seppo Parkkinen	1,015,000	41
9	Mario Linno	980,000	39
10	Jon Ander Martinez	915,000	37

Our coverage begins when cards are in the air at 12 p.m. with today also featuring a live stream at OlyBet.tv commentated by George Sandford and Andreas Hoglund. Stay tuned to see who the final nine players will be!

Day 3 Seat Draw Posted Friday 22nd September, 2023 at 20:07(UTC+0) by Jason Glatzer

Table	Seat	Name	Chips	Big Blinds
11	1	Marko Harkonen	1,205,000	48
11	2	Urmo Velvelt	535,000	21
11	3	Kyosti Isberg	880,000	35
11	4	Anders Hansson	855,000	34
11	5	Hendrik Uibo	1,765,000	71
11	6	Maciej Komorowski	595,000	24
11	7	Ermo Kosk	430,000	17
11	8	Max Rotko	405,000	16
12	1	Igor Yaroshevskyy	315,000	13
12	2	Emil Hovmark	555,000	22
12	3	Adria Comas I Roura	210,000	8
12	4	Aigars Taukacs	385,000	15
12	5	Kris Tikka	380,000	15
12	6	Juho Suutari	320,000	13
12	7	Deividas Butnoras	470,000	19
12	8	Luca Beretta	1,155,000	46
13	1	Jimi Koponen	480,000	19
13	2	Bartlomiej Kijak	910,000	36
13	3	Seppo Parkkinen	1,015,000	41
13	4	David Asqino	585,000	23
13	5	Hannes Praks	400,000	16
13	6	Andzej Zinkevic	640,000	26
13	7	Andrius Bielskis	505,000	20
13	8	Tornike Tchitadze	455,000	18
14	1	Remigijus Dzerva	410,000	16
14	2	Mairo Tori	450,000	18
14	3	Tomasz Mroz	605,000	24
14	4	Artur Kulanurk	1,085,000	43
14	5	Kevin Karenius	280,000	11
14	6	Henri Antikainen	505,000	20
14	7	Pekka Ikonen	780,000	31
14	8	Amanullah Tahiri	175,000	7
18	1	Ignacio Garrido	650,000	26
18	2	Adrians Imsa	465,000	19
18	3	Karl Relander	135,000	5
18	4	Jesus Ucero	1,100,000	44
18	5	Gilles Simon	405,000	16
18	6	Sebastian Wahl	305,000	12
18	8	Martin Piik	215,000	9
19	1	Ekrem Atush	780,000	31
19	2	Samuel Richards	340,000	14
19	3	Jose Larios Domene	355,000	14
19	4	Youngseo Yoon	220,000	9
19	5	Joni Rantamaki	375,000	15
19	6	Vu Hoang Vuong	1,135,000	45
19	7	Emanuele Mari	795,000	32
20	1	Stanislavas Macugins	595,000	24
20	2	Aleksandr Arutjunov	565,000	23
20	4	Antti Eeva	140,000	6
20	5	Mario Linno	980,000	39
20	6	Jun Beum Chun	445,000	18
20	7	Anna-Mari Hursti	395,000	16
20	8	Jari-Pekka Juhola	655,000	26
21	1	Toms Civcs	330,000	13
21	3	Steponas Venckus	350,000	14
21	4	Alger Pissarev	490,000	20
21	5	Kasper Mellanen	315,000	13
21	6	Jon Ander Martinez	915,000	37
21	7	Akseli Paalanen	1,300,000	52
21	8	Maruen Zormati	865,000	35

20:06 (UTC+0)

Day 3 of WSOPC Tallinn Started
Level: 21     Blinds: 10,000/25,000     Ante: 25,000

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter