0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0063 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-04-03'
AND `url` = 'https://www.maineventtravel.com/live-reporting/pure-poker-tour-toc-main-event-2023'
ORDER BY `views` DESC

0.0260 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-04-03'
AND `url` = 'https://www.maineventtravel.com/live-reporting/pure-poker-tour-toc-main-event-2023'

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

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

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

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

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

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

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

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

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

0.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.0135 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

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

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

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

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

0.0037 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.0069 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` = 'pure-poker-tour-toc-main-event-2023'

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

0.0536 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0055 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '158'
AND `published` = 1

0.0977 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0050 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '160'
AND `published` = 1

0.0422 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0210 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '162'
AND `published` = 1

0.0051 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '162'

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '52'
AND `name` = '2'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0211 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7032'
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` = '7030'
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` = '7027'
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` = '7026'
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` = '7025'
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` = '7010'
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` = '7009'
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` = '162'
ORDER BY `busted` ASC, `current_chips` DESC

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

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(2)
  • 888poker UK Poker League(5)
  • APAT(12)
  • APPT(3)
  • Aria Resort & Casino(3)
  • Asian Poker Tour(4)
  • Aspers Casino Westfield Stratford City(8)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(1)
  • British Poker Series(8)
  • BSOP(4)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(8)
  • EAPT(2)
  • EPT(4)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(50)
  • Grosvenor UK Poker Open(0)
  • GUKPT Grosvenor(7)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Festival(0)
  • Irish Poker Open(1)
  • Irish Poker Tour(11)
  • King's Resort(0)
  • Kings of Tallinn(0)
  • Kings of Vilnius(0)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(14)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • OlyBet Showdown Vilnius (1)
  • Orleans Summer Open(0)
  • PartyPoker Tour(3)
  • Poker GO Tour(3)
  • Poker Skills Events(1)
  • PokerStars Open(4)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Festival(3)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(2)
  • Unibet DeepStack Open(8)
  • Venetian Deepstack Extravaganza(1)
  • Women's Winter Festival(0)
  • WPT(4)
  • WPT Prime(1)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(4)
  • WSOP International Circuit(3)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(1)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • #FinalTableFreeroll – Viva Las Vegas

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

Tournament of Champions Event #11: $1,650 Main Event Live Reporting - Day 2

Tournament of Champions - Live Reporting

Event #11: $1,650 Main Event See other events

Event #1: $340 Seniors Event Event #2: $560 NLH Bounty Event #3: $340 NLH/PLO Event #4: $220 Team Tournament Event #5: $450 NLH Event #6: $290 NLH Turbo Event #7: $340 NLH Bounty Event #8: $670 NLH 6-Max Event #9: $560 PLO Bounty Event #10: $290 NLH Turbo Event #11: $1,650 Main Event Event #12: $2,500 Super High Roller Event #13 $340 Freezeout

Tournament of Champions - Live Reporting Event #1: $340 Seniors Event Event #2: $560 NLH Bounty Event #3: $340 NLH/PLO Event #4: $220 Team Tournament Event #5: $450 NLH Event #6: $290 NLH Turbo Event #7: $340 NLH Bounty Event #8: $670 NLH 6-Max Event #9: $560 PLO Bounty Event #10: $290 NLH Turbo Event #11: $1,650 Main Event Event #12: $2,500 Super High Roller Event #13 $340 Freezeout

---

Current Level 29 Current Day 2

---

Blinds 60,000/120,000 Ante 120000

Entries 274 Remaining 2

---

Prize Pool (CAD) $CAD387,847 First Prize (CAD) $CAD70,000

Chip Leaders Day 2

1

Matt Jarvis

8,200,000

Day 1A Day 1B Day 2

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 2

Matt Jarvis Wins Main Event after Epic Heads Up Posted Monday 4th December, 2023 at 03:46(UTC-7) by Lyle Bateman

It was a heads-up for the ages that lasted almost four hours with each player having the lead at various points. In part, the length was down to the fact that the average stack to start HU was almost 140 big blinds, but neither player was willing to give an inch.

In the end, Matt Jarvis had to get there from behind to take down Dylan Descheneaux. Both players made excellent bets, calls, and folds through the game, and in the final hand, Descheneaux flopped top pair against a flush draw for Jarvis with and the money went in.

While Jarvis likely expected to get there with his club draw, instead he turned a deuce and rivered a seven to go runner-runner two-pair for the win. Jarvis was certainly dialed in today, but as is the case with tournament poker, he also had a few huge spots go his way, even before the final hand. Early in Day 2, he went runner-runner two-pair against fellow BC grinder and Day 2 chip leader MIke Kim to send him to the rail, then once they got to the final table, he brutally dispatched Tina Nguyen when he got kings in the small blind and she woke up with queens in the big.

That's just tournament poker, however, and Jarvis was on form for the whole game. This was Jarvis' fifth career win, but his first since 2014 when he won the High Roller at WPT Montreal.

Dylan Descheneaux Out in 2nd Place for $55,357 Posted Monday 4th December, 2023 at 02:52(UTC-7) by Lyle Bateman

It was an epic heads-up battle and not just because it was close to four hours long. Both players were dialed in and in the end, it came down to a cooler. Matt Jarvis was on the right end of a few of them tonight, and this was another example. The money went in on the flop showing .

