0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0087 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-19' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event6/3/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_event6/3/updates', 1, '2024-12-19')

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0003 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`active` = '1'

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

0.0040 SECONDS:
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30

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

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

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

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

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

0.0277 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` = '355' AND `published` = 1

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

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

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

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

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

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

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

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

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

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

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

0.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` = '16009' 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` = '16007' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.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` = '15715' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Current Level 38 Current Day 4
Blinds 300,000/600,000 Ante 600000
Entries 812 Remaining 1
Prize Pool (EUR) €1,052,352 First Prize (EUR) €167,900
1 New Update - Click to refresh
Live Updates - Day 3
10:14 (UTC+2)
Day 3 of Olympic Park Casino Ended
Level: 32     Blinds: 75,000/100,000     Ante: 100,000
Final Table Seat Draw Posted Sunday 28th July, 2024 at 03:42(UTC+2) by Jason Glatzer

Seat Name Country Chips Big Blinds
1 Roberto Ahane Olsen Sweden 6,925,000 46
2 Sergei Aleksejev Estonia 3,500,000 23
3 Evgeny Vyal Estonia 3,275,000 22
4 Kriss Riekstins Latvia 2,000,000 13
5 Espen Smorholm Sandvik Norway 1,900,000 13
6 Jeffrey Cormier Canada 11,850,000 79
7 Yurii Zabrodotskyi Ukraine 6,975,000 47
8 Mindaugas Kriauciunas Lithuania 2,700,000 18
9 Aurimas Stanevicius Lithuania 1,425,000 10
Enea Subashi Eliminated in 10th Place (€13,800) Posted Sunday 28th July, 2024 at 03:38(UTC+2) by Jason Glatzer

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

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

Enea Subashi:
Jeffrey Cormier:
Roberto Olsen:

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

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

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

Player Chips Progress
Jeffrey Cormier 11,850,000 6,850,000
Yurii Zabrodotskyi 6,975,000 2,650,000
Roberto Olsen 6,925,000 200,000
Sergei Aleksejev 3,500,000 1,100,000
Evgeny Vyal 3,275,000 1,325,000
Mindaugas Kriauciunas 2,700,000 750,000
Kriss Riekstins 2,000,000 500,000
Espen Sandvik 1,900,000 600,000
Aurimas Stanevicius 1,425,000 1,600,000
Enea Subashi 0 0
Riekstins Doubles Through Sandvik Posted Sunday 28th July, 2024 at 02:58(UTC+2) by Jason Glatzer

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

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

Kriss Riekstins:
Espen Sandvik:

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

Player Chips Progress
Kriss Riekstins 2,500,000 1,250,000
Espen Sandvik 2,500,000 1,175,000
01:17 (UTC+2)
Start of Level 32
Blinds: 75,000/100,000     Ante: 100,000
Break Time and Chip Counts Posted Sunday 28th July, 2024 at 01:17(UTC+2) by Jason Glatzer

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

Player Chips Progress
Yurii Zabrodotskyi 9,625,000 6,625,000
Roberto Olsen 7,125,000 675,000
Jeffrey Cormier 5,000,000 1,535,000
Sergei Aleksejev 4,600,000 850,000
Espen Sandvik 3,675,000 975,000
Aurimas Stanevicius 3,025,000 975,000
Enea Subashi 2,400,000 700,000
Mindaugas Kriauciunas 1,950,000 700,000
Evgeny Vyal 1,950,000 1,665,000
Kriss Riekstins 1,250,000 1,050,000
Gunnar Wedde Eliminated in 11th Place (€13,800) Posted Sunday 28th July, 2024 at 00:51(UTC+2) by Jason Glatzer

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

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

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

Player Chips Progress
Roberto Olsen 7,800,000 4,325,000
Gunnar Wedde 0 0
Ignotas Tamasauskas Eliminated in 12th Place (€11,200) Posted Sunday 28th July, 2024 at 00:34(UTC+2) by Jason Glatzer

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

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

