0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0226 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2025-04-04'
AND `url` = 'https://www.maineventtravel.com/live-reporting/pure-poker-tour-toc-nlh-2023'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.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.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'pure-poker-tour-toc-nlh-2023'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '46'
0.0276 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0197 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '149'
AND `published` = 1
0.0346 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0268 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '151'
AND `published` = 1
0.0510 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0276 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '152'
AND `published` = 1
0.0001 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '152'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '46'
AND `name` = '2'
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '152'
ORDER BY `busted` ASC, `current_chips` DESC
0.0055 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` = '152'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '6692'
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` = '6691'
ORDER BY `chip_change` DESC, `busted` ASC
0.0174 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6690'
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` = '6689'
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` = '6688'
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` = '6687'
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` = '6686'
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` = '6684'
ORDER BY `chip_change` DESC, `busted` ASC
0.0173 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6683'
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` = '6681'
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` = '6680'
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` = '6679'
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` = '6678'
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` = '6677'
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` = '6676'
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` = '6674'
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` = '6673'
ORDER BY `chip_change` DESC, `busted` ASC
0.0173 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6671'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6670'
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` = '6669'
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` = '6668'
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` = '6667'
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` = '6666'
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` = '6665'
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` = '6664'
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` = '6663'
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` = '6661'
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` = '6660'
ORDER BY `chip_change` DESC, `busted` ASC
0.0367 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6659'
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` = '6658'
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` = '6657'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6656'
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` = '6654'
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` = '6653'
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` = '6651'
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` = '6650'
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` = '6649'
ORDER BY `chip_change` DESC, `busted` ASC
0.0166 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6648'
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` = '6647'
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` = '6646'
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` = '6645'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6644'
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` = '6643'
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` = '6642'
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` = '6641'
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` = '6640'
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` = '6639'
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` = '6638'
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` = '6637'
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` = '6636'
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` = '6635'
ORDER BY `chip_change` DESC, `busted` ASC
0.0176 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6634'
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` = '6633'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6629'
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` = '6630'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6628'
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` = '152'
ORDER BY `busted` ASC, `current_chips` DESC
0.0080 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` = '152'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '6692'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6691'
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` = '6690'
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` = '6689'
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` = '6688'
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` = '6687'
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` = '6686'
ORDER BY `chip_change` DESC, `busted` ASC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6684'
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` = '6683'
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` = '6681'
ORDER BY `chip_change` DESC, `busted` ASC
0.0094 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6680'
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` = '6679'
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` = '6678'
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` = '6677'
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` = '6676'
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` = '6674'
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` = '6673'
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` = '6671'
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` = '6670'
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` = '6669'
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` = '6668'
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` = '6667'
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` = '6666'
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` = '6665'
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` = '6664'
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` = '6663'
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` = '6661'
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` = '6660'
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` = '6659'
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` = '6658'
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` = '6657'
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` = '6656'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6654'
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` = '6653'
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` = '6651'
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` = '6650'
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` = '6649'
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` = '6648'
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` = '6647'
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` = '6646'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6645'
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` = '6644'
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` = '6643'
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` = '6642'
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` = '6641'
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` = '6640'
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` = '6639'
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` = '6638'
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` = '6637'
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` = '6636'
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` = '6635'
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` = '6634'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6633'
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` = '6629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6630'
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` = '6628'
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` = '152'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2249
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.
Eric Wasylenko Goes Two-for-Two in Multi-Days Posted Tuesday 28th November, 2023 at 21:01(UTC-7) by Lyle Bateman
It took Eric Wasylenko 7 years to win his first trophy in Alberta, and now he's just won his second in less than a week. He came close to his first one back in September here at Yellowhead when he was runner-up to Jason Tran in the Main Event, but he secured his first Alberta trophy on the weekend in Event #2 and he just bagged his second here in Event #5 tonight.
The double win also puts Wasy in the driver's seat for Player of the Series with 260 points. Francis Fan now has 165.9 points for second with Rob Lothian still in third with 125.6 now. Fan tried to get some extra points today in the Bounty, but I just had a look at the remaining field in that one and didn't spot him, so it looks like he won't be adding any more points to his total today.
His two wins this week will certainly push his Hendon Mob earnings over $800k but he may need to use some of that for a new suitcase to get all his AB trophies home from this trip.
Final Payouts for Event #5
Julius Roque Out in 2nd Place for $10,200 Posted Tuesday 28th November, 2023 at 20:50(UTC-7) by Lyle Bateman
Eric Wasylenko and Julius Roque finished one-two in chips in the first flight of this event, and when it got down to heads up, it was still Wasylenko and Roque, in that order with the top two stacks. The heads-up phase went quickly with only three hands played before the big confrontation.
In the final hand, Roque limped, then called for his life when Wasy shoved the big stack. It was a race spot with Wasylenko on jacks against the king-queen for Roque. The ten-high board was no help to Roque and the jacks took it down to send Roque to the cage for $10.2k.
Player
Chips
Progress
Eric Wasylenko
4,875,000
1,425,000
Julius Roque
0
0
David Quang Out in 3rd Place for $6,900 Posted Tuesday 28th November, 2023 at 20:35(UTC-7) by Lyle Bateman
They are heads up now after a blind on blind confrontation where Eric Wasylenko jammed the small with the big stack, and David Quang called the big with the small stack. Quang was ahead with king-ten against queen-nine for Wasy, but the nine came on the flop with no help for Quang on turn or river.
Player
Chips
Progress
Eric Wasylenko
3,450,000
830,000
David Quang
0
0
Chips on Break Posted Tuesday 28th November, 2023 at 20:23(UTC-7) by Lyle Bateman
Player
Chips
Progress
Eric Wasylenko
2,620,000
320,000
Julius Roque
1,355,000
295,000
David Quang
805,000
15,000
20:20 (UTC-7)
Start of Level 26 Blinds: 30,000/60,000 Ante: 60,000
Roque Moves on Wasy Posted Tuesday 28th November, 2023 at 20:10(UTC-7) by Lyle Bateman
Julius Roque flatted the small blind before eric Wasylenko raised the big to 175k. Roque didn't take long to come over the top to 600k and Wasylenko mucked quickly. Wasy is still leading three ways, but Roque isn't far behind him.
Player
Chips
Progress
Eric Wasylenko
2,300,000
300,000
Julius Roque
1,650,000
250,000
David Quang
820,000
100,000
Jayvee Lumahan Out in 4th Place for $5,050 Posted Tuesday 28th November, 2023 at 19:52(UTC-7) by Lyle Bateman
Jayvee Lumahan raise-folded for almost half his stack in the previous hand, and then when Eric Wasylenko opened to 100k under the gun, he reraised the button to 265k, leaving only about 60k behind.
Wasylenko shoved the big stack, and Lumahan put in the rest with against . Lumahan flopped a four, but Wasylenko turned his seven and held to send Lumahan out in 4th place for #,##0","3":1},"12":0}">$5,050.
#,##0","3":1},"12":0}">The pot left Wasy with a huge lead and more than half the chips in play.
Player
Chips
Progress
Eric Wasylenko
2,600,000
900,000
Jayvee Lumahan
0
0
19:36 (UTC-7)
Start of Level 25 Blinds: 25,000/50,000 Ante: 50,000
Lee Clark Out in 5th Place for $4,010 Posted Tuesday 28th November, 2023 at 19:29(UTC-7) by Lyle Bateman
Lee Clark got his short stack in with ace-six after a raise to 80k from cutoff Eric Wasylenko and a call from button Jayvee Lumahan. On Wasy called with his pocket jacks but Clark spiked his ace, but Wasy turned the straight and held to send Clark to the cage.
Player
Chips
Progress
Eric Wasylenko
1,700,000
1,175,000
Julius Roque
1,400,000
550,000
David Quang
920,000
130,000
Jayvee Lumahan
700,000
50,000
Lee Clark
0
0
Roque Check-Calls River Posted Tuesday 28th November, 2023 at 19:05(UTC-7) by Lyle Bateman
I arrived at the action on the river with the board reading with a huge pot already in the middle. Julius Roque checked from the small blind and Jayvee Lumahan slid out a bet of 550k. Roque called quite quickly, and his flopped pair with king-jack was good against the king-queen bricked straight draw for Lumahan.
Player
Chips
Progress
Julius Roque
1,950,000
850,000
Jayvee Lumahan
650,000
830,000
Lumahan Leads to start Level 24 Posted Tuesday 28th November, 2023 at 18:58(UTC-7) by Lyle Bateman
Player
Chips
Progress
Jayvee Lumahan
1,480,000
230,000
Julius Roque
1,100,000
300,000
David Quang
1,050,000
100,000
Lee Clark
790,000
60,000
Eric Wasylenko
525,000
275,000
18:56 (UTC-7)
Start of Level 24 Blinds: 20,000/40,000 Ante: 40,000
Lukas Lacko Out in 6th Place for $3,390 Posted Tuesday 28th November, 2023 at 18:47(UTC-7) by Lyle Bateman
It came down to a blind-on-blind cooler for Lukas Lacko today when he shoved the small with ace-jack and ran into Julius Roque's ace-queen in the big. He couldn't find his jack and hit the rail in 6th place.
Player
Chips
Progress
Julius Roque
800,000
180,000
Lukas Lacko
0
0
Francis Fan Out in 7th Place for $2,900 Posted Tuesday 28th November, 2023 at 18:34(UTC-7) by Lyle Bateman
Most of the damage happened in a huge cooler between Francis Fan and Julius Roque. Fan had pocket tens but he ran into kings for Roque and couldn't survive. That left him with about 50k which was all in on the next hand in the big blind and he sent the rest to Jayvee Lumahan.
Player
Chips
Progress
Jayvee Lumahan
1,250,000
105,000
Julius Roque
620,000
235,000
Francis Fan
0
0
Quang back over a Million Posted Tuesday 28th November, 2023 at 18:23(UTC-7) by Lyle Bateman
I picked up the action on the turn with the board reading and Eric Wasylenko check-called for 100k from David Quang. The river saw Wasy check again, but this time he folded when Quang slid out 285k.
Player
Chips
Progress
David Quang
1,150,000
295,000
Eric Wasylenko
800,000
225,000
18:09 (UTC-7)
Start of Level 23 Blinds: 15,000/30,000 Ante: 30,000
Lumahan in the Lead Posted Tuesday 28th November, 2023 at 18:09(UTC-7) by Lyle Bateman
Jayvee Lumahan and Eric Wasylenko both have more than 1 million chips not for first and second place. Players are on a break with the end of Level 22 and will be back at the felt in a bit more than 5 minutes for action at 15k/30k/30k.
Player
Chips
Progress
Jayvee Lumahan
1,145,000
395,000
Eric Wasylenko
1,025,000
175,000
David Quang
855,000
145,000
Lee Clark
850,000
100,000
Julius Roque
385,000
175,000
Francis Fan
380,000
70,000
Lukas Lacko
285,000
215,000
Clark Takes Big One Posted Tuesday 28th November, 2023 at 17:38(UTC-7) by Lyle Bateman
Eric Wasylenko raised to 50k under the gun and was called by Lee Clark in the hijack and Julius Roque on the big blind. They all checked the flop, but Roque fired 70k on the turn.
Both players called to the river where it checked to Clark. He tanked for a bit before sliding out a bet of 250k and getting a quick fold from Roque and a slightly slower one from Wasy.
Player
Chips
Progress
Lee Clark
950,000
400,000
Eric Wasylenko
850,000
100,000
Julius Roque
560,000
290,000
17:19 (UTC-7)
Start of Level 22 Blinds: 15,000/25,000 Ante: 25,000
Lumahan Turns It Posted Tuesday 28th November, 2023 at 17:19(UTC-7) by Lyle Bateman
Lukas Lacko opened to 50k from the middle and Jayvee Lumahan called from the big blind. They both checked the flop but Lumahan fired 35k on the turn.
He fired again for 60k on the river and Lacko called, mucking when Lumahan showed king-six of diamonds.
Player
Chips
Progress
Jayvee Lumahan
750,000
220,000
Quang in the Lead Posted Tuesday 28th November, 2023 at 17:05(UTC-7) by Lyle Bateman
David Quang has the chip lead now with about 1 million and Julius Roque looks to be second with about 850k now. Both PoS leaders, Eric Wasylenko and Francis Fan, are also still in the mix, though Fan looks to be the short stack right now while Wasy is in 3rd.
Player
Chips
Progress
David Quang
1,000,000
150,000
Julius Roque
850,000
146,000
Eric Wasylenko
750,000
265,000
Lee Clark
550,000
35,000
Jayvee Lumahan
530,000
80,000
Lukas Lacko
500,000
200,000
Francis Fan
450,000
35,000
Resul Dauti Out in 8th Place for $2,460 Posted Tuesday 28th November, 2023 at 16:58(UTC-7) by Lyle Bateman
Eric Wasylenko opened to 40k under the gun and David Quang flatted the middle before Resul Dauti went all in for 185k from the small blind. Wasylenko got out of the way, but Quang put in the call.
Resul Dauti: David Quang:
Quang flopped a club draw then turned his queen to take the lead and hold, sending Dauti to the cage for 8th place money while he chipped up to over 1 million.
Player
Chips
Progress
David Quang
1,150,000
503,000
Resul Dauti
0
0
Lumahan Gets There for Double; Moon Lee Out in 9th Place Posted Tuesday 28th November, 2023 at 16:48(UTC-7) by Lyle Bateman
Jayvee Lumahan shoved the button before Lee Clark reshoved for more from the small blind. Lumahan was behind with the suited connectors against for Clark. Lumahan hit his nine on the all-diamond flop and had to fade Clark's diamond draw, but he managed it and got the double,
Meanwhile, in the next hand, Moon Lee hit the rail in 9th place for $2,010.
Player
Chips
Progress
Lee Clark
515,000
320,000
Jayvee Lumahan
450,000
301,000
Moon Lee
0
0
16:41 (UTC-7)
Start of Level 21 Blinds: 10,000/20,000 Ante: 20,000
Final Table Faces Posted Tuesday 28th November, 2023 at 16:27(UTC-7) by Lyle Bateman
Final Table Time Posted Tuesday 28th November, 2023 at 16:13(UTC-7) by Lyle Bateman
They are down to the final nine players now after three quick exits. Ross Wilson took 12th place before a double knockout on the other table got them down to nine. Shawn Taghavi shoved the cutoff, David Quang called from the button, and Brad Sartison called with less from the small blind.
Brad Sartison: Shawn Taghavi: David Quang:
Quang spiked a seven on the turn to take a lock on the hand and send the game to the final table. Stay tuned for some pictures shortly.
Player
Chips
Progress
Brad Sartison
0
0
Shawn Taghavi
0
0
Ross Wilson
0
0
Chips from Break Posted Tuesday 28th November, 2023 at 15:56(UTC-7) by Lyle Bateman
Eric Wasylenko is in the lead now with just over 1 million chips, but Julius Roque is right behind with just shy of a million. David Quang looks to be the 3rd place stack now with a bit less than 650k while no one els even has 500k.
Player
Chips
Progress
Eric Wasylenko
1,015,000
415,000
Julius Roque
996,000
86,000
David Quang
647,000
410,000
Resul Dauti
445,000
368,000
Francis Fan
415,000
55,000
Lukas Lacko
300,000
121,000
Moon Lee
232,000
116,000
Lee Clark
195,000
5,000
Jayvee Lumahan
149,000
62,000
Brad Sartison
142,000
66,000
Shawn Taghavi
140,000
120,000
Ross Wilson
120,000
56,500
15:52 (UTC-7)
Start of Level 20 Blinds: 10,000/15,000 Ante: 15,000
Dauti With the Baby Flush Posted Tuesday 28th November, 2023 at 15:41(UTC-7) by Lyle Bateman
Eric Wasylenko opened under the gun to 25k and Resul Dauti was the only caller from the button. Both players checked the flop of and Wasy check-called for 15k on the turn. They went back to checking on the river and Wasy showed queen-seven for bottom pair on the flop, but Dauti was on pocket threes with the and took it down with the baby clubs.
Three From the Final Table Posted Tuesday 28th November, 2023 at 15:37(UTC-7) by Lyle Bateman
They are down to 12 players left after Weston Pring just hit the rail in 13th place. He pocketed the final payout of $1,570 and the next three eliminations before the final table can expect to pocket $1,790.
Player
Chips
Progress
Weston Pring
0
0
Down to 13 Remaining Posted Tuesday 28th November, 2023 at 15:33(UTC-7) by Lyle Bateman
Chris Macpherson just hit the rail in 14th place for a score of $1,570. He had just tripled up a short stack when he was all in against Julius Roque and David Quang who checked through the board. Macpherson hit his king on the flop and was best, but the chip-up was short-lived as he was collecting his things just a couple of hands later.
Player
Chips
Progress
Chris Macpherson
0
0
Down to 14 Posted Tuesday 28th November, 2023 at 15:29(UTC-7) by Lyle Bateman
Antonio Manfredi was the most recent exit from Day 2 in 15th place for $1,570. I missed the action but his chips went to the stack of Julius Roque who is down a bit from the last count but still doing well.
Player
Chips
Progress
Julius Roque
910,000
45,000
Antonio Mantredi
0
0
Average Stack Just under 30 Bigs Posted Tuesday 28th November, 2023 at 15:23(UTC-7) by Lyle Bateman
There are still 15 players left in the action today with the average stack at 325k right now. That means they are playing 27 bigs on average until the end of this level, which is just over 20 minutes away.
They'll go for another break following this level.
15 Players Remain Posted Tuesday 28th November, 2023 at 15:10(UTC-7) by Lyle Bateman
Kali Shuali was the most recent bust from Day 2. I missed the action, but Shuali cashed for $1,400 in 16th place. She won the first event this past summer in Calgary at Deerfoot's Summer Super Stack after taking down a Venetian Deepstack about a month earlier. She went on to have another deep final table run in Calgary as well, so she looks to be having a good year on the felt.
Player
Chips
Progress
Kali Shuali
0
0
15:03 (UTC-7)
Start of Level 19 Blinds: 6,000/12,000 Ante: 12,000
Clark Takes from Wasy Posted Tuesday 28th November, 2023 at 15:03(UTC-7) by Lyle Bateman
Eric Wasylenko raised to 20k under the gun and only Lee Clark called from the big blind. The flop was and Clark check-called for 15k. The turn was bringing the third spade to the board and both players checked. The river brought a lead of 25k from Clark, and Wasy snap-mucked.
Player
Chips
Progress
Eric Wasylenko
600,000
10,000
Lee Clark
200,000
205,000
Manfredi Holds for Double Posted Tuesday 28th November, 2023 at 14:52(UTC-7) by Lyle Bateman
It was a race between the queen-jack suited overs for Shawn Taghavi against the pocket tens for Antonio Manfredi. The low board ran clean for the pocket pair and Manfredi chipped up to about 260k while Taghavi was down to about the same amount.
Shortly after, Moon Lee doubled when his dominated king-jack got there with trip kings against ace-jack.
Player
Chips
Progress
Antonio Mantredi
262,000
59,500
Shawn Taghavi
260,000
111,500
Moon Lee
116,000
30,000
Roque Nearing 1 Million Posted Tuesday 28th November, 2023 at 14:44(UTC-7) by Lyle Bateman
Julius Roque is still leading, with Weston Pring and Eric Wasyloenko looking near neck-and-neck for second place with just over 600k each. I'll grab complete counts at the upcoming break in about an hour.
Player
Chips
Progress
Julius Roque
955,000
45,000
Weston Pring
620,000
440,000
Eric Wasylenko
610,000
152,500
Francis Fan
360,000
120,000
Down to 16 Posted Tuesday 28th November, 2023 at 14:38(UTC-7) by Lyle Bateman
Ali Razzaq was the most recent casualty in Day 2 for 17th place worth $1,400. He sent his chips to the growing stack of Julius Roque who is now over 900k.
Player
Chips
Progress
Julius Roque
910,000
310,000
Ali Razzaq
0
0
Down to 17 Posted Tuesday 28th November, 2023 at 14:33(UTC-7) by Lyle Bateman
Danny Bajaj was the most recent bust in 18th place for the first payout at $1,400. Meanwhile, on the same table, Jayvee Lumahan survived all-in versus Shawn Taghavi when Taghavi's tens couldn't hold against the ace-nine suited for Lumahan.
Player
Chips
Progress
Danny Bajaj
0
0
14:23 (UTC-7)
Start of Level 18 Blinds: 5,000/10,000 Ante: 10,000
Fan and Wasy Side-by-Side Posted Tuesday 28th November, 2023 at 14:23(UTC-7) by Lyle Bateman
They started the day across from each other on the same table, but after the redraw the top two players in the PoS race are now side-by-side on Table 2 with Eric Wasylenko in Seat 6 and Francis Fan to his left in Seat 7.
Meanwhile. chip leader Julius Roque is on the other table, away from the PoS combatants but still sitting pretty,
Down to 18 Posted Tuesday 28th November, 2023 at 14:17(UTC-7) by Lyle Bateman
They are doing a two-table redraw now after the elimination of Tina Nguyen in 19th place. She took the final payout of $1,290 and the next player to bust will pocket $1,400.
Player
Chips
Progress
Tina Nguyen
0
0
One Player Away from Two-Table Redraw Posted Tuesday 28th November, 2023 at 14:13(UTC-7) by Lyle Bateman
They are down to 19 players left now after the recent exit of Jeff Scruton in 20th place for $1,290. One more player will earn that prize before they hit the redraw and it jumps to $1,400.
Player
Chips
Progress
Jeff Scruton
0
0
Down to 20 Players Left Posted Tuesday 28th November, 2023 at 14:07(UTC-7) by Lyle Bateman
Andy Li was among the casualties from Day 2 of Event #5 to bring the field down to 20 remaining. Li took the first payout of $1,180, while Rob Lothian and Tim Salangsang took the rest of the payouts at that level. Lothian got his stack in with tens, but the big blind was priced in to call with jack-eight and hit his jack to send Lothian to the rail.
Additionally, Ron Lauzon hit the rail in 21st place when his pocket sixes couldn't hold against ace-five to take the first payout at $1,290.
Player
Chips
Progress
Tim Salangsang
0
0
Robert Lothian
0
0
Andy Li
0
0
Ron Lauzon
0
0
David Chau First Out in the Money for $1,100 Posted Tuesday 28th November, 2023 at 13:52(UTC-7) by Lyle Bateman
Julius Roque is running pure now with a stack of about 600k after his pocket kings sent David Chau to the rail for the min-cash spot worth $1,100. Chau was very short on Day 1b but managed to spin it up for a decent stack to start today so while he would surely have liked to go a bit deeper, getting the min-cash is a decent score considering he wan near felted on 1b.
Player
Chips
Progress
Julius Roque
600,000
68,500
David Chau
0
0
Roque Leading in the Money Posted Tuesday 28th November, 2023 at 13:40(UTC-7) by Lyle Bateman
The bubble-bursting hand against Preston Stevenson just before the current break was enough to send Julius Roque into the chip lead with more than half a million. Eric Wasylenko is hovering around his start stack for today while Francis Fan has dropped a bit. Rob Lothian is sitting at just over 100k now.
The PoS race is very much still on today, and while there are still a number of events left to score points in, if Fan, Wasy, or Lothian win this one they will almost certainly have a stranglehold on the lead.
Player
Chips
Progress
Julius Roque
531,500
158,000
Eric Wasylenko
457,500
13,000
Lee Clark
405,000
112,000
Francis Fan
240,000
101,500
Robert Lothian
114,000
7,000
In the Money; Ten Minute Break Posted Tuesday 28th November, 2023 at 13:32(UTC-7) by Lyle Bateman
They are now in the money after a quick hand for hand phase that lasted only a single hand. Preston Stevenson found himself in a race against Julius Roque with Stevenson's ace-king looking to hit against the pocket tens of Roque. The board ran clean for the tens and Stevenson was the last player to bust outside the money today.
Players are now on a ten-minute break following hand-for-hand, and they'll return for almost three full levels of poker before the next break.
Player
Chips
Progress
Preston Stevenson
0
0
13:27 (UTC-7)
Start of Level 17 Blinds: 4,000/8,000 Ante: 8,000
Hand for Hand Posted Tuesday 28th November, 2023 at 13:27(UTC-7) by Lyle Bateman
They are down to 26 players after the elimination of Sopheak Heang on the soft bubble. The clock is now paused with 2 minutes coming off manually for each hand played.
Player
Chips
Progress
Sopheak Heang
0
0
Down to Three Tables Posted Tuesday 28th November, 2023 at 13:16(UTC-7) by Lyle Bateman
They are down to 27 players left in Day 2 no after Leo Zhang couldn't spin up his shirt stack early today. They'll go hand-for-hand to the money after the next elimination and while there is a break on the schedule for the end of this level, that break will be moved until the end of hand-for-hand play.
Player
Chips
Progress
Leo Zhang
0
0
Top Three PoS Leaders Play Together Today Posted Tuesday 28th November, 2023 at 13:03(UTC-7) by Lyle Bateman
It looks like the top three players in the Player of the Series standings will be playing together for a whole today as the redraw has been moved to the final two tables since they did a redraw for the start today. Since the top three are all on Table 1, that table won't break after the first elimination so while they may be moved away from each other do to balancing, they'll be facing each other down on the same table for at least the first few hands today.
It's worth noting that Francis Fan looks to be a bit late to the game today as his seat is still empty with play now underway.
Player
Chips
Progress
Eric Wasylenko
470,500
0
Francis Fan
341,500
0
Robert Lothian
121,000
0
Day 2 Set to Go Posted Tuesday 28th November, 2023 at 12:58(UTC-7) by Lyle Bateman
The Day 2 players are taking their seats now with the action set to start very shortly. There are 28 players returning to fight for 25 paid spots, and they will do the full three-table redraw after the first elimination today when they get to 27 left.
Battle for the Points Set for Day 2 Posted Tuesday 28th November, 2023 at 00:17(UTC-7) by Lyle Bateman
It was a bit of a storybook ending for the two starting flights in this one. Player of the Series leader Eric Wasylenko bagged the big stack on Day 1a, and will be playing the most chips to start Day 2. Wasy is in a neck-and-neck battle with Francis Fan for the top on the PoS though, with Fan just .3 points behind him, and Fan was the chip leader to end Day 1b.
Julius Roque, who also bagged big on 1a, is in between them in the counts, but no doubt both Fan and Wasy will have an eye to each other's stacks through the day, and they won't have to look far to start the day either as they are seated at the same table. That may not last long however as with 28 players coming back they'll be redrawing after the first elimination.
Day 2 starts with most of Level 16 to play before they jump to the 40-minute blinds for Level 17. The action gets underway at 1 pm but players are asked to be in the Pearl room by 12:45 to get the bags open so play can begin on time.
Day 2 Players by Seat
Day 2 Players by Stack
Day 2 Players by Name
Payouts for Event #5
Player of the Series Standings After 5 Events
00:01 (UTC-7)
Start of Level 16 Blinds: 3,000/6,000 Ante: 6,000
23:44 (UTC-7)
Day 2 of Tournament of Champions Started Level: 15 Blinds: 2,500/5,000 Ante: 5,000
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.