Jarvis was on a flush draw with against top pair for Descheneaux with . "More outs," said Jarvis when the came on the turn to pair him up, and he had the game in hand when the double-paired him on the river.

Player		Chips	Progress
Matt Jarvis		8,200,000	2,900,000
Dylan Descheneaux		0	0

"Really Close" Posted Monday 4th December, 2023 at 02:42(UTC-7) by Lyle Bateman

Matt Jarvis opened to 280k, then hit the tank hard when Dylan Descheneaux shoved for 2.35 million. "It's really close," he muttered as he thought about it for a couple of minutes before mucking to put Descheneaux close to 3 million again.

Player		Chips	Progress
Matt Jarvis		5,300,000	900,000
Dylan Descheneaux		2,900,000	900,000

Descheneaux Claws Some Back Posted Monday 4th December, 2023 at 02:33(UTC-7) by Lyle Bateman

While the average stack now is about 34 bigs, Dylan Descheneaux has less than 20 now, but he just got some back. He called a bet of 250k from Matt Jarvis, then check-called for 180k on the flop. He jammed the turn and forced a fold from Jarvis. Jarvis still has the big stack though.

Player		Chips	Progress
Matt Jarvis		6,200,000	300,000
Dylan Descheneaux		2,000,000	275,000

02:26 (UTC-7)

Start of Level 29
Blinds: 60,000/120,000     Ante: 120,000

Jarvis Leads at Break Posted Monday 4th December, 2023 at 02:16(UTC-7) by Lyle Bateman

It's been an epic heads-up battle tonight with more than three hours in the books now. They are just on a break with Matt Jarvis in the big lead, but Dylan Descheneaux isn't going gently and they are still 35 big blinds on average when they return from the break so there's still some play in this.

Player		Chips	Progress
Matt Jarvis		6,500,000	1,600,000
Dylan Descheneaux		1,725,000	1,575,000

Descheneaux Takes it on the Flop Posted Monday 4th December, 2023 at 01:54(UTC-7) by Lyle Bateman

The flop read and after a check from Matt Jarvis, Dylan Descheneaux bet 480k into a pot of almost 700k and took it down. He is now chipping back up and has more than 3 million but still trails Jarvis.

Player		Chips	Progress
Matt Jarvis		4,900,000	1,600,000
Dylan Descheneaux		3,300,000	1,600,000

01:40 (UTC-7)

Start of Level 28
Blinds: 50,000/100,000     Ante: 100,000

Jarvis Has Nuts Posted Monday 4th December, 2023 at 01:40(UTC-7) by Lyle Bateman

The turn was out on a wet board of and Dylan Descheneaux check-called a bet of 350k. The river brought in the backdoor diamonds and Descheneaux checked again.

Matt Jarvis slid out a bet of 540k and Descheneaux called pretty quickly. "Nuts," said Jarvis, showing the as Descheneaux mucked his hand.

Player		Chips	Progress
Matt Jarvis		6,500,000	600,000
Dylan Descheneaux		1,700,000	600,000

Beer Level Posted Monday 4th December, 2023 at 01:33(UTC-7) by Lyle Bateman

They are playing for a lot of money heads up, but with last call just announced, the two players decided on a beer level. The battle continues, but now with beer.

Jarvis Four Bet Shoves on Descheneaux Posted Monday 4th December, 2023 at 01:28(UTC-7) by Lyle Bateman

No cards were shown, but it looks like there was almost a huge showdown. Dylan Descheneaux limped, then three-bet after Matt Jarvis raised to 640k. Jarvis shoved and Descheneaux let out an audible groan, tanked for a bit, then elected to let go of his hand.

Player		Chips	Progress
Matt Jarvis		5,900,000	700,000
Dylan Descheneaux		2,300,000	700,000

Heads Up Warriors Posted Monday 4th December, 2023 at 01:21(UTC-7) by Lyle Bateman

Player		Chips	Progress
Matt Jarvis		5,200,000	100,000
Dylan Descheneaux		3,000,000	100,000

01:10 (UTC-7)

Start of Level 27
Blinds: 40,000/80,000     Ante: 80,000

Jarvis Pulling Ahead Posted Monday 4th December, 2023 at 01:06(UTC-7) by Lyle Bateman

Matt Jarvis looks to have more almost 5.5 million now with Dylan Descheneaux under 3 million, but the battle continues.

Player		Chips	Progress
Matt Jarvis		5,300,000	900,000
Dylan Descheneaux		2,900,000	900,000

Jarvis to the Lead Again Posted Monday 4th December, 2023 at 00:55(UTC-7) by Lyle Bateman

Matt Jarvis just took the lead again in a hand where he rivered the nut flush, but Dylan Descheneaux managed to get out of it without too much damage. Descheneaux opened to 130k, then called when Jarvis bumped it up to 460k.

Both players checked through the flop and turn, and Jarvis again checked the river. Descheneaux elected not to fire at it and checked it back with Jarvis showing for the rivered nuts.

Player		Chips	Progress
Matt Jarvis		4,400,000	500,000
Dylan Descheneaux		3,800,000	500,000

00:42 (UTC-7)

Start of Level 26
Blinds: 30,000/60,000     Ante: 60,000

Still close to Even Posted Monday 4th December, 2023 at 00:42(UTC-7) by Lyle Bateman

