0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0070 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event6/3/updates'
ORDER BY `views` DESC

0.0006 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event6/3/updates', 1, '2024-09-01')

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

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

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

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

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

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

0.0003 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

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

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0003 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.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.0065 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0005 SECONDS: 
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_wsop_tallinn_event6'

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '142'

0.0269 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0384 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '345'
AND `published` = 1

0.0279 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0043 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '353'
AND `published` = 1

0.1597 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0073 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '354'
AND `published` = 1

0.1083 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0076 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '355'
AND `published` = 1

0.0252 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0046 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '356'
AND `published` = 1

0.0661 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0096 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '357'
AND `published` = 1

0.0259 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0044 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '358'
AND `published` = 1

0.0270 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0051 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '364'
AND `published` = 1

0.0252 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0453 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '372'
AND `published` = 1

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

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

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

0.0058 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16049'
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` = '16020'
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` = '16018'
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` = '16009'
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` = '16007'
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` = '16006'
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` = '15991'
ORDER BY `chip_change` DESC, `busted` ASC

0.0475 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15988'
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` = '15987'
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` = '15959'
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` = '15955'
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` = '15967'
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` = '15952'
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` = '15944'
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` = '15934'
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` = '15931'
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` = '15918'
ORDER BY `chip_change` DESC, `busted` ASC

0.0467 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15916'
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` = '15926'
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` = '15907'
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` = '15900'
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` = '15898'
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` = '15890'
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` = '15891'
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` = '15886'
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` = '15894'
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` = '15892'
ORDER BY `chip_change` DESC, `busted` ASC

0.0471 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15882'
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` = '15872'
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` = '15870'
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` = '15866'
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` = '15862'
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` = '15859'
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` = '15852'
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` = '15842'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0100 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15799'
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` = '15798'
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` = '15796'
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` = '15788'
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` = '15786'
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` = '15771'
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` = '15764'
ORDER BY `chip_change` DESC, `busted` ASC

0.0475 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15763'
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` = '15754'
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` = '15751'
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` = '15746'
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` = '15728'
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` = '15715'
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` = '15714'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0096 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15670'
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` = '15660'
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` = '15653'
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` = '15650'
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` = '15645'
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` = '15642'
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` = '15624'
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` = '15608'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

0.0049 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '364'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0056 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16049'
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` = '16020'
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` = '16018'
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` = '16009'
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` = '16007'
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` = '16006'
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` = '15991'
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` = '15988'
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` = '15987'
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` = '15959'
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` = '15955'
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` = '15967'
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` = '15952'
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` = '15944'
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` = '15934'
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` = '15931'
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` = '15918'
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` = '15916'
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` = '15926'
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` = '15907'
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` = '15900'
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` = '15898'
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` = '15890'
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` = '15891'
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` = '15886'
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` = '15894'
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` = '15892'
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` = '15882'
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` = '15872'
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` = '15870'
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` = '15866'
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` = '15862'
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` = '15859'
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` = '15852'
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` = '15842'
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` = '15833'
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` = '15824'
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` = '15811'
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` = '15799'
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` = '15798'
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` = '15796'
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` = '15788'
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` = '15786'
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` = '15771'
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` = '15764'
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` = '15763'
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` = '15754'
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` = '15751'
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` = '15746'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15728'
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` = '15715'
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` = '15714'
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` = '15705'
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` = '15698'
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` = '15689'
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` = '15683'
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` = '15679'
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` = '15671'
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` = '15670'
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` = '15660'
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` = '15653'
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` = '15650'
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` = '15645'
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` = '15642'
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` = '15624'
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` = '15608'
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` = '15609'
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` = '364'
ORDER BY `busted` ASC, `current_chips` DESC

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

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553

    

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(1)
  • 888poker UK Poker League(3)
  • APAT(5)
  • APPT(2)
  • Aria Resort & Casino(1)
  • Asian Poker Tour(1)
  • Aspers Casino Westfield Stratford City(4)
  • Battle Of Malta(1)
  • Borgata Poker(2)
  • Bratislava Poker Festival(0)
  • British Poker Series(4)
  • BSOP(2)
  • Circuito Nacional De Poker(0)
  • Costa Rica Poker Festival(1)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(6)
  • EAPT(3)
  • 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(3)
  • Grosvenor Goliath(0)
  • Grosvenor Poker 25/50(30)
  • Grosvenor UK Poker Open(0)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(3)
  • Hippodrome Casino(1)
  • IPO(1)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(7)
  • Kings of Tallinn(1)
  • LAPT(2)
  • London Poker Festival(1)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(0)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(5)
  • Moneymaker Tour(3)
  • North American Poker Tour(1)
  • Olympic Park Casino(1)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(0)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • 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(1)
  • Unibet DeepStack Open(6)
  • Unibet Open(0)
  • Venetian Deepstack Extravaganza(1)
  • Women's Winter Festival(1)
  • WPT(4)
  • WPT Alpha 8(0)
  • WPT Prime(3)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(11)
  • WSOP International Circuit(4)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(1)
• 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
  • London Poker Festival FinalTableFreeroll
  • Malta Poker Festival FinalTableFreeroll
  • MPF Autumn 24 VIP Package Giveaway
  • The Killarney Festival FinalTableFreeroll

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

Olympic Park Casino Event #6: €1M GTD €1,500 NLH Main Event Live Reporting - Day 4

Olympic Park Casino - Live Reporting Event #1: €250 No-Limit Hold'em (Estonian) Event #1: €250 No-Limit Hold'em Event #3: €555 No-Limit Hold'em Event #4: €350 PLO4&5 Progressive Bounty Event #5: €250 NLH Queens (Estonian) Event #5: €250 NLH Queens Event #6: €1M GTD €1,500 Main Event (Estonian) Event #6: €1M GTD €1,500 NLH Main Event Event #7: €1,100 PLO4&5 Event #8: €1,100 NLH Mystery Bounty Event #9: €3,000 No-Limit Hold'em Six-Max (Estonian) Event #9: €3,000 No-Limit Hold'em Six-Max Event #3: €555 No-Limit Hold'em (Finnish) Event #6: €1M GTD €1,500 NLH Main Event (Finnish) Event #7: €1,100 PLO4&5 (Finnish) Event #9: €3,000 No-Limit Hold'em Six-Max (Finnish)

---

Current Level 38 Current Day 4

---

Blinds 300,000/600,000 Ante 600000

