0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0097 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1/2/updates'
ORDER BY `views` DESC

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1/2/updates', 1, '2024-12-23')

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

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

0.0002 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.0004 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

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

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

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

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

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

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

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

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

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

0.0328 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0069 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '97'
AND `published` = 1

0.0284 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0066 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '106'
AND `published` = 1

0.0284 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0065 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '111'
AND `published` = 1

0.0285 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0058 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '112'
AND `published` = 1

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

0.0277 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0058 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '115'
AND `published` = 1

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '28'
AND `name` = '2'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4673'
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` = '4668'
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` = '4672'
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` = '4658'
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` = '4660'
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` = '4655'
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` = '4654'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4643'
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` = '4642'
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` = '4635'
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` = '4633'
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` = '4634'
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` = '4627'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0067 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4800'
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` = '4792'
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` = '4790'
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` = '4789'
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` = '4786'
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` = '4784'
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` = '4781'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4749'
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` = '4751'
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` = '4743'
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` = '4742'
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` = '4738'
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` = '4736'
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` = '4734'
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` = '4732'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4692'
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` = '4691'
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` = '4689'
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` = '4686'
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` = '4684'
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` = '4683'
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` = '4678'
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` = '4674'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4673'
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` = '4668'
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` = '4672'
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` = '4658'
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` = '4660'
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` = '4655'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4627'
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` = '4626'
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` = '4622'
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` = '4617'
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` = '4616'
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` = '4613'
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` = '4607'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

    

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(3)
  • 888poker UK Poker League(6)
  • APAT(1)
  • APPT(0)
  • Aria Resort & Casino(1)
  • Asian Poker Tour(5)
  • Aspers Casino Westfield Stratford City(9)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(0)
  • British Poker Series(11)
  • BSOP(0)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(1)
  • EPT(2)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(70)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(0)
  • GUKPT Grosvenor(9)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Festival(0)
  • Irish Poker Open(1)
  • Irish Poker Tour(11)
  • Kings of Tallinn(1)
  • Kings of Vilnius(0)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(11)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Open(5)
  • Pure Poker Tour(0)
  • Queens of Tallinn(0)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(0)
  • The Caribbean Poker Series(0)
  • The Festival(0)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • Unibet DeepStack Open(2)
  • Venetian Deepstack Extravaganza(2)
  • Women's Winter Festival(0)
  • WPT(2)
  • WPT Prime(1)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(13)
  • WSOP International Circuit(5)
  • 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
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

Login / Register

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

English

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

• £   GBP
• $   USD
• €   EUR

WSOPC Tallinn Event #1: €555 No-Limit Hold'em Live Reporting - Day 3

WSOPC Tallinn - Live Reporting

Event #1: €555 No-Limit Hold'em See other events

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

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

---

Current Level 30 Current Day 3

---

Blinds 75,000/150,000 Ante 150000

Entries 382 Remaining 1

---

Prize Pool (EUR) €183,360 First Prize (EUR) €34,435

Chip Leaders Day 3

1

Viacheslav Sultanov

11,500,000

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

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 2

Rasmus Lundstrom & Larsen Torbjorn Leads Final 9 in Event #1: €555 No-Limit Hold'em Posted Saturday 16th September, 2023 at 22:02(UTC+0) by Jason Glatzer

Rasmus Lundstrom and Torbjorn Larsen (pictured above) will kick off the final table of nine players when the action resumes on Sunday for the final day of Event #1: €555 No-Limit Hold'em after ending the day with 2,555,000 and 2,445,000 in chips respecitvely.

Day 2 began with 330 entries and 170 players remaining. Another 52 entries got into the mix to bring the field up to 382 entries for a €183,360 prize pool. The top 47 players collected at least a €1,000 min-cash after Latvia's Matiss Celmins hit the rail.

Poker beasts Jon Kyte (16th - €1,950), Ranno Sootla (21st - €1,550), Max Avela (25th - €1,300), Glen Gaines (26th - €1,300), and Feras Abid (36th - €1,100) all finished in the money but bowed out before the final table.

Meanwhile, Lundstrom and Larsen will be joined by Lukasz Fraczek (1,640,000), Day 1c chip leader Charles-Eric Benoit (1,400,000), Viacheslav Sultanov (1,115,000), Aleksi Naski (995,000), Rimantas Boguzas (555,000), Georgios Skarparis (550,000), and Ryan Mandara (210,000) in the quest for the title and the €38,510 top prize with at least the ninth-place prize of €4,150 already locked up.

In a surprising, yet cool, turn of events, the final table will boast nine players from nine different nationalities.

The final table will be live-streamed at OlyBet.tv. We will also provide full coverage of the final table in our blog so be sure to tune back in when the action resumes at 12 p.m. on Sunday. Blinds will start at 30,000/60,000 with a 60,000 big blind ante and increase every 30 minutes until a winner is crowned.

Check out the Day 2 seat draw, the full Day 2 payouts, and the end-of-day chip counts below.

Final Table Seat Draw

Seat	Player	Country	Chips	Big Blinds
1	Aleksi Naski	Finland	995,000	17
2	Lukasz Fraczek	Poland	1,640,000	27
3	Charles-Eric Benoit	Canada	1,400,000	23
4	Rasmus Lundstrom	Sweden	2,555,000	43
5	Viacheslav Sultanov	Ukraine	1,115,000	19
6	Ryan Mandara	United Kingdom	210,000	4
7	Georgios Skarparis	Cyprus	550,000	9
8	Rimantas Boguzas	Lithuania	555,000	9
9	Torbjorn Larsen	Norway	2,445,000	41

Day 2 Payouts

Place	Player	Country	Prize
1			€38,510
2			€25,750
3			€17,750
4			€12,650
5			€9,300
6			€7,100
7			€5,800
8			€4,900
9			€4,150
10	Dominikas Ruskys	Lithuania	€3,550
11	Martin Piik	Estonia	€3,000
12	Jonas Ruginis	Lithuania	€3,000
13	Viktor Blinov	Estonia	€2,450
14	Andres Leppik	Estonia	€2,450
15	Tonis Viik	Estonia	€2,450
16	Jon Kyte	Norway	€1,950
17	Johan Grave	Norway	€1,550
18	Maksim Solodilov	Estonia	€1,550
19	Samuli Hietala	Finland	€1,550
20	Jan-Mikael Kesanen	Finland	€1,550
21	Ranno Sootla	Estonia	€1,550
22	Anatoly Filatov	Estonia	€1,550
23	Kazimieras Ramaska	Lithuania	€1,550
24	Risto Parnat	Estonia	€1,550
25	Max Avela	Finland	€1,300
26	Glen Gaines	United Kingdom	€1,300
27	Martin Lategui	Uruguay	€1,300
28	Kjetil Hanstvedt	Norway	€1,300
29	Atte Franssila	Finland	€1,300
30	Romas Bassus	Lithuania	€1,300
31	Athanasios Kostouros	Greece	€1,300
32	Roland Luik	Estonia	€1,300
33	Joshua Stewart	United Kingdom	€1,100
34	Sami-Sander Kivi	Estonia	€1,100
35	Hanno Kerem	Estonia	€1,100
36	Feras Abid	Finland	€1,100
37	Kai Lehto	Finland	€1,100
38	Jarno Jokiniemi	Finland	€1,100
39	Luca Beretta	Italy	€1,100
40	Kalle Keski Opas	Finland	€1,100
41	Vasileios Kokkinos	Greece	€1,000
42	Rauno Remmel	Estonia	€1,000
43	Dmitri Dudakov	Estonia	€1,000
44	Aleksandr Gamonovits	Estonia	€1,000
45	Antonios Onoufriou	Cyprus	€1,000
46	Marius Bacanskis	Lithuania	€1,000
47	Topi Palenius	Finland	€1,000

Player		Chips	Progress
Torbjorn Larsen		2,445,000	895,000
Lukasz Fraczek		1,640,000	840,000
Charles-Eric Benoit		1,400,000	110,000
Viacheslav Sultanov		1,115,000	235,000
Aleksi Naski		995,000	95,000
Rimantas Boguzas		555,000	155,000
Rasmus Lundstrom		555,000	945,000
Georgios Skarparis		550,000	100,000
Ryan Mandara		210,000	525,000

Larsen Wins The Last Flip Of Day 2 Posted Saturday 16th September, 2023 at 20:58(UTC+0) by Alaxandar Georgiev

Level 26: 25,000/50,000 (50,000)
Entries: 9/382

Dominykas Ruskys shoved from the cut-off for 670,000 chips and the decision was left with Torbjorn Larsen on the big blind. After a lot of consideration, Larsen made the call.