Dylan Descheneaux has pulled back into a slight lead now, but Matt Jarvis is clawing it back whenever he does. In the most recent hand, Descheneaux limped, then called when Jarvis made it 175k. Jarvis led for 190k on the flop and Descheneaux called.

The turn was checked around, but Jarvis fired big for 510k on the river and Descheneaux let it go.

Player		Chips	Progress
Dylan Descheneaux		4,300,000	200,000
Matt Jarvis		3,900,000	200,000

Even Stacks Posted Monday 4th December, 2023 at 00:22(UTC-7) by Lyle Bateman

They are basically dead-even now after a hand where Matt Jarvis check-raised a flop from 60k to 190k. Dylan Descheneaux called the flop but then folded to the bet of 375k on the very bricky looking turn

Player		Chips	Progress
Matt Jarvis		4,100,000	750,000
Dylan Descheneaux		4,100,000	770,000

Back at the Felt Posted Monday 4th December, 2023 at 00:14(UTC-7) by Lyle Bateman

They are back at the felt now for Level 25.

Break Time Posted Sunday 3rd December, 2023 at 23:59(UTC-7) by Lyle Bateman

Players are on a break and will return to play in about 10 minutes. Dylan Descheneaux has a lead of about 1.5 million now and when they return for Level 25 they'll finally be less than 100 big blinds deep.

Player		Chips	Progress
Dylan Descheneaux		4,870,000	730,000
Matt Jarvis		3,350,000	750,000

23:57 (UTC-7)

Start of Level 25
Blinds: 25,000/50,000     Ante: 50,000

Descheneaux Rivers the Straight Posted Sunday 3rd December, 2023 at 23:48(UTC-7) by Lyle Bateman

Matt Jarvis raised to 90k, then called when Dylan Descheneaux reraised it to 290k. Jarvis called to see on the flop.

Desceheneaux check-called for 330k on the turn, and he checked again on the river. Jarvis thought for a  bit, then checked saying "I'm not going to go for thin value." His check proved prescient as Descheneaux showed for the rivered straight.

Player		Chips	Progress
Dylan Descheneaux		5,600,000	600,000
Matt Jarvis		2,600,000	600,000

Descheneaux Turns It Posted Sunday 3rd December, 2023 at 23:34(UTC-7) by Lyle Bateman

The flop was already out reading and Dylan Descheneaux check-called a bet of 55k. He opted to lead for 60k on the turn and Jarvis called to the river.

Descheneau slid out a bet of 130k and Jarvis didn't take long to call. Descheneaux had ace-queen for turned top pair and Jarvis said "Nice hand" as he mucked his cards.

Player		Chips	Progress
Dylan Descheneaux		5,000,000	500,000
Matt Jarvis		3,200,000	500,000

23:31 (UTC-7)

Start of Level 24
Blinds: 20,000/40,000     Ante: 40,000

Smoothing Out the Numbers Posted Sunday 3rd December, 2023 at 23:24(UTC-7) by Lyle Bateman

The final two players just paused the clock for a few minutes to chat about the money. In the end, they didn't make much of a change, but 1st place will now get $70k even, down from $73,497 while second place will get that much added to the total for a modified prize of $55,357.

Heads Up for the Hardware Posted Sunday 3rd December, 2023 at 23:19(UTC-7) by Lyle Bateman

Matt Jarvis and Dylan Descheneaux Heads Up for the Hardware

Descheneaux to the Lead Posted Sunday 3rd December, 2023 at 23:10(UTC-7) by Lyle Bateman

Matt Jarvis opened to 65k then called when Dylan Descheneaux raised to 190k. Descheneaux fired 125k on the flop and 420k on the turn. Jarvis called both times, then hit the tank hard when Descheneaux slid out 950k on the river.

Jarvis thought for quite a while before he slid his cards to the dealer. "I'll show one time," said Descheneaux, rolling over for king-high.

"Nice bet," said Jarvis. With the game now heads up, the blinds have dropped to 30 minutes in length.

Player		Chips	Progress
Dylan Descheneaux		4,500,000	800,000
Matt Jarvis		3,700,000	800,000

Jarvis Ahead, but Not By Much Posted Sunday 3rd December, 2023 at 22:56(UTC-7) by Lyle Bateman

Matt Jarvis is playing about 4.5 million to 3.7 million for Dylan Descheneaux. They are almost 140 big blinds average right now, but given the way the coolers and beats have been coming tonight, it doesn't seem that unlikely for it to get in.

Player		Chips	Progress
Matt Jarvis		4,500,000	560,000
Dylan Descheneaux		3,700,000	2,050,000

Colten Yamagishi Out in 3rd Place for $34,580 Posted Sunday 3rd December, 2023 at 22:49(UTC-7) by Lyle Bateman

It's heads up now in the Main Event and it's been a night of coolers with Matt Jarvis on the top end of a few tonight. In the latest example, Colten Yamagishi woke up with ace-jack on the button and ran into Jarvis' aces. The aces held and Yamagishi had to settle for 3rd.

Player		Chips	Progress
Colten Yamagishi		0	0

Back in Action Posted Sunday 3rd December, 2023 at 22:23(UTC-7) by Lyle Bateman

The final three players are back in action now for Level 23 with blinds at 15k/30k/30k.

22:23 (UTC-7)

Start of Level 23
Blinds: 15,000/30,000     Ante: 30,000