Entries 812 Remaining 1

---

Prize Pool (EUR) €1,052,352 First Prize (EUR) €167,900

Chip Leaders Day 4

1

Aurimas Stanevicius

40,600,000

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

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 3

10:14 (UTC+2)

Day 3 of Olympic Park Casino Ended
Level: 32     Blinds: 75,000/100,000     Ante: 100,000

Final Table Seat Draw Posted Sunday 28th July, 2024 at 03:42(UTC+2) by Jason Glatzer

Seat	Name	Country	Chips	Big Blinds
1	Roberto Ahane Olsen	Sweden	6,925,000	46
2	Sergei Aleksejev	Estonia	3,500,000	23
3	Evgeny Vyal	Estonia	3,275,000	22
4	Kriss Riekstins	Latvia	2,000,000	13
5	Espen Smorholm Sandvik	Norway	1,900,000	13
6	Jeffrey Cormier	Canada	11,850,000	79
7	Yurii Zabrodotskyi	Ukraine	6,975,000	47
8	Mindaugas Kriauciunas	Lithuania	2,700,000	18
9	Aurimas Stanevicius	Lithuania	1,425,000	10

Enea Subashi Eliminated in 10th Place (€13,800) Posted Sunday 28th July, 2024 at 03:38(UTC+2) by Jason Glatzer

Level 29: 75,000/150,000 (150,000)
Entries: 9/812

Roberto Olsen opened for 300,000 from under the gun before Enea Subashi three-bet jammed for 875,000. Jeffrey Cormier four-bet shoved for 5,400,000 and Olsen called.

Enea Subashi:
Jeffrey Cormier:
Roberto Olsen:

It appeared likely that we would restart tomorrow with a eight-player final table. However, Cormier remained hot and asked for a ten.

A ten was asked, and a ten was received on the runout as Cormier won the main pot and side pot to eliminate Olsen on the final table bubble and double through Subashi to take the chip lead away from Olsen near the end of the night.

The action will resume for the final table at noon on Sunday with our coverage beginning at 12:30 p.m. to sync with the live-stream of the final table at OlyBet.tv.

Player		Chips	Progress
Jeffrey Cormier		11,850,000	6,850,000
Yurii Zabrodotskyi		6,975,000	2,650,000
Roberto Olsen		6,925,000	200,000
Sergei Aleksejev		3,500,000	1,100,000
Evgeny Vyal		3,275,000	1,325,000
Mindaugas Kriauciunas		2,700,000	750,000
Kriss Riekstins		2,000,000	500,000
Espen Sandvik		1,900,000	600,000
Aurimas Stanevicius		1,425,000	1,600,000
Enea Subashi		0	0

Riekstins Doubles Through Sandvik Posted Sunday 28th July, 2024 at 02:58(UTC+2) by Jason Glatzer

Level 29: 75,000/150,000 (150,000)
Entries: 10/812

Kriss Riekstins jammed for 1.1 million from early position and was called by Espen Sandvik from the button.

Kriss Riekstins:
Espen Sandvik:

Riekstins won the flip to stay alive and double through Sandvik after the ran out on the board.

Player		Chips	Progress
Kriss Riekstins		2,500,000	1,250,000
Espen Sandvik		2,500,000	1,175,000

01:17 (UTC+2)

Start of Level 32
Blinds: 75,000/100,000     Ante: 100,000

Break Time and Chip Counts Posted Sunday 28th July, 2024 at 01:17(UTC+2) by Jason Glatzer

Players are on what is likely their final break of Day 2. Check out the chip counts of the final 10 players below.

Player		Chips	Progress
Yurii Zabrodotskyi		9,625,000	6,625,000
Roberto Olsen		7,125,000	675,000
Jeffrey Cormier		5,000,000	1,535,000
Sergei Aleksejev		4,600,000	850,000
Espen Sandvik		3,675,000	975,000
Aurimas Stanevicius		3,025,000	975,000
Enea Subashi		2,400,000	700,000
Mindaugas Kriauciunas		1,950,000	700,000
Evgeny Vyal		1,950,000	1,665,000
Kriss Riekstins		1,250,000	1,050,000

Gunnar Wedde Eliminated in 11th Place (€13,800) Posted Sunday 28th July, 2024 at 00:51(UTC+2) by Jason Glatzer

Level 28: 50,000/125,000 (125,000)
Entries: 10/812

Just about every elimination is taking place at the feature table. You will have to watch the action to get the hand breakdown, but Gunnar Wedde had his stack of around a dozen big blinds committed with and was up against the held by Roberto Olsen.

"Good game," said Wedde after the ran out on the board.

Player		Chips	Progress
Roberto Olsen		7,800,000	4,325,000
Gunnar Wedde		0	0

Ignotas Tamasauskas Eliminated in 12th Place (€11,200) Posted Sunday 28th July, 2024 at 00:34(UTC+2) by Jason Glatzer

Level 28: 50,000/125,000 (125,000)
Entries: 11/812

Yet another elimination took place at the televised feature table. This time, it was Ignotas Tamasauskas who hit the rail in 12th place when his was no good for about 16 big blinds against the held by Aurimas Stanevicius after the ran out on the board.

Player		Chips	Progress
Aurimas Stanevicius		4,000,000	2,470,000
Ignotas Tamasauskas		0	0

00:10 (UTC+2)

Start of Level 31
Blinds: 50,000/125,000     Ante: 125,000

Vilius Zabarauskas Eliminated in 13th Place (€13,200) Posted Saturday 27th July, 2024 at 23:43(UTC+2) by Jason Glatzer

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

As of late, all the eliminations have occurred at the televised feature table. Vilius Zabarauskas was the latest to go. He jammed a short stack from the button and was called by Enea Subashi from the big blind.

Vilius Zabarauskas:
Enea Subashi:

Zabarauskas was ahead but fell to Subashi's trips in 13th place for €13,200 after the ran out on the board.

Player		Chips	Progress
Enea Subashi		1,700,000	440,000
Vilius Zabarauskas		0	0

Marius Morel Eliminated in 14th Place (€9,200) Posted Saturday 27th July, 2024 at 23:29(UTC+2) by Jason Glatzer

Level 28: 50,000/100,000 (100,000)
Entries: 13/812

Estonian hero Marius Morel just hit the rail, while Jeffrey Cormier continues to run red-hot at the final table. In this last hand, he even called the river card.

