0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0060 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1/2/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.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.0068 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.0004 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.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '28'
0.0254 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0048 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '97'
AND `published` = 1
0.0250 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0041 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '106'
AND `published` = 1
0.0248 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0041 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '111'
AND `published` = 1
0.0250 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0043 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '112'
AND `published` = 1
0.0249 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0041 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '113'
AND `published` = 1
0.0252 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0039 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.0056 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.0040 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.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4800'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4792'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4790'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4786'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4781'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4779'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4805'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4776'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4770'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4767'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4764'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4761'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4759'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4756'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4753'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4749'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4751'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4743'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4742'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4738'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4736'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4732'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4731'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4729'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4727'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4725'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4720'
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` = '4715'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4719'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4713'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4712'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4709'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4707'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4706'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4704'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4696'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4702'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4692'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4691'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4689'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4686'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4684'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4683'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4678'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4674'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4673'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4668'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4672'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4658'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4660'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4655'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4654'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4651'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4645'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4643'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4642'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4635'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4633'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4634'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4627'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4626'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4622'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4617'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4616'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4613'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4607'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4606'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4609'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4595'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4594'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4592'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4590'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4600'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4588'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4580'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4573'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4572'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4570'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 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.0055 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '113'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4800'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4792'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4790'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4789'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4786'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4784'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4781'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4779'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4805'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4776'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4770'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4767'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4764'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4761'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4759'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4756'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4753'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4749'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4751'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4743'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4742'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4738'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4736'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4734'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4732'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4731'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4729'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4727'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4725'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4720'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4715'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4719'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4713'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4712'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4709'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4707'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4706'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4704'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4696'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4702'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4692'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4691'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4689'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4686'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4684'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4683'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4678'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4674'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4673'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4668'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4672'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4658'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4660'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4655'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4654'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4651'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4645'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4643'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4642'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4635'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4633'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4634'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4627'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4626'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4622'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4617'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4616'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4613'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4607'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4606'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4609'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4595'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4594'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4592'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4590'
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` = '4600'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4588'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4580'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4573'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4572'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4570'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '115'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
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 fromRimantas 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.
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 theflop. Skarparis was drawing dead on theturn and Ruskys doubled up with a full house after theriver 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
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.