Yamagishi Kicks Wasylenko Out in 4th Place for $24,900 Posted Sunday 3rd December, 2023 at 22:14(UTC-7) by Lyle Bateman

Colten Yamagishi opened under the gun to 50k before Eric Wasylenko three-bet the small blind to 175k. Yamagishi called to a flop of . Wasy bet 100k and Yamagish flatted to the turn.

Wasylenko fired another bet of 200k and again Yamagishi made the call. Both players checked the on the river and Yamagishi's ace-queen just out-kicked the ace-jack for Wasy. Wasylenko won the Player of the Series this time around on the back of his wins in both Event #2 and #5, and he made a very solid run at going three-for-three in multi-day games in this series.

That left Wasy short and he hit the rail on the following hand for 4th place. The final three players are on what may well be the final break of the game, however they are remarkably deep at the moment with the average stack at more than 90 bigs.

Player		Chips	Progress
Matt Jarvis		3,940,000	40,000
Colten Yamagishi		1,650,000	560,000
Dylan Descheneaux		1,650,000	100,000
Eric Wasylenko		0	0

Tina Nguyen Coolered in 5th Place for $19,470 Posted Sunday 3rd December, 2023 at 21:55(UTC-7) by Lyle Bateman

Matt Jarvis has been on the right end of a couple of sick hands today, and he's now playing around half the chips in play. Earlier in the night he sent fellow West Coaster Mike Kim to the rail when he ran out to two pair with queen-jack to crush Kim's kings.

He just woke up with kings in the small blind with Tina Nguyen finding queens in her big. The kings held for a massive cooler in the blinds, and Jarvis is playing almost 4 million of the 8.2 million in play.

Player		Chips	Progress
Matt Jarvis		3,900,000	1,000,000
Tina Nguyen		0	0

"I got it" Posted Sunday 3rd December, 2023 at 21:35(UTC-7) by Lyle Bateman

Colten Yamagishi raised to 50k from the cutoff and Matt Jarvis called from the button along with Tina Nguyen from the small blind. She led for 75k on the flop and only Yamagishi made the call.

Nguyen checked the turn, and Yamagishi bet 115k. Nguyen went into the tank for a bit and Yamagishi said "I got it." It took her a few more seconds to fold her ace-nine of clubs face up, and Yamagishi showed pocket tens as he collected the pot.

Jarvis to Lead Posted Sunday 3rd December, 2023 at 21:23(UTC-7) by Lyle Bateman

Matt Jarvis is in the lead now after a big hand with Eric Wasylenko and Dylan Descheneaux. I arrived at the table with action on the turn and the board showing . They check it around to the river where Jarvis put in a bet of 135k, Both players called him, but they both mucked when he showed king-jack for turned top pair.

Player		Chips	Progress
Matt Jarvis		2,900,000	1,100,000
Eric Wasylenko		1,800,000	100,000
Dylan Descheneaux		1,550,000	550,000
Tina Nguyen		1,150,000	50,000
Colten Yamagishi		815,000	275,000

Kris Steinbach Out in 6th Place for $16,170 Posted Sunday 3rd December, 2023 at 21:17(UTC-7) by Lyle Bateman

They are down to 5 remaining now after Kris Steinbach hit the rail for 6th place money worth $16,170.

Player		Chips	Progress
Kris Steinbach		0	0

Main Event Could Finish Tonight Posted Sunday 3rd December, 2023 at 21:15(UTC-7) by Lyle Bateman

Normally, the final table of the Main EVent plays out on Monday but since this year's event got to the FT so quickly today they decided to keep playing. With just 6 players left now, it's at least possible the game will end tonight, though the players will still have the option of calling it a night and coming back to finish it tomorrow.

For now, they play on, but it's an open question how much later they'll play today and whether there will be Main Event action tomorrow or not.

21:08 (UTC-7)

Start of Level 22
Blinds: 15,000/25,000     Ante: 25,000

Descheneaux Leads Six-Ways Posted Sunday 3rd December, 2023 at 21:08(UTC-7) by Lyle Bateman

With play now six-handed, Dylan Descheneaux has taken the lead with more than 2 million chips while Matt Jarvis and Eric Wasylenko are in second and third with 1.8m and 1.7m respectively.

Player		Chips	Progress
Dylan Descheneaux		2,100,000	1,190,000
Matt Jarvis		1,800,000	585,000
Eric Wasylenko		1,700,000	60,000
Tina Nguyen		1,100,000	750,000
Colten Yamagishi		1,090,000	62,000
Kris Steinbach		350,000	90,000

Daniel Lefebvre Out in 7th Place for $13,650 Posted Sunday 3rd December, 2023 at 21:00(UTC-7) by Lyle Bateman

There are just 6 players left on the final table now after Daniel Lefebvre hit the rail in 7th place. To no one's surprise, the winner of the last two High Rollers here on the PPT immediately jumped over to the Super High Roller to see if he can't go three-for-three.

Ambrose Ng Out in 8th Place for $11,320 Posted Sunday 3rd December, 2023 at 20:49(UTC-7) by Lyle Bateman

They are down to 7 players left now on the Main Event final table after Ambrose Ng hit the rail in 8th place for $11,320. I missed the action as I was getting the final table pictures sorted out.

Player		Chips	Progress
Ambrose NG		0	0
Mike Baldwin		0	0