Morel got his short stack in at the feature table with and was up against the held by Jeffrey Cormier.

Cormier asked for a queen on the river and one came to keep his sixes safe on the runout for Morel to exit in 14th place.

Player		Chips	Progress
Jeffrey Cormier		5,500,000	2,535,000
Marius Morel		0	0

23:28 (UTC+2)

Start of Level 30
Blinds: 50,000/100,000     Ante: 100,000

Vilde Fagerbakke Eliminated in 15th Place (€9,200) Posted Saturday 27th July, 2024 at 23:28(UTC+2) by Jason Glatzer

Level 26: 40,000/80,000 (80,000)
Entries: 14/812

Vilde Fagerbakke got her last million or so chips in against Jeffrey Cormier at the feature table. You can check out the action at OlyBet.tv.

Vilde Fagerbakke:
Jeffrey Cormier:

Cormier celebrated after his fours held to oust Fagerbakke in 15th place for €9,200. The clock paused after this hand for a chip race of the 5,000 chips.

Player		Chips	Progress
Jeffrey Cormier		4,000,000	1,035,000
Vilde Fagerbakke		0	0

Sohrab Malkari Eliminated in 16th Place (€8,001) Posted Saturday 27th July, 2024 at 23:11(UTC+2) by Jason Glatzer

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

Sohrab Malkari lost most of his stack when his was unable to hold against Kriss Riekstins's on the runout.

The rest went shortly after when he jammed into the held by Yurii Zabrodotskyi. The ran out on the board for Malkari to hit the rail in 16th place for €8,001.

Player		Chips	Progress
Yurii Zabrodotskyi		3,000,000	605,000
Kriss Riekstins		2,300,000	1,260,000
Sohrab Malkari		0	0

Gunnar Wedde Leads Final Two Tables Posted Saturday 27th July, 2024 at 22:32(UTC+2) by Jason Glatzer

Player		Chips	Progress
Gunnar Wedde		4,545,000	1,735,000
Espen Sandvik		4,065,000	250,000
Ignotas Tamasauskas		3,855,000	45,000
Sergei Aleksejev		3,750,000	25,000
Evgeny Vyal		3,615,000	600,000
Roberto Olsen		3,475,000	405,000
Jeffrey Cormier		2,965,000	135,000
Mindaugas Kriauciunas		2,650,000	280,000
Yurii Zabrodotskyi		2,580,000	220,000
Sohrab Malkari		2,440,000	565,000
Aurimas Stanevicius		1,530,000	1,095,000
Enea Subashi		1,260,000	610,000
Vilde Fagerbakke		1,070,000	430,000
Kriss Riekstins		1,040,000	260,000
Marius Morel		945,000	1,155,000
Vilius Zabarauskas		815,000	2,405,000

Slack Elimination in 17th Place (€8,001) Posted Saturday 27th July, 2024 at 22:32(UTC+2) by Alaxandar Georgiev

Level 26: 40,000/80,000 (80,000)
Entries: 17/812

Blind-on-blind action between Ben Slack and Espen Sandvik on the big blind. Slack jammed for 1,300,000 chips and Sandvik called him real quick.

Ben Slack:
Espen Sandvik:

Slack needed to hit one of the other 3 aces or some other combination to stay in and fight for the big money. The flop came king high and there weren't any aces showing, the turn was another club and now Slack was also drawing to make a flush.

The river meant it was time to shake hands and say goodbyes for Slack. He finished the tournament in 17th place and took home €8,001.

Player		Chips	Progress
Espen Sandvik		4,400,000	585,000
Ben Slack		0	0

Wedde Gets Paid With Big Slick Posted Saturday 27th July, 2024 at 22:25(UTC+2) by Jason Glatzer

Level 26: 40,000/80,000 (80,000)
Entries: 17/812

Gunnar Wedde fired a pot-sized bet of 900,000 with the on the board after the river. Yurii Zabrodotskyi went into the tank for a couple of minutes before he called.

Wedde turned over an unbeatable hand with to win the pot after Zabrodotskyi tossed his cards face down into the muck.

Player		Chips	Progress
Gunnar Wedde		4,000,000	1,190,000
Yurii Zabrodotskyi		2,000,000	185,000

Fagerbakke Doubles With Ace-Ten Posted Saturday 27th July, 2024 at 22:03(UTC+2) by Jason Glatzer

Level 26: 40,000/80,000 (80,000)
Entries: 17/812

Yurii Zabrodotskyi mini-raised from the hijack before Vilde Fagerbakke three-bet jammed for 655,000 from the cutoff. Zabrodotskyi asked for a count before he found a call.

Vilde Fagerbakke:
Yurii Zabrodotskyi:

Ace-ten was good on the runout for Fagerbakke to double her short stack.

Player		Chips	Progress
Yurii Zabrodotskyi		2,800,000	615,000
Vilde Fagerbakke		1,500,000	165,000

22:03 (UTC+2)

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

Lucky Double for Olsen Posted Saturday 27th July, 2024 at 22:03(UTC+2) by Jason Glatzer

Level 25: 30,000/60,000 (60,000)
Entries: 17/812

Roberto Olsen was nearly on the rail but instead now has a healthy stack. Olsen opened for 125,000 from under the gun. Ignotas Tamasauskas raised to 425,000 from the small blind. Olsen four-bet jammed for 1,650,000 and Tamasauskas called.

Roberto Olsen:
Ignotas Tamasauskas:

"Oh no," said Olsen when the cards were tabled.

Olsen got there with two pair on the runout to stave off elimination.

Player		Chips	Progress
Ignotas Tamasauskas		3,900,000	100,000
Roberto Olsen		3,400,000	1,880,000

Nohad Teliani Eliminated in 18th Place (€6,900) Posted Saturday 27th July, 2024 at 21:29(UTC+2) by Jason Glatzer

Level 25: 30,000/60,000 (60,000)
Entries: 17/812

Over at the feature table, Nohad Teliani lost her stack to Evgeny Vyal when her was unable to hold against . You can watch the hand on the stream at OlyBet.tv.

Meanwhile, this leaves Vilde Fagerbakke as the last lady standing in the Main Event.

Player		Chips	Progress
Nohad Teliani		0	0

Liutauras Armanavicius Eliminated in 19th Place (€6,900) Posted Saturday 27th July, 2024 at 21:21(UTC+2) by Jason Glatzer

Level 25: 30,000/60,000 (60,000)
Entries: 18/812

