0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0069 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-27' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-ppt-series3-event08/2/updates' ORDER BY `views` DESC

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024-ppt-series3-event08/2/updates', 1, '2024-12-27')

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

0.0001 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.0001 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.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

0.0039 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-ppt-series3-event08'

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '157'

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

0.0276 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` = '365' AND `published` = 1

0.0273 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0052 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '377' AND `published` = 1

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '157' AND `name` = '2'

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

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

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '16287' 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` = '16286' 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` = '16285' 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` = '16284' 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` = '16282' 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` = '16281' 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` = '16280' 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` = '16279' 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` = '16278' 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` = '16273' 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` = '16270' 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` = '16269' 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` = '16268' 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` = '16267' ORDER BY `chip_change` DESC, `busted` ASC

0.0068 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '16264' 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` = '16263' 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` = '16262' 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` = '16261' 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` = '16260' 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` = '16259' 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` = '16258' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0094 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '16256' 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` = '16255' 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` = '16254' 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` = '16250' 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` = '16249' 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` = '16248' 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` = '16247' 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` = '16246' 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` = '16245' 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` = '16244' 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` = '16243' 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` = '16239' 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` = '16238' 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` = '16237' 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` = '16236' 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` = '16235' 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` = '16234' 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` = '16233' 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` = '16225' 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` = '16224' 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` = '16223' 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` = '16222' 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` = '16221' 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` = '16220' 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` = '16219' 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` = '16218' 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` = '16217' 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` = '16216' 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` = '16215' 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` = '16214' 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` = '16211' 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` = '16210' 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` = '16209' 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` = '16208' 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` = '16205' 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` = '16204' ORDER BY `chip_change` DESC, `busted` ASC

0.0081 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '16203' 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` = '16202' 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` = '16201' 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` = '16200' 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` = '16197' 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` = '16196' 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` = '16194' 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` = '16193' 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` = '16192' 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` = '16191' 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` = '16190' 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` = '16188' 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` = '16187' 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` = '16186' 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` = '16184' 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` = '16183' 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` = '16182' 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` = '16181' 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` = '16180' 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` = '16179' 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` = '16177' 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` = '16176' 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` = '16175' 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` = '16089' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0070 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '16287' 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` = '16286' 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` = '16285' 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` = '16284' 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` = '16282' 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` = '16281' 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` = '16280' 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` = '16279' 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` = '16278' 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` = '16273' 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` = '16270' 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` = '16269' 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` = '16268' ORDER BY `chip_change` DESC, `busted` ASC