Torbjorn Larsen:
Dominykas Ruskys:  

Unfortunate flop for the Lithuanian as the dealer unfolded giving Larsen a pair and a huge chance to go to the Final Table. Turn changed nothing and Ruskys was already packing his things, another on the river saw the last player to bust the Day 2. 

He managed to win the price of €3,550 for finishing in 10th place.

Day 3 continues tomorrow with the final table with just nine players remaining in the hunt for the first WSOP gold ring of the inaugural WSOPC Tallinn.

Player		Chips	Progress
Torbjorn Larsen		1,550,000	670,000
Dominykas Ruskys		0	0

Boguzas Ousts Piik Posted Saturday 16th September, 2023 at 20:42(UTC+0) by Alaxandar Georgiev

Level 26: 25,000/50,000 (50,000)
Entries: 10/382

Martin Piik had another deep run but unfortunately the Estonian fell short of the final table. Piik called an under-the-gun all-in from Rimantas Boguzas for his remaining 230,000 chips.

Rimantas Boguzas: 
Martin Piik: 

Behind and at risk the flop  gave Piik a gut-shot for the straight, while the  on the turn improved Boguza's chances to win. The river  wasn't any good for Martin as he finished the tournament in 11th place cashing in €3,000.

Day 2 will finish when 9 players remain. 

Player		Chips	Progress
Rimantas Boguzas		400,000	50,000
Martin Piik		0	0

Ruginis Dusts Off Short Stack Posted Saturday 16th September, 2023 at 20:31(UTC+0) by Jason Glatzer

Level 26: 25,000/50,000 (50,000)
Entries: 11/382

It was a heck of a ride for Lithuania's Jonas Ruginis but sometimes good things must come to an end. Ruginis was down to just four big blinds when he jammed them from the small blind. Lukasz Fraczek called from the big blind and the cards were turned over.

Jonas Ruginis:
Lukasz Fraczek:

Ruginis was behind but had some hope with two live cards, however, was eliminated in 12th place for €3,000 after he bricked the board.

Player		Chips	Progress
Lukasz Fraczek		800,000	575,000
Jonas Ruginis		0	0

End of the Line for Blinov Posted Saturday 16th September, 2023 at 20:24(UTC+0) by Jason Glatzer

Level 26: 25,000/50,000 (50,000)
Entries: 12/382

Viktor Blinov (pictured below) was down to just six big blinds when he jammed from the button. Aleksi Naski asked for a count before he called from the small blind.

Viktor Blinov:
Aleksi Naski:

Blinov connected with his ten on the flop but it was more or less a coin-flip situation with Naski holding an overcard and a flush draw. The flush draw completed on the turn and Blinov wished the table a good game after the river completed the board.

Player		Chips	Progress
Aleksi Naski		900,000	270,000
Viktor Blinov		0	0

Leppik Runs Into Larsen's Rockets Posted Saturday 16th September, 2023 at 20:18(UTC+0) by Jason Glatzer

Level 26: 25,000/50,000 (50,000)
Entries: 13/382

Andres Leppik (pictured below) jammed from the small blind for around 10 big blinds and was called by Torbjorn Larsen from the big blind.

Andres Leppik:
Torbjorn Larsen:

It was a bit of bad luck for Leppik to wake up with a strong hand in the small blind only to go up against the best hand in poker. Leppik improved to a full house on the runout. However, his eights full of kings wasn't as good as Larsen's eights full of aces and he hit the rail in 14th place for €2,450.

20:12 (UTC+0)

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

Lundstrom Eliminates Viik and Takes Lead With Lucky Cowboys Posted Saturday 16th September, 2023 at 20:12(UTC+0) by Jason Glatzer

Level 25: 20,000/40,000 (40,000)
Entries: 14/382

Three players had their stacks committed preflop with Tonis Viik (pictured below) getting his last 340,000 in the middle and Rasmus Lundstrom getting his final 550,000 into the pot. Viacheslav Sultanov had both players covered both with chips and hands.

Tonis Viik:
Rasmus Lundstrom:
Viacheslav Sultanov:

While Viik was unable to get lucky and hit the rail in 14th place for €2,450 the same can't be said for Lundstrom who asked if he could take a photo of the hand after his cowboys improved to trips on the with a king spiking the flop. Lundstrom was nearly on the rail and instead he took the chip lead.

Player		Chips	Progress
Rasmus Lundstrom		1,500,000	1,040,000
Viacheslav Sultanov		1,350,000	515,000
Tonis Viik		0	0

"It's Not Much" Posted Saturday 16th September, 2023 at 19:55(UTC+0) by Jason Glatzer

Level 25: 20,000/40,000 (40,000)
Entries: 15/382

Lukasz Fraczek jammed for about 10 big blinds from early position before Rimantas Boguzas (pictured below) called off his stack of 175,000.

Rimantas Boguzas:
Lukasz Fraczek:

Fraczek connected with his deuce on the board but doubled up Boguzas anyway after being unable to further improve from there.

Fraczek asked how much he had to pay off.

"Not much," Boguzas replied.

Player		Chips	Progress
Rimantas Boguzas		450,000	40,000
Lukasz Fraczek		225,000	65,000

Sultanov Eliminates Kyte Posted Saturday 16th September, 2023 at 19:54(UTC+0) by Alaxandar Georgiev

Level 25: 20,000/40,000 (40,000)
Entries: 15/382

Relentless aggression was displayed by Viacheslav Sultanov as he three-bet the open raise from Jon Kyte (pictured above) for five straight times. A monster pot began after Kyte raised to 100,000 and Sultanov quickly re-raised to 225,000.

After thinking for a bit Kyte put all of his betting discs in the middle which were a whopping 800,000 chips and with no hesitation Sultanov called.

Viacheslav Sultanov:
Jon Kyte:

The  flop gave some better odds for Kyte as he said: "Eight please". Turn and a river brick saw one of the big stacks - Kyte go out in 16th place and cashed the tournament for €1,950.

The final 15 players earned a pay jump to at least €2,450.

Player		Chips	Progress
Viacheslav Sultanov		1,865,000	800,000
Jon Kyte		0	0

19:45 (UTC+0)

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

Meet Canada's Kelly Kellner Posted Saturday 16th September, 2023 at 19:40(UTC+0) by Jason Glatzer

Full Updated Chip Counts at Break Posted Saturday 16th September, 2023 at 19:34(UTC+0) by Jason Glatzer

Day 1c chip leader Charles-Erik Benoit (pictured above) was back on top on the break with a chip-leading stack of 1,290,000.

Check out the full chip counts below.

Player		Chips	Progress
Charles-Eric Benoit		1,290,000	500,000
Aleksi Naski		1,170,000	820,000
Viacheslav Sultanov		1,065,000	565,000
Viktor Blinov		975,000	855,000
Torbjorn Larsen		880,000	585,000
Jon Kyte		870,000	250,000
Andres Leppik		755,000	0
Jonas Ruginis		755,000	245,000
Ryan Mandara		735,000	145,000
Tonis Viik		570,000	385,000
Rasmus Lundstrom		460,000	310,000
Georgios Skarparis		450,000	500,000
Dominykas Ruskys		440,000	70,000
Lukasz Fraczek		290,000	40,000
Martin Piik		195,000	245,000

Likely Final Break Posted Saturday 16th September, 2023 at 19:22(UTC+0) by Jason Glatzer

The final 16 players went on what is likely their final break of Day 2 as the day will end with just nine hopefuls for tomorrow's live-streamed final table.

In fact, it is a near certainty that we won't see another break after this one as players will be coming back to an average stack of less than 18 big blinds.

Skarparis Doubles With Rockets Posted Saturday 16th September, 2023 at 19:11(UTC+0) by Jason Glatzer

Level 24: 15,000/30,000 (30,000)
Entries: 16/382

Rasmus Lundstrom opened for 65,000 from the button before Georgios Skarparis (pictured below) fired out a light three-bet to 115,000. Lundstrom called a few moments later before the duo checked the flop.

Skarparis fired out for 150,000 on the turn and Lundstrom called. The paired the board on the river. Skarparis jammed for 165,000. Lundstrom asked for a count before calling about a minute later.

Skarparis immediately turned over the .

"Nice hand," Lundstrom said as he attempted to muck his hand. The dealer correctly reminded Lundstrom to show his hand and he turned over the .

Player		Chips	Progress
Georgios Skarparis		950,000	450,000
Rasmus Lundstrom		150,000	410,000

Payouts for €1,550 Posted Saturday 16th September, 2023 at 19:05(UTC+0) by Jason Glatzer

The following players went home with a €1,550 payout in Event #1: €555 No-Limit Hold'em.