Liutauras Armanavicius jammed his short stack of 295,000 from the hijack. Roberto Olsen asked for a count before he jammed for a bit more from the small blind.

Liutauras Armanavicius:
Roberto Olsen:

The board was unable to save Armanavicius and he was eliminated in 19th place for €6,900.

Player		Chips	Progress
Roberto Olsen		2,000,000	480,000
Liutauras Armanavicius		0	0

Matte Karjalainen Eliminated in 20th Place (€6,900) Posted Saturday 27th July, 2024 at 21:08(UTC+2) by Jason Glatzer

Level 25: 30,000/60,000 (60,000)
Entries: 19/812

Matte Karjalainen had his short stack in good at the televised feature table with and was up against the held by Marius Morel.

Morel got there for a straight on the board to eliminate Karjalainen in 20th place for €6,900.

Player		Chips	Progress
Marius Morel		2,100,000	550,000
Matte Karjalainen		0	0

Slack Doubles Through Armanavicius Posted Saturday 27th July, 2024 at 21:06(UTC+2) by Jason Glatzer

Level 25: 30,000/60,000 (60,000)
Entries: 20/812

Ben Slack jammed for 885,000 from the cutoff. Liutauras Armanavicius asked for a count from the button before eventually jamming over the top for a bit more.

Ben Slack:
Liutauras Armanavicius:

Slack doubled his stack after the safely ran out on the board.

Player		Chips	Progress
Ben Slack		1,850,000	815,000
Liutauras Armanavicius		650,000	875,000

Robert Rudolf Rohr Eliminated in 21st Place (€6,100) Posted Saturday 27th July, 2024 at 20:59(UTC+2) by Jason Glatzer

Level 25: 30,000/60,000 (60,000)
Entries: 20/812

Ignotas Tamasauskas opened for 125,000 from the cutoff. Robert Rohr three-bet jammed the button for around 720,000, and Tamasauskas called.

Robert Rohr:
Ignotas Tamasauskas:

Tamasauskas nailed a set on the runout to win the flip and eliminate Rohr in 20th place for €6,100.

Player		Chips	Progress
Ignotas Tamasauskas		4,000,000	695,000
Robert Rohr		0	0

WSCOPC €350 Online Ring Event Posted Saturday 27th July, 2024 at 20:51(UTC+2) by Lina Olofsson

For anyone who wants to be in on the action but couldn't make it here to Tallinn the Online Event started 45 minutes ago on Olybet. It's open to all players in Estonia, Lithuania, Finland, and Latvia and so far 88 players bought in and compete for the 11th golden ring. 

Late registration is open until 11 pm for the ones who feel urged to play and has an account with Olybet. 

20:44 (UTC+2)

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

Sandvik Leads at Break Posted Saturday 27th July, 2024 at 20:01(UTC+2) by Jason Glatzer

Espen Sandvik leads the way at the dinner break over the 21 hopefuls remaining the 2024 WSOP Circuit Tallinn €1,500 Main Event.

Check out the full chip counts at the break:

Player		Chips	Progress
Espen Sandvik		3,815,000	185,000
Sergei Aleksejev		3,725,000	745,000
Ignotas Tamasauskas		3,305,000	2,325,000
Vilius Zabarauskas		3,220,000	780,000
Evgeny Vyal		3,015,000	1,460,000
Jeffrey Cormier		2,830,000	475,000
Gunnar Wedde		2,810,000	1,095,000
Mindaugas Kriauciunas		2,370,000	695,000
Yurii Zabrodotskyi		2,185,000	860,000
Sohrab Malkari		1,875,000	115,000
Vilde Fagerbakke		1,665,000	585,000
Marius Morel		1,550,000	690,000
Liutauras Armanavicius		1,525,000	240,000
Roberto Olsen		1,520,000	1,020,000
Ben Slack		1,035,000	365,000
Robert Rohr		895,000	755,000
Kriss Riekstins		780,000	720,000
Nohad Teliani		755,000	305,000
Enea Subashi		650,000	265,000
Matte Karjalainen		640,000	435,000
Aurimas Stanevicius		435,000	1,375,000

Dinner Time Posted Saturday 27th July, 2024 at 19:52(UTC+2) by Jason Glatzer

Players are on a one-hour dinner break. When the action resumes, blinds will increase to 30,000/60,000 (60,000).

Jaarko Soukas Eliminated in 22rd Place (€6,100) Posted Saturday 27th July, 2024 at 19:46(UTC+2) by Jason Glatzer

Level 24: 25,000/50,000 (50,000)
Entries: 21/812

Jaarko Suokas jammed for 615,000 from late position and was called by Espen Sandvik from the small blind.

Jaarko Soukas:
Espen Sandvik:

Aces held to oust Suokas in 23rd place for €6,100 after the ran out on the board.

Player		Chips	Progress
Espen Sandvik		4,000,000	500,000
Jarkko Suokas		0	0

Aleksei Vandyshev Eliminated in 23rd Place (€6,100) Posted Saturday 27th July, 2024 at 19:32(UTC+2) by Jason Glatzer

Level 24: 25,000/50,000 (50,000)
Entries: 22/812

Aleksei Vandyshev had crumbs in his stack when his 35,000 in chips went in from middle position. Ignotas Tamasauskas raised to 100,000 and Roberto Olsen defended his big blind.

Olsen check-called bets of 50,000 on the flop and for 300,000 on the turn before both players checked the river. Vandyshev was out the door with , while Olsen held . Meanwhile, Tamasauskas won the hand with to take down the pot.

Player		Chips	Progress
Ignotas Tamasauskas		2,500,000	1,665,000
Roberto Olsen		600,000	100,000
Aleksei Vandyshev		0	0

Tamasauskas Doubles With Big Slick Posted Saturday 27th July, 2024 at 19:22(UTC+2) by Jason Glatzer

Level 24: 25,000/50,000 (50,000)
Entries: 23/812

Ignotas Tamasauskas four-bet jammed for 1,050,000 and was called by Robert Rohr.

Ignotas Tamasauskas:
Robert Rohr:

There was a bit of drama after the turn but the river put things back where they were preflop after the board results in Tamasauskas doubling through Rohr.

Player		Chips	Progress
Ignotas Tamasauskas		2,300,000	1,465,000
Robert Rohr		1,650,000	115,000

18:50 (UTC+2)

Start of Level 27
Blinds: 25,000/50,000     Ante: 50,000