Final Table Faces Posted Sunday 3rd December, 2023 at 20:47(UTC-7) by Lyle Bateman

Tina Nguyen

Eric Wasylenko

Kris Steinbach

Matt Jarvis

Dylan Descheneaux

Daniel Lefebvre

Colten Yamagishi

Ambrose Ng

Mike Baldwin

Mike Baldwin Out in 9th Place for $9,000 Posted Sunday 3rd December, 2023 at 20:40(UTC-7) by Lyle Bateman

They are down to 8 players left now on the final table and everyone remaining is now guaranteed a five-figure payout. Mike Baldwin was the player to just miss out on five figures when his day ended in 9th place for $9,000.

Cody McKay Bubbles the Final Table Posted Sunday 3rd December, 2023 at 20:20(UTC-7) by Lyle Bateman

They are down to 9 players left on the final table now after Cody McKay hit the rail in 10th place. Eric Wasylenko is still in the lead with Matt Jarvis in 2nd place. See below for a look at the cashing players to date.

FInal Table Bubble Posted Sunday 3rd December, 2023 at 20:08(UTC-7) by Lyle Bateman

Ian Alvarado just hit the rail in 11th place to bring the field down to 10 left on the bubble to the final table. He had the short stack coming back from break and couldn't find the double.

Wasy Leads Posted Sunday 3rd December, 2023 at 20:06(UTC-7) by Lyle Bateman

Multi-day wizard Eric Wasylenko is the chip leader after the break with 11 players left. Below is a look at the final 11 stacks from break with Matt Jarvis and Colten Yamagishi also playing more than 1 million.

Player		Chips	Progress
Eric Wasylenko		1,760,000	260,000
Matt Jarvis		1,215,000	15,000
Colten Yamagishi		1,152,000	701,000
Dylan Descheneaux		910,000	430,000
Daniel Lefebvre		705,000	305,000
Ambrose NG		555,000	45,000
Cody Mckay		460,000	138,000
Mike Baldwin		460,000	105,000
Kris Steinbach		440,000	75,000
Tina Nguyen		350,000	170,000
Ian Alvarado		140,000	120,000

20:05 (UTC-7)

Start of Level 21
Blinds: 10,000/20,000     Ante: 20,000

Action on Two Tables Posted Sunday 3rd December, 2023 at 19:42(UTC-7) by Lyle Bateman

In the first hand, Matt Jarvis raised to 32k under the gun and got a call from Ambrose Ng in the big blind. Both players checked the flop but when Ng checked the turn, Jarvis bet 42k and got the fold.

On the other table, there was a four-club, paired, wheel board out and Kris Steinbach was facing a bet of 130k from Eric Wasylenko. After some time in the tank he made the call, but mucked when Wasy showed the for the nut flush.

Meanwhile, Brant Taylor hit the rail in 12th place shortly after.

Player		Chips	Progress
Eric Wasylenko		1,500,000	800,000
Matt Jarvis		1,230,000	115,000
Ambrose NG		600,000	345,000
Kris Steinbach		515,000	125,000
Brant Taylor		0	0

Second Langevin Brother Hits the Rail along with Bash Ramahi Posted Sunday 3rd December, 2023 at 19:18(UTC-7) by Lyle Bateman

They are down to 12 left now after Robert Langevin joined his brother Pierre on the rail and Bash Ramahi lost his stack shortly after. Robert managed to ladder up once over Pierre, while Ramahi's chips ended up in the stack of Eric Wasylenko.

Player		Chips	Progress
Eric Wasylenko		700,000	205,000
Bash Ramahi		0	0
Robert Langevin		0	0

Down to 14 Posted Sunday 3rd December, 2023 at 19:12(UTC-7) by Lyle Bateman

There are just 14 players left in the Main Event now after Nu Teliani hit the rail in 15th place for the first payout of $6,670.

Player		Chips	Progress
Nohad Teliani		0	0

Down to 15 Posted Sunday 3rd December, 2023 at 18:50(UTC-7) by Lyle Bateman

There are just 15 players left in the Main Event now to start Level 20. Ryan Cairns was the most recent bust to bring the game to 15 left.

Player		Chips	Progress
Ryan Cairns		0	0

18:49 (UTC-7)

Start of Level 20
Blinds: 10,000/15,000     Ante: 15,000

Ramahi Doubles through Steinbach Posted Sunday 3rd December, 2023 at 18:25(UTC-7) by Lyle Bateman

It was blind-on-blind when the money went in between Kris Steinbach (sb) and Bash Ramahi (bb). It was roughly a coin flip with Ramahi on ace-ten against king-jack for Steiner. The ace held on a board that missed them both and Ramahi chipped up to 300k.

Player		Chips	Progress
Kris Steinbach		640,000	265,000
Bash Ramahi		300,000	94,000

Down to 16 Left Posted Sunday 3rd December, 2023 at 18:17(UTC-7) by Lyle Bateman

Jayvee Lumahan was the most recent exit from the final two tables to bring the game down to 16 left. The average stack at the moment is about 40 big blinds.

Main Event Payouts to 17th Place

Twins Finally Split Posted Sunday 3rd December, 2023 at 18:09(UTC-7) by Lyle Bateman

Pierre and Robert Langevin were sitting together for basically the whole day. When the third table broke, they both got moved to Table 2, though they were no longer side-by-side. However, Pierre is now on the rail after exiting in 18th place. but brother Robert is still in the mix.