0.0082 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '16267' 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` = '16264' 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` = '16263' 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` = '16262' 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` = '16261' 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` = '16260' 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` = '16259' 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` = '16258' 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` = '16257' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0080 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '16248' 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` = '16247' 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` = '16246' 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` = '16245' 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` = '16244' 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` = '16243' 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` = '16239' 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` = '16238' 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` = '16237' 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` = '16236' 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` = '16235' 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` = '16234' 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` = '16233' 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` = '16225' 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` = '16224' 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` = '16223' 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` = '16222' 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` = '16221' 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` = '16220' 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` = '16219' 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` = '16218' 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` = '16217' ORDER BY `chip_change` DESC, `busted` ASC

0.0073 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '16216' 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` = '16215' 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` = '16214' 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` = '16211' 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` = '16210' 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` = '16209' 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` = '16208' 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` = '16205' 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` = '16204' 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` = '16203' 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` = '16202' 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` = '16201' 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` = '16200' 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` = '16197' 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` = '16196' 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` = '16194' 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` = '16193' 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` = '16192' 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` = '16191' 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` = '16190' 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` = '16188' 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` = '16187' 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` = '16186' 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` = '16184' 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` = '16183' 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` = '16182' 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` = '16181' 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` = '16180' 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` = '16179' 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` = '16177' 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` = '16176' 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` = '16175' 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` = '16089' 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` = '16087' 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` = '16083' ORDER BY `chip_change` DESC, `busted` ASC

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

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

English
2024 PPT Series #3 Event #8: $1,100 Main Event ($990 + $110) Live Reporting - Day 2
1 New Update - Click to refresh
Live Updates - Day 2
Ryan Cairns Wins Main Event for $49,000 Posted Monday 29th July, 2024 at 06:09(UTC-7) by Lyle Bateman

The marathon Main Event is now over and Ryan Cairns was the player with all the chips at the end. It was an epic Day 2 that lasted nearly 17 hours with the final table taking up about half of that.

They played down from 48 returning players to the final table in about 7 hours, then took nearly 8 to decide the rest of the spots. They got four-ways by about 10:30 am, then played three more hours before it it was down to three. It then took another 3 hours or so to make to the heads-up portion of the game, and along the way the final three smoothed out the money so that 3rd place finished Gary Rooprai got $42k for second.

Heads up then took about another hour to complete and the final two made another deal that saw the chip leader at the time, Tyler Panas, secure $52,400 while Cairns agreed to take $49k for the shorter stack. Once the deal was made, things moved a bit quicker as Cairns doubled to even shortly after the deal, then found and ace with the best kicker to grab another double into the lead.

In the final confrontation, it came down to suited cards for both players. Panas shoved and Cairns tank-called with . The board missed both players and Cairns' queen-high was best for the win.

This was Cairns fifth win, but was also the biggest score of his career, eclipsing his third-place finish in the Yellowhead Main Event from the 2022 Tournament of Champions where he picked up just shy of $30k. The score tonight should put Cairns at around $240k in total earnings on Hendon mob once it's posted.

Tyler Panas Out in 2nd Place for $52,400 Posted Monday 29th July, 2024 at 05:24(UTC-7) by Lyle Bateman

The marathon final table for the Main Event is now over after Tyler Panas shoved for 2.1 million and Ryan Cairns called it off. Both players were suited, but Cairns had the best of it with against . The board of missed both hands, leaving the queen high to take it down. Panas had secured a $52,400 payout earlier when he had the chip lead, however.

Player Chips Progress
Ryan Cairns 11,400,000 2,700,000
Tyler Panas 0 0
Cairns Doubles to Lead Posted Monday 29th July, 2024 at 05:15(UTC-7) by Lyle Bateman

The final two players evened out the money a bit prior to this hand, and Tyler Panas secured $52,400 while Ryan Cairns agreed to $49k as the short stack. The next hand, Panas shoved and Cairns called off after some thought.

It was ace-three for Panas against ace-seven for Cairns, and the seven played on a board of giving Cairns the double into a big lead.

Player Chips Progress
Ryan Cairns 8,700,000 3,000,000
Tyler Panas 2,700,000 3,000,000
05:08 (UTC-7)
Start of Level 31
Blinds: 100,000/200,000     Ante: 200,000
Cairns Flushes to Even Posted Monday 29th July, 2024 at 04:38(UTC-7) by Lyle Bateman

They are about even now after a big hand that saw Ryan Cairns chip up. I picked up the action on the flop reading and Cairns check-called a bet of 380k from Tyler Panas. Cairns checked called again for 500k on the turn, then led for 1 million on the river. Panas mucked but Cairns showed jack-high clubs for the turned pair and rivered flush.

Player Chips Progress
Ryan Cairns 5,700,000 2,700,000
Tyler Panas 5,700,000 200,000
Gary Rooprai Out in 3rd Place for $42,000 after Deal Posted Monday 29th July, 2024 at 04:23(UTC-7) by Lyle Bateman

Gary Rooprai has been short for a while, and when he found a suited king he got his final 510k into the middle. Tyler Panas called with a better suited king and held to send Rooprai home in 3rd for the adjusted prize of $42,000.

Player Chips Progress
Gary Rooprai 0 0
Deal Time Posted Monday 29th July, 2024 at 04:04(UTC-7) by Lyle Bateman

After 15 hours at the tables today, the final three players have decided to smooth out the money a bit. They didn't ICM chop based on the stacks, but first place will now get $55,000, 2nd $46,400, and 3rd will pocket $42,000.

They now play on to decide the final three spots.

04:02 (UTC-7)
Start of Level 30
Blinds: 80,000/160,000     Ante: 160,000
Cairns Takes One Posted Monday 29th July, 2024 at 03:47(UTC-7) by Lyle Bateman

Tyler Panas raised the button to 320k and Ryan Cairns defended with a call. Cairns check-called for 400k on flop, and they both checked through the turn and river. Cairns showed for top pair and took it down.

Player Chips Progress
Tyler Panas 5,500,000 700,000
Ryan Cairns 3,000,000 400,000
Gary Rooprai 2,900,000 1,100,000
Rooprai to 4 Million Posted Monday 29th July, 2024 at 03:32(UTC-7) by Lyle Bateman

Gary Rooprai is chipping up and is now in second place. He opened to 240k from the button and then called when Tyler Panas min-clicked it back. The flop saw Panas fire 260k and Rooprai called to the turn.

Panas bet 500k, nearly half of Rooprai's remaining chips, but he came over the top with a shove for 1.2m. Panas called it off with aces including the ace of spades, but Rooprai was already there with . That removed a couple of outs from Panas who was looking for a 4th spade that wasn't a jack or a six, but the river bricked and Rooprai's flopped flush held.

Player Chips Progress
Tyler Panas 4,800,000 1,600,000
Gary Rooprai 4,000,000 2,400,000
Ryan Cairns 2,600,000 530,000
Rooprai Doubles Posted Monday 29th July, 2024 at 03:08(UTC-7) by Lyle Bateman

Gary Rooprai was left short before the break, but he just got a double coming back. The money went in on the flop showing and Tyler Panas bet 200k from the small blind. Roopari shoved all in for 770k and after some time in the tank, Panas called it off.

Panas was good with a but he needed to fade spades as Rooprai was on . The river sealed the deal and Rooprai collected the pot after the meaningless river.

Player Chips Progress
Tyler Panas 6,400,000 900,000
Gary Rooprai 1,600,000 830,000
Panas Hits Nut Flush Posted Monday 29th July, 2024 at 02:52(UTC-7) by Lyle Bateman

In the final hand of the previous level, Gary Rroprai raised the button to 200k and Tyler Panas called the big blind. Panas led for 200k on the flop and Rooprai called. Panas fired 280k on the turn and got the call to on the river.

Panas sized up to 600k and Rooprai hit the tank for quite a while before sliding in the call for almost half his stack. Panas showed for the rivered nut flush and Rooprai could only muck.

Player Chips Progress
Tyler Panas 7,300,000 3,950,000
Ryan Cairns 3,130,000 1,670,000
Gary Rooprai 770,000 2,130,000
02:48 (UTC-7)
Start of Level 29
Blinds: 60,000/120,000     Ante: 120,000
Rooprai Tests Panas Posted Monday 29th July, 2024 at 02:27(UTC-7) by Lyle Bateman

Tyler Panas opened big to 360k, and Gary Rooprai hit the tank for a couple of minutes before he finally shoved fro 1.28 million. That sent Panas into the tank for a while as well, but he ultimately mucked showing an ace face up as he did.

Rooprai Three-Bets Posted Monday 29th July, 2024 at 02:08(UTC-7) by Lyle Bateman

Ryan Cairns opened to 200k from the button, but Gary Rooprai came over the top from the big blind to 500k. Cairns tanked for a bit before mucking, and Rooprai rolled over pocket aces.

01:47 (UTC-7)
Start of Level 28
Blinds: 50,000/100,000     Ante: 100,000
Three-Way Chips Posted Monday 29th July, 2024 at 01:32(UTC-7) by Lyle Bateman
Player Chips Progress
Ryan Cairns 4,800,000 200,000
Tyler Panas 3,350,000 260,000
Gary Rooprai 2,900,000 200,000
Zhi Jiang Out iin 4th Place for $21,840 Posted Monday 29th July, 2024 at 01:25(UTC-7) by Lyle Bateman

They are down to three now after Zhi Jiang got his short stack in with ace-jack but ran into aces for Ryan Cairns. An ace came on the turn and that was enough for Cairns to retake the lead.

Player Chips Progress
Ryan Cairns 5,000,000 1,450,000
Zhi Jiang 0 0
Jiang Shoves Big Posted Monday 29th July, 2024 at 01:08(UTC-7) by Lyle Bateman

Gary Rooprai raised to 160k from the button, then hit the tank when Zhi Jiang shoved his big blind for 650k. After about a minute or so, Rooprai folded to chip Jiang back up to about 900k.

Player Chips Progress
Gary Rooprai 2,700,000 870,000
Zhi Jiang 900,000 70,000
00:46 (UTC-7)
Start of Level 27
Blinds: 40,000/80,000     Ante: 80,000
Chips at Break Posted Monday 29th July, 2024 at 00:37(UTC-7) by Lyle Bateman

Gary Rooprai has a slight lead at the break, but its only by 20k over Ryan Cairns. Tyler Panas is a bit behind them with a bit more than 3 million while Zhi Jiang is under a million after a couple fo brutal rivers against Rooprai.

Player Chips Progress
Gary Rooprai 3,570,000 430,000
Ryan Cairns 3,550,000 100,000
Tyler Panas 3,090,000 90,000
Zhi Jiang 970,000 142,000
Running Sixes Boat Up for Rooprai Posted Monday 29th July, 2024 at 00:25(UTC-7) by Lyle Bateman

There was just a massive confrontation between Zhi Jiang and Gary Rooprai. The hand started with Tyler Panas raising under the gun to 170k. He was called by Gary Rooprai on the button and Zhi Jiang in the big blind.

The flop was and it all kicked off. Action checked to Rooprai who fired 300k. Zhi Jiang shoved a covering stack and Rooprai called it off.

Rooprai flopped a set with pocket sevens, but Jiang had the flop stones with . Rooprai was looking for the board to pair, and it did so in an unusual fashion, coming for the running riverboat and a big chip up to the lead.

Player Chips Progress
Gary Rooprai 4,000,000 2,000,000
Ryan Cairns 3,450,000 50,000
Tyler Panas 3,000,000 0
Zhi Jiang 1,112,000 1,288,000
Rooprai Takes it on River Posted Sunday 28th July, 2024 at 23:56(UTC-7) by Lyle Bateman

Zhi Jiang raised to 120k from the button and Gary Rooprai defended his big blind. Rooprai check-called for 90k on the flop and they both checked the turn. Rooprai bet 400k on the river and Jiang mucked his hand.

Player Chips Progress
Zhi Jiang 2,400,000 200,000
Gary Rooprai 2,000,000 100,000
Chips for Level 26 Posted Sunday 28th July, 2024 at 23:38(UTC-7) by Lyle Bateman
Player Chips Progress
Ryan Cairns 3,500,000 500,000
Tyler Panas 3,000,000 600,000
Zhi Jiang 2,600,000 700,000
Gary Rooprai 2,100,000 200,000
23:29 (UTC-7)
Start of Level 26
Blinds: 30,000/60,000     Ante: 60,000
Rooprai Rivers It Posted Sunday 28th July, 2024 at 23:18(UTC-7) by Lyle Bateman

Gary Rooprai opened to 100k under the gun, and Zhi Jiang flatted from the small blind. Ziang check-called for 100k on the flop and they both checked the turn. Jiang checked again on the river but shoved when Rooprai bet 350. 

Rooprai hit the tank for a bit, but finally put in the call, guessing that Jiang had to have gone runner-runner to beat him. It turned out to be set over set as Jiang flopped a set of fives, but Rooprai rivered a set of nines for a big double up.

Player Chips Progress
Zhi Jiang 3,300,000 350,000
Gary Rooprai 2,300,000 1,000,000
Chip Updates Posted Sunday 28th July, 2024 at 22:59(UTC-7) by Lyle Bateman
Player Chips Progress
Ryan Cairns 4,000,000 150,000
Zhi Jiang 3,650,000 770,000
Tyler Panas 2,400,000 0
Gary Rooprai 1,300,000 250,000
Panas Chips Up Posted Sunday 28th July, 2024 at 22:48(UTC-7) by Lyle Bateman

Ryan Cairns raised to 100k from the button and Tyler Panas called from the big blind. The flop was and both players checked to the turn. Panas checked again, then raised Cairns' 80k bet to 200k.

Cairns called to the river and Panas fired 500k. Cairns called but mucked when Panas showed for the flopped straight that improved on the river.

Player Chips Progress
Ryan Cairns 4,150,000 1,300,000
Tyler Panas 2,400,000 730,000
Break Chips Posted Sunday 28th July, 2024 at 22:21(UTC-7) by Lyle Bateman

Ryan Cairns is still the big leader, but Zhi Jiang is chipping up nicely. The average stack for Level 25 will be about 57 big blinds, but Cairns has nearly twice the average while Rooprai and Panas barely have an average stack between them.

Player Chips Progress
Ryan Cairns 5,450,000 790,000
Zhi Jiang 2,880,000 2,225,000
Tyler Panas 1,670,000 480,000
Gary Rooprai 1,550,000 100,000
22:19 (UTC-7)
Start of Level 25
Blinds: 25,000/50,000     Ante: 50,000
Trevor Cameron Out in 5th Place for $16,870 Posted Sunday 28th July, 2024 at 22:12(UTC-7) by Lyle Bateman

In the second of two quick exits following Stephen Dauphinais's 7th place exit, Trevor Cameron ended his run in 5th place for $16,870.

Player Chips Progress
Trevor Cameron 0 0
Ali Khani Out in 6th Place for $13,860 Posted Sunday 28th July, 2024 at 22:10(UTC-7) by Lyle Bateman

I missed the action writing up the Stephen Dauphinais hand, but Ali Khani followed him to the payout desk for 6th place.

Player Chips Progress
Ali Khani 0 0
Stephen Dauphinais Out in 7th Place for $11,560 Posted Sunday 28th July, 2024 at 22:09(UTC-7) by Lyle Bateman

Stephen Dauphinais took the first payout over $10k when he cour-bet shoved his big blind over a raise from Gary Rooprai on the button and a three-bet from Ryan Cairns in the small. Rooprai folded but Cairns snapped it off with pocket tens against for Dauphinais. He turned a seven but it wasn't enough to save him and he hit the rail for 7th place.

Player Chips Progress
Stephen Dauphinais 0 0
Rooprai Doubles Posted Sunday 28th July, 2024 at 21:45(UTC-7) by Lyle Bateman

It was a huge hand when the case king came on the turn. It gave Trevor Cameron two pair with kings and tens, but Rooprai had pocket kings for the set. That gave him a double back to nearly 1.5 million.

Player Chips Progress
Gary Rooprai 1,450,000 700,000
Trevor Cameron 655,000 695,000
Ron Lightning Out in 8th Place for $9,430 Posted Sunday 28th July, 2024 at 21:36(UTC-7) by Lyle Bateman

They are down to 7 now after Ron Lightning lost his short stack fro 8th place today.

Player Chips Progress
Ronald Lightning 0 0
21:18 (UTC-7)
Start of Level 24
Blinds: 20,000/40,000     Ante: 40,000
Panas Doubles with Kings Posted Sunday 28th July, 2024 at 21:15(UTC-7) by Lyle Bateman

I arrived at the table with the hand complete and the dealer counting a double out for Tyler Panas from the stack of Gary Rooprai. Panas was at risk with kings against ace-queen for Rooprai, and the kings held.

Player Chips Progress
Ryan Cairns 4,660,000 1,345,000
Trevor Cameron 1,350,000 185,000
Tyler Panas 1,190,000 200,000
Ali Khani 900,000 120,000
Gary Rooprai 750,000 1,055,000
Stephen Dauphinais 670,000 430,000
Zhi Jiang 655,000 170,000
Ronald Lightning 450,000 225,000
Shane Brotherwood Out in 9th Place for $7,300 Posted Sunday 28th July, 2024 at 21:08(UTC-7) by Lyle Bateman

I missed the action while I was doing the pictures, but Shane Brotherwood hit the rail for 9th place shortly after they sat down at the final table.

Player Chips Progress
Shane Brotherwood 0 0
Final Table Faces Posted Sunday 28th July, 2024 at 21:01(UTC-7) by Lyle Bateman

Sarvesh Pershad Bubbles Final Table Posted Sunday 28th July, 2024 at 20:47(UTC-7) by Lyle Bateman

I missed the action while I was doing some updates on other games, but they are now at the Main Event final table after Sarvesh Pershad hit the cage in 10th place. His chips went to the ever-increasing stack of Ryam Cairns.

I'll grab some FT photos shortly.

Cameron Wheels Over Lumahan's Ladies Posted Sunday 28th July, 2024 at 20:31(UTC-7) by Lyle Bateman

They are down to 10 players left now in the Main Event after a big hand saw Trevor Cameron raise the hijack only to face a shove for 330k from Jayvee Lumahan on the button. Cameron hit the tank for a bit, asking out loud "Should I even be thinking about calling with this?"

He finally tossed in the call and was live with against the pocket queens for Lumahan. Cameron flopped a gutshot and turned the wheel on a board of and Lumahan hit the cage for 11th place.

Jiang Shows Jacks Posted Sunday 28th July, 2024 at 20:20(UTC-7) by Lyle Bateman

Ryan Cairns raised to 60k under the gun. Ali Khani mucked on the button saying "I'm supposed to call, but I'll stay out of your way". Zhi Jiang then bumped it up to 240k from the small blind and Cairns wryly said to Khani "Aren't you glad you stayed out of my way" as he mucked his hand to Jiang's three-bet.

Jiang showed jacks as he collected the pot and Cairns said Jiang would have "dominated him" if he'd called.

Final 11 Back in Action Posted Sunday 28th July, 2024 at 20:14(UTC-7) by Lyle Bateman

Level 23 is now underway with the final 11 Main Event players in action. Blinds are 15k/30k/30k with an average stack of just over 1 million, or about 33 big blinds. Ryan Cairns leads by a mile with Gary Rooprai playing about half as much as him for second.

20:12 (UTC-7)
Start of Level 23
Blinds: 15,000/30,000     Ante: 30,000
Dinner Stacks Posted Sunday 28th July, 2024 at 19:56(UTC-7) by Lyle Bateman

James Werry hit the rail just before dinner to bring the field down to 11 remaining. Below is a look at all the chips for the remaining players, who will be back at the felt in about 15 minutes for Level 23

Player Chips Progress
Ryan Cairns 3,315,000 965,000
Gary Rooprai 1,805,000 510,000
Trevor Cameron 1,165,000 465,000
Tyler Panas 990,000 670,000
Sarvesh Pershad 960,000 510,000
Zhi Jiang 825,000 475,000
Ali Khani 780,000 40,000
Jayvee Lumahan 450,000 250,000
Shane Brotherwood 325,000 115,000
Stephen Dauphinais 240,000 780,000
Ronald Lightning 225,000 155,000
James Werry 0 0
Tran is Done Posted Sunday 28th July, 2024 at 19:28(UTC-7) by Lyle Bateman

Trevor Cameron and Jay Tran were all in with almost exactly the same stack with Cameron holding the best. They were both suited in spades, but Cameron had queen-ten to jack-six for Tran. The board ran clean for the queen-high and Tran was out the next hand

Player Chips Progress
Trevor Cameron 700,000 95,000
Jay Tran 0 0
Four Quick Busts; Cairns Nears 2.5 million Posted Sunday 28th July, 2024 at 19:20(UTC-7) by Lyle Bateman

After about 90 minutes of small-ball action that saw the field stable at 17, they are down to 13 over the span of about 5 minutes. Quentin Siffledeen sent a huge pot to Ryan Cairns before hitting the rail when the case king came in a hand where Siffledeen was on ace-king and Cairns had pocket kings. Peter Griffin followed from the same table as Russ Sluchinski was busting from the other table, then Lin NIu headed to the payout desk for 14th place.

Player Chips Progress
Ryan Cairns 2,350,000 1,550,000
Lina Niu 0 0
Russ Sluchinski 0 0
Peter Griffin 0 0
Quentin Siffledeen 0 0
Jiang Calls Three-Bet Posted Sunday 28th July, 2024 at 19:03(UTC-7) by Lyle Bateman

Zhi Jiang opened early for 50k, and Jay Tran (who won a Main Event on the PPT last year) raised it up to 125k two to his left. Jiang called and they both shut down after that, checking through the board. Jiang showed tens and Tran mucked.

There are about 40 minutes left in Level 22, and the remaining players will get a chance to have some dinner for 30 minutes at the end of this level.

Niu Gets a Double Posted Sunday 28th July, 2024 at 18:55(UTC-7) by Lyle Bateman

Lina Niu has been at risk with her short stack a few times recently and got them through, but she just got a nice double back to over 500k to give her a bit more breathing room. That's still a bit less than the average stack of 665k, but she's playing 20 bigs now at least.

Player Chips Progress
Lina Niu 530,000 410,000
Dauphinais Takes it on the Flop Posted Sunday 28th July, 2024 at 18:50(UTC-7) by Lyle Bateman

Stephen Dauphnais raised to 50k from the cutoff, and Sarvesh Pershad called from the big blind. He checked the flop and mucked when Dauphinais fired 85k.

Player Chips Progress
Stephen Dauphinais 1,020,000 15,000
Sarvesh Pershad 450,000 100,000
18:41 (UTC-7)
Start of Level 22
Blinds: 15,000/25,000     Ante: 25,000
Cameron Outflops Cairns Posted Sunday 28th July, 2024 at 18:22(UTC-7) by Lyle Bateman

Trevor Cameron raised early to 55k, then tank-called when Ryan Cairns raised from his left to 120k. Action slowed down and the players checked through the board, and Cameron's king-queen outflopped the pocket tens for Cairns.

Sluchinski Gets One Through Posted Sunday 28th July, 2024 at 18:06(UTC-7) by Lyle Bateman

Ron Lightning opened to 45k under the gun and Russ Sluchinski shoved for 150k from the middle. Tyler Panas had a long think about calling from the small blind, but ultimately gave it up, as did Lightning.

Player Chips Progress
Ronald Lightning 380,000 185,000
Russ Sluchinski 245,000 5,000
Chips From Break Posted Sunday 28th July, 2024 at 17:44(UTC-7) by Lyle Bateman

Ashkan Razavi hit the cage for 18th place just before the break, so there are 17 players still alive in the Main Event to start Level 21. I grabbed a full set of counts on the break, and Quentin Siffledeen, with almost 1.6 million, has taken the lead from Gary Rooprai, but Rooprai is still sitting pretty with almost 1.3 million

Player Chips Progress
Quentin Siffledeen 1,580,000 110,000
Gary Rooprai 1,295,000 95,000
Stephen Dauphinais 1,005,000 0
Ryan Cairns 800,000 80,000
Ali Khani 740,000 75,000
Jayvee Lumahan 700,000 19,000
Peter Griffin 670,000 225,000
Trevor Cameron 605,000 95,000
Ronald Lightning 565,000 100,000
Sarvesh Pershad 550,000 340,000
Jay Tran 505,000 15,000
Shane Brotherwood 440,000 140,000
James Werry 430,000 190,000
Zhi Jiang 350,000 70,000
Tyler Panas 320,000 20,000
Russ Sluchinski 250,000 20,000
Lina Niu 120,000 140,000
Ashkan Razavi 0 0
17:38 (UTC-7)
Start of Level 21
Blinds: 10,000/20,000     Ante: 20,000
Dauphinais Shoves River; Park Bubbles Final Two Tables Posted Sunday 28th July, 2024 at 17:23(UTC-7) by Lyle Bateman

Stephen Dauphinais raised to 30k under the gun, and he was called by Shane Brotherwood from the small blind and Russ Sluchinski from the big. It checked to Dauohinais on the flop and he fired 30k.

Only Sluchinski called to turn where both players checked to the river. Sluchinski checked again but mucked when Dauphinais shoved a covering stack.

Meanwhile, on another table, Joon Park lost his stack to bubble the final two tables.

Player Chips Progress
Stephen Dauphinais 1,005,000 5,000
Russ Sluchinski 270,000 20,000
Joon Park 0 0
Table 16 Updates Posted Sunday 28th July, 2024 at 17:02(UTC-7) by Lyle Bateman
Player Chips Progress
Stephen Dauphinais 1,000,000 300,000
Ronald Lightning 665,000 95,000
Shane Brotherwood 580,000 286,500
Tyler Panas 300,000 100,000
Russ Sluchinski 290,000 110,000
Ashkan Razavi 290,000 400,000
Sarvesh Pershad 210,000 29,000
More Chip Updates from Table 17 Posted Sunday 28th July, 2024 at 16:57(UTC-7) by Lyle Bateman
Player Chips Progress
Gary Rooprai 1,200,000 150,000
Ryan Cairns 880,000 786,000
Ali Khani 815,000 672,000
Jayvee Lumahan 719,000 520,000
Jay Tran 520,000 110,000
James Werry 240,000 340,000
Park Shoves Big Blind Posted Sunday 28th July, 2024 at 16:53(UTC-7) by Lyle Bateman

Trevor Cameron opened to 36k from the cutoff, and Lina Niu called from the small blind before Joon Park shoved for 216k from the big. He got the shove through for a chip up to over 300k again, and I grabbed the counts from the rest of the table at the same time.

Player Chips Progress
Quentin Siffledeen 1,470,000 575,000
Trevor Cameron 700,000 547,000
Peter Griffin 445,000 226,000
Zhi Jiang 420,000 360,000
Joon Park 326,000 514,000
Lina Niu 260,000 160,000
Bubble to Final Two Tables Posted Sunday 28th July, 2024 at 16:42(UTC-7) by Lyle Bateman

They are down to 19 players left now, with one elimination to fo to the final two tables. Ron Toledo and Mehmet Siginc (who won the PLO Big Bounty earlier in the week) were the most recent exits.

Player Chips Progress
Mehmet Siginc 0 0
Ron Toledo 0 0
Down to 21 to Start Level 20 Posted Sunday 28th July, 2024 at 16:35(UTC-7) by Lyle Bateman

Andrew van Graans was the 22nd place finisher tonight with Level 20 just now underway.

Player Chips Progress
Andrew van Gaans 0 0
16:33 (UTC-7)
Start of Level 20
Blinds: 10,000/15,000     Ante: 15,000
Sluchinski Defends Big Posted Sunday 28th July, 2024 at 16:19(UTC-7) by Lyle Bateman

Tyler Panas opened to 30k from the hijack and Asjkan Razavi called from the button before Russ Sluchinski raised it up to 100k from the big blind. That was enough to earn him the pot. In the next hand on the same table, Andrew van Gaans shoved under the gun and got it through.

Player Chips Progress
Stephen Dauphinais 700,000 549,500
Ashkan Razavi 690,000 70,000
Tyler Panas 400,000 155,000
Russ Sluchinski 400,000 75,000
Andrew van Gaans 150,000 142,500
Jiang Doubles Blind on Blind Posted Sunday 28th July, 2024 at 16:09(UTC-7) by Lyle Bateman

I've finally had a chance to watch some action, and Zhi Jiang just got a nice double through Lina Niu. It was blind on blind when Jiang shoved for about 25k and Niu said "I have to call."

Jiang was best with the suited against for Niu. The board ran clean for the ace-high and Jiang is still alive with about 60k now.

Player Chips Progress
Lina Niu 420,000 80,000
Zhi Jiang 60,000 258,000
Down to 22 Posted Sunday 28th July, 2024 at 15:56(UTC-7) by Lyle Bateman

Bobby Gropp was the most recent exit from the Main to bring them down to 22 players remaining with about 30 minutes to play in Level 19.

Player Chips Progress
Bobbty Gropp 0 0
23 Remain Posted Sunday 28th July, 2024 at 15:43(UTC-7) by Lyle Bateman

They are down to 23 left now with two quick exits right after the break, and the room is likely to get a bit quieter as result. DJ Sharma, whose shouts of "Sharma TIME!" can be heard throughout the room, in addition to his signature laugh, can always be heard whenever he's in action, ended his run in 25th today while Ron Lauzon, who is always one of the friendliest and most talkative players at any table, ended his day in 23rd. Lauzon was also chosen as the staff-selected Player of the Series this time around, a unanimous choice that was met with a healthy round of applause from the entire field when it was announced earlier today, indicating just how well-like Lauzon is in the local community.

Player Chips Progress
DJ Sharma 0 0
Ron Lauzon 0 0
Some Stacks from Break Posted Sunday 28th July, 2024 at 15:33(UTC-7) by Lyle Bateman

I wasn't able to get a complete stack update at the break, but I managed to get a look at a few of the bigger ones out there still. It looks like Gary Rooprai is still the leader, but Quentin Siffledeen is closing in fast with just under 900k. Joon Park has the Hammer as well with about 840k and he and Siffledeen are side-by-side on the same table, so fireworks could ensue at some point, especially blind on blind. Ash Razavi and Ron Lightning are also stacking big with more than 700k each.

Player Chips Progress
Gary Rooprai 1,050,000 19,000
Quentin Siffledeen 895,000 617,500
Joon Park 840,000 176,000
Ashkan Razavi 760,000 411,000
Ronald Lightning 760,000 265,000
Jay Tran 630,000 361,500
James Werry 580,000 346,000
Mehmet Siginc 500,000 144,000
Russ Sluchinski 475,000 36,500
Down to 25 at Break Posted Sunday 28th July, 2024 at 15:19(UTC-7) by Lyle Bateman

25 players went out for the first break of the day today after Clayton Littke, Leo Zhang, and PPT ambassador Haven Taylor were the most recent exits just before they went for the break, with Taylor busting on the final hand of Level 18.

Player Chips Progress
Clayton Littke 0 0
Leo Zhang 0 0
Haven Taylor 0 0
15:17 (UTC-7)
Start of Level 19
Blinds: 6,000/12,000     Ante: 12,000
Three-Table Bubble Posted Sunday 28th July, 2024 at 14:51(UTC-7) by Lyle Bateman

Christopher Lawson was the 29th-place finisher today, bringing the field to 28. I'm still working on backend stuff at my desk, so I've been unable to watch much of the action so far today.

Player Chips Progress
Christopher Lawson 0 0
Nearing Three Tables Posted Sunday 28th July, 2024 at 14:48(UTC-7) by Lyle Bateman

Richard Rex and Dylan Webb were the most recent casualties from the Main Event. They are now down to 29 remaining, 2 off the three-table redraw.

Player Chips Progress
Dylan Webb 0 0
Richard Rex 0 0
Down to 31 Posted Sunday 28th July, 2024 at 14:42(UTC-7) by Lyle Bateman

Pam MacNaughton and Oleksandr Pugach were the most recent exits from the Main Event, bringing the field down to 31 and moving the payouts into the third level for $2,550.

Player Chips Progress
Oleksandr Pugach 0 0
Pam MacNaughton 0 0
Down to 33 to Start Level 18 Posted Sunday 28th July, 2024 at 14:18(UTC-7) by Lyle Bateman

Things are moving so quickly today that I'm having trouble keeping up with the busts. I haven't really had time to watch any action as more players are busting as I am entering the previous info. Most recently, Brett Uhrich, Christopher Lastiwka, and Kris Steinbach all hit the rail. Steinbach is in for his second cash of the tournament as his Day 1a surrendered stack got paid out in 49th place this morning.

Player Chips Progress
Brett Uhrich 49,000 0
Christopher Lastiwka 0 0
Kris Steinbach 0 0
14:15 (UTC-7)
Start of Level 18
Blinds: 5,000/10,000     Ante: 10,000
Four Tables Left Posted Sunday 28th July, 2024 at 14:08(UTC-7) by Lyle Bateman

They are down to 36 players left now on the final four tables of the game.

Player Chips Progress
Brian Anderson 0 0
Kyle Bonazzo 0 0
Jason Law 0 0
Josh Mercredi 0 0
40 Left in Day 2 Posted Sunday 28th July, 2024 at 13:52(UTC-7) by Lyle Bateman

They are moving pretty quickly today. With about 20 minutes to play in Level 17, the field is down to 40 now after Brad German and Joseph Anderson busted recently.

Player Chips Progress
Brad German 0 0
Joseph Anderson 0 0
Dow to 42 Left Posted Sunday 28th July, 2024 at 13:42(UTC-7) by Lyle Bateman

They are down to 42 players left in the Main Event Day 2 now after the recent exits of David Pietrzyowski and Avery Aloneissi.

Player Chips Progress
Avery Aloneissi 0 0
David Pietrzyowski 0 0
Quick Action so Far Posted Sunday 28th July, 2024 at 13:26(UTC-7) by Lyle Bateman

They are down to 44 now with the first table of the day broken. Jeff Forester was the most recent exit in 45th place.

Player Chips Progress
Jeff Forester 0 0
Down to 45 Posted Sunday 28th July, 2024 at 13:22(UTC-7) by Lyle Bateman

They are down to 45 players left now after two quick eliminations for Herbert Zamora in 48th place, Hiro Harada in 47th place, and Tina Nguyen in 46th.

Player Chips Progress
Tina Nguyen 0 0
Hiro Harada 0 0
Herbert Zamora 0 0
13:20 (UTC-7)
Start of Level 17
Blinds: 4,000/8,000     Ante: 8,000
Cards in the Air for Day 2 Posted Sunday 28th July, 2024 at 13:07(UTC-7) by Lyle Bateman

They are about to get underway for Day 2 of the Main. I've clarified what happens with Kris Steinbach's second stack - He gets paid twice today! Steiner has already grabbed the min-cash for today in 49th place and he's still playing his second stack, so he'll have another payout somewhere between 48th and 1st. Gonna make for an interesting submission to Hendon mob lol.

The action is now underway with 5 min remaining in Level 16 with Level 17 about to start for 60 minutes.

Tentative Seat Assignments **DOUBLE CHECK ON DAY 2** Posted Sunday 28th July, 2024 at 04:16(UTC-7) by Lyle Bateman

Tentative Seat Assignments for Day 2

Table Seat Player Chips
17 2 Ali Khani 143,000
15 8 Andrew van Gaans 292,500
16 6 Ashkan Razavi 349,000
15 2 Avery Aloneissi 52,000
14 7 Bobbty Gropp 204,000
13 6 Brad German 94,500
18 2 Brett Uhrich 49,000
16 2 Brian Anderson 176,500
17 1
Christopher Lastiwka
83,000
16 8
Christopher Lawson
162,000
18 3 Clayton Littke 322,500
18 9 David Pietrzyowski 48,000
16 7 DJ Sharma 324,000
14 6 Dylan Webb 103,000
15 9 Gary Rooprai 1,069,000
14 8 Haven Taylor 508,500
17 3 Herbert Zamora 42,000
13 9 Hiro Harada 98,000
15 3 James Werry 234,000
13 2 Jason Law 125,000
17 7 Jay Tran 268,500
17 4 Jayvee Lumahan 144,000
16 4 Jeff Forester 77,500
14 3 Joon Park 664,000
15 7 Joseph Anderson 290,500
13 5 Josh Mercredi 170,000
13 3 Kris Steinbach 152,000
17 6 Kyle Bonazzo 220,000
17 5 Leo Zhang 377,000
13 4 Lina Niu 340,000
13 8 Mehmet Siginc 356,000
15 1 Oleksandr Pugach 188,500
14 9 Pam MacNaughton 200,500
15 5 Peter Griffin 219,000
14 4 Quentin Siffledeen 277,500
14 5 Richard Rex 63,000
16 1 Ron Lauzon 109,000
15 4 Ron Toledo 77,000
15 3 Ronald Lightning 495,000
16 9 Russ Sluchinski 438,500
18 4 Ryan Cairns 94,000
16 5 Sarvesh Pershad 239,000
15 6
Shane Brotherwood
403,000
13 7
Stephen Dauphinais
150,500
17 9 Tina Nguyen 86,000
18 5 Trevor Cameron 153,000
18 8 Tyler Panas 245,000
14 1 Zhi Jiang 318,000
Gary Rooprai Brings 1 Million to Day 2 Posted Sunday 28th July, 2024 at 04:11(UTC-7) by Lyle Bateman

Event: #8 - $1,100 Main Event ($990 + $110)
Date: Day 2, July 28, 1 pm
Blinds: 60 Minutes
Entries: 377
Day 2: 48
Prizes: $354,569 ($66,230 for the Winner)

The Day 2 field is now set with 48 players returning. Technically, there are 49 players returning, but Kris Steinbach bagged stacks on both Day 1a and 1b so only 48 stacks will be in play on Sunday. I'm unsure how Steinbach's surrendered stack will be handled when Day 2 kicks off, but I'll update that tomorrow.

Gary Rooprai will be the big stack to start Day 2 as he bagged more than a million on 1b. Joon "Huge Hammer" Park has the second stack with 664k while PPT ambassador Haven Taylor is 3rd with 508,500. Ron Lightning and Russ Sluchinski round out the top five counts. Full stack details can be found under the Chip Counts tab.

Day 1a was the earliest finisher, so Day 2 will kick off with just over 5 minutes remaining in Level 16 with Level 17 played as a one-hour Day 2 level. This game might finish out on Sunday night, but players should be aware that it could come back for a Day 3 on Monday, depending on how the day plays.

I'll be posting a seat list shortly for Day 2, but there were some anomalies on the sheets I got at the end of the night, so I'm not 100% confident the posted draw will be correct. Players and stacks will be accurate, but the seats may be a bit out of whack, but PPT staff will have the actual seat assignments ready for the start of the day, so players will know where they sit before the game kicks off.


03:58 (UTC-7)
Day 2 of 2024 PPT Series #3 Started
Level: 16     Blinds: 3,000/6,000     Ante: 6,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.