Kaspar Kaisel Eliminated in 24th Place (€5,400) Posted Saturday 27th July, 2024 at 18:49(UTC+2) by Jason Glatzer

Level 24: 20,000/40,000 (40,000)
Entries: 23/812

Kaspar Kaisel committed his seven big blind stack and got it in good against Aleksei Vandyshev.

Kaspar Kaisel:
Aleksei Vandyshev:

Kaisel was far ahead after the flop. The turn improved to Vandyshev to a full house much to the dismay of Kaisel.

"Good game," Kaisel said after not getting back up front on the river.

Player		Chips	Progress
Aleksei Vandyshev		1,200,000	110,000
Kaspar Kaisel		0	0

Malkari Wins a Flip With Sevens Posted Saturday 27th July, 2024 at 18:46(UTC+2) by Jason Glatzer

Level 24: 20,000/40,000 (40,000)
Entries: 24/812

Sohrab Malkari opened from under the gun before he called a three-bet jam by Roberto Olsen from the big blind for 850,000.

Sohrab Malkari:
Roberto Olsen:

Malkari won the flip to stay alive and double his stack after the ran out on the board.

Player		Chips	Progress
Sohrab Malkari		1,760,000	855,000
Roberto Olsen		700,000	895,000

Big Slick for Sandvik Posted Saturday 27th July, 2024 at 18:21(UTC+2) by Jason Glatzer

Level 24: 20,000/40,000 (40,000)
Entries: 24/812

Espen Sandvik opened for 80,000 from middle position. Vilius Zabarauskas three-bet to 230,000 from one seat over, and Sandvik called.

Sandvik check-called a bet of 160,000 by Zabarauskas on the flop before check-calling a bet of 225,000 on the turn. The river completed the board. Sandvik led out for a small sizing of 130,000. Zabarauskas went into the tank before he called.

Sandvik tabled the and won the hand after Zabarauskas mucked his cards.

Player		Chips	Progress
Vilius Zabarauskas		4,000,000	635,000
Espen Sandvik		3,500,000	605,000

Delay and Chip Counts Posted Saturday 27th July, 2024 at 17:39(UTC+2) by Jason Glatzer

Our reporting will now be on a 30-minute delay so as not to give away any spoilers from the stream.

Vilius Zabarauskas had the chip lead over the final 24 players. Check out the full chip counts below:

Player		Chips	Progress
Vilius Zabarauskas		4,635,000	2,800,000
Sergei Aleksejev		4,470,000	170,000
Jeffrey Cormier		3,305,000	255,000
Espen Sandvik		2,895,000	980,000
Aurimas Stanevicius		1,810,000	150,000
Gunnar Wedde		1,715,000	625,000
Mindaugas Kriauciunas		1,675,000	765,000
Roberto Olsen		1,595,000	405,000
Evgeny Vyal		1,555,000	170,000
Robert Rohr		1,535,000	165,000
Kriss Riekstins		1,500,000	1,200,000
Ben Slack		1,400,000	200,000
Kaspar Kaisel		1,375,000	90,000
Yurii Zabrodotskyi		1,325,000	1,245,000
Jarkko Suokas		1,315,000	5,000
Liutauras Armanavicius		1,285,000	215,000
Aleksei Vandyshev		1,090,000	400,000
Vilde Fagerbakke		1,080,000	30,000
Matte Karjalainen		1,075,000	925,000
Enea Subashi		915,000	880,000
Sohrab Malkari		905,000	75,000
Marius Morel		860,000	245,000
Ignotas Tamasauskas		835,000	370,000
Nohad Teliani		450,000	300,000

Pihela Jr. Loses Flip to Aleksejev Posted Saturday 27th July, 2024 at 17:13(UTC+2) by Jason Glatzer

Level 24: 20,000/40,000 (40,000)
Entries: 24/812

Igor Pihela Jr three-bet jammed for more than 700,000 from the blinds and was called by Sergei Aleksejev, who originally opened from early position.

Igor Pihela Jr:
Sergei Aleksejev:

Aleksejev's ace found a partner on the board to eliminate Pihela in 25th place. Robert Kaggerud also recently hit the rail in 26th place, shortly before Aleksejev.

Player		Chips	Progress
Sergei Aleksejev		4,300,000	500,000
Robert Kaggerud		0	0
Igor Pihela Jr		0	0

16:58 (UTC+2)

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

Krumins Bricks Flush Draw Posted Saturday 27th July, 2024 at 16:58(UTC+2) by Jason Glatzer

Level 25: 15,000/30,000 (30,000)
Entries: 26/812

Eriks Krumins was aiming to win his second WSOP Circuit Tallinn ring this festival in a huge way but just hit the rail in 29th place to Sergei Aleksejev.

Krumins committed his stack from the blinds with and was up against the of Aleksejev on the flop. Krumins bricked the turn and river to exit to Aleksejev's straight.

Player		Chips	Progress
Sergei Aleksejev		3,800,000	1,675,000
Mairo Tori		0	0
Juuso Koskela		0	0
Roope Tarmi		0	0
Eriks Krumins		0	0

Day 8 Video Recap Posted Saturday 27th July, 2024 at 16:53(UTC+2) by Jason Glatzer

Krumins Busts Petelytskyi Posted Saturday 27th July, 2024 at 16:30(UTC+2) by Jason Glatzer

Level 25: 15,000/30,000 (30,000)
Entries: 30/812

Roman Petelytskyi jammed his short stack from late position and was called by Event #1: €250 NLH champion Eriks Krumins from the big blind.

Roman Petelytskyi:
Eriks Krumins:

Krumins connected with his jack to finish with a better two pair to eliminate Petelytskyi in 31st place with Gregory Telman and Elias Suhonen also hitting the rail during Level 25.

Player		Chips	Progress
Eriks Krumins		1,100,000	805,000
Gregory Telman		0	0
Roman Petelytskyi		0	0
Elias Suhonen		0	0

Malkari Doubles With Sixes Posted Saturday 27th July, 2024 at 16:23(UTC+2) by Jason Glatzer

Level 25: 15,000/30,000 (30,000)
Entries: 31/812

Sohrab Malkari jammed from early position and was called by Roberto Olsen from the blinds.

Sohrab Malkari:
Roberto Olsen:

Malkari's sixes won the flip on the runout, but Malkari stood up, appearing to some, including Jeffrey Cormier, as ready to go.