Player Chips Progress
Aurimas Stanevicius 4,000,000 2,470,000
Ignotas Tamasauskas 0 0
00:10 (UTC+2)
Start of Level 31
Blinds: 50,000/125,000     Ante: 125,000
Vilius Zabarauskas Eliminated in 13th Place (€13,200) Posted Saturday 27th July, 2024 at 23:43(UTC+2) by Jason Glatzer

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

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

Vilius Zabarauskas:
Enea Subashi:

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

Player Chips Progress
Enea Subashi 1,700,000 440,000
Vilius Zabarauskas 0 0
Marius Morel Eliminated in 14th Place (€9,200) Posted Saturday 27th July, 2024 at 23:29(UTC+2) by Jason Glatzer

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

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

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

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

Player Chips Progress
Jeffrey Cormier 5,500,000 2,535,000
Marius Morel 0 0
23:28 (UTC+2)
Start of Level 30
Blinds: 50,000/100,000     Ante: 100,000
Vilde Fagerbakke Eliminated in 15th Place (€9,200) Posted Saturday 27th July, 2024 at 23:28(UTC+2) by Jason Glatzer

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

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

Vilde Fagerbakke:
Jeffrey Cormier:

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

Player Chips Progress
Jeffrey Cormier 4,000,000 1,035,000
Vilde Fagerbakke 0 0
Sohrab Malkari Eliminated in 16th Place (€8,001) Posted Saturday 27th July, 2024 at 23:11(UTC+2) by Jason Glatzer

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

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

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

Player Chips Progress
Yurii Zabrodotskyi 3,000,000 605,000
Kriss Riekstins 2,300,000 1,260,000
Sohrab Malkari 0 0
Gunnar Wedde Leads Final Two Tables Posted Saturday 27th July, 2024 at 22:32(UTC+2) by Jason Glatzer

Player Chips Progress
Gunnar Wedde 4,545,000 1,735,000
Espen Sandvik 4,065,000 250,000
Ignotas Tamasauskas 3,855,000 45,000
Sergei Aleksejev 3,750,000 25,000
Evgeny Vyal 3,615,000 600,000
Roberto Olsen 3,475,000 405,000
Jeffrey Cormier 2,965,000 135,000
Mindaugas Kriauciunas 2,650,000 280,000
Yurii Zabrodotskyi 2,580,000 220,000
Sohrab Malkari 2,440,000 565,000
Aurimas Stanevicius 1,530,000 1,095,000
Enea Subashi 1,260,000 610,000
Vilde Fagerbakke 1,070,000 430,000
Kriss Riekstins 1,040,000 260,000
Marius Morel 945,000 1,155,000
Vilius Zabarauskas 815,000 2,405,000
Slack Elimination in 17th Place (€8,001) Posted Saturday 27th July, 2024 at 22:32(UTC+2) by Alaxandar Georgiev

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

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

Ben Slack:
Espen Sandvik:

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

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


Player Chips Progress
Espen Sandvik 4,400,000 585,000
Ben Slack 0 0
Wedde Gets Paid With Big Slick Posted Saturday 27th July, 2024 at 22:25(UTC+2) by Jason Glatzer

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

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

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

Player Chips Progress
Gunnar Wedde 4,000,000 1,190,000
Yurii Zabrodotskyi 2,000,000 185,000
Fagerbakke Doubles With Ace-Ten Posted Saturday 27th July, 2024 at 22:03(UTC+2) by Jason Glatzer

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

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

Vilde Fagerbakke:
Yurii Zabrodotskyi:

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

Player Chips Progress
Yurii Zabrodotskyi 2,800,000 615,000
Vilde Fagerbakke 1,500,000 165,000
22:03 (UTC+2)
Start of Level 29
Blinds: 40,000/80,000     Ante: 80,000
Lucky Double for Olsen Posted Saturday 27th July, 2024 at 22:03(UTC+2) by Jason Glatzer

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

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