Player	Place	Prize
17	Johan Grave	€ 1,550
18	Maksim Solodilov	€ 1,550
19	Samuli Hietala	€ 1,550
20	Jan-Mikael Kesanen	€ 1,550
21	Ranno Sootla (pictured below)	€ 1,550
22	Anatoly Filatov	€ 1,550
23	Kazimieras Ramaska	€ 1,550
24	Risto Parnat	€ 1,550

Ruginis Eliminates Grave Posted Saturday 16th September, 2023 at 19:04(UTC+0) by Alaxandar Georgiev

Level 24: 15,000/30,000 (30,000)
Entries: 16/382

Jonas Ruginis raised to 60,000 from an early position. Johan Grave jammed over the top for 270,000 from one seat over and Ruginis called.

Jonas Ruginis:
Johan Grave:

At risk, Grave needed some help on the flop, but he got none on the . Another heart on the turn made him gain and lose a few outs and the river lost his hopes for the tournament.

Finishing in 17th place Grave had a good run in the tournament and cashed for €1,550. Maksim Solodilov hit the rail just before in 18th place leaving just two tables of players remaining.

Player		Chips	Progress
Jonas Ruginis		1,000,000	230,000
Johan Grave		0	0

18:48 (UTC+0)

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

Double Up For Piik Posted Saturday 16th September, 2023 at 18:48(UTC+0) by Alaxandar Georgiev

Level 22: 10,000/25,000 (25,000)
Entries: 18/382

Martin Piik shoved the small blind for 220,000 chips and Jonas Ruginis quickly called from the big blind.

Martin Piik:
Ruginis Jonas:

Nothing on the flop for Ruginis as Piik's ace-high was good. Turn and river made sure that Piik won the hand and it was a lovely double up for him.

Player		Chips	Progress
Jonas Ruginis		770,000	230,000
Martin Piik		440,000	140,000

Learn What It Is Like to Be a Poker Dealer Posted Saturday 16th September, 2023 at 18:41(UTC+0) by Jason Glatzer

"No Drama" for Ruskys Posted Saturday 16th September, 2023 at 18:39(UTC+0) by Jason Glatzer

Level 22: 10,000/25,000 (25,000)
Entries: 18/382

Dominykas Ruskys (pictured below) three-bet jammed the button for 225,000 and was called by Georgios Skarparis, who opened from the cutoff.

Dominykas Ruskys: 
Georgios Skarparis: 

Ruskys was flipping for his tournament life but pulled miles ahead after improving to a set on the  flop. Skarparis was drawing dead on the  turn and Ruskys doubled up with a full house after the  river paired the board.

"That was boring," said Ryan Mandara, who was also at the table. "No drama."

Player		Chips	Progress
Dominykas Ruskys		510,000	50,000
Georgios Skarparis		500,000	350,000
Risto Parnat		0	0
Kazimieras Ramaska		0	0
Anatoly Filatov		0	0
Ranno Sootla		0	0
Jan-Mikael Kesanen		0	0
Samuli Hietala		0	0

18:22 (UTC+0)

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

Quads For The Lads Posted Saturday 16th September, 2023 at 18:21(UTC+0) by Alaxandar Georgiev

Level 22: 10,000/20,000 (20,000)
Entries: 23/382

The chip leader after the dinner break Jon Kyte opened the pot by raising it to 40,000 chips leading to only Johan Grave calling from the cut-off.

The action continued on the flop as Kyte check-raised Grave's bet of 50,000 to 140,000 chips. The decision for Grave wasn't hard as he went all in for the remaining 220,000 chips.

Jon Kyte:
Johan Grave:

Open-ended, but still behind Kyte was hoping for a straight, but instead the turn and river won the hand for Grave as he was happy with his quads.

Player		Chips	Progress
Jon Kyte		620,000	205,000
Johan Grave		440,000	140,000

Cooler On The Blinds Posted Saturday 16th September, 2023 at 18:04(UTC+0) by Alaxandar Georgiev

Level 22: 10,000/20,000 (20,000)
Entries: 24/382

Eric Benoit raised to 50,000 from the small blind and Risto Pärnat called from the big.

Eric continued on the flop and tossed 30,000 chips, after some thinking Benoit called.

The dealer turned the next card, which was  followed by a check and a 65,000 bet from Pärnat. 

Benoit again went into his time bank and raised to 140,000 while his opponent didn't waste time and quickly announced he was all in for 350,000 chips - snap call from Benoit and the players showed down.

Eric Benoit:

Risto Pärnat:

The river changed nothing as Pärnat lost the huge pot and is now left with only 40,000 chips.

Soon after he lost his remaining chips and finished in 24th place.

Player		Chips	Progress
Charles-Eric Benoit		790,000	560,000
Risto Parnat		0	330,000

Players Cashing for €1,300 Posted Saturday 16th September, 2023 at 17:57(UTC+0) by Jason Glatzer

The following players cashed for €1,300 in Event #1. The final three tables have each locked up at least a €1,550 payout.

Player	Place	Prize
25	Max Avela	€1,300
26	Glen Gaines	€1,300
27	Martin Lategui	€1,300
28	Kjetil Hanstvedt	€1,300
29	Atte Franssila	€1,300
30	Romas Bassus	€1,300
31	Athanasios Kostouros	€1,300
32	Roland Luik (pictured below)	€1,300

Kyte Runs Into Sultanov's Flush Posted Saturday 16th September, 2023 at 17:54(UTC+0) by Jason Glatzer

Level 22: 10,000/20,000 (20,000)
Entries: 24/382

Jon Kyte jammed the river with the on the board and was called by Viacheslav Sultanov. 

Kyte turned over the and paid Sultanov off who turned over the for the nut flush to double his stack.

After Glen Gaines hit the rail in 26th place, Day 1b chip leader Max Avela's run ended at the same time at a different table in 25th place and Kyte didn't seem too thrilled about his table changing.

"I double you up and then we go," Kyte said.

Player		Chips	Progress
Jon Kyte		825,000	165,000
Viacheslav Sultanov		500,000	310,000
Max Avela		0	0
Glen Gaines		0	0

17:41 (UTC+0)

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

Naski Doubles Through Filatov Posted Saturday 16th September, 2023 at 17:38(UTC+0) by Jason Glatzer

Level 21: 10,000/15,000 (15,000)
Entries: 26/382

Anatoly Filatov bet 15,000 into a limped blind vs. blind pot after the came on the flop before Aleski Naski (pictured below) shoved for 170,000. Filatov tanked for a minute before he called.

Aleksi Naski:
Anatoly Filatov:

Filatov flopped two pair but Naski also flopped the world of draws both a flush draw and an open-ended straight draw. The turn was blank for Naski. However, the river was a different story as Naski nailed his straight to double his stack.

Meanwhile, a few other players hit the rail to leave just 26 players remaining.

Player		Chips	Progress
Anatoly Filatov		580,000	10,000
Aleksi Naski		350,000	110,000
Romas Bassus		0	0
Atte Franssila		0	0
Kjetil Hanstvedt		0	0
Martin Lategui		0	0

Ruginis Eliminates Hanstvedt Posted Saturday 16th September, 2023 at 17:37(UTC+0) by Alaxandar Georgiev

Level 20: 10,000/15,000 (15,000)
Entries: 27/382

Jonas Ruginis opened to 45,000 under the gun and Kjetil Hanstvedt called from the lojack.

Ruginis didn't hesitate to bet the rainbow flop and Hanstvedt called 25,000. The action continued on the turn as Ruginis bet 65,000 and Hanstvedt went all-in for 310,000 chips followed by a snap call from Ruginis.

Jonas Ruginis:
Kjetil Hanstvedt:  

Already drawing only for a tie Hanstvedt didn't manage to get it on the river and he finished the tournament in 28th place cashing for €1,300.

Player		Chips	Progress
Jonas Ruginis		1,000,000	345,000
Kjetil Hanstvedt		0	0

Meet Taago Tamm Posted Saturday 16th September, 2023 at 17:23(UTC+0) by Jason Glatzer

Kostouros Lost His Chip Posted Saturday 16th September, 2023 at 17:17(UTC+0) by Jason Glatzer

Level 21: 10,000/15,000 (15,000)
Entries: 30/382

Kostouros Athanasios was down to literally a chip and a chair at the dinner break. No Cinderella story came for Athanasios as he chip went in when he was in the big blind and was up against Georgios Skarparis (pictured below) who opened from early position.

Kostouros Athanasios:
Georgios Skarparis:

Athanasios was drawing thin after Skarparis' king connected on the flop and was drawing dead after the turn. His chip went over to Skarparis after the river paired the board.