"You won the hand," said Cormier.

"I know," said Malkari, now getting ready to sit back down after breathing a huge sigh of relief. "I am not stupid."

"Nice hand," Olsen said soon after before addressing the table. "He deserved it after the hand before."

Player		Chips	Progress
Roberto Olsen		2,000,000	1,435,000
Sohrab Malkari		980,000	525,000

New TV Table Line-Up and Chip Counts Posted Saturday 27th July, 2024 at 16:00(UTC+2) by Jason Glatzer

There will be a new TV table live on air soon at OlyBet.tv. Check out the line-up and chip counts below:

Player		Chips	Progress
Aurimas Stanevicius		1,960,000	10,000
Vilius Zabarauskas		1,835,000	725,000
Enea Subashi		1,795,000	780,000
Evgeny Vyal		1,385,000	85,000
Mindaugas Kriauciunas		910,000	655,000
Roope Tarmi		835,000	415,000
Gregory Telman		495,000	225,000

15:49 (UTC+2)

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

Cormier Leads at Break Posted Saturday 27th July, 2024 at 15:44(UTC+2) by Jason Glatzer

Jeffrey Cormier took the chip lead at the TV table after a blind vs. blind cooler against Elias Suhonen.

Cormier flopped a set, while Suhonen flopped two pair. You won't have to rewind much to check it out on the stream at OlyBet.tv.

Player		Chips	Progress
Jeffrey Cormier		3,050,000	2,595,000
Sergei Aleksejev		2,125,000	1,897,000
Matte Karjalainen		2,000,000	1,520,000
Aurimas Stanevicius		1,950,000	50,000
Espen Sandvik		1,915,000	1,645,000
Eriks Krumins		1,905,000	595,000
Vilius Zabarauskas		1,835,000	765,000
Vilius Zabarauskas		1,795,000	725,000
Robert Rohr		1,700,000	1,447,000

Second Break Posted Saturday 27th July, 2024 at 15:23(UTC+2) by Jason Glatzer

Players are on their second break. Blinds will increase to 15,000/30,000 (30,000) when the action resumes in 20 minutes.

Haapaniemi Loses Short Stack Posted Saturday 27th July, 2024 at 15:21(UTC+2) by Jason Glatzer

Level 24: 10,000/25,000 (25,000)
Entries: 33/812

Ignotas Tamasauskas jammed the button for 375,000. Sauli Haapaniemi (pictured below) called off his tiny stack of 55,000 from the small blind and was pleased to see he had two live cards.

Sauli Haapaniemi:
Ignotas Tamasauskas:

Ace-ten held on the runout to eliminate Haapaniemi in 34th place.

Player		Chips	Progress
Ignotas Tamasauskas		465,000	750,000
Sauli Haapaniemi		0	0

Set of Ducks for Krumins Posted Saturday 27th July, 2024 at 15:16(UTC+2) by Jason Glatzer

Level 24: 10,000/25,000 (25,000)
Entries: 34/812

Rubens Akopjancs opened from middle position to 50,000. Event #1: €250 NLH champion Eriks Krumins three-bet to 150,000 from the cutoff and Akopjancs called.

Akopjancs check-raised the flop from 150,000 to 300,000 and Krumins called. Akopjancs jammed for less than 800,000 on the turn. Krumins snap-called and had his opponent drawing to two outs for his tournament life.

Rubens Akopjancs:
Eriks Krumins:

Bottom set held after the river completed the board to eliminate Akopjancs. Meanwhile, Henri Katila and Laurynas Vaitkevicius hit the rail to leave 34 players remaining with the break minutes away.

Player		Chips	Progress
Eriks Krumins		2,500,000	1,400,000
Laurynas Vaitkevicius		0	0
Henri Katila		0	0
Rubens Akopjancs		0	0

Klezys Loses Flip to Vyal Posted Saturday 27th July, 2024 at 14:40(UTC+2) by Jason Glatzer

Level 24: 10,000/25,000 (25,000)
Entries: 37/812

Kasparas Klezys jammed the button for 530,000. Evgeny Vyal asked for a count before he called from the small blind for more than half his stack. Mindaugas Kriauciunas folded his short stack from the big blind and the cards were turned over.

Kasparas Klezys:
Evgeny Vyal:

Klezys was ahead until the river. He said "good game" to the rest of the table after losing the flip and ending up in 38th place on the board.

Meanwhile, start-of-the-day chip leader Paul Koppe, Juuso Oksanen, and Niko Ilmonen also exited recently.

Player		Chips	Progress
Evgeny Vyal		1,300,000	510,000
Niko Ilmonen		0	0
Juuso Oksanen		0	0
Paul Koppe		0	0
Kasparas Klezys		0	0

14:24 (UTC+2)

Start of Level 24
Blinds: 10,000/25,000     Ante: 25,000

Fagerbakke and Teliani Final Two Women Posted Saturday 27th July, 2024 at 14:21(UTC+2) by Jason Glatzer

Level 23: 10,000/20,000 (20,000)
Entries: 41/812

Vilde Fagerbakke and Nohad Teliani (both pictured below) were the final two women in the Main Event to start the day. They have witnessed more than a couple of dozen players hit the rail in their quest to make tomorrow's final table of nine players for a chance to win the Main Event.

We wish both ladies the best of luck. Along with the other players, we will keep you updated on their progress throughout the day.

Player		Chips	Progress
Vilde Fagerbakke		1,050,000	210,000
Nohad Teliani		750,000	95,000

Stanevicius Eliminates Stankevics Posted Saturday 27th July, 2024 at 14:02(UTC+2) by Jason Glatzer

Level 23: 10,000/20,000 (20,000)
Entries: 43/812

Gunnar Wedde survived a scare with ace-queen against Igor Pihela Jr's ace-king on a double-paired board as another all-in and call was taking place at the table behind this action.

Krisjanis Stankevics jammed for approximately a dozen big blinds from early position. Aurimas Stanevicius (pictured below) paused for a few moments from a few seats over before he called while the rest of the table folded.

Krisjanis Stankevics:
Aurimas Stanevicius:

Stanevicius ousted Stankevics after the ran out on the board, while Andre Villandberg, Jukka Moisio, and Daniel Clifford all hit the rail to leave just 41 players remaining.

Player		Chips	Progress
Aurimas Stanevicius		1,900,000	350,000
Krisjanis Stankevics		0	0
Daniel Clifford		0	0
Jukka Moisio		0	0
Andre Villandberg		0	0

