0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0070 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event3/2/updates'
ORDER BY `views` DESC
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.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.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT `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.0062 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_wsop_tallinn_event3'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '137'
0.0250 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0057 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '330'
AND `published` = 1
0.0249 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '339'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '137'
AND `name` = '2'
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '330'
ORDER BY `busted` ASC, `current_chips` DESC
0.0062 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` = '330'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '14820'
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` = '14689'
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` = '14691'
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` = '14688'
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` = '14686'
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` = '14683'
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` = '14682'
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` = '14680'
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` = '14679'
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` = '14678'
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` = '14677'
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` = '14669'
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` = '14670'
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` = '14664'
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` = '14661'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14658'
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` = '14655'
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` = '14646'
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` = '14638'
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` = '14634'
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` = '14632'
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` = '14627'
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` = '14623'
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` = '14622'
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` = '14616'
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` = '14613'
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` = '14611'
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` = '14609'
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` = '14605'
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` = '14601'
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` = '14600'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14594'
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` = '14581'
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` = '14576'
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` = '14574'
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` = '14571'
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` = '14564'
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` = '14555'
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` = '14554'
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` = '14552'
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` = '14546'
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` = '14545'
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` = '14542'
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` = '14533'
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` = '14530'
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` = '14528'
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` = '14523'
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` = '14524'
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` = '14522'
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` = '14514'
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` = '14516'
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` = '14513'
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` = '14512'
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` = '14511'
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` = '14510'
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` = '14509'
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` = '14504'
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` = '14506'
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` = '14503'
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` = '14499'
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` = '14501'
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` = '14498'
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` = '14496'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14500'
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` = '14495'
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` = '14493'
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` = '14492'
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` = '14491'
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` = '14490'
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` = '14489'
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` = '14486'
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` = '14484'
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` = '14483'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '330'
ORDER BY `busted` ASC, `current_chips` DESC
0.0050 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` = '330'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '14820'
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` = '14689'
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` = '14691'
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` = '14688'
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` = '14686'
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` = '14683'
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` = '14682'
ORDER BY `chip_change` DESC, `busted` ASC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14680'
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` = '14679'
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` = '14678'
ORDER BY `chip_change` DESC, `busted` ASC
0.0084 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14677'
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` = '14669'
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` = '14670'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14664'
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` = '14661'
ORDER BY `chip_change` DESC, `busted` ASC
0.0163 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14658'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14655'
ORDER BY `chip_change` DESC, `busted` ASC
0.0188 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14646'
ORDER BY `chip_change` DESC, `busted` ASC
0.0489 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14638'
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` = '14634'
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` = '14632'
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` = '14627'
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` = '14623'
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` = '14622'
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` = '14616'
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` = '14613'
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` = '14611'
ORDER BY `chip_change` DESC, `busted` ASC
0.0566 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14609'
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` = '14605'
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` = '14601'
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` = '14600'
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` = '14594'
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` = '14581'
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` = '14576'
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` = '14574'
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` = '14571'
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` = '14564'
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` = '14555'
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` = '14554'
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` = '14552'
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` = '14546'
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` = '14545'
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` = '14542'
ORDER BY `chip_change` DESC, `busted` ASC
0.0158 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14533'
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` = '14530'
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` = '14528'
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` = '14523'
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` = '14524'
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` = '14522'
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` = '14514'
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` = '14516'
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` = '14513'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14512'
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` = '14511'
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` = '14510'
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` = '14509'
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` = '14504'
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` = '14506'
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` = '14503'
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` = '14499'
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` = '14501'
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` = '14498'
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` = '14496'
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` = '14500'
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` = '14495'
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` = '14493'
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` = '14492'
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` = '14491'
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` = '14490'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14489'
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` = '14486'
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` = '14484'
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` = '14483'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '339'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553
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.
Day 2 of Olympic Park Casino Ended Level: 30 Blinds: 40,000/80,000 Ante: 80,000
Ridas Bitauskas Bubbles The Final Table in 10th (€4,250) Posted Wednesday 24th July, 2024 at 00:19(UTC+2) by Alaxandar Georgiev
Level 30: 40,000/80,000 (60,000) Entries: 10/617
Ridas Bitauskas was left with under a blind from his last hand and was all-in on the first hand after the break.
David Bright raised 165,000 from the small blind and Roope Tarmi called from the big.
The flop was - Bright check-folded to Tarmi's bet and both players revealed their cards.
Ridas Bitauskas: Roope Tarmi:
Bitauskas was only hoping for an ace or a backdoor draw. There was some hope on the turn which gave him a gutshot. The river was another four which made him bust the tournament in 10th place for €4,250
Player
Chips
Progress
Roope Tarmi
2,690,000
390,000
Ridas Bitauskas
0
0
00:16 (UTC+2)
Start of Level 30 Blinds: 40,000/80,000 Ante: 80,000
Huge Hand On The FT Bubble Posted Wednesday 24th July, 2024 at 00:08(UTC+2) by Alaxandar Georgiev
Level 29: 30,000/60,000 (60,000) Entries: 10/617
Roope Tarmi opened the hand from under the gun and Ridas Bitauskas called 120,000 from the button.
Tarmi bet the flop and Bitauskas just called. The turn paired the board and completed the flush draw and Tarmi slowed down a bit. He checked and Bitauskas put him all in after some thinking.
Roope Tarmi snap-called and showed his flush against Bitauskas . The Lithuanian was drawing dead and they both had very similar stacks.
After a count, Tarmi had 830,000 and Bitauskas covered him only by 65,000 chips and is left with less than a blind on the final table bubble.
The players will now take their 15-minute break and after that, everyone will know if the "chip and a chair" stories can come true in the WSOPC Ring Event #3
Player
Chips
Progress
Roope Tarmi
2,300,000
2,264,500
Ridas Bitauskas
65,000
1,335,000
Final Table Bubble Play Posted Tuesday 23rd July, 2024 at 23:53(UTC+2) by Alaxandar Georgiev
Level 29: 30,000/60,000 (60,000) Entries: 10/617
Only 10 players are left at almost midnight here in Olympic Casino Tallinn and only one of them will win the €55,210 first-place prize and the golden WSOPC ring.
The average stack is 1,850,000 and the blinds will be going up in just a few minutes. The Day will finish after just one bust out. Good luck to all of the remaining players.
Ruslans Levockins Is Eliminated in 11th place (€4,250) Posted Tuesday 23rd July, 2024 at 23:48(UTC+2) by Alaxandar Georgiev
Level 29: 30,000/60,000 (60,000) Entries: 11/617
Oleksii Natoptanyi raised the first to 120,000 and got a flat call from one of the chip leaders - Phil Gross sitting on the button.
Action folded to Latvia's Ruslans Levockins who ripped his remaining 550,000 in the middle. A snap all-in followed by Natoptanyi and Gross said he couldn't call and mucked his cards.
Ruslans Levockins: Oleksii Natoptanyi:
Levockins was in trouble, his Ukrainian opponent had the better of it, and the flop changed nothing. The turn was another and bricked Levockins hopes of winning a golden ring.
Ruslans Levockin's good play through Day 2 managed to get him in the top 11 and secured a payout of €4,250 for him.
Player
Chips
Progress
Oleksii Natoptanyi
2,000,000
400,000
Ruslans Levockins
0
0
Boris Smolianskii is Eliminated in 12th place (€4,250) Posted Tuesday 23rd July, 2024 at 23:40(UTC+2) by Alaxandar Georgiev
Level 29: 30,000/60,000 (60,000) Entries: 12/617
Boris Smolianskii was left a bit short and had around 8 blinds when he open-jammed from the hi-jack. Phil Gross looked like he had an easy decision on his left and just called. Everyone else folded.
Boris Smolianskii: Phil Gross:
With just 8 blinds left Smolianskii managed to run into Aces, even tho he had one in his hand.
The flop was quite interesting , the two clubs gave Smolianskii a decent chance to double-up, while his opponent hit the one-outer top set of Aces.
The turn wasn't the color Smolianskii needed and the river was a black card, but not the suit he wished for.
Boris Smolianskii finished just 3 positions shy of the final table and will take home €4,250.
Player
Chips
Progress
Phil Gross
2,600,000
700,000
Boris Smolianskii
0
0
23:30 (UTC+2)
Start of Level 29 Blinds: 40,000/80,000 Ante: 60,000
Jan Holte Busts In 13th place (€3,650) Posted Tuesday 23rd July, 2024 at 23:30(UTC+2) by Alaxandar Georgiev
Level 28: 25,000/50,000 (50,000) Entries: 13/617
Rasmus Sihvonen raised from the button to 100,000 and Jan Holte quickly jammed his remaining 11 blind in the middle.
Dmitri Damaskin went a bit into the tank and eventually also announced that he was all in. Sihvonen snap folded and we had another player at risk.
Jan Holte: Dmitri Damaskin:
Holte couldn't hit any pair on the board and had to get up off his chair.
Jan Holte's run ended in 13th place for €3,650.
Player
Chips
Progress
Dmitri Damaskin
1,800,000
1,735,500
Rasmus Sihvonen
1,600,000
100,000
Jan Holte
0
0
Dowling goes out in 14th place (€3,250) Posted Tuesday 23rd July, 2024 at 23:24(UTC+2) by Alaxandar Georgiev
Level 28: 25,000/50,000 (50,000) Entries: 14/617
Christopher Dowling had a decision to make on the button as his stack was getting shorter and shorter. His decision ended up being all-in.
Rasmus Sihvonen made the call from the small blind and both went on to showdown.
Christopher Dowling: Rasmus Sihvonen:
Dowling really hoped to hit something on the flop, as he was behind. The flop king high flop didn't help his cause and he was drawing dead on the turn.
Dowling is eliminated just 13 players away from the golden ring and will take €3,250.
Player
Chips
Progress
Rasmus Sihvonen
1,700,000
1,491,500
Jan Holte
520,000
780,000
Christopher Dowling
0
0
Keränen is Eliminated in 15th place (€3,250) Posted Tuesday 23rd July, 2024 at 23:14(UTC+2) by Alaxandar Georgiev
Level 28: 25,000/50,000 (50,000) Entries: 15/617
Ville-Matti Keränen jammed around 14 blinds from the hi-jack with his and got called by David Bright's .
The flop came which gave Keranen some backdoor outs. Another spade hit on the turn and yet another one which completed Bright's flush draw.
sm:text- md:text- font-bold leading-none">Ville-Matti Keränen is eliminated in 15th place and will take home €3,250.
Player
Chips
Progress
David Bright
2,700,000
1,700,000
Ville-Matti Keranen
0
0
Holte Scoops A Big One Posted Tuesday 23rd July, 2024 at 23:07(UTC+2) by Alaxandar Georgiev
Level 27: 20,000/40,000 (40,000) Entries: 16/617
Jan Holte and Kaido Mikk were heads-up on the river. The board was and they were playing blind on blind.
There were already 500,000 chips in the middle and Mikk was the first to act, he bet another 300,000 and his opponent announced that he was all-in.
Kaido Mikk had only 430,000 behind and did muck his cards after a while.
Jan Roger Holte wins a nice pot of over 1,100,000 chips right before the eventual final table.
Kaido Mikk busted in one of the next few hands with jc] against Ridas Bitauskas's and gets paid €2,900 for 16th place.
Player
Chips
Progress
Ridas Bitauskas
1,400,000
1,356,500
Jan Holte
1,300,000
100,000
Kaido Mikk
0
0
23:00 (UTC+2)
Start of Level 28 Blinds: 25,000/50,000 Ante: 50,000
Final Two Tables Draw Posted Tuesday 23rd July, 2024 at 22:43(UTC+2) by Alaxandar Georgiev
Level 27: 20,000/40,000 (40,000) Entries: 17/617
The WSOPC Ring Event #3 is down to its last 16 players and they have been re-drawn to the last 2 tables.
The day will be played till our final 9 players and the action will continue tomorrow at 13:00.
Jungevicius Eliminated in 18th place (€2,550) Posted Tuesday 23rd July, 2024 at 22:41(UTC+2) by Alaxandar Georgiev
Level 27: 20,000/40,000 (40,000) Entries: 17/617
Another all-in took place at table number two. Raise from Ignotas Tamasauskas to 80,000 and Kestutis Jungevicius shoved his last 350,000 chips with his pocket tens . The table folded around to the original raiser and he snap-called with his {jc].
Nothing worked for Jungevicius on the board and his hopes for a ring are over in 17th place which guarantees him a payout of €2,900. He made the pay jump because another player - Aurimas Stanevicius busted before him on the other table in 18th place.
Player
Chips
Progress
Ignotas Tamasauskas
940,000
887,000
Kestutis Jungevicius
0
0
Aurimas Stanevicius
0
0
Maikel Homin Eliminated in 20th place (€2,550) Posted Tuesday 23rd July, 2024 at 22:32(UTC+2) by Alaxandar Georgiev
Level 27: 20,000/40,000 (40,000) Entries: 20/617
Maikel Homin shoved his remaining 4 blinds from the small blind and got instantly called by Phil Gross in the big blind.
Maikel Homin: Phil Gross:
Behind and at risk Estonian's Homin needed help from the dealer. The had not even one diamond on it, the turn was which gave Homin some additional outs.
The river ended Homin's performance in 20th place and he got €2,550 for it.
Marios Mansour busted the next hand on the same table and will take home the same prize.
Player
Chips
Progress
Phil Gross
1,900,000
1,685,000
Maikel Homin
0
0
Marios Mansour
0
0
22:28 (UTC+2)
Start of Level 27 Blinds: 20,000/40,000 Ante: 40,000
Five Is Not A Good Number For Mancinelli Posted Tuesday 23rd July, 2024 at 22:06(UTC+2) by Alaxandar Georgiev
Level 25: 15,000/30,000 (30,000) Entries: 24/617
Edoardo Mancinelli opened from the cutoff to 60,000 and action folded around to Oleksii Natoptanyi who was sitting in the big. He jammed it all in and put his opponent all in to call for his 21 blinds. Mancinelli called.
Edoardo Mancinelli:
Oleksii Natoptanyi:
Mancinelli was in good shape to double up after a safe flop of , Natoptanyi needed to hit a five or a seven for the chop. The dealer turned exactly what he wished for and Mancinelli's tournament life was hanging by a thread.
No luck for the Italian, river drilled another five to finish a full house for the Ukrainian. He finished in 24th place right before a €250 ladder to €2,250
Player
Chips
Progress
Oleksii Natoptanyi
1,600,000
1,526,000
Edoardo Mancinelli
0
0
Last Three Tables Re-Draw Posted Tuesday 23rd July, 2024 at 21:38(UTC+2) by Alaxandar Georgiev
Level 25: 15,000/30,000 (30,000) Entries: 24/617
The WSOPC Ring Event #3 €555 NLH is now down to the last 24 players out of 617 total entries. This means we do have our last three tables and it's time for a seat redraw.
All players, but the 24th are guaranteed at least €2,250 cash, and only one of them will take home the golden jewelry.
Ranno Sootla who won the €660 Mystery Bounty Ring Event last year busted in 25th place.
Here are the last players who busted before the redraw:
Player
Chips
Progress
Ranno Sootla
0
0
Markku Ihamaki
0
0
Sauli Haapaniemi
0
0
Timo Ruuska
0
0
Roman Jezov
0
0
Erik Lindqwist
0
0
Timmy Anker
0
0
Ritvars Cekalins
0
0
21:29 (UTC+2)
Start of Level 26 Blinds: 15,000/30,000 Ante: 30,000
Sick Cooler For Roman Jezov Posted Tuesday 23rd July, 2024 at 21:28(UTC+2) by Alaxandar Georgiev
Level 24: 10,000/25,000 (25,000) Entries: 29/617
Tommy Piiroinen raised first in and got shoved for 270,000 from Roman Jezov. After the other players folded Piiroinen didn't think much and threw in a chip for the call.
Roman Jezov: Tommy Piroinen:
Monster hand for Jezov - pocket kings, bu his opponent wasn't in such a bad shape with the three aces still in the deck.
The flop was crazy - Jezov had a full-house on the flop, while his opponent was drawing to such himself..
The turn didn't change much, but oh the river .. it was the which completed a bigger full-house for Piroinen.
Unlucky spot for Roman Jezov saw him bust in 29th place for €1,750
Player
Chips
Progress
Tommy Piiroinen
1,200,000
1,007,500
Roman Jezov
0
0
Last 20 Busted Players in The Money Posted Tuesday 23rd July, 2024 at 21:08(UTC+2) by Alaxandar Georgiev
Here is the list of players who busted within the range of 33rd to 53rd place in the WSOPC Ring Event #3.
Players from 32nd to 39th will get €1,550 and from 40th to 55th will get €1,350.
Player
Chips
Progress
Victor Prior Fernandez Amat
0
0
Pavel Solodovnikov
0
0
Modestas Kryzanauskas
0
0
Mykhailo Mikhalov
0
0
Jorn Martinsen
0
0
Lorenzo Arduini
0
0
Paul Koppe
0
0
Jaakko Tirkkonen
0
0
Tuomas Tervonen
0
0
Audrius Laimelis
0
0
Rolandas Aglinskas
0
0
Joshua Stewart
0
0
Antti Vetelainen
0
0
Jari-Pekka Juhola
0
0
Xi Tran
0
0
Jani Tuovinen
0
0
Ben Slack
0
0
Mikael Haapaniemi
0
0
Marius Hakonsen
0
0
Hans Fernkvist
0
0
Frederico Alves Dos Santos
0
0
21:02 (UTC+2)
Start of Level 25 Blinds: 10,000/25,000 Ante: 25,000
Juhola Shoves Ahead Posted Tuesday 23rd July, 2024 at 21:02(UTC+2) by Alaxandar Georgiev
Level 24: 10,000/20,000 (20,000) Entries: 36/617
David Bright opened the pot from the button and Jari Juhola jammed it all in for about 430,000 and got quickly called by Bright.
Jari Juhola: David Bright:
Bright's Jack didn't have a buddy like Juhola's Jack and that meant he needed to find at least an Ace somewhere along the board. Both had very similar stack and it was basically two tournament lives at stake.
Great flop for Bright, his opponent was now drawing to a backdoor chop or a one outer jack. The turn was and the river . Jari Juhola finished in 36th position and will take €1,550.
Player
Chips
Progress
David Bright
1,000,000
590,000
Jari-Pekka Juhola
0
0
Almost A Million Chips Pot Posted Tuesday 23rd July, 2024 at 20:47(UTC+2) by Alaxandar Georgiev
Level 24: 10,000/20,000 (20,000) Entries: 38/617
Jani Tuovinen's tournament life was on the line after he ripped it all in from the small blind after a button raise from Edoardo Mancinelli. He didn't get called by the Italian, because Jan Holte also went all-in from the big blind.
Jani Tuovinen: Jan Holte:
Two hearts on the gave Tuovinen some chance of a backdoor, that ended fast on the brick turn. His tournament life also ended after the dealer put the on the river. He busts the tournament in 38th place and will cash out €1,550.
Player
Chips
Progress
Jan Holte
1,200,000
500,000
Jani Tuovinen
0
0
20:32 (UTC+2)
Start of Level 24 Blinds: 10,000/20,000 Ante: 20,000
Meet The Big Chip Leader - Phil Gross Posted Tuesday 23rd July, 2024 at 20:32(UTC+2) by Alaxandar Georgiev
Level 23: 10,000/15,000 (15,000) Entries: 41/617
Phil Gross is on a hot roll as he busts players left and right. He has a staggering amount of 2,200,000 chips which amounts to 110 big blinds on the current level. He is almost a million off the second-biggest stack at the moment. The average stack right now is 475,000.
Four Blinds And A Dream Posted Tuesday 23rd July, 2024 at 20:24(UTC+2) by Alaxandar Georgiev
Level 23: 10,000/15,000 (15,000) Entries: 46/617
Mykhailo Mikhalov Jammed his last 4 blinds after an early raise from Edoardo Mancinelli, followed by an all-in from Northern Ireland's David Bright. Everyone folded and both got their cards face up.
Mykhailo Mikhalov: David Bright:
No luck for Mikhalov on the board. He busts the Day 2 in 46th place and will take home €1,350.
Player
Chips
Progress
David Bright
410,000
170,000
Mykhailo Mikhalov
0
0
Chip Lead Pot ALERT! Posted Tuesday 23rd July, 2024 at 20:14(UTC+2) by Alaxandar Georgiev
Level 23: 10,000/15,000 (15,000) Entries: 50/617
Ben Slack was heads-up with Kaido Mikk on a scary board of and there was already 300,000 chips in the middle. Slack checked and after a while Mikk bet 160,000.
With both flush draws missing and maybe a straight draw too Slack made the call and was shown the bad news quickly. Kaido Mikk turned his cards around and he had for a full-house.
Kaido Mikk scoops the huge 620,000 pot and with his 300,000 behind he is now the chipleader of Day 2.
Player
Chips
Progress
Kaido Mikk
920,000
795,000
Ben Slack
200,000
115,500
20:00 (UTC+2)
Start of Level 23 Blinds: 10,000/15,000 Ante: 15,000
Players Who Busted In The Money Posted Tuesday 23rd July, 2024 at 19:59(UTC+2) by Alaxandar Georgiev
26 players have already busted in just one level after they got into the money, some notable names that left the fight for the ring are Jon Kyte who won the Pot-Limit Omaha Ring Event at WSOPC Tallinn 2023, and Linda Nguyen who played the Day 2, and the final table of the ladies event at the same time.
You can also check out the payouts in our payouts section. 40th - 55th - €1,350 56th - 71th - €1,200 71th - 79th - €1,100
Here is a list of all the players who busted after they got into the money:
Player
Chips
Progress
Richard Koppel
0
0
Mykola Kostyrko
0
0
Robert Kallikorm
0
0
Vitalijus Kuzmicius
0
0
Andrius Dubietis
0
0
Kevin Karenius
0
0
Vasyl Tkachenko
0
0
Christel Haller
0
0
Franco Spichtig
0
0
Knut Turk
0
0
Jari Mahonen
0
0
Artjoms Hromovs
0
0
Enrique Martinez
0
0
Mario Fenaroli
0
0
Totti Arosuo
0
0
Jon Kyte
0
0
Kaido Koorits
0
0
Linda Nguyen
0
0
Tapio Aaltonen
0
0
Nikodemas Staniukaitis
0
0
Maksym Klopotok
0
0
Laurynas Vaitkevicius
0
0
Kaspars Butans
0
0
Nicolas Bokowski
0
0
Kristjan Maasalu
0
0
Klaudijus Bajoras
0
0
Players Are Now On A One Hour Break Posted Tuesday 23rd July, 2024 at 19:04(UTC+2) by Alaxandar Georgiev
Things went very quickly from 79 down to 53 players before the bigger dinner break which is exactly one-hour long. Players will return to level 23 and blinds 10,000/15,000 - Ante 15,000. They have all now locked up 1,350 and the next ladder is at top 39.
#FinalTableFreeroll Posted Tuesday 23rd July, 2024 at 19:03(UTC+2) by Matthew Summers
Busted Players near the money. Posted Tuesday 23rd July, 2024 at 18:37(UTC+2) by Alaxandar Georgiev
These are the players who nearly made the money, but won't be taking any from Event #3: €555 No-Limit Hold'em. Good luck to everyone in the other events!
Player
Chips
Progress
Teppo Joentausta
0
0
Tadas Simas
0
0
Jeffrey Cormier
0
0
Meelis Ahman
0
0
Ekrem Esker Atush
0
0
Timo Malo
0
0
Tero Laurila
0
0
Jorden Verbraeken
0
0
Dominik Ostrowski
0
0
Nohad Teliani
0
0
Igor Aleksandrov
0
0
18:30 (UTC+2)
Start of Level 22 Blinds: 6,000/12,000 Ante: 12,000
Gross Makes A Huge Call On The Bubble Posted Tuesday 23rd July, 2024 at 18:28(UTC+2) by Alaxandar Georgiev
Level 21: 5,000/10,000 (10,000) Entries: 80/617
Phil Gross from Germany min-raised from under the gun and got shoved on by Totti Arosuo who was sitting on the button. Gross had to call off his remaining 215,000 chips without knowing two shorter stacks already bubbled on the other tables, yet he made the call and revealed their cards.
Phil Gross: Totti Arosuo:
Arosuo clearly wanted to push him off a hand on the stone bubble, but Gross had a pretty strong hand. He made a set on the flop and put a big smile on his face as his opponent was already drawing dead on the turn. Gross will now continue the fight with a healthy stack of 460,000.
Player
Chips
Progress
Phil Gross
460,000
245,000
Totti Arosuo
210,000
215,000
Stone Bubble For Teppo Joentausta Posted Tuesday 23rd July, 2024 at 18:21(UTC+2) by Alaxandar Georgiev
Level 21: 5,000/10,000 (10,000) Entries: 80/617
Teppo Joentausta was all-in on the same hand as the previous player busted out and it was him from the small blind and his 74,000 chips against the call of Aurimas Stanevicius on the big blind.
Teppo Joentausta: Aurimas Stanevicius:
Joentausta had a premium one, but unfortunately for him, his opponent hit a ten on the flop and needed help from the next two cards. Jack or an Ace would've probably meant at least €1,100 min-cash for him, but none of these cards came.
Congratulations all of the remaining 79 players are now in the money and still fighting for the golden ring.
Player
Chips
Progress
Aurimas Stanevicius
600,000
260,000
Teppo Joentausta
0
0
Hand For Hand On The Stone Bubble Posted Tuesday 23rd July, 2024 at 18:08(UTC+2) by Alaxandar Georgiev
Level 21: 5,000/10,000 (10,000) Entries: 81/617
Nohad Teliani just busted with her against Henri Schalin's pocket only two away from the money and €1,100 min-cash.
Now the play is hand for hand as we are waiting for the final bust out before everyone is in the money.
Player
Chips
Progress
Nohad Teliani
0
0
18:05 (UTC+2)
Start of Level 21 Blinds: 5,000/10,000 Ante: 10,000
Laurila Busts In 85th Place Posted Tuesday 23rd July, 2024 at 18:01(UTC+2) by Alaxandar Georgiev
Level 20: 4,000/8,000 (8,000) Entries: 85/617
Kestutis Jungevicius once again opened to 20,000 on table eight and got jammed on by Tero Laurila for 137,000. Just a few players off the money, this all-in looked quite strong. Jungevicius took some time and threw a chip in.
Tero Laurila: Kestutis Jungevicius:
A flip at first sight, Laurila needed to fade some kings and queens as he was ahead preflop. The window card rolled up and it sure was not good news for Laurila - was the first one and then to complete the flop.
Laurila needed an ace or jack to stay alive but didn't get any on the turn and brick .
Just minutes later the tournament is already hand for hand and 2 away from the money.
Player
Chips
Progress
Kestutis Jungevicius
410,000
240,000
Tero Laurila
0
0
Important Hand For Martinez Near The Money Posted Tuesday 23rd July, 2024 at 17:45(UTC+2) by Alaxandar Georgiev
Level 20: 4,000/8,000 (8,000) Entries: 89/617
Just 10 players off the money Enrique Martinez shoved for 9 big blinds from an early position and everyone folded except for Lithuania's Nikodemas Staniukaitis who tanked a bit and made the call.
Enrique Martinez: Nikodemas Staniukaitis:
Bad news for Staniukaitis who saw he was dominated by a better hand. The gave hopes for Staniukaitis only on the turn, but they quickly faded by the fifth card and he was forced to give Spain's Martinez 72,000 chips.
Player
Chips
Progress
Nikodemas Staniukaitis
170,000
70,000
Enrique Martinez
150,000
93,000
Who's Got The Jack? Posted Tuesday 23rd July, 2024 at 17:36(UTC+2) by Alaxandar Georgiev
Level 20: 4,000/8,000 (8,000) Entries: 91/617
A big pot was played between Audrius Laimelis and Kestutis Jungevicius. Laimelis defended an utg open from his opponent and the action was already four cards in after both checked the flop. The turn was led by Laimelis for 26,000 and called by his Lithuanian fellow.
The river was the and Laimelis pushed his remaining 72,000 in the middle and got a call fairly quickly.
Audrius Laimelis: - two pair Kestutis Jungevicius: - top pair
Both got a pair of Jacks on the turn, but Laimelis scooped the pot with his second card, which he had paired already on the flop.
Player
Chips
Progress
Audrius Laimelis
240,000
110,000
Kestutis Jungevicius
170,000
34,000
17:25 (UTC+2)
Start of Level 20 Blinds: 4,000/8,000 Ante: 8,000
More Eliminations in Day 2 Posted Tuesday 23rd July, 2024 at 17:24(UTC+2) by Alaxandar Georgiev
Check out some more of the eliminated players before the money down below:
Player
Chips
Progress
Malkari Sohrab
0
0
Ralf Mikk
0
0
Donatas Pilinkus
0
0
David Tennback
0
0
Morten Bremseth
0
0
Miika Toyras
0
0
Kimmo Kurko
0
0
Aleksi Naski
0
0
Andrius Mazeika
0
0
Marius Morel
0
0
Petteri Miettinen
0
0
Tarmo Tammel
0
0
Fredric Eriksson
0
0
Andre Magi
0
0
Touko Berndtson
0
0
Maksim Petrov
0
0
Sander Leigri
0
0
Bjorn Tore Tvedt
0
0
Anders Beckman
0
0
Peteris Balodis
0
0
Sondre Lunde
0
0
Konsta Heikkila
0
0
Kasper Mellanen
0
0
Taago Tamm
0
0
Priit Vanem
0
0
Johannes Cleven
0
0
Espen Sandvik
0
0
Athanasios Kostouros
0
0
Aleksandr Naumov
0
0
Arturs Putnins
0
0
Helina Tamm
0
0
Otto Kiiskinen
0
0
Raphael Godard
0
0
Vidar Assersen
0
0
Jonatan Fors
0
0
Theis Nielsen
0
0
Georgi Abuladze
0
0
Victor Fernandez Garcia
0
0
Tomi Arponen
0
0
Marcus Carlsen
0
0
Morten Bremseth
0
0
David Tennback
0
0
Donatas Pilinkus
0
0
Ralf Mikk
0
0
Malkari Sohrab
0
0
Natalia Manuyko
0
0
Kazimieras Ramaska
0
0
Nebojsa Musulin
0
0
Vadims Milovs
0
0
Mika Hautakangas
0
0
Luca Sebastiani
0
0
Kelly Limonova
0
0
Tanel Merida
0
0
Lasse Aarninsalo
0
0
Aleksandr Jelpidiforov
0
0
Konstantin Farber
0
0
Jargo Alavali
0
0
Tal Herzog
0
0
Jordi Conejos Baixas
0
0
Christian Steinbo
0
0
Siim Suviste
0
0
Zanas Lubys
0
0
Sakari Setala
0
0
Ville Pohjalainen
0
0
Andrius Bielskis
0
0
Kristo Klaassen
0
0
Sebastian Wahl
0
0
Luka Sorainen
0
0
Mohammed Al-Khazraji
0
0
Sargon Esfendiyari
0
0
Jarmo Salonen
0
0
Liutauras Armanavicius
0
0
30 Player Off The Money Posted Tuesday 23rd July, 2024 at 16:56(UTC+2) by Alaxandar Georgiev
The day is going fast and we are closing in on the paid place. There are 109 players left out of the 617 entries. The competitors just finished their 15-minute break and will return to Level 19 on blinds 3,000/6,000 and 6,000 Ante.
Check out some of the bigger stacked players:
Player
Chips
Progress
Marcus Carlsen
435,000
65,000
Aurimas Stanevicius
340,000
180,000
Tuomas Tervonen
300,000
269,500
Mykhailo Mikhalov
300,000
207,000
Maikel Homin
280,000
135,500
Ekrem Esker Atush
240,000
210,000
Nikodemas Staniukaitis
240,000
172,500
16:49 (UTC+2)
Start of Level 19 Blinds: 4,000/8,000 Ante: 6,000
Bad Runout for Jon Kyte Posted Tuesday 23rd July, 2024 at 16:26(UTC+2) by Alaxandar Georgiev
Level 18: 2,500/5,000 (5,000) Entries: 115/617
2023 Pot-Limit Omaha Ring Event champion Jon Kyte opened to 10,000 from the cutoff and got re-raised to 22,000 from Antti Veteläinen who had a big stack on the button.
Kyte paid and they saw a flop of on which Kyte checked and his opponent bet 12,000. The Norwegian called and the turn was . this time they both checked.
The river was a which completed a potential one-card straight. Kyte led for 18,000 and Vetelainen put him all-in. Kyte had to decide for his remaining 6 blinds and did make the fold eventually. He managed to double-up after a few hands and is still in the game for the gold.
Player
Chips
Progress
Antti Vetelainen
290,000
90,000
Jon Kyte
31,000
49,000
16:06 (UTC+2)
Start of Level 18 Blinds: 2,000/5,000 Ante: 5,000
Laimelis Doubles Up Posted Tuesday 23rd July, 2024 at 16:04(UTC+2) by Alaxandar Georgiev
Level 17: 2,000/4,000 (4,000) Entries: 125/617
Tommi Lankinen put his tournament life on the line by shoving his last 14 blinds from an early position and got called by Audrius Laimelis from the cutoff. Both had similar stacks, but Lankinen was at risk.
Tommi Lankinen: Audrius Laimelis:
Jack in the window for Lankinen had him probably feel good for a second, right before the third card turned out to be another eight . With the turn Lankinen was already drawing dead and busted out of the tournament.
Player
Chips
Progress
Audrius Laimelis
130,000
57,000
Tommi Lankinen
0
0
The Ladies Like Martinsen Posted Tuesday 23rd July, 2024 at 15:51(UTC+2) by Alaxandar Georgiev
Level 17: 2,000/4,000 (4,000) Entries: 143/617
Roger Odden jammed his last 17 blinds under the gun and action folded around to Ville-Matti Keränen on the button who also went all-in for a bit more than 180,000. On his left Jorn Martinsen called swiftly after checking the stacks for his remaining 144,000.
Roger Odden: Ville-Matti Keranen: Jorn Martinsen:
Martinsen had the best hand preflop with his pocket ladies, while Odden was in bad shape against both players. The gave Odden some hope, since he was given 4 more outs for a straight. The turn was another seven and the river changed nothing.
A big scoop of 350,000 chips for Martinsen, a bust out for Odden, and a small stack left for Keranen was the result of the three-way all-in.
Player
Chips
Progress
Jorn Martinsen
350,000
233,500
Ville-Matti Keranen
38,000
167,000
Roger Odden
0
0
15:46 (UTC+2)
Start of Level 17 Blinds: 2,000/4,000 Ante: 4,000
Sick Three Way All-In Posted Tuesday 23rd July, 2024 at 15:31(UTC+2) by Alaxandar Georgiev
Level 16: 1,500/3,000 (3,000) Entries: 168/617
Janne Rusanen opened the pot from an early position and got one call right behind him, then Jarri-Pekka Juhola made a 3-bet to 20,000 and an all-in for 32,500 chips followed by Ralf Mikk that had the small blind posted.
Rusanen didn't think much and shoved it all in as well for about 55,000, Juhola also didn't think twice and snap-called both.
Janne Rusanen: Jarri-Pekka Juhola: Ralf Mikk:
All of them had monster stacks, Rusanen had the pocket rockets and Juhola had the second-best starting hand.
The flop came which was not good at all for both players at risk - Rusanen and Mikk. A very interesting popped on the turn giving Mikk some flush-draw outs, he needed a spade to win the pot and stay alive and that is exactly what he got on the river.
Crazy pot between the 3 players and as usual the underdog won the hand. Ralf Mikk will continue with 100,000 stack which is just below the average for the level and Juhola won a small side pot worth 40,000.
Player
Chips
Progress
Jari-Pekka Juhola
112,000
82,000
Ralf Mikk
109,500
43,000
Janne Rusanen
0
0
15:08 (UTC+2)
Start of Level 16 Blinds: 1,500/3,000 Ante: 3,000
Payouts Announced - 79 Players Will Be Paid Posted Tuesday 23rd July, 2024 at 15:00(UTC+2) by Alaxandar Georgiev
Ring Event #3: €555 No-Limit Hold'em got a total of 617 entries, and only 189 remain at the time of writing. Payouts for the players have just been announced and a total prize pool of €296,160 will be divided amongst the top 79 of them.
First place is the staggering amount of €55,210, and one lucky person will take the prize home, followed by the third WSOPC golden ring.
All 79 will be guaranteed a min-cash payout of at least €1,100. The full payouts are in the Payouts tab in our coverage.
14:50 (UTC+2)
Start of Level 15 Blinds: 1,000/2,500 Ante: 2,500
Eliminations After End Of Late Registration Posted Tuesday 23rd July, 2024 at 14:50(UTC+2) by Alaxandar Georgiev
Here are the next batch of players who busted Day 2 and can no longer re-enter:
Player
Chips
Progress
Aleksander Lattikas
0
0
Alexey Cherkasov
0
0
Rashad Iskandarov
0
0
Oskar Ojaveer
0
0
Johannes Cleven
0
0
Kimmo Kurko
0
0
Summer Westerbur
0
0
Jevgenijs Sapronenko
0
0
Jeffrey Cormier
0
0
Marten Oks
0
0
Erwan Pirotais
0
0
Eriks Krumins
0
0
Joshua Stewart
0
0
Ekrem Esker Atush
0
0
Gatis Popovs
0
0
Mario Fenaroli
0
0
Igor Pihela Jr
0
0
Algirdas Sukys
0
0
Jaanus Veste
0
0
Radoslaw Hordynski
0
0
Aleksandr Januskevic
0
0
Marius Morel
0
0
Arturs Pless
0
0
Priit Vanem
0
0
Ignotas Tamasauskas
0
0
Jeffrey Cormier
0
0
Jevgenijs Sapronenko
0
0
Johannes Cleven
0
0
Roope Holma
0
0
Jari Mahonen
0
0
Ignotas Tamasauskas
0
0
Mairo Tori
0
0
Deniss Levinskis
0
0
Vitalijus Kuzmicius
0
0
Roman Petelytskyi
0
0
Nils Butevics
0
0
Sauli Haapaniemi
0
0
Edvinas Tarasevicius
0
0
Hok Lai
0
0
Espen Sandvik
0
0
Enrique Martinez
0
0
Jari Porkka
0
0
Enea Subashi
0
0
Jeffrey Cormier
0
0
Herli Olop
0
0
Daniel Tankel
0
0
Dmitri Dudakov
0
0
Artjoms Sutjagins
0
0
Algirdas Sukys
0
0
Tobias Napel
0
77,000
Tobias Napel
0
77,000
Bigger Stacks In Day 2 Posted Tuesday 23rd July, 2024 at 14:29(UTC+2) by Alaxandar Georgiev
Here are some of the bigger stacks on Day 2 after the first four levels were completed.
Marcus Carlsen continues to chip the lead on Day 2 with 212 players left. The average stack is at 87,583 and players will continue at Level 15 - blinds 1,000/2,500 and Ante 2,500.
Player
Chips
Progress
Marcus Carlsen
370,000
40,000
Tero Laurila
245,000
169,000
Andrei Mjagkov
215,000
74,500
Ville-Matti Keranen
205,000
143,000
Antti Vetelainen
200,000
108,000
Tomi Arponen
190,000
60,500
Artjoms Hromovs
180,000
74,000
Aurimas Stanevicius
160,000
101,500
Offers & Promos Posted Tuesday 23rd July, 2024 at 14:26(UTC+2) by Matthew Summers
Main Event Travel is dedicated to providing the number one Poker Travel booking platform for players heading to tournaments around the world.
Join our Facebook Group, your gateway to offers and promotions created specifically for Poker Travellers looking for convenience, value, info, and expert customer service.
Last 20 Minutes of Late Registration Posted Tuesday 23rd July, 2024 at 14:04(UTC+2) by Alaxandar Georgiev
The players just finished with Level 14 and this means all 200 of them get to go on a 20-minute break. Late registration for Day 2 will be open until the break ends.
The Rich Get Richer Posted Tuesday 23rd July, 2024 at 13:51(UTC+2) by Alaxandar Georgiev
Level 14: 1,000/2,000 (2,000) Entries: 203/584
Norway's Marcus Carlsen was the top stack heading into Day 2 with an impressive 218,500 chip stack. He got involved in a pot after he raised under the gun to 4,000 and Christopher Dowling shoved his remaining 35,000 chips. Everyone else folded and Carlsen made the call.
Marcus Carlsen: Christopher Dowling:
Carlsen was in the lead with the better pocket pair and even managed to hit a set on the flop. The other two cards were not seven and seven which meant only one thing for Dowling - a last chance to re-enter or leave the fight for the third golden ring.
Player
Chips
Progress
Marcus Carlsen
330,000
111,500
Christopher Dowling
0
0
13:50 (UTC+2)
Start of Level 14 Blinds: 1,000/2,000 Ante: 2,000
Ladies Against Rockets For Subashi Posted Tuesday 23rd July, 2024 at 13:40(UTC+2) by Alaxandar Georgiev
Level 13: 1,000/2,000 (2,000) Entries: 198/568
Both Artjoms Hromovs and Greece's Enea Subashi found themselves all-in preflop and they had monster hands.
Artjoms Hromovs: Enea Subashi:
Hromovs had his opponent quite dominated and it looked like it was over for Subashi on the flop with Hromovs hitting top set. Subashi was already packing his things when the hit the turn and brought some hope for him.
BANG .. what a river - the dealer drills the giving Subashi the straight he needs. Devastating river for Hromovs as he loses a big 94,000 pot, but still has a healthy stack of over a hundred thousand.
Player
Chips
Progress
Artjoms Hromovs
106,000
44,000
Enea Subashi
94,000
64,000
Forus Needs A Greenstein Posted Tuesday 23rd July, 2024 at 13:27(UTC+2) by Alaxandar Georgiev
Level 13: 1,000/2,000 (2,000) Entries: 206/556
Tarjei Forus (pictured below) who managed to get to the 8-Game Ring Event yesterday opened shoved for a little less than 10 big blinds and got called by Kristo Klaassen who was sitting on the big blind.
Tarjei Forus: Kristo Klaassen:
Forus needed to hit his ace since his opponent had a very strong pocket pair. No help for him on the flop, neither on the turn or river, which meant this bullet in Day 2 is finished for Tarjei Forus.
Player
Chips
Progress
Kristo Klaassen
78,000
9,500
Tarjei Forus
0
0
13:24 (UTC+2)
Start of Level 13 Blinds: 1,000/2,000 Ante: 2,000
Early Eliminations In Day 2 Posted Tuesday 23rd July, 2024 at 13:17(UTC+2) by Alaxandar Georgiev
Here are some of the players who already busted in the Day 2. Hopefully, most of them return and keep battling for the ring as late registration is open for 2 more levels.
Player
Chips
Progress
Mikael Haapaniemi
0
0
Arturs Pless
0
0
Hans Hagberg
0
0
Hans Abrahamsson
0
0
Laurynas Vaitkevicius
0
0
Jan Holte
0
0
Sondre Lunde
0
0
Richard Koppel
0
0
Joel Haapio
0
0
Alvils Bijons
0
0
Eriks Krumins
0
0
Kim Granneman
0
0
Anton Makejev
0
0
Sondre Lunde
0
0
Matts Jakobsson
0
0
Sondre Lunde
0
0
Jon Kyte
0
0
Egidijus Digrys
0
0
Artur Kulanurk
0
0
Pavel Solodovnikov
0
0
Daniel Daw
0
0
Taago Tamm
0
0
David Bright
0
0
Dzianis Dubina
0
0
Stanislav Smeljov
0
0
Gatis Popovs
0
0
Daniel Stacey
0
0
Jussi Julkunen
0
0
Ricardas Bartasius
0
0
Paul Koppe
0
0
Ekrem Esker Atush
0
0
Chris-Mikael Hansen
0
0
Ville-Tapio Mesiranta
0
0
Janis Vasiljevs
0
0
Uladzimir Luchkou
0
0
Zechariah Montoya
0
0
Enea Subashi
0
0
Kimmo Mertala
0
0
Rolandas Aglinskas
0
0
Nils Veipans
0
0
Christopher Dowling
0
0
Sander Einlo
0
0
Sergei Kuznetsov
0
0
Jari-Pekka Juhola
0
0
Dalius Ulevicius
0
0
Hromovs Extends His Good Stack Posted Tuesday 23rd July, 2024 at 12:58(UTC+2) by Alaxandar Georgiev
Level 12: 1,000/1,500 (1,500) Entries: 235/535
Artjoms Hromovs was heads-up on the river against France's Erwan Pirotais and there were already 40,000 chips in the middle on the board. Hromovs jammed his four chips in each worth 25,000 and got his opponent into the tank.
After a while, Pirotais ended up folding and Hromovs is up to 150,000 with the average stack being 70,000 at the moment.
Player
Chips
Progress
Artjoms Hromovs
150,000
91,000
Erwan Pirotais
37,000
39,000
12:43 (UTC+2)
Start of Level 12 Blinds: 1,000/1,500 Ante: 1,500
Stewart Gets A Good One Posted Tuesday 23rd July, 2024 at 12:40(UTC+2) by Alaxandar Georgiev
Level 11: 1,000/1,500 (1,500) Entries: 237/519
Once again Joshua Stewart was in play as he put all of his remaining 13,500 chips all-in after a 3,000 raise from Ville-Matti Keränen. Jarmo Salonen called from the big blind and Keränen put another 10,500 for the call.
Just like one of the earlier pots it checked around till the river on board and everyone turned their cards up.
Joshua Stewart: Jarmo Salonen: Ville-Matti Keränen:
Salonen had a pair of Kings, which was good against Keränen's pocket fives, but it was no bueno against Stewert's set of nines. A nice triple-up for him and he is up to a bit over 40,000.
Player
Chips
Progress
Jarmo Salonen
164,000
41,500
Ville-Matti Keranen
48,500
13,500
Joshua Stewart
41,500
23,500
Can Häkkinen Find A Triple-Up ? Posted Tuesday 23rd July, 2024 at 12:22(UTC+2) by Alaxandar Georgiev
Level 11: 1,000/1,500 (1,500) Entries: 235/497
Joshua Stewart opened up the action on table number 3 with a raise to 3,000 and an all-in followed by Verneri Häkkinen from the cutoff. It folded around to Sargon Esfendiyari on the big who made the call for 11,500 - Stewert also completed with a call.
Three-way to the flop no action was made by both still involved. Checks from both on the turn and river got them all to show their cards.
Joshua James Stewart: Verneri Häkkinen: Sargon Esfendiyari:
Esfendiyari was likely to win the pot even without the river, but it certainly helped his cause. Häkkinen busts Day 2, but he still has 4 more levels to re-enter and fight for the golden ring.
Player
Chips
Progress
Sargon Esfendiyari
50,000
25,500
Joshua Stewart
18,000
7,000
Verneri Hakkinen
0
0
Shuffle Up And Deal - Day 2 of Ring Event #3: €555 No-Limit Hold'em Starts Posted Tuesday 23rd July, 2024 at 12:12(UTC+2) by Alaxandar Georgiev
Action at Olympic Park Casino starts once again with Day 2 of Ring Event #3: €555 No-Limit Hold'em.
235 players managed to continue from the four starting days and 8 we already have 8 new entries so far. Late registration is open for the first 4 levels and then it's game on for the third golden ring in the WSOP Circuit here in Tallinn.
11:57 (UTC+2)
Day 2 of Olympic Park Casino Started Level: 11 Blinds: 1,000/1,500 Ante: 1,500
Marcus Carlsen Leads €555 NLH Heading Into Day 2 Posted Tuesday 23rd July, 2024 at 11:04(UTC+2) by Jason Glatzer
The three-day Event #3: €555 No-Limit Hold'em ring event completed its four opening flights with the field already attracting 461 entries for a €221,280 prize pool.
These figures will continue to grow as late registration remains open for the first four blind levels of Tuesday's Day 2, which begins at 12 p.m. The first two blind levels of the day will be 1,000/1,500 (1,500) before two levels repeat again with 1,000/2,000 (2,000) blinds. This means players buying in on Day 2 or re-entering if things don't start well will have 20 big blinds at the start with a 30,000 starting stack.
After that, late registration will close, the prizes will be announced, and blinds will continue to increase every 30 minutes until a final table of nine players is reached.
Norway's Marcus Carlssen leads the way heading into Day 2 with an impressive 218,500 chip stack. Finland's Rasmus Sihvonen (208,500) and Jarmo Salonen (205,500) were the only two players to begin the day with at least 200,000 in chips.
We will be live reporting Event #5: €555 No-Limit Hold'em from Day 2 onwards.
Day 2 Seat Draw Posted Tuesday 23rd July, 2024 at 10:48(UTC+2) by Jason Glatzer
Table
Seat
Name
Country
Chips
Big Blinds
1
1
Mikael Haapaniemi
Finland
15,000
10
1
2
Aleksandr Januskevic
Lithuania
69,000
46
1
3
Tarjei Forus
Norway
30,000
20
1
5
Georgi Abuladze
Estonia
68,000
45
1
6
David Tennback
Sweden
18,000
12
1
7
Summer Westerbur
United States
39,500
26
1
8
Kristo Klaassen
Estonia
68,500
46
2
1
Marius Morel
Estonia
66,500
44
2
2
Ralf Mikk
Estonia
66,500
44
2
3
Marten Oks
Estonia
67,000
45
2
4
Pavel Solodovnikov
Estonia
26,500
18
2
5
Edoardo Mancinelli
Italy
80,000
53
2
6
Jani Tuovinen
Finland
34,500
23
2
7
Tobias Napel
Norway
77,000
51
3
2
Stanislav Smeljov
Estonia
61,500
41
3
3
Hok Lai
United Kingdom
96,500
64
3
4
Joshua Stewart
Northern Ireland
25,000
17
3
5
Verneri Hakkinen
Finland
11,500
8
3
6
Nikodemas Staniukaitis
Lithuania
67,500
45
3
7
Jarmo Salonen
Finland
205,500
137
3
8
Sargon Esfendiyari
Finland
24,500
16
4
2
Igor Aleksandrov
Estonia
38,000
25
4
3
Modestas Kryzanauskas
Lithuania
32,500
22
4
4
Liutauras Armanavicius
Lithuania
47,000
31
4
5
Konsta Heikkila
Finland
50,000
33
4
6
Tapio Aaltonen
Finland
73,500
49
4
7
Aleksander Lattikas
Estonia
85,000
57
4
8
Mika Hautakangas
Finland
26,500
18
5
1
Timo Ruuska
Finland
55,000
37
5
2
Aurimas Stanevicius
Lithuania
58,500
39
5
3
Anton Makejev
Estonia
22,000
15
5
4
Maksym Klopotok
Ukraine
111,000
74
5
5
Linda Nguyen
Norway
125,500
84
5
6
Tomi Arponen
Finland
129,500
86
5
7
Dalius Ulevicius
Lithuania
26,000
17
6
1
Mario Fenaroli
Switzerland
58,500
39
6
2
Xi Tran
Norway
62,500
42
6
3
Erik Lindqwist
Sweden
151,000
101
6
4
Dmitri Dudakov
Estonia
54,000
36
6
5
Arturs Pless
Latvia
19,500
13
6
7
Andrius Dubietis
Lithuania
106,500
71
6
8
Klaudijus Bajoras
Lithuania
23,500
16
7
1
Dmitri Damaskin
Estonia
64,500
43
7
2
Tommy Piiroinen
Finland
192,500
128
7
4
Vadims Milovs
Latvia
49,500
33
7
5
Zanas Lubys
Lithuania
54,000
36
7
6
Johannes Cleven
Norway
29,000
19
7
7
Eriks Krumins
Latvia
36,000
24
7
8
Kim Granneman
Norway
30,500
20
8
1
Marius Hakonsen
Norway
75,500
50
8
3
Tero Laurila
Finland
76,000
51
8
4
Morten Bremseth
Norway
70,000
47
8
5
Oskar Ojaveer
Estonia
48,500
32
8
6
Tuomas Tervonen
Finland
30,500
20
8
7
Ekrem Esker Atush
Finland
77,500
52
8
8
Kestutis Jungevicius
Lithuania
136,000
91
9
1
Algirdas Sukys
Lithuania
22,000
15
9
2
Vasyl Tkachenko
Ukraine
80,000
53
9
3
Jussi Julkunen
Finland
35,000
23
9
4
Roope Tarmi
Finland
35,500
24
9
6
Artjoms Hromovs
Latvia
59,000
39
9
7
Taago Tamm
Estonia
23,000
15
9
8
Erwan Pirotais
France
76,000
51
10
1
Bjorn Tore Tvedt
Norway
22,000
15
10
2
Antti Vetelainen
Finland
92,000
61
10
3
Marcus Carlsen
Norway
218,500
146
10
4
Petteri Miettinen
Finland
20,500
14
10
5
Laurynas Vaitkevicius
Lithuania
79,500
53
10
6
Richard Koppel
Estonia
14,000
9
10
8
Christopher Dowling
Ireland
59,500
40
11
1
Igor Pihela Jr
Estonia
78,500
52
11
2
Jaakko Tirkkonen
Finland
31,000
21
11
3
Artur Kulanurk
Estonia
19,000
13
11
4
Ville Pohjalainen
Finland
96,000
64
11
6
Dzianis Dubina
Poland
28,500
19
11
7
Jonatan Fors
Finland
15,000
10
11
8
Sebastian Wahl
Finland
42,000
28
16
1
Vidar Assersen
Norway
75,500
50
16
3
Kevin Karenius
Finland
56,500
38
16
4
Andrei Mjagkov
Estonia
140,500
94
16
5
Siim Suviste
Estonia
115,000
77
16
6
Herli Olop
Estonia
44,500
30
16
7
Roope Holma
Finland
43,000
29
16
8
Ignotas Tamasauskas
Lithuania
53,000
35
17
1
Aleksandr Jelpidiforov
Estonia
142,000
95
17
2
Boris Smolianskii
Israel
59,000
39
17
3
Luka Sorainen
Finland
92,500
62
17
4
Nicolas Bokowski
Germany
111,000
74
17
6
Sander Leigri
Estonia
80,500
54
17
7
David Bright
Northern Ireland
43,000
29
17
8
Ranno Sootla
Estonia
37,000
25
18
1
Frederico Alves Dos Santos
Brazil
50,000
33
18
2
Andre Magi
Estonia
61,500
41
18
4
Franco Spichtig
Switzerland
37,000
25
18
5
Deniss Levinskis
Latvia
29,000
19
18
6
Janis Vasiljevs
Latvia
24,000
16
18
7
Jordi Conejos Baixas
Spain
60,000
40
18
8
Aleksi Naski
Finland
119,000
79
23
1
Arturs Putnins
Latvia
64,000
43
23
2
Hans Hagberg
Sweden
29,000
19
23
3
Andrius Bielskis
Lithuania
50,500
34
23
5
Nebojsa Musulin
Germany
183,000
122
23
6
Victor Prior Fernandez Amat
Spain
78,500
52
23
7
Aleksandr Naumov
Lithuania
59,500
40
23
8
Chris-Mikael Hansen
Norway
74,500
50
24
1
Markku Ihamaki
Finland
41,000
27
24
3
Nils Veipans
Latvia
96,500
64
24
4
Christian Steinbo
Norway
74,000
49
24
5
Ridas Bitauskas
Lithuania
43,500
29
24
6
Roman Jezov
Estonia
121,000
81
24
7
Daniel Daw
United Kingdom
23,000
15
24
8
Timo Malo
Finland
150,000
100
25
1
Edvinas Tarasevicius
Lithuania
82,500
55
25
3
Kazimieras Ramaska
Lithuania
91,500
61
25
4
Kaspars Butans
Latvia
55,000
37
25
5
Athanasios Kostouros
Greece
24,000
16
25
6
Ritvars Cekalins
Latvia
17,500
12
25
7
Matts Jakobsson
Sweden
35,000
23
25
8
Victor Fernandez Garcia
Spain
49,500
33
26
1
Jari Mahonen
Finland
70,500
47
26
2
Jeffrey Cormier
Canada
85,500
57
26
3
Nils Butevics
Latvia
27,000
18
26
5
Natalia Manuyko
Estonia
92,000
61
26
6
Jevgenijs Sapronenko
Latvia
70,500
47
26
7
Lorenzo Arduini
Italy
44,000
29
26
8
Kristjan Maasalu
Estonia
129,500
86
27
1
Tigrans Vilums
Latvia
99,000
66
27
2
Ben Slack
United Kingdom
84,500
56
27
3
Mairo Tori
Estonia
60,500
40
27
4
Theis Nielsen
Norway
63,500
42
27
5
Radoslaw Hordynski
Poland
29,500
20
27
6
Enea Subashi
Greece
28,500
19
27
8
Andrius Mazeika
Lithuania
68,500
46
28
1
Tarmo Tammel
Estonia
29,500
20
28
2
Kaido Koorits
Estonia
60,000
40
28
3
Vitalijus Kuzmicius
Lithuania
88,500
59
28
4
Kimmo Kurko
Finland
115,000
77
28
5
Daniel Stacey
United Kingdom
64,500
43
28
7
Meelis Ahman
Estonia
104,000
69
29
1
Oleksii Natoptanyi
Ukraine
74,000
49
29
2
Sergei Kuznetsov
Estonia
27,000
18
29
3
Jan Holte
Norway
32,500
22
29
4
Sondre Lunde
Norway
9,000
6
29
7
Tanel Evert
Estonia
101,500
68
29
8
Otto Kiiskinen
Finland
85,000
57
30
2
Hans Fernkvist
Sweden
125,000
83
30
3
Jari-Pekka Juhola
Finland
92,000
61
30
4
Dominik Ostrowski
Poland
71,000
47
30
6
Fredric Eriksson
Sweden
91,000
61
30
7
Tal Herzog
Israel
38,500
26
30
8
Roman Petelytskyi
Ukraine
38,000
25
31
1
Mohammed Al-Khazraji
Finland
96,000
64
31
2
Mykola Kostyrko
Ukraine
90,500
60
31
3
Raphael Godard
France
60,500
40
31
4
Donatas Pilinkus
Lithuania
106,500
71
31
5
Alexey Cherkasov
Estonia
32,500
22
31
8
Sauli Haapaniemi
Finland
29,500
20
32
1
Hans Abrahamsson
Sweden
48,500
32
32
3
Rolandas Aglinskas
Lithuania
47,500
32
32
4
Nohad Teliani
Canada
34,000
23
32
5
Paul Koppe
Estonia
21,000
14
32
6
Timmy Anker
Denmark
170,500
114
32
7
Marios Mansour
Cyprus
125,000
83
32
8
Teppo Joentausta
Finland
97,500
65
33
1
Mykhailo Mikhalov
Ukraine
93,000
62
33
2
Joel Haapio
Finland
28,500
19
33
4
Jorn Martinsen
Norway
116,500
78
33
5
Luca Sebastiani
Italy
43,500
29
33
6
Jari Porkka
Sweden
37,000
25
33
7
Kasper Mellanen
Finland
157,500
105
33
8
Knut Turk
Estonia
70,000
47
34
1
Egidijus Digrys
Lithuania
17,000
11
34
2
Konstantin Farber
Germany
107,000
71
34
3
Kimmo Mertala
Finland
37,000
25
34
4
Artjoms Sutjagins
Latvia
18,000
12
34
5
Miika Toyras
Finland
10,900
7
34
6
Jargo Alavali
Estonia
61,500
41
34
8
Roger Odden
Norway
127,000
85
35
1
Christel Haller
Estonia
62,500
42
35
2
Maikel Homin
Estonia
144,500
96
35
3
Anders Beckman
Sweden
18,500
12
35
4
Daniel Tankel
United Kingdom
77,500
52
35
6
Priit Vanem
Estonia
25,000
17
35
7
Ricardas Bartasius
Lithuania
16,500
11
35
8
Ville-Tapio Mesiranta
Finland
58,000
39
36
1
Ruslans Levockins
Latvia
69,000
46
36
2
Jorden Verbraeken
Belgium
44,000
29
36
3
Rasmus Sihvonen
Finland
208,500
139
36
4
Sakari Setala
Finland
72,000
48
36
5
Peteris Balodis
Latvia
42,000
28
36
7
Henri Schalin
Finland
130,000
87
36
8
Uladzimir Luchkou
Belarus
23,000
15
37
1
Sander Einlo
Estonia
91,500
61
37
2
Jon Kyte
Norway
32,500
22
37
3
Maksim Petrov
Estonia
67,000
45
37
5
Lasse Aarninsalo
Finland
46,000
31
37
6
Sohrab Malkari
Norway
70,500
47
37
7
Tadas Simas
Lithuania
35,000
23
37
8
Helina Tamm
Estonia
50,500
34
38
1
Kaido Mikk
Estonia
125,000
83
38
2
Masse Mirza
Estonia
22,500
15
38
3
Alvils Bijons
Latvia
42,000
28
38
5
Rashad Iskandarov
Estonia
58,000
39
38
6
Jaanus Veste
Estonia
52,500
35
38
7
Robert Kallikorm
Estonia
58,500
39
38
8
Audrius Laimelis
Lithuania
73,000
49
39
2
Touko Berndtson
Finland
21,000
14
39
3
Espen Sandvik
Norway
24,000
16
39
4
Tanel Merida
Estonia
50,000
33
39
5
Enrique Martinez
Spain
57,000
38
39
6
Zechariah Montoya
United States
28,500
19
39
7
Gatis Popovs
Latvia
42,500
28
39
8
Kelly Limonova
Estonia
46,500
31
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.