Player		Chips	Progress
Georgios Skarparis		850,000	35,000
Athanasios Kostouros		0	0

Back From Dinner Posted Saturday 16th September, 2023 at 17:11(UTC+0) by Jason Glatzer

Level 21: 10,000/15,000 (15,000)
Entries: 31/382

Players are back with full stomachs and ready for battle. The action will continue until just nine players remain with Jon Kyte (pictured below), who late registered at the start of Day 2, holding the chip lead with nearly 1 million in chips.

17:09 (UTC+0)

Start of Level 21
Blinds: 10,000/15,000     Ante: 15,000

Payouts for €1,100 Posted Saturday 16th September, 2023 at 17:08(UTC+0) by Jason Glatzer

The following players cashed for €1,100. The final 32 players each locked up a €1,300 payout at a minimum.

Player	Place	Prize
33	Joshua Stewart	€ 1,100
34	Sami-Sander Kivi	€ 1,100
35	Hanno Kerem	€ 1,100
36	Feras Abid	€ 1,100
37	Kai Lehto	€ 1,100
38	Jarno Jokiniemi	€ 1,100
39	Luca Beretta	€ 1,100
40	Kalle Keski Opas	€ 1,100

Full Chip Counts at Break Posted Saturday 16th September, 2023 at 16:56(UTC+0) by Jason Glatzer

Player	Chips	Big Blinds
Jon Kyte	990,000	66
Georgios Skarparis	815,000	54
Jonas Ruginis	655,000	44
Jan-Mikael Kesanen	595,000	40
Anatoly Filatov	590,000	39
Ryan Mandara	590,000	39
Rasmus Lundstrom	560,000	37
Max Avela	490,000	33
Risto Parnat	470,000	31
Ranno Sootla	470,000	31
Dominykas Ruskys	460,000	31
Rimantas Boguzas	410,000	27
Samuli Hietala	370,000	25
Kjetil Hanstvedt	345,000	23
Andres Leppik	320,000	21
Johan Grave	300,000	20
Martin Piik	300,000	20
Torbjon Larsen	295,000	20
Lukasz Fraczek	250,000	17
Maksim Solodilov	245,000	16
Atte Franssila	240,000	16
Glen Gaines	240,000	16
Aleksi Naski	240,000	16
Romas Bassus	230,000	15
Charles-Eric Benoit	230,000	15
Martin Lategui	205,000	14
Viacheslav Sultanov	190,000	13
Tonis Viik	185,000	12
Viktor Blinov	120,000	8
Kazimieras Ramaska	105,000	7
Athanasios Kostouros	5,000	0

Time for Dinner Posted Saturday 16th September, 2023 at 16:08(UTC+0) by Jason Glatzer

Players are on a 60-minute dinner break. We will update the full chip counts of the remaining players after the break.

Action Before Dinner Posted Saturday 16th September, 2023 at 16:07(UTC+0) by Alaxandar Georgiev

Level 20: 6,000/12,000 (12,000)
Entries: 34/382

Rasmus Lundström opened the pot by raising to 24,000, Martin Piik (pictured above) near him called and action folded to short-stacked Sami Sander and he pushed his last 42,000 chips in the middle, followed by two calls. 

The other two players were happy to check the  flop and the turn saw Lundström check again. Piik tried to steal the pot by betting 30,000 and Lundström called to see the river.

Another check-check on river and Lundström showed down being the second nut flush. Sander opened and is out in 34th place cashing for  €1,100.

Players Who Min-Cashed for €1,000 Posted Saturday 16th September, 2023 at 15:57(UTC+0) by Jason Glatzer

Level 20: 6,000/12,000 (12,000)
Entries: 46/382

The following players min-cashed Event #1 for a €1,000 payout. The remaining 40 players have each locked up at least a €1,100 prize.

Player	Place	Prize
41	Vasileios Kokkinos	€1,000
42	Rauno Remmel (pictured below)	€1,000
43	Dmitri Dudakov	€1,000
44	Aleksandr Gamonovits	€1,000
45	Antonios Onoufriou	€1,000
46	Marius Bacanskis	€1,000
47	Topi Palenius	€1,000

Celmins Bubbles Event #1 Posted Saturday 16th September, 2023 at 15:53(UTC+0) by Alaxandar Georgiev

Level 19: 5,000/10,000 (10,000)
Entries: 47/382

Everyone appeared tense as there were three different all-ins on the bubble during the same hand. While two short stacks managed to double up Matiss Celmins had a much rougher go with his stack in the pot.

Celmins jammed from the cutoff his short stack and Kazimieras Ramaska called.

Matiss Celmins:

Kazimieras Ramaska:

To the flop almost crushed Celmin's hopes of cashing the tournament as he was drawing only to a straight and needed to find a ten. 

Neither the  nor the  river saved Celmins and he officially busted Event #1 on the money bubble.

The remaining 47 players are guaranteed at least a €1,000 min-cash with the prizes quickly going up from there.

Player		Chips	Progress
Kazimieras Ramaska		400,000	160,000
Matiss Celmins		0	0

Meet Estonian Poker Beast Ranno Sootla Posted Saturday 16th September, 2023 at 15:50(UTC+0) by Jason Glatzer

Big Slick Good for Mandara Posted Saturday 16th September, 2023 at 15:48(UTC+0) by Jason Glatzer

Level 20: 6,000/12,000 (12,000)
Entries: 46/382

Ryan Mandara opened from late position and was called by a player in later position before Jonas Ruginis three-bet jammed for more than 10 big blinds. Mandara came over the top and the other player in the hand folded.

Jonas Ruginis:
Ryan Mandara:

The board improved Mandara to a better two pair than Ruginis to eliminate his opponent.

Player		Chips	Progress
Ryan Mandara		600,000	570,000
Rimantas Boguzas		0	322,000

15:37 (UTC+0)

Start of Level 20
Blinds: 6,000/12,000     Ante: 12,000

Quad Nines for Ramaska Posted Saturday 16th September, 2023 at 15:36(UTC+0) by Jason Glatzer

Level 19: 5,000/10,000 (10,000)
Entries: 49/382

Matiss Celmins open-jammed from the small blind and was called by Kazimieras Ramaska from the big blind for his stack of 114,000. The other tables played out their hands before the cards were turned over with Ramaska at risk.

Kazimieras Ramaska:
Matiss Celmins:

It wasn't looking great for Ramaska early on with a queen coming out of the window. However, the last card on the flop improved Ramaska to a set. Ramaska still had a small sweat after the turn with Celmins at that point holding a gutshot straight draw. However, the case spiked the river to double Ramaska up in a dramatic fashion with four of a king.

Player		Chips	Progress
Kazimieras Ramaska		240,000	145,000
Matiss Celmins		200,000	10,000
James Noonan		0	0

Stone Bubble Miracle for Remmel Posted Saturday 16th September, 2023 at 15:26(UTC+0) by Alaxandar Georgiev

Level 19: 5,000/10,000 (10,000)
Entries: 48/382

Joshua Stewart opened from under the gun on the bubble and action folded to the big blind where Rauno Remmel shoved his remaining 40,000 stack at risk to bust right before the money.

Joshua Stewart:
Remmel Rauno:

No luck for Remmel as the flop turned. The dealer drew a on turn and on the river and lucky for Remmel he survived the first all-in on the bubble

Player		Chips	Progress
Joshua Stewart		320,000	290,000
Rauno Remmel		100,000	52,000

Kings Full for Sultanov Posted Saturday 16th September, 2023 at 15:13(UTC+0) by Jason Glatzer

Level 19: 5,000/10,000 (10,000)
Entries: 49/382

Jon Kyte opened for 22,000 from the cutoff before Viacheslav Sultanov three-bet jammed for 138,000. Kyte tanked for a few minutes before he opted to call.

Viacheslav Sultanov:
Jon Kyte:

"Kings again?" Kyte said referring to a previously reported hand where he gave a bad beat with treys against Evgeny Kerimov's kings.

This time Kyte got nowhere on the  board. Sultanov, who was ahead the entire way, officially doubled up with a full house.

Player		Chips	Progress
Jon Kyte		725,000	225,000
Viacheslav Sultanov		300,000	100,000

Bad Beat Near The Money Posted Saturday 16th September, 2023 at 15:10(UTC+0) by Alaxandar Georgiev

Level 19: 5,000/10,000 (10,000)
Entries: 49/382

The massive pot was played four spots of the money with a 20,000 raise from Evgeny Kerimov and two calls behind as the action headed to the big blind where Jon Kyte announced he was all in. Kerimov quickly called and the cards were turned over. 

Evgeny Kerimov:
Jon Kyte:

The didn't change much, and neither did the , but the river won the pot for Kyte and he scooped the 90 big blinds hand while sending Kerimov packing just short of the money.

Player		Chips	Progress
Jon Kyte		880,000	380,000
Marco Baglioni		0	0
Alexander Nemchin		0	0
Evgeny Kerimov		0	0

Video Recap From Yesterday Posted Saturday 16th September, 2023 at 15:01(UTC+0) by Jason Glatzer

Friday was another fantastic day at the WSOPC Tallinn at Olympic Park Casino and the Hilton Tallinn Park.

Check out the video highlights from Day 2 below:

14:55 (UTC+0)

Start of Level 19
Blinds: 5,000/10,000     Ante: 10,000

Piik Double Ups Posted Saturday 16th September, 2023 at 14:50(UTC+0) by Alaxandar Georgiev

Level 17: 4,000/8,000 (8,000)
Entries: 54/382

Martin Piik (pictured above) open-jammed jammed for about 80,000 from the button and Matiss Celmins on his left called from the small blind.

Martin Piik:
Jonas Ruginis:

The flop was friendly for Celmins with him having the better hand and also the flush draw. The on the turn gave Piik some additional out as the dealer put the on the river leading to a great double-up for the Estonian.

Player		Chips	Progress
Jonas Ruginis		620,000	560,000
Matiss Celmins		210,000	25,000
Martin Piik		176,000	144,500

Big Slick for Filatov Posted Saturday 16th September, 2023 at 14:46(UTC+0) by Jason Glatzer

Level 17: 4,000/8,000 (8,000)
Entries: 54/382

It has been an amazing day for GGPoker Ambassador Anatoly Filatov as he late entered at the start of the day and was recently above 400,000 in chips.

In a recently hand, Filatov check-called a bet of 55,000 by Torjborn Larsen into a pot of around double this with the on the board after the turn.

Both Filatov and Larsen checked after the river completed the board. Filatov turned over the for two pair with aces over deuces with a king kicker. Larsen shook his head out of frustration before he mucked his hand face down. 

There are tons of chips on the table as Larsen still had around 700,000 in chips after losing the above hand and Jon Kyte, another player to late enter today, had about 500,000.

Player		Chips	Progress
Torbjorn Larsen		700,000	650,500
Jon Kyte		500,000	470,000
Anatoly Filatov		400,000	3,000

Closer to the Money Bubble Posted Saturday 16th September, 2023 at 14:33(UTC+0) by Jason Glatzer

Level 17: 4,000/8,000 (8,000)
Entries: 57/382

The action is close to the money with 57 players remaining and 47 players going home with at least a min-cash of €1,000. The below players lost their stacks and won't be among those competing past the money bubble.

Player		Chips	Progress
Linas Jautakis		0	0
Rene Peterkopf		0	0
Arthur Boatman		0	0
Ville Mustonen		0	0
Markku Vihavainen		0	0
Albert Gorelik		0	0
Nikolay Ponomarev		0	0
Arturs Daugis		0	0
Vasco Segendorf		0	0

14:29 (UTC+0)

Start of Level 18
Blinds: 4,000/8,000     Ante: 8,000

Cowboys Good for Sultanov Posted Saturday 16th September, 2023 at 14:13(UTC+0) by Jason Glatzer

Level 17: 3,000/6,000 (6,000)
Entries: 67/382

Viacheslav Sultanov four-bet jammed from the hijack and was quickly called by Aleksandr Gamonovits for about 100,000 from the button.

Viacheslav Sultanov:
Aleksandr Gamonovits:

Sultanov was ahead but had a sweat for his tournament life but never left his seat with his cowboys holding on the board.

Player		Chips	Progress
Viacheslav Sultanov		200,000	139,500
Aleksandr Gamonovits		115,000	10,000
Janar Kokk		0	0
Morten Bremseth		0	0
Igor Pihela Jr.		0	0
Andrei Mjagkov		0	0

Red, Black, Blue, or Silver? Posted Saturday 16th September, 2023 at 13:57(UTC+0) by Lina Olofsson

Just like if we had been in the fabulous Las Vegas and the World Series, here in Tallinn, we have four different tournament rooms. The Main tournament room is in the Grand Ballroom which is the Blue area. Right next door we have the Red area where the players in this event are gathered and enjoying themselves. Outside these two tournament rooms, we have the Black area which is in the lobby area. On the opposite of these, we have the fourth and last tournament area which is the Silver one.  

And what would a WSOP tournament be without a feature table and a secondary feature table right? Here in Tallinn, you can find the glorious feature table just to the right after you've entered the stairs up from the Hotel lobby. The live streaming will start off by tomorrow with the final day of the very first event of this WSOPC which is the €555 No Limit Hold'em. But don't worry this tournament will be streamed right next to that final table with cameras so you can follow the action first hand.

This is the first time WSOP Circuit is coming to the Estonian capital Tallinn but my guess is it won't be the last because so far it has lived up to everything you possibly can expect as a player. Both when it comes to the tournaments with the amazing staff and also Hilton Park is surely living up to its five stars and has the best service you can imagine.

 

13:55 (UTC+0)

Start of Level 17
Blinds: 3,000/6,000     Ante: 6,000

Updated Big Stacks at Break Posted Saturday 16th September, 2023 at 13:54(UTC+0) by Jason Glatzer

Player		Chips	Progress
Anatoly Filatov		397,000	367,000
Evgeny Kerimov		380,000	3,000
Maksim Solodilov		365,000	336,000
Samuli Hietala		335,000	311,000
Rimantas Boguzas		322,000	263,000
Georgios Skarparis		320,000	213,000
Andres Leppik		308,000	266,000
Ranno Sootla		290,000	260,000
Max Avela		266,000	21,000
Aleksi Naski		265,000	152,000
Rasmus Lundstroem		260,000	167,000
Dominykas Ruskys		240,000	164,500
Matiss Celmins		235,000	167,000
Jan-Mikael Kesanen		220,000	196,500
Glen Gaines		183,000	133,500
Luca Beretta		170,000	110,000
Marius Bacanskis		166,000	110,000
Raivo Pinsel		157,000	99,000

Second Break Posted Saturday 16th September, 2023 at 13:32(UTC+0) by Jason Glatzer

Players are on their second break of Day 2. We will update some of the biggest stacks from around the room at the break.

Blinds will increase to 3,000/6,000 with a 6,000 big blind ante when the action resumes.

Meanwhile, Janar Kokk dropped by for a quick hello which wasn't good news as this means he was out of Event #1. He shared he ran his jacks into his opponent's kings and is otherwise happy with his play despite the lack of a result.

"It Wasn't a Slow Roll" Posted Saturday 16th September, 2023 at 13:25(UTC+0) by Jason Glatzer

Level 16: 2,000/4,000 (4,000)
Entries: 77/382

Evgeny Kerimov opened for a min-raise from early position from the corner seat before Maksim Petrov three-bet shoved for around 120,000 from one seat over from the other corner of the table.

The action folded around to Kerimov who tanked for about three minutes before someone pointed out it was his turn.

"It's not a slow roll," said Kerimov after he quickly called with this information.

Evgeny Kerimov:
Maksim Petrov:

It was a bit of a cooler for Petrov but we impartially agree it seemed highly unlikely this was a slow roll and the rest of the table appeared to say the same.

Miracles didn't happen for Petrov as he big slick was unable to get ahead of pocket rockets on the board.

Player		Chips	Progress
Evgeny Kerimov		383,000	310,000
Eriks Krumins		0	0
Albert Ostrovskij		0	0
Jouni Knuutinen		0	0
Masse Mirza		0	0
Ismail Borgi		0	0
Vladislav Topilskiy		0	0
Johan Martinsen		0	0
Robert Relander		0	0
Samuel Saariaho		0	0
Roope Tarmi		0	0
Maksim Petrov		0	0

Pinsel Lost With Set Aces Posted Saturday 16th September, 2023 at 13:15(UTC+0) by Alaxandar Georgiev

Level 15: 2000/5,000 (5,000)
Entries: 81/382

With 43,500 chips in the middle and three players, to the flop things were already tense as Raivo Pinsel (pictured below) made a 25,000 bet and Hanno Kerem shoved his remaining 66,500 chips with the third player Max Avela folding behind.

Everyone was amazed at what the players revealed:

Raivo Pinsel:
Hanno Kerem:

Hoping for a full-house start of the day chip leader Pinsel wasn't very happy with the turn and the on the river as Kerem scoops a huge pot with his flopped straight.

Player		Chips	Progress
Hanno Kerem		176,500	151,500
Raivo Pinsel		58,000	108,000

13:06 (UTC+0)