Parnat Runs Into Slack's Cowboys Posted Saturday 27th July, 2024 at 13:48(UTC+2) by Jason Glatzer

Level 23: 10,000/20,000 (20,000)
Entries: 45/812

Ben Slack opened from middle position for 45,000. Risto Parnat three-bet jammed for about a dozen big blinds from the button and Slack snap-called.

Risto Parnat:
Ben Slack:

Slack nailed a set on the flop. Parnat had some thin hope and asked for his "one-time" after the followed on the turn.

A blank on the river ended Parnat's deep run in the Main Event in 46th place, with Joshua Stewart hitting the rail just before Parnat.

Player		Chips	Progress
Ben Slack		1,200,000	670,000
Joshua Stewart		0	0
Risto Parnat		0	0

Berggren Loses Short Stack to Tori Posted Saturday 27th July, 2024 at 13:32(UTC+2) by Jason Glatzer

Level 23: 10,000/20,000 (20,000)
Entries: 47/812

Mairo Tori opened for 45,000 from the cutoff. Christoffer Berggren three-bet jammed for about five big blinds from the button, and Tori called.

Christopher Berggren:
Mairo Tori:

Although Berggren had some draws on the turn, he lost to Tori's straight after the ran out on the board.

Player		Chips	Progress
Mairo Tori		750,000	250,000
Victor Fernandez Garcia		0	0
Christopher Berggren		0	0

13:25 (UTC+2)

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

Big Stacks at Break Posted Saturday 27th July, 2024 at 13:21(UTC+2) by Jason Glatzer

Player		Chips	Progress
Enea Subashi		2,575,000	25,000
Yurii Zabrodotskyi		2,570,000	1,225,000
Rubens Akopjancs		2,300,000	810,000
Aurimas Stanevicius		1,550,000	400,000
Elias Suhonen		1,510,000	250,000
Jarkko Suokas		1,310,000	750,000
Vilde Fagerbakke		1,260,000	1,150,000
Eriks Krumins		1,100,000	495,000

First Break Posted Saturday 27th July, 2024 at 13:04(UTC+2) by Jason Glatzer

Players are on a 20-minute break. Blinds will increase to 10,000/20,000 with a 20,000 big blind ante when the action resumes.

Subashi Chipping Up Posted Saturday 27th July, 2024 at 13:03(UTC+2) by Jason Glatzer

Level 22: 10,000/15,000 (15,000)
Entries: 49/812

Enea Subashi jammed for more than the 500,000 or so that Nicolai Ejstrud had in his stack with a four-five-six-seven on the board after the river.

Ejstrud eventually called and turned over the . Subashi turned over the for the straight to take Ejstrud's stack.

Player		Chips	Progress
Enea Subashi		2,600,000	945,000
Tero Kilkanen		0	0
Nicolai Ejstrud		0	0
Ermo Kosk		0	0

Recent Eliminations Posted Saturday 27th July, 2024 at 12:47(UTC+2) by Jason Glatzer

Level 22: 10,000/15,000 (15,000)
Entries: 52/812

The following players recently were eliminated from the Main Event, leaving just 52 players remaining.

Player		Chips	Progress
Matias Kesanen		0	0
Andre Grigorjev		0	0
Mauri Dorbek		0	0
Sondre Lunde		0	0
Janis Leja		0	0
Nicklas Dehli		0	0

Lindberg Loses Flip to Armanavicius Posted Saturday 27th July, 2024 at 12:29(UTC+2) by Jason Glatzer

Level 22: 10,000/15,000 (15,000)
Entries: 58/812

Bjorn Lindberg four-bet jammed for 365,000 and was called by Liutauras Armanavicius.

Bjorn Lindberg:
Liutauras Armanavicius:

Lindberg got out of his chair and was ready to go despite improving to the top pair in the flop. Although this was normally good, in this case, Armanavicius improved to a set.

Lindberg had more hope on the turn but bricked the to end his Day 3 run early.

Player		Chips	Progress
Liutauras Armanavicius		1,500,000	345,000
Markku Koplimaa		0	0
Rustam Havryliuk		0	0
Tapio Aaltonen		0	0
Artur Kulanurk		0	0
Bjorn Lindberg		0	0

Jacks Good for Teliani Posted Saturday 27th July, 2024 at 12:20(UTC+2) by Jason Glatzer

Level 22: 10,000/15,000 (15,000)
Entries: 63/812

Daniel Clifford opened for 30,000 from early position. Nohad Teliani three-bet to 110,000 from one seat over before Robert Kaggerud four-bet shoved for about 900,000. Clifford quickly folded, while Teliani needed about 20 seconds to call off her stack of 345,000.

Nohad Teliani:
Robert Kaggerud:

Jacks beat tens on the runout for Teliani to earn an early double. Meanwhile, five players already hit the rail in the early moments including former OlyBet Poker manager Martin Piik.

Player		Chips	Progress
Nohad Teliani		845,000	345,000
Robert Kaggerud		540,000	360,000
Martin Piik		0	0
Andrei Silencov		0	0
Konstantin Farber		0	0
Jyri Merivirta		0	0
Steven Tool		0	0

Chip Leader Paul Koppe at TV Table Posted Saturday 27th July, 2024 at 12:14(UTC+2) by Jason Glatzer

Level 22: 10,000/15,000 (15,000)
Entries: 68/812

The feature table has just kicked off with the action starting at OlyBet.tv at 12:30 p.m. with hole cards exposed.

Chip leader Paul Koppe, Estonian poker beast Markku Koplimaa, and Canada's Jeffrey Cormier are among the players at the table.

Cards in the Air Posted Saturday 27th July, 2024 at 12:03(UTC+2) by Jason Glatzer

Level 22: 10,000/15,000 (15,000)
Entries: 68/812

Cards are in the air to start the penultimate day of the Main Event.

Paul Koppe Leads Final 68 Players in 2024 WSOP Circuit Tallinn Main Event Posted Saturday 27th July, 2024 at 10:41(UTC+2) by Jason Glatzer

Day 2 of the 2024 WSOP Circuit €1,500 Main Event made history at Olympic Park Casino and the Hilton Tallinn Park on Friday. 119 new entries came into the mix before late registration closed on Day 2, bringing the field up to 812 entries. The €1,052,352 prize pool crushed the €1,000,000 guarantee and set a new record for the largest event in Olympic Tallinn Park history.