Player		Chips	Progress
Pierre Langevin		0	0

Down to Final Two Tables Posted Sunday 3rd December, 2023 at 17:53(UTC-7) by Lyle Bateman

Krzysztof Slaski was the bubble to the final two tables shortly after they came back from the break. Below is a look at the stacks collected during the break with what should be updates for all stacks now.

Player		Chips	Progress
Matt Jarvis		1,345,000	45,000
Kris Steinbach		905,000	495,000
Eric Wasylenko		905,000	165,000
Mike Baldwin		565,000	342,000
Tina Nguyen		520,000	120,000
Dylan Descheneaux		480,000	80,000
Colten Yamagishi		451,000	385,500
Robert Langevin		440,000	0
Daniel Lefebvre		400,000	50,000
Cody Mckay		322,000	243,000
Brant Taylor		265,000	12,000
Ian Alvarado		260,000	25,000
Ambrose NG		255,000	12,500
Nohad Teliani		220,000	75,000
Bash Ramahi		206,000	37,000
Pierre Langvuin		160,000	140,000
Ryan Cairns		150,000	89,000
Jayvee Lumahan		100,000	180,000
Krzysztof Slaski		0	0
Jason Pelletier		0	0

17:52 (UTC-7)

Start of Level 19
Blinds: 6,000/12,000     Ante: 12,000

Down to 20; Jarvis to the Lead Posted Sunday 3rd December, 2023 at 17:24(UTC-7) by Lyle Bateman

Darcy VanWachem and Mike Kim just hit the rail to bring the field down to 20, and Kim went out brutally to November Niner Matt Jarvis. Kim was in great shape for a huge double to over 1 million with kings over queen-jack for Jarvis, but Jarvis ran out to twp pair with a queen and a jack on board to send the start-of-day leader to the rail in perhaps the sickest pot of the day so far.

Player		Chips	Progress
Matt Jarvis		1,300,000	600,000
Mike Kim		0	0
Darcy VanWachem		0	0

Busted Before the Money Posted Sunday 3rd December, 2023 at 17:18(UTC-7) by Lyle Bateman

Player		Chips	Progress
Terry Berlingoette		0	0
Dean May		0	0
Michael Malm		0	0
Talal Shoush		0	0
Brady O'Hara		0	0
Sharmark Mohamed		0	0
Rob Limpert		0	0
Saroar Parvez		0	0
Graham Lupton		0	0
Denis Halvadzija		0	0
George Broumas		0	0

Busted Players in the Money Posted Sunday 3rd December, 2023 at 17:13(UTC-7) by Lyle Bateman

Player		Chips	Progress
Deven Lane		0	0
Benny Sarnelli		0	0
Pui Lun Lau		0	0
Jason Tran		0	0
Weston Pring		0	0
Shawn Taghavi		0	0
Kyle Ho		0	0
Derek Letourneau		0	0
Robert Lothian		0	0
Taran Parmar		0	0
Stephen Green		0	0
Keith Schultz		0	0

Jarvis Takes a Big One Posted Sunday 3rd December, 2023 at 17:10(UTC-7) by Lyle Bateman

I arrived at the action on the river with the board reading and big blind Ian Alvarado was facing a shove from Matt Jarvis after a bet of 60k. There was a pretty big pot already in the middle, and Alvarado tanked for more than a minute before finally giving up his hand to send a big pot to Jarvis without a showdown.

Meanwhile, on another table, Francis Fan hit the rail in 23rd place.

Player		Chips	Progress
Matt Jarvis		700,000	270,000
Ian Alvarado		285,000	315,000
Francis Fan		0	0

More Stack Updates Posted Sunday 3rd December, 2023 at 17:02(UTC-7) by Lyle Bateman

There are still 23 players left in the game with about 30 minutes to go until the next break.

Player		Chips	Progress
Tina Nguyen		640,000	40,000
Ian Alvarado		600,000	294,500
Dylan Descheneaux		560,000	486,000
Mike Kim		530,000	170,000
Daniel Lefebvre		450,000	317,000
Robert Langevin		440,000	202,000
Matt Jarvis		430,000	130,000
Pierre Langvuin		300,000	98,500

23 Players Left to Start Level 18 Posted Sunday 3rd December, 2023 at 16:35(UTC-7) by Lyle Bateman

Level 18 has just begun and the field is down to 23 players left now. Deven Lane from Regina hit the rail shortly before Level 17 ended for 24th place and the first payout of $4,650.

16:34 (UTC-7)

Start of Level 18
Blinds: 5,000/10,000     Ante: 10,000

$4,220 Payouts Complete Posted Sunday 3rd December, 2023 at 16:26(UTC-7) by Lyle Bateman

They are down to 24 players left in the Main Event now with just over 10 minutes to play in Level 17. Stephen Green was the most recent exit in 25th place for the final payout of $4,220. The next player out can expect to pocket $4,650.

Results for First Two Payout Levels from the Main Event

Some Big Stack Updates Posted Sunday 3rd December, 2023 at 16:13(UTC-7) by Lyle Bateman