Start of Level 16
Blinds: 2,000/5,000     Ante: 5,000

More Eliminations Posted Saturday 16th September, 2023 at 13:05(UTC+0) by Jason Glatzer

Level 15: 1,500/3,000 (3,000)
Entries: 89/382

The following players hit the rail during Level 15.

Player		Chips	Progress
Kimmo Kurko		0	0
Azamat Dyussembekov		0	0
Jose Zaragoza		0	0
Daniele Venditti		0	0
James Little		0	0
Janek Tammsaar		0	0
Tarmo Tammel		0	0
Agnius Sankaitis		0	0
Nikolay Ponomarev		0	0
Todd Jatras		0	0
Mairo Tori		0	0
Stanislovas Norkus		0	0
Andrey Koks		0	0
Inigo Naveiro		0	0
Richard Randolph Jr		0	0
Marko Vest		0	0

Krumins Survives At Risk Posted Saturday 16th September, 2023 at 13:01(UTC+0) by Alaxandar Georgiev

Level 15: 1,500/3,000 (3,000)
Entries: 102/382

Morten Bremseth opened the pot by tossing 8,000 in the middle and the decision was left with Eriks Krumins on the big blind with his ten blinds left.  Krumins needed some time before he announced he was all in and Bremseth called. 

With the short stack at risk, players revealed their cards.

Morten Krumins: 
Eriks Bremseth: 

The flop didn't change much for Krumins. The turn made him get up from his chair and lucky for him the dealer put the on the river which completed the straight for Krumins and he managed to double up.

Player		Chips	Progress
Morten Bremseth		126,000	42,500
Eriks Krumins		85,000	40,000

12:39 (UTC+0)

Start of Level 15
Blinds: 2,000/4,000     Ante: 4,000

Short Stacks Collide Posted Saturday 16th September, 2023 at 12:39(UTC+0) by Jason Glatzer

Level 14: 1,500/3,000 (3,000)
Entries: 112/382

Jonas Riginis and Ermo Kosk (pictured below) both had their sub-starting stacks in the middle with Riginis covered Kosk by 1,000 chips.

Ermo Kosk:
Jonas Riginis:

The board didn't improve Kosk and he was on the rail along with other players listed below.

Player		Chips	Progress
Jonas Ruginis		60,000	34,500
Mark Metsla		0	0
Joni Rantamaki		0	0
Michele Tocci		0	0
Vygerdas Jonikas		0	0
Oskar Ojaveer		0	0
Martti Keel		0	0
Tanel Koht		0	0
Ermo Kosk		0	0

Recent Eliminations Posted Saturday 16th September, 2023 at 12:24(UTC+0) by Jason Glatzer

Level 14: 1,500/3,000 (3,000)
Entries: 129/382

The field is down to just 129 entries after a flurry of eliminations since late registration closed. Check out who recently exited the event below.

Player		Chips	Progress
Michailas Miserkejevas		0	0
Igor Pihela		0	0
Yusuke Tanaka		0	0
Dominik Ostrowski		0	0
Vasilij Barna		0	0
Jyri Erametsa		0	0
Vilius Zamzickas		0	0
Vladmir Iljunin		0	0
Kert Hallik		0	0
Georgios Tsouloftas		0	0
Steponas Vencus		0	0
Boris Smolianskii		0	0
Stig Mattsson		0	0
Karlis Kreslins		0	0
Magnus Pukk		0	0
Joona Ranta-Nilkku		0	0
Siim Suviste		0	0
Rasmus Sepping		0	0
Enea Subashi		0	0
Daniel Kunman		0	0
Artur Kulanurk		0	0

12:07 (UTC+0)

Start of Level 14
Blinds: 1,500/3,000     Ante: 3,000

€38,510 Top Prize Posted Saturday 16th September, 2023 at 12:07(UTC+0) by Jason Glatzer

The payouts have been announced with the top 47 players banking at least a min-cash of €1,100 for nearly double the €555 entry fee.

Tomorrow's winner will not only earn a gold ring but also go home with the tasty €38,510 top prize. Check out the full payouts below or head to the Payouts tab within our coverage.

Place	Prize
1	€38,510
2	€25,750
3	€17,750
4	€12,650
5	€9,300
6	€7,100
7	€5,800
8	€4,900
9	€4,150
10	€3,550
11-12	€3,000
13-15	€2,450
16	€1,950
17-24	€1,550
25-32	€1,300
33-47	€1,100

Homin Almost Left His Seat Posted Saturday 16th September, 2023 at 12:00(UTC+0) by Alaxandar Georgiev

Level 13: 1,000/2,500 (2,500)
Entries: 143/382

Maikel Homin jammed his short 20,000 stack from under the gun with eight players to act behind. Kazimieras Ramaska called. Homin already left his seat just after he turned over his cards. 

Maikel Homin: Kazimieras Ramaska:  . The  came on the flop and right as Homin was ready to leave the room the dealer banged the  on the turn and the player at risk won the hand with on the river.

Player		Chips	Progress
Kazimieras Ramaska		95,000	8,500
Maikel Homin		45,000	6,500

Three Chips; One Chair Posted Saturday 16th September, 2023 at 11:43(UTC+0) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 159/382

Juho Heiska, who late registered on Day 2, and Janar Kokk, who re-entered on Day 2, collided with their short stacks preflop with Heiska barely having his opponent covered.

Janar Kokk:
Juho Heiska:

The board ran dry for both players for Kokk to double through Heiska.

"Three chips, one chair," commented Heiska after the hand who was left with just three yellow chips worth 1,000 each.

Heiska added some more chips as he tripled up the next hand against the big-stacked Edgars Beizaks.

Player		Chips	Progress
Edgars Beizaks		190,000	86,000
Janar Kokk		67,500	27,000
Juho Heiska		12,500	17,500

€183,360 Prize Pool Posted Saturday 16th September, 2023 at 11:34(UTC+0) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 159/382

A total of 62 entries got into the mix early on Day 2 before late registration closed to grow the field up to 382 entries for a €183,360 prize pool.

The action resumed with 159 players in their seats and will play down to a final table of nine players. Payouts will be announced shortly and we will post in the blog.

11:32 (UTC+0)

Start of Level 13
Blinds: 1,000/2,500     Ante: 2,500

Big Stacks at Break Posted Saturday 16th September, 2023 at 11:31(UTC+0) by Jason Glatzer

Risto Parnat leads the way heading into the first break. The action is set to resume in a couple of minutes. Check out some of the biggest chip stacks below.

Player		Chips	Progress
Risto Parnat		247,000	107,000
Max Avela		245,000	61,000
Albert Ostrovskij		202,000	77,000
Lukasz Fraczek		196,000	46,000
Raivo Pinsel		166,000	52,000
Alexander Nemchin		159,000	102,500
Urmo Velvelt		157,000	67,500
Vasco Segendorf		154,000	14,000
Roland Luik		145,000	7,000
Martin Lategui		140,000	6,500
Charles-Eric Benoit		140,000	3,000
Dmitri Dudakov		138,000	14,000
Sami-Sander Kivi		113,000	4,500

More Eliminations Before Break Posted Saturday 16th September, 2023 at 11:25(UTC+0) by Jason Glatzer

Player		Chips	Progress
Marko Vest		0	0
Julius Tiihonen		0	0
Alessandro Angotti		0	0
Manoel Filho		0	0
Timo Perttunen		0	0
Edgars Maurmanis		0	0
James Noonan		0	0
Martin Oks		0	0
Rasmus Sepping		0	0
Yanis Mehdi Sahli		0	0
Alexander Klochkov		0	0
Mario Jurgens		0	0
Masse Mirza		0	0
Roope Holma		0	0
Igor Pihela		0	0
Andres Leppik		0	0
Matts Jakobsson		0	0
Saulius Tumosa		0	0
Marco Kolle		0	0
Mart Rinken		0	0
Kaupo Tenno		0	0
Janar Kokk		0	0
Jan-Mikael Kesanen		0	0
Seppo Lehtonen		0	0
Evgeny Kerimov		0	0
Vasilij Barna		0	0
Athanasios Kostouros		0	0
Raimo Reimann		0	0
Nils Gard		0	0
Joel Holmberg		0	0
Ken Okada		0	0
Ucero Martinez		0	0

Last Hand Before Break Posted Saturday 16th September, 2023 at 11:22(UTC+0) by Alaxandar Georgiev

Level 12: 1,000/2,000 (2,000)
Entries: 158/378

Viik Tõnis (pictured above) opened under the gun for a min-raise before Alexander Nemchin three-bet 9,000 from the small blind. Tõnis called as the other players went to break.