The action played well past the money bubble, which paid the top 103 entries at least a €3,000 min-cash for double the €1,500 buy-in after Estonian poker hero Igor Pihela Jr. delivered a bad beat with ace-jack vs. ace-king on an ace-high board to eliminate Finland's Nemo Israel emptyhanded.

Estonia's Paul Koppe leads the way with 1,660,000, with Greece's Enea Subashi just a chip behind with 1,655,000. Meanwhile, Eriks Krumins, who already won a WSOP Circuit gold ring this festival in Event #1: €250 NLH, is looking for their most prestigious ring, ending Day 2 in third place with 1,595,000. Fellow Latvian Rubens Akopjancs (fourth - 1,490,000) and Estonia's Kaspar Kaisel (1,465,000)

Place	Name	Country	Chips	Big Blinds
1	Paul Koppe	Estonia	1,660,000	111
2	Enea Subashi	Greece	1,655,000	110
3	Eriks Krumins	Latvia	1,595,000	106
4	Rubens Akopjancs	Latvia	1,490,000	99
5	Kaspar Kaisel	Estonia	1,465,000	98
6	Yurii Zabrodotskyi	Ukraine	1,345,000	90
7	Elias Suhonen	Finland	1,260,000	84
8	Ignotas Tamasauskas	Lithuania	1,215,000	81
9	Liutauras Armanavicius	Lithuania	1,155,000	77
10	Aurimas Stanevicius	Lithuania	1,150,000	77

Cards will be back in the air at noon on Saturday, with Day 3 playing down to a final table of nine players with one-hour blind levels. We will update you on the side tables while WSOP Circuit commentator George Sandford will hold down the commentating booth with guests throughout the day on the live-streamed feature table. You can check both out at OlyBet.tv.

Day 3 Seat Draw Posted Saturday 27th July, 2024 at 09:36(UTC+2) by Jason Glatzer

Table	Seat	Name	Country	Chips	Big Blinds
12	1	Risto Parnat	Estonia	325,000	22
12	2	Robert Kaggerud	Norway	900,000	60
12	3	Roman Petelytskyi	Ukraine	305,000	20
12	4	Daniel Clifford	Sweden	505,000	34
12	5	Nohad Teliani	Canada	500,000	33
12	6	Artur Külanurk	Estonia	60,000	4
12	7	Robert Rohr	Germany	253,000	17
12	8	Ignotas Tamasauskas	Lithuania	1,215,000	81
13	1	Gunnar Wedde	Norway	1,090,000	73
13	2	Marius Morel	Estonia	1,105,000	74
13	3	Andre Villandberg	Estonia	585,000	39
13	4	Mairo Tori	Estonia	500,000	33
13	5	Christopher Berggren	Sweden	515,000	34
13	6	Konstantin Färber	Germany	100,000	7
13	7	Vilde Fagerbakke	Norway	110,000	7
13	8	Rustam Havryliuk	Ukraine	115,000	8
14	1	Sondre Lunde	Norway	260,000	17
14	2	Matias Kesanen	Finland	390,000	26
14	3	Mindaugas Kriauciunas	Lithuania	255,000	17
14	4	Juuso Oksanen	Finland	210,000	14
14	5	Henri Katila	Finland	325,000	22
14	6	Roberto Olsen	Sweden	565,000	38
14	7	Espen Sandvik	Norway	270,000	18
14	8	Matte Karjalainen	Finland	480,000	32
15	1	Andre Grigorjev	Estonia	230,000	15
15	2	Jeffrey Cormier	Canada	455,000	30
15	3	Markku Koplimaa	Estonia	265,000	18
15	4	Jarkko Suokas	Finland	560,000	37
15	6	Niko Ilmonen	Finland	440,000	29
15	7	Yurii Zabrodotskyi	Ukraine	1,345,000	90
15	8	Paul Koppe	Estonia	1,660,000	111
16	1	Gregory Telman	Israel	270,000	18
16	3	Nicklas Dehli	Denmark	465,000	31
16	4	Ben Slack	United Kingdom	530,000	35
16	5	Juuso Koskela	Finland	370,000	25
16	6	Ermo Kosk	Estonia	445,000	30
16	7	Vilius Zabarauskas	Lithuania	1,070,000	71
16	8	Nicolai Ejstrud	Denmark	500,000	33
19	1	Eriks Krumins	Latvia	1,595,000	106
19	2	Kriss Riekstins	Latvia	300,000	20
19	3	Igor Pihela Jr	Estonia	245,000	16
19	4	Liutauras Armanavicius	Lithuania	1,155,000	77
19	5	Laurynas Vaitkevicius	Lithuania	745,000	50
19	6	Tero Kilkanen	Finland	285,000	19
19	7	Rubens Akopjancs	Latvia	1,490,000	99
19	8	Bjorn Lindberg	Sweden	460,000	31
20	1	Evgeny Vyal	Estonia	790,000	53
20	2	Krisjanis Stankevics	Latvia	235,000	16
20	3	Janis Leja	Latvia	125,000	8
20	4	Victor Fernandez Garcia	Spain	165,000	11
20	5	Aurimas Stanevicius	Lithuania	1,150,000	77
20	6	Tapio Aaltonen	Finland	369,000	25
20	7	Jukka Moisio	Finland	360,000	24
20	8	Kasparas Klezys	Lithuania	162,500	11
21	1	Roope Tarmi	Finland	420,000	28
21	2	Kaspar Kaisel	Estonia	1,465,000	98
21	3	Sergei Aleksejev	Estonia	228,000	15
21	4	Joshua Stewart	United Kingdom	735,000	49
21	5	Jyri Merivirta	Finland	154,500	10
21	7	Sauli Haapaniemi	Finland	115,000	8
21	8	Enea Subashi	Greece	1,655,000	110
22	1	Mauri Dorbek	Estonia	475,000	32
22	2	Steven Tool	Estonia	50,000	3
22	3	Elias Suhonen	Finland	1,260,000	84
22	4	Aleksei Vandyshev	Estonia	690,000	46
22	5	Martin Piik	Estonia	220,000	15
22	7	Sohrab Malkari	Norway	455,000	30
22	8	Andrei Silencov	Moldova	290,000	19

09:36 (UTC+2)

Day 3 of Olympic Park Casino Started
Level: 22     Blinds: 10,000/15,000     Ante: 15,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