0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0071 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-13'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-wsop-cal-aug-e9'
ORDER BY `views` DESC

0.0170 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-13'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-wsop-cal-aug-e9'

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

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

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

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

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

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

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

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

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

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

0.0002 SECONDS: 
SELECT *
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.0002 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0005 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.0002 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.0410 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.0008 SECONDS: 
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024-wsop-cal-aug-e9'

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '179'

0.0414 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0093 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '391'
AND `published` = 1

0.0503 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0059 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '393'
AND `published` = 1

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

0.0056 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '394'

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

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

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

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

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

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

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

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

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

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

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

0.0070 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16990'
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` = '16989'
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` = '16988'
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` = '16987'
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` = '16986'
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` = '16985'
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` = '16984'
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` = '16983'
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` = '16982'
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` = '16981'
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` = '16980'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0122 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16979'
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` = '16977'
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` = '16976'
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` = '16975'
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` = '16974'
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` = '16973'
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` = '16972'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0344 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16961'
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` = '16960'
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` = '16959'
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` = '16958'
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` = '16957'
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` = '16956'
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` = '16955'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

0.0088 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16989'
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` = '16988'
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` = '16987'
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` = '16986'
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` = '16985'
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` = '16984'
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` = '16983'
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` = '16982'
ORDER BY `chip_change` DESC, `busted` ASC

0.0282 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16981'
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` = '16980'
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` = '16978'
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` = '16979'
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` = '16977'
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` = '16976'
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` = '16975'
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` = '16974'
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` = '16973'
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` = '16972'
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` = '16969'
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` = '16968'
ORDER BY `chip_change` DESC, `busted` ASC