Roberto Olsen:
Ignotas Tamasauskas:

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

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

Player Chips Progress
Ignotas Tamasauskas 3,900,000 100,000
Roberto Olsen 3,400,000 1,880,000
Nohad Teliani Eliminated in 18th Place (€6,900) Posted Saturday 27th July, 2024 at 21:29(UTC+2) by Jason Glatzer

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

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

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

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

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

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

Liutauras Armanavicius:
Roberto Olsen:

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

Player Chips Progress
Roberto Olsen 2,000,000 480,000
Liutauras Armanavicius 0 0
Matte Karjalainen Eliminated in 20th Place (€6,900) Posted Saturday 27th July, 2024 at 21:08(UTC+2) by Jason Glatzer

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

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

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

Player Chips Progress
Marius Morel 2,100,000 550,000
Matte Karjalainen 0 0
Slack Doubles Through Armanavicius Posted Saturday 27th July, 2024 at 21:06(UTC+2) by Jason Glatzer

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

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

Ben Slack:
Liutauras Armanavicius:

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

Player Chips Progress
Ben Slack 1,850,000 815,000
Liutauras Armanavicius 650,000 875,000
Robert Rudolf Rohr Eliminated in 21st Place (€6,100) Posted Saturday 27th July, 2024 at 20:59(UTC+2) by Jason Glatzer

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

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

Robert Rohr:
Ignotas Tamasauskas:

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

Player Chips Progress
Ignotas Tamasauskas 4,000,000 695,000
Robert Rohr 0 0
WSCOPC €350 Online Ring Event Posted Saturday 27th July, 2024 at 20:51(UTC+2) by Lina Olofsson

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

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

20:44 (UTC+2)
Start of Level 28
Blinds: 30,000/60,000     Ante: 60,000
Sandvik Leads at Break Posted Saturday 27th July, 2024 at 20:01(UTC+2) by Jason Glatzer

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

Check out the full chip counts at the break:

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

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

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

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

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

Jaarko Soukas:
Espen Sandvik:

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

Player Chips Progress
Espen Sandvik 4,000,000 500,000
Jarkko Suokas 0 0
Aleksei Vandyshev Eliminated in 23rd Place (€6,100) Posted Saturday 27th July, 2024 at 19:32(UTC+2) by Jason Glatzer

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

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

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

Player Chips Progress
Ignotas Tamasauskas 2,500,000 1,665,000
Roberto Olsen 600,000 100,000
Aleksei Vandyshev 0 0
Tamasauskas Doubles With Big Slick Posted Saturday 27th July, 2024 at 19:22(UTC+2) by Jason Glatzer

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

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

Ignotas Tamasauskas:
Robert Rohr:

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

Player Chips Progress
Ignotas Tamasauskas 2,300,000 1,465,000
Robert Rohr 1,650,000 115,000
18:50 (UTC+2)
Start of Level 27
Blinds: 25,000/50,000     Ante: 50,000
Kaspar Kaisel Eliminated in 24th Place (€5,400) Posted Saturday 27th July, 2024 at 18:49(UTC+2) by Jason Glatzer

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

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

Kaspar Kaisel:
Aleksei Vandyshev:

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

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

Player Chips Progress
Aleksei Vandyshev 1,200,000 110,000
Kaspar Kaisel 0 0
Malkari Wins a Flip With Sevens Posted Saturday 27th July, 2024 at 18:46(UTC+2) by Jason Glatzer

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

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

Sohrab Malkari:
Roberto Olsen:

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

Player Chips Progress
Sohrab Malkari 1,760,000 855,000
Roberto Olsen 700,000 895,000
Big Slick for Sandvik Posted Saturday 27th July, 2024 at 18:21(UTC+2) by Jason Glatzer

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

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

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

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

Player Chips Progress
Vilius Zabarauskas 4,000,000 635,000
Espen Sandvik 3,500,000 605,000
Delay and Chip Counts Posted Saturday 27th July, 2024 at 17:39(UTC+2) by Jason Glatzer

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

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

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

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

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