Both players checked the flop and the turn showed the . The 7,500 bet from Nemchin didn't stop Tõnis and the hand proceeded with the on the river where the pre-flop aggressor bet another 8,000 and Tõnis made the call again as Nemchin didn't hesitate to show his which was good enough to win the hand after his opponent mucked his cards.

Player		Chips	Progress
Tonis Viik		48,000	2,500
Alexander Nemchin		0	0

Three More Re-Entry Hands Posted Saturday 16th September, 2023 at 10:59(UTC+0) by Jason Glatzer

Players are about to go on a break. However, the floor announced there will be three more hands at each table before this happens. Late registration will be closed after the break and we will know the total prize pool shortly after.

End of Journey for Svystunov Posted Saturday 16th September, 2023 at 10:57(UTC+0) by Alaxandar Georgiev

Level 12: 1,000/2000 (2000)
Entries: 173/350

Poland's Lukasz Fraczek opened the pot by tossing 4,000 chips into the pot and Ukraine's Kostiantyn Svystunov defended his big blind.

Svystunov snap-jammed his remaining short stack of 19,000 on the flop and Fraczek wasted no time in finding a call.

Kostiantyn Svystunov:
Lukasz Fraczek:

Svystunov didn't look happy as the turn revealed the but still had some hope for a full-house, but the on the river ended his run in the tournament unless he opts to re-enter before late registration closes before the start of Level 13.

Player		Chips	Progress
Lukasz Fraczek		150,000	71,000
Kostiantyn Svystunov		0	0

Recent Eliminations Posted Saturday 16th September, 2023 at 10:51(UTC+0) by Jason Glatzer

Players have been hitting the rail at a fast and furious pace. Check out the players that recently were eliminated from Event #1. Some of the players will get back into the action so don't be shocked to see them back in the chip counts as the day proceeds.

Player		Chips	Progress
Albert Gorelik		0	0
Matti Lasanen		0	0
Joel Holmberg		0	0
Jorge Paredas Bravo		0	0
Michele Tocci		0	0
Tapio Aaltonen		0	0
Jordi Baixas		0	0
Martin Sediak		0	0
Kostiantyn Svystunov		0	0
Kaur Ajamaa		0	0
Oskar Ojaveer		0	0
Manoel Filho		0	0
Anatoly Filatov		0	0
Marko Hynynen		0	0
Tadas Karosas		0	0
Ramunas Mika		0	0
Domene Larios		0	0
Matts Jakobsson		0	0
Zydrunas Karcemarskas		0	0
David Lopez de Miguel		0	0
Mateusz Mieczkowski		0	0
Yi-Zhan Peng		0	0
Victor Fernandez Garcia		0	0
Anna-Mari Hursti		0	0

10:37 (UTC+0)

Start of Level 12
Blinds: 1,000/2,000     Ante: 2,000

Queens Good for Parnat Posted Saturday 16th September, 2023 at 10:37(UTC+0) by Jason Glatzer

Level 11: 1,000/1,500 (1,500)
Entries: 174/350

Masse Mirza bet 15,000 into a pot of around 60,000 with the on the board after the turn. Risto Parnat shoved for around 40,000 and Mirza tanked for several minutes.

Mirza eventually called but didn't seem too thrilled about it. His intuition was correct.

Risto Parnat:
Masse Mirza:

Mirza's overpair was one pair short and Parnat doubled his stack instead of hitting the rail after a blank river completed the board.

Player		Chips	Progress
Risto Parnat		140,000	85,500
Masse Mirza		50,000	55,000

Smirnov Doubles Through Pinsel Posted Saturday 16th September, 2023 at 10:31(UTC+0) by Alaxandar Georgiev

The action folded to the start of the day chip leader Raivo Pinsel from the cut-off. He opened to 3500 and short-stacked Aleksei Smirnov defended his big blind. 

Flop uncovered the and Pinsel was quick to bet 5,500 on this dicey board. Smirnov quickly called and the players showed down their hands with Smirnov at risk.

Aleksei Smirnov:
Raivo Pinsel:

Smirnov was ahead with the better pair and his hand held after the turn and river completed the board to double through the start of the day chip leader.

Player		Chips	Progress
Raivo Pinsel		114,000	105,000
Aleksei Smirnov		50,000	21,000

Larios Runs Into Ostrovskij's Quads Posted Saturday 16th September, 2023 at 10:21(UTC+0) by Jason Glatzer

Level 11: 1,000/1,500 (1,500)
Entries: 178/346

Domene Larios jammed for 20,000 from middle position and was called by Albert Ostrovskij.

Domene Larios:
Albert Ostrovskij:

Both players wished each other good luck before Larios began to wince after Ostrovskij improved to a full house on the flop.

The table was in shock after Larios was drawing dead on the turn as this improved Ostrovskij further to quads. The blank river completed the board and Larios will need to re-enter if he wants a chance to cash in this event.

Meanwhile, Jonikas Vygerdas, Jan-Michael Kesanen, and Vytautas Kacerauskas all hit the rail during the early moments of Day 2.

Player		Chips	Progress
Albert Ostrovskij		125,000	28,500
Vytautas Kacerauskas		0	0
Jan-Mikael Kesanen		0	0
Vygerdas Jonikas		0	0
Domene Larios		0	0

No Love for Evert Posted Saturday 16th September, 2023 at 10:12(UTC+0) by Jason Glatzer

Level 11: 1,000/1,500 (1,500)
Entries: 182/334

Tanel Evert jammed for more than the 30,000 or so Okada had left from the big blind over the open by Ken Okada from the small blind. Okada called and was in a great spot to double his stack during the first blind level of Day 2.

Ken Okada:
Tanel Evert:

The board didn't push Evert ahead as he doubled up Okada.

A hand or two later, Evert jammed the rest of his short stack with and didn't get there against the held by Johan Martinsen and will need to re-enter if he wishes a chance at a coveted WSOPC gold ring in Event #1.

Player		Chips	Progress
Ken Okada		80,000	45,000
Johan Martinsen		80,000	24,500
Tanel Evert		0	0

Cards in the Air Posted Saturday 16th September, 2023 at 10:03(UTC+0) by Jason Glatzer

Level 11: 1,000/1,500 (1,500)
Entries: 182/332

Cards are in the air to start Day 2 of the 2023 WSOPC Tallinn Event #1: €555 No-Limit Hold'em.

Already a dozen new players hopped into the mix to bring the field up to 332 entries and counting. The final number of entrants and the total prize pool will be announced shortly after late registration closes before the start of Level 13.

Day 2 Begins at Noon Posted Saturday 16th September, 2023 at 07:48(UTC+0) by Jason Glatzer

Welcome to our coverage of the 2023 World Series of Poker Circuit (WSOPC) Tallinn at Olympic Park Casino and the adjoining Hilton Tallinn Park.

Saturday will boast Day 2 of the first ring event in the three-day Event #1: €555 No-Limit Hold'em and Day 1 of the two-day Event #2: €1,100 No-Limit Hold'em. The four opening flights attracted 320 entries for a €153,600 prize pool. A total of 170 players advanced with more to come with more entries expected to grow the prize pool during the first two blind levels of Day 2 with unlimited re-entries still permitted until the end of the first break of the day.

Day 1a chip leader Raivo Pinsel (pictured above) from Estonia leads the way after managing to catapult his 30,000 opening stack into 219,000. Day 1d chip leader Kalle Keski-Opas (187,500), Day 1b chip leader Max Avela (184,000), Vasco Segendorf (168,000), and Dmitri Dudakov (152,000) also will kick off Day 2 in the top five.

Event #1: Top 10 Leaderboard Entering Day 2

Place	Player	Country	Chips	Big Blinds
1	Raivo Pinsel	Estonia	219,000	146
2	Kalle Keski-Opas	Finland	187,500	125
3	Max Avela	Finland	184,000	123
4	Vasco Segendorf	Germany	168,000	112
5	Dmitri Dudakov	Estonia	152,000	101
6	Roland Luik	Estonia	152,000	101
7	Charles-Eric Benoit	Canada	143,000	95
8	Martin Lategui	Uruguay	133,500	89
9	Janne Nevalainen	Finland	131,000	87
10	Eriks Krumins	Latvia	125,000	83

Cards will be in the air starting at noon on Saturday with Level 11 with blinds at 1,000/1,500 with a 1,500 big blind ante and increase every 30 minutes. Expect tons of action early with late registration still open for the first hour of the day. Players will bag chips into tomorrow's televised final day after the action is down to just nine hopefuls. Stay tuned to see who will be on the final table of the first ring event in the inaugural WSOPC Tallinn.