It looks like multi-day crusher Eric Wasylenko could be on his way to winning his third multi-day event at this series. He has chipped up considerably since the start of the day and now looks to be the chip leader with more than 700k. Tina Nguyen just grabbed a double to about 600k when her kings held against the flopped flush draw for Ambrose Ng for a big double, while Matt Jarvis has chipped up to about 560k for the third-place stack right now.

Player		Chips	Progress
Eric Wasylenko		740,000	527,500
Tina Nguyen		600,000	526,000
Matt Jarvis		560,000	198,000
Kris Steinbach		410,000	109,000
Mike Kim		360,000	210,000

Twins Stay Together Posted Sunday 3rd December, 2023 at 16:04(UTC-7) by Lyle Bateman

They switched positions after the redraw and moved to a new table, but the Langevin twins still somehow managed to get seated next to each other again after the redraw. They are on Table 3 now in seats 2 and 3, but this time, Robert has position on Pierre.

25 Players Left Posted Sunday 3rd December, 2023 at 16:01(UTC-7) by Lyle Bateman

Taran Parmar just hit the rail in 26th place for the second payout of $4,220. There is one more payout for that amount before it jumps to $4,650 at 24th place.

26 Left after Redraw Posted Sunday 3rd December, 2023 at 15:49(UTC-7) by Lyle Bateman

It turns out Rob Lothian also busted just before the three-table redraw taking the first payout at $4,220 to bring the game down to 26 now.

Down to 27 Left Posted Sunday 3rd December, 2023 at 15:43(UTC-7) by Lyle Bateman

There were four quick exits to start Level 17 to bring the field down to 27 and the three-table redraw. Westin Pring, Shawn Taghavi, Kyle Ho, and Derek Leterneau were the players to fill out the $3,790 pay level and the next player out jumps to $4,220.

15:26 (UTC-7)

Start of Level 17
Blinds: 4,000/8,000     Ante: 8,000

No Repeat Winner Posted Sunday 3rd December, 2023 at 15:19(UTC-7) by Lyle Bateman

Jason Tran won this Main Event in the last Yellowhead series in September this year, and he bagged a Day 2 stack in this one as well. However, we won't be seeing him go back-to-back at Yellowhead as he just hit the rail in 32nd spot in the final hand before the break on Table 1.

Jason Tran, Winner of the Main Event from PPT #4 in September

First Break of the Day Posted Sunday 3rd December, 2023 at 15:12(UTC-7) by Lyle Bateman

The Main Event players are on their first break of Day 2 now with 32 players left in the action. They'll be back at the felt in a bit more than 10 minutes for Level 17 with blinds at 4k/8k/8k.

Just under 15 Minutes to First Break of Day 2 Posted Sunday 3rd December, 2023 at 14:57(UTC-7) by Lyle Bateman

They are down to 33 players left now with about 15 minutes to play in Level 16. They'll go for the first break of the day at the end of this level. Benny Sarnelli was the most recent exit from the Main in 34th place.

Twins in the Money Posted Sunday 3rd December, 2023 at 14:47(UTC-7) by Lyle Bateman

There's a bit of an unusual situation on Table 2 at the moment. Twin brothers Robert and Pierre Langevin are seated next to each other in seats 7 and 8. Both of them are now in the money, but blind-on-blind confrontations on that table could have family implications down the road.

Keith Shultz First Out in the Money Posted Sunday 3rd December, 2023 at 14:42(UTC-7) by Lyle Bateman

They are down to 34 players left in the game now after Keith Shultz was the first player to collect cash from the Main Event with a 35th-place finish for $3,790. That's payout for all places to 28th place and it jumps to $4,220 at 27th.

Fan Puts Kim to Test Posted Sunday 3rd December, 2023 at 14:38(UTC-7) by Lyle Bateman

MIke Kim hasn't had a great first few levels today after starting the day as the chip leader. He is down to about 150k now with just over 30 minutes to go in Level 16 and a recent hand against Francis Fan took some of it.

I arrived at the action on the turn with the board reading and Fan was all in with the big stack, putting Kim to the test for his tournament life. He found the muck, but his stack is quite a bit shorter than when the day began.

Player		Chips	Progress
Francis Fan		500,000	199,500
Mike Kim		150,000	406,000

14:10 (UTC-7)

Start of Level 16
Blinds: 3,000/6,000     Ante: 6,000

LImpert Bubbles the Money in Brutal Cooler Posted Sunday 3rd December, 2023 at 14:03(UTC-7) by Lyle Bateman

Brant Taylor opened the cutoff to 15k before Rob Limpter three-bet the small blind to 45k. Taylor hit the tank for a bit and counted out his stack, electing to flat call to the flop. Limpert checked, Talyor shoved, and Limpert nearly beat him into the pot with the snap-call.

Rob Limpert:
Brant Taylor:

It was a massive cooler that likely was seeing the money in the middle no matter how it played with both players flopping a set. Limpert couldn't find his case jack for the win and hit the rail on the stone bubble today while the remaining 35 players are now in the money today.

Ramahi's Aces Hold On the Soft Bubble Posted Sunday 3rd December, 2023 at 13:50(UTC-7) by Lyle Bateman

Bash Ramahi and Brady O'hara were all in at risk against the start-of-day leader Mike Kim. O'hara was on a suited ace against pocket sevens for Kim and the Rockets for Ramahi. The board ran clean for the aces which sent O'hara to the rail on the soft bubble and gave Ramahi a chip.