Igor Pihela Jr:
Sergei Aleksejev:

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

Player Chips Progress
Sergei Aleksejev 4,300,000 500,000
Robert Kaggerud 0 0
Igor Pihela Jr 0 0
16:58 (UTC+2)
Start of Level 26
Blinds: 20,000/40,000     Ante: 40,000
Krumins Bricks Flush Draw Posted Saturday 27th July, 2024 at 16:58(UTC+2) by Jason Glatzer

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

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

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

Player Chips Progress
Sergei Aleksejev 3,800,000 1,675,000
Mairo Tori 0 0
Juuso Koskela 0 0
Roope Tarmi 0 0
Eriks Krumins 0 0
Day 8 Video Recap Posted Saturday 27th July, 2024 at 16:53(UTC+2) by Jason Glatzer

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

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

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

Roman Petelytskyi:
Eriks Krumins:

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

Player Chips Progress
Eriks Krumins 1,100,000 805,000
Gregory Telman 0 0
Roman Petelytskyi 0 0
Elias Suhonen 0 0
Malkari Doubles With Sixes Posted Saturday 27th July, 2024 at 16:23(UTC+2) by Jason Glatzer

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

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

Sohrab Malkari:
Roberto Olsen:

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

"You won the hand," said Cormier.

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

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

Player Chips Progress
Roberto Olsen 2,000,000 1,435,000
Sohrab Malkari 980,000 525,000
New TV Table Line-Up and Chip Counts Posted Saturday 27th July, 2024 at 16:00(UTC+2) by Jason Glatzer

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

Player Chips Progress
Aurimas Stanevicius 1,960,000 10,000
Vilius Zabarauskas 1,835,000 725,000
Enea Subashi 1,795,000 780,000
Evgeny Vyal 1,385,000 85,000
Mindaugas Kriauciunas 910,000 655,000
Roope Tarmi 835,000 415,000
Gregory Telman 495,000 225,000
15:49 (UTC+2)
Start of Level 25
Blinds: 15,000/30,000     Ante: 30,000
Cormier Leads at Break Posted Saturday 27th July, 2024 at 15:44(UTC+2) by Jason Glatzer

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

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

Player Chips Progress
Jeffrey Cormier 3,050,000 2,595,000
Sergei Aleksejev 2,125,000 1,897,000
Matte Karjalainen 2,000,000 1,520,000
Aurimas Stanevicius 1,950,000 50,000
Espen Sandvik 1,915,000 1,645,000
Eriks Krumins 1,905,000 595,000
Vilius Zabarauskas 1,835,000 765,000
Vilius Zabarauskas 1,795,000 725,000
Robert Rohr 1,700,000 1,447,000
Second Break Posted Saturday 27th July, 2024 at 15:23(UTC+2) by Jason Glatzer

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

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

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

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

Sauli Haapaniemi:
Ignotas Tamasauskas:

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

Player Chips Progress
Ignotas Tamasauskas 465,000 750,000
Sauli Haapaniemi 0 0
Set of Ducks for Krumins Posted Saturday 27th July, 2024 at 15:16(UTC+2) by Jason Glatzer

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

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

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

Rubens Akopjancs:
Eriks Krumins:

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

Player Chips Progress
Eriks Krumins 2,500,000 1,400,000
Laurynas Vaitkevicius 0 0
Henri Katila 0 0
Rubens Akopjancs 0 0
Klezys Loses Flip to Vyal Posted Saturday 27th July, 2024 at 14:40(UTC+2) by Jason Glatzer

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

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

Kasparas Klezys:
Evgeny Vyal:

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

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

Player Chips Progress
Evgeny Vyal 1,300,000 510,000
Niko Ilmonen 0 0
Juuso Oksanen 0 0
Paul Koppe 0 0
Kasparas Klezys 0 0
14:24 (UTC+2)
Start of Level 24
Blinds: 10,000/25,000     Ante: 25,000
Fagerbakke and Teliani Final Two Women Posted Saturday 27th July, 2024 at 14:21(UTC+2) by Jason Glatzer

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

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

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