Day 2 Seat Draw Posted Friday 15th September, 2023 at 23:57(UTC+0) by Jason Glatzer

Table	Seat	Player	Chips	Big Blinds
1	1	James Noonan	109,000	73
1	2	Jouni Knuutinen	68,500	46
1	3	Inigo Martin	31,500	21
1	5	Maikel Homin	38,500	26
1	6	Alexander Klochkov	38,000	25
1	7	Rimantas Boguzas	59,000	39
1	8	Tanel Merida	13,000	9
2	1	Artur Külanurk	41,500	28
2	2	Georgios Tsouloftas	112,500	75
2	3	Kaupo Tenno	20,500	14
2	4	Mairo Tori	44,500	30
2	5	Vladislav Topilskiy	62,000	41
2	6	Dominykas Ruskys	75,500	50
2	7	Igor Pihela Jr.	109,000	73
2	9	James Little	46,500	31
3	1	Oskar Ojaveer	22,500	15
3	2	Joel Holmberg	20,500	14
3	3	Jose Zaragoza	78,500	52
3	4	Janne Nevalainen	131,000	87
3	5	Azamat Dyussembekov	30,500	20
3	6	Agnius Sankaitis	90,500	60
3	7	Feras Abid	32,000	21
3	8	Ilya Nikiforov	92,000	61
4	1	Atte Franssila	55,500	37
4	2	Vilius Zamzickas	32,500	22
4	3	Alessandro Angotti	29,500	20
4	4	Aleksandr Gamonovits	105,000	70
4	6	Rene Peterkopf	56,500	38
4	7	Raimo Reimann	43,500	29
4	8	Jouni Hakosalo	23,500	16
4	9	Antonios Onoufriou	24,000	16
5	1	Kazimieras Ramaska	86,500	58
5	2	Janne Havio	72,500	48
5	3	Kert Hallik	61,500	41
5	4	Matiss Celmins	68,000	45
5	6	Samuli Hietala	24,000	16
5	7	Jorge Paredes Bravo	56,000	37
5	8	Dominik Ostrowski	36,500	24
5	9	Vasilj Barna	44,500	30
6	2	Yusuke Tanaka	36,500	24
6	3	Saulius Tumosa	21,500	14
6	4	Nikolay Ponomarev	35,500	24
6	5	Martin Lategui	133,500	89
6	6	Joni Rantamäki	36,000	24
6	7	Ken Okada	35,000	23
6	8	Tanel Evert	52,000	35
6	9	Johan Martinsen	55,500	37
7	2	Samuel Saariaho	64,000	43
7	3	Viacheslav Sultanov	60,500	40
7	4	Seppo Lehtonen	71,500	48
7	5	Nils Gard	31,500	21
7	6	Stanislovas Norkus	37,500	25
7	7	Michele Tocci	21,500	14
7	8	Jonas Ruginis	25,500	17
7	9	Luca Beretta	60,000	40
8	1	Torbjörn Larsen	49,500	33
8	2	Daniel Kunman	35,500	24
8	3	Arko Akenpärg	100,500	67
8	4	Glen Gaines	49,500	33
8	5	Viktor Blinov	89,500	60
8	6	Marko Hynynen	25,000	17
8	7	Matti Lasanen	30,500	20
8	8	Vladimiras Meckovskis	53,000	35
9	1	Ramunas Mika	27,000	18
9	2	Max Avela	184,000	123
9	3	Martin Venno	51,000	34
9	4	Ermo Kosk	25,000	17
9	6	Heikki Huhtala	25,000	17
9	7	Markku Vihavainen	35,500	24
9	9	Matts Jakobsson	34,500	23
10	1	Timo Perttunen	31,000	21
10	2	Kjetil Hanstvedt	64,500	43
10	4	Andrey Koks	78,000	52
10	6	Ismail Borgi	60,500	40
10	7	Maksim Petrov	40,000	27
10	8	Janek Tammsaar	78,500	52
10	9	Adria Comas I Roura	48,000	32
11	1	Topi Palenius	107,500	72
11	2	Tapio Aaltonen	28,500	19
11	4	Lukasz Fraczek	79,000	53
11	5	Zydrunas Karcemarskas	43,000	29
11	6	Martin Sediak	61,000	41
11	7	Romas Bassus	53,000	35
11	8	Kostiantyn Svystunov	23,000	15
11	9	Karlis Kreslins	36,000	24
12	1	Mario Jürgens	90,500	60
12	3	Julius Tiihonen	17,000	11
12	4	Tadas Karosas	55,500	37
12	5	Edgars Beizaks	104,000	69
12	6	Linas Jautakis	26,500	18
12	7	Martti Keel	62,000	41
12	8	Janar Kokk	40,500	27
12	9	Evgeny Kerimov	73,000	49
13	1	Rasmus Sepping	48,500	32
13	3	Jarno Jokiniemi	22,000	15
13	4	Andres Leppik	42,000	28
13	6	Raivo Pinsel	219,000	146
13	7	Robert Relander	71,000	47
13	8	Hanno Kerem	25,000	17
13	9	Aleksei Smirnov	29,000	19
14	1	Anna-Mari Hursti	25,000	17
14	2	Morten Bremseth	83,500	56
14	3	Tanel Koht	34,000	23
14	4	Marten Oks	33,000	22
14	6	Rasmus Lundström	93,000	62
14	7	Mart Rinken	72,500	48
14	8	Jordi Baixas	33,500	22
14	9	Eriks Krumins	125,000	83
15	1	Martin Piik	31,500	21
15	3	Joona Ranta-Nilkku	29,500	20
15	4	Stig Mattsson	62,000	41
15	6	Yanis Mehdi Sahli	65,000	43
15	7	Andrei Mjagkov	26,000	17
15	8	Vytautas Kacerauskas	19,500	13
15	9	Jyri Erämetsä	45,000	30
16	1	Sami-Sander Kivi	108,500	72
16	2	Athanasios Kostouros	68,000	45
16	3	Roland Luik	152,000	101
16	4	Marco Baglioni	49,500	33
16	5	Kimmo Kurko	58,500	39
16	6	Yasuke Kakiuchi	80,500	54
16	7	Arturs Daugis	8,000	5
16	9	Kalle Keski-Opas	187,500	125
17	2	Jesus Martinez Ucero	18,000	12
17	3	Charles-Eric Benoit	143,000	95
17	4	Igor Pihela Sr.	81,000	54
17	5	Masse Mirza	105,000	70
17	6	Johan Grave	88,500	59
17	7	Vygerdas Jonikas	12,500	8
17	8	Risto Pärnat	54,500	36
17	9	Rauno Remmel	48,000	32
18	1	Vasco Segendorf	168,000	112
18	2	Dmitri Dudakov	152,000	101
18	3	Alexander Nemchin	56,500	38
18	4	Tarmo Tammel	27,000	18
18	5	Kaur Ajamaa	24,000	16
18	6	Tõnis Viik	50,500	34
18	7	Boris Smolianskii	64,500	43
18	8	David Lopez De Miguel	23,000	15
19	1	Mateusz Mieczkowski	16,500	11
19	2	Roope Holma	59,000	39
19	3	Siim Suviste	28,500	19
19	5	Georgios Skarparis	107,000	71
19	6	Magnus Pukk	49,500	33
19	7	Daniele Venditti	36,000	24
19	8	Maksim Solodilov	29,000	19
19	9	Urmo Velvelt	89,500	60
20	1	Roope Tarmi	45,000	30
20	3	Ville Mustonen	31,000	21
20	5	Aleksi Naski	113,000	75
20	6	Enea Subashi	58,000	39
20	7	Michailas Miserkejevas	22,500	15
20	8	Yi-Zhan Peng	47,000	31
20	9	Jan-Mikael Kesänen	23,500	16
21	1	Alarih Kadanik	43,500	29
21	2	Vladimir Iljunin	110,000	73
21	3	Edgars Maurmanis	28,000	19
21	4	Arthur Boatman	63,000	42
21	5	Mark Metsla	15,000	10
21	6	Richard Randolph Jr.	68,000	45
21	8	Manoel Filho	17,500	12
21	9	Todd Jatras	48,500	32
22	1	Domene Larios	19,500	13
22	2	Marco Kölle	26,000	17
22	3	Steponas Venckus	35,000	23
22	4	Albert Ostrovskij	96,500	64
22	5	Vasileios Kokkinos	91,500	61
22	6	Marko Vest	35,000	23
22	7	Victor Fernandez Garcia	30,500	20
22	8	Marius Bacanskis	56,000	37

23:56 (UTC+0)

Day 2 of WSOPC Tallinn Started
Level: 11     Blinds: 1,000/1,500     Ante: 1,500

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