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.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event3/2/updates', 1, '2024-09-01')

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

English
Olympic Park Casino Event #3: €555 No-Limit Hold'em Live Reporting - Day 3
1 New Update - Click to refresh
Live Updates - Day 2
11:46 (UTC+2)
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

MainEventTravel.com's Exclusive Added Value Promotion!

Win back up to 100% of Tournament Travel booked with MET in Eligible Events!

Head to MainEventTravel.com > Promotions for full details.

#FinalTableFreeroll

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.

 

Join today ?? https://www.facebook.com/groups/maineventtraveloffersandpromotions/

 

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.

???? ?? ???? ??????????? ? 1 ????? ? ???????? ?????????

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 . More 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.