Player Chips Progress
Vilde Fagerbakke 1,050,000 210,000
Nohad Teliani 750,000 95,000
Stanevicius Eliminates Stankevics Posted Saturday 27th July, 2024 at 14:02(UTC+2) by Jason Glatzer

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

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

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

Krisjanis Stankevics:
Aurimas Stanevicius:

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

Player Chips Progress
Aurimas Stanevicius 1,900,000 350,000
Krisjanis Stankevics 0 0
Daniel Clifford 0 0
Jukka Moisio 0 0
Andre Villandberg 0 0
Parnat Runs Into Slack's Cowboys Posted Saturday 27th July, 2024 at 13:48(UTC+2) by Jason Glatzer

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

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

Risto Parnat:
Ben Slack:

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

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

Player Chips Progress
Ben Slack 1,200,000 670,000
Joshua Stewart 0 0
Risto Parnat 0 0
Berggren Loses Short Stack to Tori Posted Saturday 27th July, 2024 at 13:32(UTC+2) by Jason Glatzer

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

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

Christopher Berggren:
Mairo Tori:

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

Player Chips Progress
Mairo Tori 750,000 250,000
Victor Fernandez Garcia 0 0
Christopher Berggren 0 0
13:25 (UTC+2)
Start of Level 23
Blinds: 10,000/20,000     Ante: 20,000
Big Stacks at Break Posted Saturday 27th July, 2024 at 13:21(UTC+2) by Jason Glatzer
Player Chips Progress
Enea Subashi 2,575,000 25,000
Yurii Zabrodotskyi 2,570,000 1,225,000
Rubens Akopjancs 2,300,000 810,000
Aurimas Stanevicius 1,550,000 400,000
Elias Suhonen 1,510,000 250,000
Jarkko Suokas 1,310,000 750,000
Vilde Fagerbakke 1,260,000 1,150,000
Eriks Krumins 1,100,000 495,000
First Break Posted Saturday 27th July, 2024 at 13:04(UTC+2) by Jason Glatzer

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

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

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

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

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

Player Chips Progress
Enea Subashi 2,600,000 945,000
Tero Kilkanen 0 0
Nicolai Ejstrud 0 0
Ermo Kosk 0 0
Recent Eliminations Posted Saturday 27th July, 2024 at 12:47(UTC+2) by Jason Glatzer

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

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

Player Chips Progress
Matias Kesanen 0 0
Andre Grigorjev 0 0
Mauri Dorbek 0 0
Sondre Lunde 0 0
Janis Leja 0 0
Nicklas Dehli 0 0
Lindberg Loses Flip to Armanavicius Posted Saturday 27th July, 2024 at 12:29(UTC+2) by Jason Glatzer

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

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

Bjorn Lindberg:
Liutauras Armanavicius:

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

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

Player Chips Progress
Liutauras Armanavicius 1,500,000 345,000
Markku Koplimaa 0 0
Rustam Havryliuk 0 0
Tapio Aaltonen 0 0
Artur Kulanurk 0 0
Bjorn Lindberg 0 0
Jacks Good for Teliani Posted Saturday 27th July, 2024 at 12:20(UTC+2) by Jason Glatzer

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

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

Nohad Teliani:
Robert Kaggerud:

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

Player Chips Progress
Nohad Teliani 845,000 345,000
Robert Kaggerud 540,000 360,000
Martin Piik 0 0
Andrei Silencov 0 0
Konstantin Farber 0 0
Jyri Merivirta 0 0
Steven Tool 0 0
Chip Leader Paul Koppe at TV Table Posted Saturday 27th July, 2024 at 12:14(UTC+2) by Jason Glatzer

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

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

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

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

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

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

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

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

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

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

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

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

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

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.