0.0077 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16967'
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` = '16966'
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` = '16965'
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` = '16964'
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` = '16963'
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` = '16962'
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` = '16961'
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` = '16960'
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` = '16959'
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` = '16958'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0109 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16949'
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` = '16948'
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` = '16947'
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` = '16946'
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` = '16945'
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` = '16944'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0168 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16937'
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` = '16936'
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` = '16935'
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` = '394'
ORDER BY `busted` ASC, `current_chips` DESC

0.0230 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2554

    

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(1)
  • 888poker UK Poker League(0)
  • APAT(3)
  • APPT(1)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(1)
  • Aspers Casino Westfield Stratford City(3)
  • Battle Of Malta(0)
  • Borgata Poker(1)
  • Bratislava Poker Festival(0)
  • British Poker Series(5)
  • BSOP(1)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(6)
  • EAPT(3)
  • EPT(1)
  • Estrellas Poker Tour(0)
  • Eureka Poker Tour(1)
  • France Poker Series(0)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(10)
  • Grosvenor UK Poker Open(0)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(1)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(8)
  • Kings of Tallinn(0)
  • Kings of Vilnius(1)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(13)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • RDS (Royal Dublin Society)(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Casino at Portomaso(1)
  • The Festival(1)
  • The Poker Room(0)
  • Triton Super High Roller Series(1)
  • UK Poker Championships(1)
  • UKIPT(1)
  • Unibet DeepStack Open(3)
  • Venetian Deepstack Extravaganza(3)
  • Women's Winter Festival(1)
  • WPT(5)
  • WPT Prime(2)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(17)
  • WSOP International Circuit(4)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(0)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• 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 FTF

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

Deerfoot Inn and Casino Event #9: $400 Monster Stack NLH ($330 + $70) Live Reporting - Day 2

Deerfoot Inn and Casino - Live Reporting

Event #9: $400 Monster Stack NLH ($330 + $70) See other events

Event #1: $400 Big 30 Stack ($330 + $70) Event #2:$600 NLH/PLO Mixed ($515 + $85) Event #3: $400 4-Flight ($330 + $70) Event #4: $600 Mystery Bounty ($515 + $85) Event #5: $400 Seniors ($330 + $70) Event #7: $1,000 Two-Day $1k ($875 + $125) Event #8: $500 Progressive Knockout ($420 + $80) Event #9: $400 Monster Stack NLH ($330 + $70) Event #10: $1,000 1k Turbo ($875 + $125) Event #11: $1,700 Main Event ($1,515 + $185) Event #12: $250 Flip & Go ($210 + $40) Event #13: $400 PLO Bounty ($330 + $70) Event #14: $400 Ladies ($330 + $70) Event #16: $250 Big 30 Stack ($200 + $50) Event #15: $2,200 High Roller ($1,965 + $235) Event #6: $400 Black Chip Bounty ($330 + $70)

Deerfoot Inn and Casino - Live Reporting Event #1: $400 Big 30 Stack ($330 + $70) Event #2:$600 NLH/PLO Mixed ($515 + $85) Event #3: $400 4-Flight ($330 + $70) Event #4: $600 Mystery Bounty ($515 + $85) Event #5: $400 Seniors ($330 + $70) Event #7: $1,000 Two-Day $1k ($875 + $125) Event #8: $500 Progressive Knockout ($420 + $80) Event #9: $400 Monster Stack NLH ($330 + $70) Event #10: $1,000 1k Turbo ($875 + $125) Event #11: $1,700 Main Event ($1,515 + $185) Event #12: $250 Flip & Go ($210 + $40) Event #13: $400 PLO Bounty ($330 + $70) Event #14: $400 Ladies ($330 + $70) Event #16: $250 Big 30 Stack ($200 + $50) Event #15: $2,200 High Roller ($1,965 + $235) Event #6: $400 Black Chip Bounty ($330 + $70)

---

Current Level 33 Current Day 2

---

Blinds 200,000/400,000 Ante 400000

Entries 881 Remaining 1

---

Prize Pool (CAD) $290,730 First Prize (CAD) $45,940

Chip Leaders Day 2

1	Zhi Gang Yang		17,700,000
2	Derek Holme		5,000,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

George Yang Slays the Monster for First Ring and $45,940 Posted Thursday 15th August, 2024 at 21:09(UTC-8) by Lyle Bateman

The Monster has been slain and Zhi Gang George Yang is the player standing atop the body. He had the big chip lead coming into the endgame, taking over from previous table captain and eventual runner-up Michael Baldwin with play four-handed. Baldwin was still in second at the point, just a few million behind Yang.

Derek Holme and Jack DIck were both lagging behind the big stacks and when Holme hit the cage in 4th place Dick was well behind in third place. Baldwin then seemed to hit a wall. He doubled up Dick twice to put Dick into a slight lead for second, but shortly after the second double, Dick sent all those chips to Yang in a blind-on-blind confrontation that saw Yang's ace-king hold over ace-nine for Dick. Yang shoved the huge stack from the small and Dick called off from the big with the dominated ace and couldn't get there.

That gave Yang a massive lead going into heads up, with about 3.5 times the chips of Baldwin. The two-handed stage didn't last long before Yang flopped a pair of nines and held to take it down over the queen-eight flopped gutshot for Baldwin. Baldwin bricked his gutshot and Yang's nine held to take down the game.

Yang has only been playing live poker for about 3 years now, with his first recorded cash in 2021. This is his first live win, but he's been close a bunch of times with more than $350k in cashes and multiple final table finishes over the past couple of years. He's been running particularly well here at Deerfoot with three final tables at Deerfoot as well as several other cashes.

This looks to be his third or fourth-best score once the exchange is done, and it will unquestionably be his best Canadian score. His previous best here in Canada was just shy of $25k for 4th place in the Nov 2022 Fall Super Stack Main Event.

Michael Baldwin Out in 2nd Place for $30,626 Posted Thursday 15th August, 2024 at 20:07(UTC-8) by Lyle Bateman

It was a quick heads-up. George Yang got to the final stage with a huge lead after sending Jack Dick to the rail in 3rd place, and just a couple of hands into heads-up play, Yang flopped a nine with nine-three and held against the queen-eight for Baldwin.

Player		Chips	Progress
Michael Baldwin		0	0

Jack Dick Out in 3rd Place for $21,035 Posted Thursday 15th August, 2024 at 20:04(UTC-8) by Lyle Bateman

Jack Dick was working on building a stack, but it all came crashing down with a dominated ace. George Yang shoved the small blind and Dick called from the big. It was ace-king of clubs for Yang against ace-nine of diamonds for Dick and the big slick held for the win.

Player		Chips	Progress
Jack Dick		0	0

19:52 (UTC-8)

Start of Level 33
Blinds: 200,000/400,000     Ante: 400,000

Dick Doubles Again to Second Posted Thursday 15th August, 2024 at 19:39(UTC-8) by Lyle Bateman

Jack Dick has just jumped into second place with close to 9 million now after winning a race against Michael Baldwin. Baldwin raised the button to 600k, then snapped it off when Dick shoved the big blind. DIck had tens against ace-queen for Baldwin, and the overcards bricked for DIck to double once again.

Player		Chips	Progress
Jack Dick		9,000,000	5,500,000
Michael Baldwin		8,500,000	5,500,000

Dick Doubles Posted Thursday 15th August, 2024 at 19:33(UTC-8) by Lyle Bateman

Michael Baldwin opened the button to 600k and Jack Dick called from the big blind. It all kicked off on the flop when DIck shoved and Bladwin snapped it off. Dick flopped open-ended with nine-seven and was drawing live to crack the aces of Baldwin.

Dick's straight came in on the turn and the river was never changing anything so DIck got the double.

Chip Updates Posted Thursday 15th August, 2024 at 19:22(UTC-8) by Lyle Bateman

Zhi Gang Yang, who also goes by George, is the leader now with 17.7 million while Michael Baldwin has about 4 million less. Jack DIck is the short stack on about 3.5 million.

Player		Chips	Progress
Zhi Gang Yang		17,700,000	9,525,000
Michael Baldwin		14,000,000	1,000,000
Jack Dick		3,500,000	375,000

19:09 (UTC-8)

Start of Level 32
Blinds: 150,000/300,000     Ante: 300,000

Derek Holme Out in 4th Place for $14,775 Posted Thursday 15th August, 2024 at 19:06(UTC-8) by Lyle Bateman

They are down to three left now after Derek Holme hit the rail in 4th place tonight. George Yang and Michael Baldwin are the big stacks with Jack Dick lagging behind in third.

Mike St. Pierre-Porter Out in 5th Place for $10,619 Posted Thursday 15th August, 2024 at 18:41(UTC-8) by Lyle Bateman

There are just four players left in the Monster Stack now after Mike St. Pierre- Porter ran into it. He was in the big blind when he called a button raise from George Yang, and then check-called for 400k on the flop.

He checked again on the turn, then shoved over the bet of 1.8 million from Yang. Yang snapped it off with pocket nines for the turned set, and the irrelevant river sent St. Pierre-Porter's jack-eight to the muck and him to the cash cage.

Player		Chips	Progress
Mike St. Pierre-Porter		0	0

Holme Takes First Hand After Dinner Posted Thursday 15th August, 2024 at 18:15(UTC-8) by Lyle Bateman

Michael Baldwin raised under the gun to 500k and Derek Holme called the button. They both checked the flop and Baldwin bet 600k on the turn. Holme called and they went back to checking on the river.

"Ace-king" said Baldwin before mucking when Holme showed ace-deuce for the flopped pair.

Dinner Chips Posted Thursday 15th August, 2024 at 18:08(UTC-8) by Lyle Bateman

Player		Chips	Progress
Michael Baldwin		13,000,000	5,000,000
Zhi Gang Yang		8,175,000	4,485,000
Mike St. Pierre-Porter		5,200,000	0
Derek Holme		5,000,000	585,000
Jack Dick		3,875,000	1,325,000

18:06 (UTC-8)

Start of Level 31
Blinds: 150,000/250,000     Ante: 250,000

Yang Gets River Value Posted Thursday 15th August, 2024 at 17:26(UTC-8) by Lyle Bateman

Jack Dick raised the button to 400k and George Yang called to see on the flop. Yang check-called for 225k and they both checked the turn. Yang fired out a 500k plaque on the river and Dick called after a few seconds, mucking his hand when Yang showed ace-nine for flopped top pair and two pair on the river.

The dinner break has now begun.

Dick Doubles Posted Thursday 15th August, 2024 at 17:19(UTC-8) by Lyle Bateman

Derek Holme opened to 400k from the cutoff and Mike St. Pierre-Porter raised the button to 1 million. Jack Dick shoved for 2.35 million from the small blind to push Holme out, but St. Pierre-Porter tank-called with more.

He was in brought shape with king-queen against ace-queen for Dick. Dick held for the double to about 5.2 million, which is about what St. Pierre-Porter ended up with after paying him off. They have a dinner break scheduled following this level, and I'll update the exact counts for everyone left at that point.

Player		Chips	Progress
Jack Dick		5,200,000	4,225,000
Mike St. Pierre-Porter		5,200,000	2,850,000

Barry Dubnyk Out in 6th Place for $7,814 Posted Thursday 15th August, 2024 at 17:03(UTC-8) by Lyle Bateman

They are down to 5 remaining now after Barry Dubnyk finally lost his stack. He's been short-stacking his way to ladders for the past couple of hours with a few small doubles along the way. He had "live cards" with queen-ten when he shoved 760k and Michael Baldwin called him off with king-four. Baldwin flopped a four to take a bigger lead, and Dubnyk bricked the rest of the board.

Player		Chips	Progress
Barry Dubnyk		0	0

Zoran Pribilovic Out in 7th Place for $5,890 Posted Thursday 15th August, 2024 at 16:54(UTC-8) by Lyle Bateman

Zoran Pribilovic's double up didn't last long. I missed the action, but he followed Josh Myers to the cash cage today for 7th place.

Player		Chips	Progress
Zoran Pribilovic		0	0

Josh Myers Out in 8th Place for $4,550 Posted Thursday 15th August, 2024 at 16:53(UTC-8) by Lyle Bateman

Josh Myers hit the cage for 8th place shortly after he doubled up Zoran Pribilovic.

Player		Chips	Progress
Josh Myers		0	0

Pribilovic Doubles Posted Thursday 15th August, 2024 at 16:45(UTC-8) by Lyle Bateman

Josh Myers raised  from the cutoff to 850k and Zoran Pribilovic shoved the button for 1.315 million. Derek Holme tanked for a bit before he gave up his small, but Myers snap-called. "I'd bet my house on this hand," he said as he showed . Pribilovic was on jacks though, and though Myers flopped a gutshot and turned double-gutty, he ultimately just paired his 5 on the river and Pribilovic took down the pot.

Player		Chips	Progress
Zoran Pribilovic		3,100,000	380,000
Josh Myers		1,650,000	880,000

16:36 (UTC-8)

Start of Level 30
Blinds: 100,000/200,000     Ante: 200,000

Myers Gets it Through Posted Thursday 15th August, 2024 at 16:36(UTC-8) by Lyle Bateman

Josh Myers just picked up some dead money after Derek Holme opened to 300k and was called by Michael Baldwin on the button and George Yang in the small blind. Myers was in the big and he shoved for 2.205 million. There was some tanking from all three players, but ultimately they all gave up their 300k and Myers raked in the uncontested pot.

Final Table Faces Posted Thursday 15th August, 2024 at 16:24(UTC-8) by Lyle Bateman

There are 8 players left now after Jason Vickers just hit the rail in a bog three-way hand. Vickers was all in with the middle stack and ace-ten against shorty Barry Dubnyk with eights and big stack Derek Holme with sevens. The eights held for Dubnyk to triple to just shy of 2 million while Holme picked up the rest of Vicker's chips from the side pot.

Here's a look at the final ten players tonight in the Monster.

Player		Chips	Progress
Barry Dubnyk		1,900,000	330,000
Jason Vickers		0	0

16:00 (UTC-8)

Start of Level 29
Blinds: 100,000/150,000     Ante: 150,000

Final Table Posted Thursday 15th August, 2024 at 15:58(UTC-8) by Lyle Bateman

They are at the 10-handed final table now after Mei Yun Ge ended her day in 11th place. She lost a big hand just before she busted when her trips were crushed by Michale Baldwin's boat.

Meanwhile, in early FT action, George Yang doubled up with eights against ace-king and Abe Shawile hit the rail in 10th place after his sixes couldn't beat pocket kings.

Player		Chips	Progress
Abe Shawile		0	0
Mei Yun Ge		0	0

Flopped Cooler Chips Up Baldwin Posted Thursday 15th August, 2024 at 15:37(UTC-8) by Lyle Bateman

The flop was out reading and both players checked it to the turn. Mei Ge bet 530k, then called when Michael Baldwin raised to 1.1 million. The river was the and Ge check-called for 2.5 million to find herself on the wrong end of a flopped cooler. Baldwin showed the rockets for the flopped boat while she tabled for the flopped trips. "I don't know how to fold trip jacks" she said as the pot was sent to Baldwin.

Player		Chips	Progress
Michael Baldwin		8,000,000	3,295,000
Mei Yun Ge		2,300,000	3,700,000

Sachin Sehgal Out in 12th Place Posted Thursday 15th August, 2024 at 15:28(UTC-8) by Lyle Bateman

They are on the final table bubble now with 11 players left and WSOP final tables always 10-handed. Sachin Sehgal just hit the rail in 12th place for $2,449 and the next two busts are set to pocket $2,932.

Player		Chips	Progress
Sachin Sehgal		0	0

Ge Chips Up on River Posted Thursday 15th August, 2024 at 15:20(UTC-8) by Lyle Bateman

The action was on the turn with the board reading and Mike St. Pierre-Porter was facing a check-raise from Mei Yun Ge. He'd bet 550k after her check, and she made it 1.3 million.

St. Pierre-porter called to the river, but then mucked when Ge shoved.

Player		Chips	Progress
Mei Yun Ge		6,000,000	1,900,000
Mike St. Pierre-Porter		2,350,000	1,235,000

Down to 12 Posted Thursday 15th August, 2024 at 15:13(UTC-8) by Lyle Bateman

There are 12 players remaining now after Kendrick Arason and Andrew Neels hit the rail shortly after they returned from the break.

Player		Chips	Progress
Andrew Neels		0	0
Kendrick Arason		0	0

Full Stacks from Break Posted Thursday 15th August, 2024 at 15:03(UTC-8) by Lyle Bateman

Player		Chips	Progress
Kendrick Arason		5,750,000	4,505,000
Michael Baldwin		4,705,000	2,305,000
Derek Holme		4,415,000	3,295,000
Mei Yun Ge		4,100,000	3,485,000
Zhi Gang Yang		3,690,000	2,690,000
Mike St. Pierre-Porter		3,585,000	1,885,000
Zoran Pribilovic		3,480,000	2,675,000
Abe Shawile		2,800,000	1,100,000
Barry Dubnyk		1,570,000	465,000
Andrew Neels		1,405,000	1,995,000
Jason Vickers		1,390,000	460,000
Sachin Sehgal		1,180,000	80,000
Jack Dick		975,000	105,000
Josh Myers		770,000	185,000

14:59 (UTC-8)

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

14 Remain Posted Thursday 15th August, 2024 at 14:44(UTC-8) by Lyle Bateman

There are about 5 minutes to play until the break with 14 players left after Justin Meng hit the rail in 15th place today. He got $2,102 and there is one more payout at that level before the jump to $2,449 at 13th place. I'll grab full chips for the remaining players at the break.

Player		Chips	Progress
Qingwei Meng		0	0

Down to 15 Posted Thursday 15th August, 2024 at 14:34(UTC-8) by Lyle Bateman

Vancouver's Anthony Smith was 16th place tonight, bringing the field to 15 remaining.

Player		Chips	Progress
Anthony Smith		0	0

Down to 16 Posted Thursday 15th August, 2024 at 14:32(UTC-8) by Lyle Bateman

Chi 'Anthony' Chan was the 17th place finisher tonight for the first cash of $2,102.

Player		Chips	Progress
Chi Kit Chan		0	0

Down to 17 Posted Thursday 15th August, 2024 at 14:22(UTC-8) by Lyle Bateman

Steve Desjarlais was the first player off the final two tables tonight and he took the final payout of $1,855. The next player to bust gets the jump to $2,102.

Player		Chips	Progress
Steve Desjarlais		0	0

Final Two Tables Posted Thursday 15th August, 2024 at 14:20(UTC-8) by Lyle Bateman

Here is a look at the players still battling at the final two tables today. I don't have full counts at the moment, but Andrew Neels is sitting on about 3.4 million for what looks like the lead now, but Anthony Snith and Mike St. Pierre-Porter still have stacks in front of them as well.

T	S	Player	Hometown
22	1	Derek Holme	Calgary, AB
22	2	Anthony Smith	Vancouver, BC
22	3	Zhi Gang 'George' Yang	Richmond, BC
22	4	Kendrick Arason	Kelowna, BC
22	5	Zoran Pribilovic	Burnaby, BC
22	6	Jason Vickers	Stoney Creek, BC
22	7	Josh Myers	Edmonton, AB
22	8	Barry Dubnyk	Lethbridge, AB
22	9	Jack Dick	Calgary, AB
30	1	Abe Shawile	Edmonton, AB
30	2	Sachin Sehgal	Calgary, AB
30	3	Steve Desjarlais	Nanaimo, BC
30	4	Andrew Neels	Innisfail, AB
30	5	Mei Yun 'Dain' Ge	Vancouver, BC
30	6	Mike St. Pierre-Porter	Kamloops, BC
30	7	Michael Baldwin	Calgary, AB
30	8	Chi Kit 'Anthony' Chan	Kamloops, BC
30	9	Qingwei Meng	Calgary, AB

Player		Chips	Progress
Andrew Neels		3,400,000	1,965,000

To-Table Redraw Posted Thursday 15th August, 2024 at 14:07(UTC-8) by Lyle Bateman

They are down to 18 left now after Michael Lloyd bubbled the final two tables today. The remaining players will take a 15-minute break following this level.

Player		Chips	Progress
Michael Lloyd		0	0

13:59 (UTC-8)

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

Sam Raz Out in 20th Place Posted Thursday 15th August, 2024 at 13:59(UTC-8) by Lyle Bateman

Sam Raz was expecting to be the bubble boy to Day 2 last night, and said so loudly to the room several times as 1b wound down. He managed to find a double late in the night and survive to Day 2 with a bit more than 200k, but his run came to an end in 20th today for $1,855. 

Player		Chips	Progress
Sam Raz		0	0

20 Remaining Posted Thursday 15th August, 2024 at 13:55(UTC-8) by Lyle Bateman

They are down to 20 players left now with about 5 minutes to play in Level 26. Aleksei Ponomarev was the 21st-place finisher today for $1,855. They are now two eliminations away from the two-table redraw.

Player		Chips	Progress
Aleksei Ponomarev		0	0

Smith Sends Dunn to Exit for Big Chip Up Posted Thursday 15th August, 2024 at 13:50(UTC-8) by Lyle Bateman

Anthony Smith is on the rise and looks to be one of the leaders right now. He has about 2.8 million in front of him after his jacks held against the sizes of Darren Dunn. Dunn raised the middle, then called off with less when Smith shoved the small blind. The board missed both players to send Dunn home in 22nd place.

Player		Chips	Progress
Anthony SMith		2,800,000	2,300,000
Darren Dunn		0	0

Down to 22 Posted Thursday 15th August, 2024 at 13:38(UTC-8) by Lyle Bateman

Day 2 chip leader Mark Mendoza was among the players to hit the rail recently. He was out in 23rd place shortly after John Ertner, whose name I misspelled as "Estner".

Player		Chips	Progress
Mark Mendoza		0	0
John Ertner		0	0

24 Players Remain Posted Thursday 15th August, 2024 at 13:32(UTC-8) by Lyle Bateman

They are down to 24 players left now after Regan Duong and Luigi Sili took the final two min-cash payouts today while Zhi Jiang managed to ladder to the 26th from his 40k start today. Henry Menard was 25th.

Player		Chips	Progress
Zhi Jiang		0	0
Henry Menard		0	0
Regan Duong		0	0
Luigi Sili		0	0

Down to 28 Posted Thursday 15th August, 2024 at 13:12(UTC-8) by Lyle Bateman

They are down to 28 players left now to start Level 26 after Robert Cicchelli ended his run in 30th and Lapchi Duong followed him to the payout desk shortly after for 29th place.

Player		Chips	Progress
Lapchi Duong		0	0
Robert Cicchelli		0	0

13:09 (UTC-8)

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

"Bubble Boy" Has More than 2 Mil Posted Thursday 15th August, 2024 at 13:04(UTC-8) by Lyle Bateman

Sam Raz was short last night on the 1b end-of-night bubble, and on a couple of occasions he loudly proclaimed "Bubble Boy All In!" when he put his short stack in. He managed to survive the end-of-day bubble for 1b and came to today's final with 260k.

He's doing a bit better than that now with one of the biggest stacks in the game after getting a double through Lapshi Duong, Action was on the flop reading and Duong had a bet of 375k in front of him but was facing a shove from Raz for about 900k. After some tank-time, Duong put in the call with ace-jack overs against pocket eights for Raz. The turn and river bricked for Duong and Raz was up to about 2.2 million while Duong is down to about 850k.

Player		Chips	Progress
Sam Raz		2,200,000	1,940,000
Lapchi Duong		850,000	1,150,000

30 Remain Posted Thursday 15th August, 2024 at 12:53(UTC-8) by Lyle Bateman

They are down to 30 now after Jerry Nelner hit the rail in 31st place. There are four more payouts at $1,767 today before it jumps to $1,855 at 26th place.

Player		Chips	Progress
Jerry Nelner		0	0

More Chips and Action Posted Thursday 15th August, 2024 at 12:45(UTC-8) by Lyle Bateman

Michael St. Pierre-Porter just sent Tedde Ballanger to the rail when Ballanger shoved ace-deuce and St. Pierre-Porter called with pocket sevens. Ballanger turned his ace and but St. Pierre-Porter was on a club draw with the as part of his pair. He called for the club, but the dealer replied with a  7 instead for the same result.

Cindy Grabia, who made a big fold on the Day 2 bubble last night to preserve a stack of more than 700k for today, followed Ballanger to the cash cage in the next hand.

Player		Chips	Progress
Lapchi Duong		2,000,000	995,000
Abe Shawile		1,700,000	1,070,000
Mike St. Pierre-Porter		1,700,000	740,000
Qingwei Meng		1,100,000	105,000
Zhi Gang Yang		1,000,000	300,000
Regan Duong		550,000	780,000
Anthony SMith		500,000	85,000
Steve Desjarlais		400,000	200,000
Cindy Grabia		0	0
Tedde Ballanger		0	0

A Couple of Stacks Posted Thursday 15th August, 2024 at 12:25(UTC-8) by Lyle Bateman

I don't have eyes on all the stacks yet -- I'll try to get a complete update as the next few levels play out, but two stacks were of particular interest. Michael Baldwin now looks to be the chip leader with a bit more than 2.4 million, and Zhi Jiang is on-pace for a huge comeback. He started the day with just a start stack after a brutal beat near the end of Day 2, but he's chipped up from 40k to start the day up to about 430k now.

The final 33 players are now back at the felt for the first 45-minute level in the Day 2 structure.

Player		Chips	Progress
Michael Baldwin		2,400,000	1,285,000
Zhi Jiang		430,000	390,000

12:20 (UTC-8)

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

33 Remain Posted Thursday 15th August, 2024 at 12:09(UTC-8) by Lyle Bateman

There are about 5 minutes to play in Level 24, and they'll be moving to the 45-minute Day 2 levels for the start of Level 25. Brian "BA" Anderson was the most recent casualty today to leave 33 players competing for the top prize now.

Player		Chips	Progress
Cache Paylor		1,035,000	0
Brian 'BA' Anderson		0	0
Alison Senycz		0	0
Dwight Czyz		0	0
Ryan Callahan		0	0
Cody Goulet		0	0
Matthew Clark		0	0
Leo Zhang		0	0
Ron Schindelheim		0	0
Kyle Cook		0	0
Brian 'BA' Anderson		0	0

A Look at the Day 2 Field Posted Thursday 15th August, 2024 at 12:01(UTC-8) by Lyle Bateman

I did a quick video on the start of Day 2 of the Monster Stack today -- check it out below to have a quick look at some of the returning players.

Down to 34 Posted Thursday 15th August, 2024 at 11:55(UTC-8) by Lyle Bateman

Leo Zhang was among the recent players to hit the rail today. I caught him as he was leaving the room and he explained that he found a suited king on the button and shoved for 8 bigs, looking for some fold equity to pick up blinds and antes. He got a call from the big stack on the big blind with ace-six and the ace got there to knock him out.

36 Players Reman Posted Thursday 15th August, 2024 at 11:39(UTC-8) by Lyle Bateman

They are down to the final four tables now as Level 24 begins today. Prizes to 39th place are loaded into the backend and I'll grab the rest of the payouts shortly.

11:06 (UTC-8)

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

Prize Pool Updated in Backend Posted Thursday 15th August, 2024 at 11:06(UTC-8) by Lyle Bateman

I went to bed last night without uploading the Day 2 prizes into the backend, but they are there now. Monika Hagele was the first person to exit today. "I lasted 2 minutes," she said with a smile as she came up to get her pay slip authorized. "Ace-queen into ace-king." Yep, poker's happening today :).

Cards Are in the Air for day 2 of the Monster Posted Thursday 15th August, 2024 at 11:01(UTC-8) by Lyle Bateman

The clock is now running on Day 2 of the Monster Stack with 45 players returning to fight for the top prize of $45,940.

8:38 to Play in Level 22 Posted Thursday 15th August, 2024 at 10:58(UTC-8) by Lyle Bateman

Day 2 action kicks off with a few minutes remaining in Level 22, and they'll play Levels 23 and 24 at Day 1 blinds before moving to the Day 2 levels for Level 25.

Day 2 Seat Assignmens for the Monster by Seat Posted Thursday 15th August, 2024 at 01:46(UTC-8) by Lyle Bateman

Monster Stack Day 2 Chips by Seat

T	S	Player	Hometown	Chips
21	1	Dwight Czyz	Canmore, AB	620,000
21	2	Alison Senycz	Calgary, AB	500,000
21	3	John Estner	Richmond, BC	1,140,000
21	4	Qingwei Meng	Calgary, AB	995,000
21	5	Sachin Sehgal	Calgary, AB	1,100,000
21	6	Michael Baldwin	Calgary, AB	1,115,000
21	7	Jack Dick	Calgary, AB	1,080,000
21	8	Zoran Pribilovic	Burnaby, BC	805,000
21	9	Brian 'BA' Anderson	North Battleford, SK	810,000
22	1	Aleksei Ponomarev	Surrey, BC	1,520,000
22	2	Josh Myers	Edmonton, AB	585,000
22	3	Abe Shawile	Edmonton, AB	630,000
22	4	Monika Hagele	Calgary, AB	360,000
22	5	Cache Paylor	Penhold, AB	1,035,000
22	6	Andrew Neels	Innisfail, AB	1,435,000
22	7	Tedde Ballanger	Burlington, ON	550,000
22	8	Daniel O'Leary	Edmonton, AB	655,000
22	9	Derek Holme	Calgary, AB	1,120,000
23	1	Jason Vickers	Stoney Creek, BC	930,000
23	2	Anthony SMith	Vancouver, BC	415,000
23	3	Steve Desjarlais	Nanaimo, BC	200,000
23	4	Jerry Nelner	Strathmore, AB	585,000
23	5	Mark Mendoza	Airdrie, AB	1,950,000
23	6	Cody Goulet	Edmonton, AB	475,000
23	7	Sam Raz	Vancouver, BC	260,000
23	8	Kendrick Arason	Kelowna, BC	1,245,000
23	9	Barry Dubnyk	Lethbridge, AB	1,105,000
29	1	Michael Lloyd	Fort Langley, BC	890,000
29	2	Cindy Grabia	Leduc, AB	765,000
29	3	Zhi Jiang	Edmonton, AB	40,000
29	4	Ryan Callahan	Calgary, AB	785,000
29	5	Mike St. Pierre-Porter	Kamloops, BC	960,000
29	6	Mei Yun Ge	Vancouver, BC	615,000
29	7	Lapchi Duong	Calgary, AB	1,005,000
29	8	Zhi Gang Yang	Richmond, BC	700,000
29	9	Regan Duong	Calgary, AB	1,330,000
30	1	Darren Dunn	Surrey, BC	1,000,020
30	2	Leo Zhang	Edmonton, AB	130,000
30	3	Henry Menard	Winnipeg, MB	370,000
30	4	Luigi Sili		485,000
30	5	Chi Kit Chan	Kamloops, BC	470,000
30	6	Robert Cicchelli	Mississauga, ON	535,000
30	7	Ron Schindelheim	Laval, QC	560,000
30	8	Kyle Cook	UK	375,000
30	9	Matthew Clark	Edmonton, AB	890,000

Day 2 Seat Assignmens for the Monster by Name Posted Thursday 15th August, 2024 at 01:43(UTC-8) by Lyle Bateman

Monster Stack Day 2 Chips by Name

T	S	Player	Hometown	Chips
22	3	Abe Shawile	Edmonton, AB	630,000
22	1	Aleksei Ponomarev	Surrey, BC	1,520,000
21	2	Alison Senycz	Calgary, AB	500,000
22	6	Andrew Neels	Innisfail, AB	1,435,000
23	2	Anthony SMith	Vancouver, BC	415,000
23	9	Barry Dubnyk	Lethbridge, AB	1,105,000
21	9	Brian 'BA' Anderson	North Battleford, SK	810,000
22	5	Cache Paylor	Penhold, AB	1,035,000
30	5	Chi Kit Chan	Kamloops, BC	470,000
29	2	Cindy Grabia	Leduc, AB	765,000
23	6	Cody Goulet	Edmonton, AB	475,000
22	8	Daniel O'Leary	Edmonton, AB	655,000
30	1	Darren Dunn	Surrey, BC	1,000,020
22	9	Derek Holme	Calgary, AB	1,120,000
21	1	Dwight Czyz	Canmore, AB	620,000
30	3	Henry Menard	Winnipeg, MB	370,000
21	7	Jack Dick	Calgary, AB	1,080,000
23	1	Jason Vickers	Stoney Creek, BC	930,000
23	4	Jerry Nelner	Strathmore, AB	585,000
21	3	John Estner	Richmond, BC	1,140,000
22	2	Josh Myers	Edmonton, AB	585,000
23	8	Kendrick Arason	Kelowna, BC	1,245,000
30	8	Kyle Cook	UK	375,000
29	7	Lapchi Duong	Calgary, AB	1,005,000
30	2	Leo Zhang	Edmonton, AB	130,000
30	4	Luigi Sili		485,000
23	5	Mark Mendoza	Airdrie, AB	1,950,000
30	9	Matthew Clark	Edmonton, AB	890,000
29	6	Mei Yun Ge	Vancouver, BC	615,000
21	6	Michael Baldwin	Calgary, AB	1,115,000
29	1	Michael Lloyd	Fort Langley, BC	890,000
29	5	Mike St. Pierre-Porter	Kamloops, BC	960,000
22	4	Monika Hagele	Calgary, AB	360,000
21	4	Qingwei Meng	Calgary, AB	995,000
29	9	Regan Duong	Calgary, AB	1,330,000
30	6	Robert Cicchelli	Mississauga, ON	535,000
30	7	Ron Schindelheim	Laval, QC	560,000
29	4	Ryan Callahan	Calgary, AB	785,000
21	5	Sachin Sehgal	Calgary, AB	1,100,000
23	7	Sam Raz	Vancouver, BC	260,000
23	3	Steve Desjarlais	Nanaimo, BC	200,000
22	7	Tedde Ballanger	Burlington, ON	550,000
29	8	Zhi Gang Yang	Richmond, BC	700,000
29	3	Zhi Jiang	Edmonton, AB	40,000
21	8	Zoran Pribilovic	Burnaby, BC	805,000

Mark Mendoza Leads Day 2 Posted Thursday 15th August, 2024 at 01:26(UTC-8) by Lyle Bateman

Event #9:	$400 Monster ($330 + $70)
Date:	Day 1a: Aug 13, 2024, 11 am Day 1b: Aug 14, 2024, 11 am Day 2: Aug 15, 2024, noon
Blinds:	30/45 Min
Start Stack:	40,000
Entries:	881
Prizes:	$290,730
1st Place:	$45,940
Returning:	45

Day 2 of the Monster Stack is set and 14 players are returning to Day 2 with 1 million or more. Mark Mendoza leads the way with almost 2 million and the top five stacks all came from Day 1a, which isn't a surprise given the much bigger field.

The winner at the end of Day 2 is set to get almost $46k plus the Circuit ring and five players at the final table will bag five-figure scores. The FT min-cash in 10th is $2,932.

The action goes at noon in the Chrome room with players asked to be in the room 15 minutes early to get the bags open and get ready to play. This game will be my main focus on Thursday until the ring is awarded,  but early in the day I may be working on backend stuff and miss out on some of the action.

01:13 (UTC-8)

Day 2 of Deerfoot Inn and Casino Started
Level: 22     Blinds: 15,000/30,000     Ante: 30,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