Ramahi was on his feet with his coat on as the board ran out. "How do I hold there?" Ramahi joked as he sat back down and collected the pot.

Nearing the Money Posted Sunday 3rd December, 2023 at 13:37(UTC-7) by Lyle Bateman

There are just over 20 minutes left in the opening level of Day 2 and the field is down to 37 left, two off the money. They'll break down to four tables and go hand-for-hand to the money after the next elimination.

Down to 44 Posted Sunday 3rd December, 2023 at 13:17(UTC-7) by Lyle Bateman

Six tables didn't last long today as they'd broken down to the final five tables within the first few hands of the day. Dean May and Denis Halvadzija were the first two exits outside the money today to bring the field to 44 now.

Day 2 of the Main is Underway! Posted Sunday 3rd December, 2023 at 13:03(UTC-7) by Lyle Bateman

They are in action for Day 2 of the Main Event now with Level 15 just started. The Final Table for this event usually plays out on Monday, and that's still a distinct possibility, but play will continue today for at least as long as the Super High Roller plays (so, about midnight) so there's a distinct possibility they could finish it all out in the Main Event today without needing Monday action.

Follow the action here through the day to find out how deep they make it.

13:00 (UTC-7)

Start of Level 15
Blinds: 2,500/5,000     Ante: 5,000

Mike Kim Leads the Way into Day 2 of the Main Event Posted Sunday 3rd December, 2023 at 01:27(UTC-7) by Lyle Bateman

Day 2 of the Main Event is now set with 46 players returning to the action. They are only playing for 35 paid spots, however, so there is still work to do for returning players.

Mike Kim is in the best position to make a deep run with a monster lead over the rest of the field. He bagged more than 550k on Day 1a, miles ahead of his closest competitor, WPT Global Canada Ambassador, November Niner, Bracelet winner, and fellow grinder from the West Coast, Matt Jarvis.

Jarvis bagged 362k on Day 1a, and Ian Alvarado (1a), Kris Steinbach (1b leader), and Francis Fan (1b) all managed to bag more than 300k to round out the top 5 stacks for Day 2.

Day 2 action kicks off at 1 pm so players are asked to be in the room by 12:45 so the bags can be opened and play started on time. As both Day 1 flights went the distance, they'll kick off Day 2 with the start of Level 15 and 60-minute levels. See below for a look at the Day 2 players sorted three ways, as well as a text table for seat assignments by table & seat.

Day 2 Players by Stack

Day 2 Players by Name

Day 2 Players by Seat

Payouts for the Tournament of Champions Main Event

Table	Seat	Player	Hometown	Chips
1	1	Ambrose Ng	Edmonton	267,500
1	2	Jayvee Lumahan	Edmonton	280,000
1	4	Francis Fan	Edmonton	300,500
1	5	Brady O'Hara	Edmonton	84,000
1	6	Bash Ramahi	Edmonton	169,000
1	7	Mike Kim	New Westminister	556,000
1	8	Graham Lupton	Ontario	47,500
1	9	Kris Steinbach	Sherwood Park	301,000
2	1	George Broumas	Edmonton	207,500
2	2	Rob Limpert	Grand Prairie	66,000
2	4	Matt Jarvis	White Rock	362,000
2	5	Talal Shoush	Edmonton	84,500
2	6	Darcy VanWachem	Edmonton	112,000
2	7	Robert Langevin	St Paul	238,000
2	8	Pierre Langvuin		201,500
2	9	Brant Taylor	Delta, BC	253,000
3	1	Taran Parmar	Edmonton	180,000
3	2	Michael Malm	Calgary	102,000
3	3	Ryan Cairns	Edmonton	61,000
3	4	Kyle Ho	Coquitlam	268,000
3	5	Weston Pring	Calgary	141,000
3	6	Daniel Lefebvre	Saskatoon	133,000
3	7	Terry Berlingoette		32,500
3	8	Robert Lothian	Sherwood Park	171,500
4	1	Sharmark Mohamed	Edmonton	83,000
4	2	Tina Nguyen	Edmonton	74,000
4	4	Stephen Green	Fort Mcmurray	153,500
4	5	Deven Lane	Regina	198,000
4	6	Benny Sarnelli	Edmonton	190,000
4	7	Keith Schultz	Prince George, BC	237,000
4	8	Derek Letourneau	Calgary	263,000
4	9	Krzysztof Slaski	Edmonton	138,000
5	2	Dean May	Fort St John	165,000
5	3	Saroar Parvez	Edmonton	64,500
5	4	Shawn Taghavi	Edmonton	265,000
5	5	Eric Wasylenko	Winnipeg	212,500
5	6	Jason Tran	Edmonton	146,500
5	8	Mike Baldwin	Calgary	223,000
5	9	Nohad Teliani	Edmonton	295,000
6	1	Pui Lun Lau	BC	144,500
6	2	Dylan Descheneaux	Grand Prairie	74,000
6	3	Ian Alvarado	Edmonton	305,500
6	4	Jason Pelletier	Edmonton	206,000
6	5	Colten Yamagishi	Edmonton	65,500
6	6	Denis Halvadzija	Edmonton	39,500
6	9	Cody Mckay	Edmonton	79,000

01:10 (UTC-7)

Day 2 of Tournament of Champions Started
Level: 14     Blinds: 2,000/4,000     Ante: 4,000

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter