0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0068 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-may-wsopc-calgary-event-3/1D/updates'
ORDER BY `views` DESC
0.0088 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.0002 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.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0004 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.0007 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0006 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.0067 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.0112 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-may-wsopc-calgary-event-3'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '117'
0.1806 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0113 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '283'
AND `published` = 1
0.1806 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0088 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '284'
AND `published` = 1
0.0925 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '285'
AND `published` = 1
0.2134 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0671 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '287'
AND `published` = 1
0.0330 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '288'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '117'
AND `name` = '1D'
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '285'
ORDER BY `busted` ASC, `current_chips` DESC
0.0942 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` = '285'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12755'
ORDER BY `chip_change` DESC, `busted` ASC
0.0623 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12754'
ORDER BY `chip_change` DESC, `busted` ASC
0.0090 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12753'
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` = '12752'
ORDER BY `chip_change` DESC, `busted` ASC
0.0147 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12751'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12750'
ORDER BY `chip_change` DESC, `busted` ASC
0.0946 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12749'
ORDER BY `chip_change` DESC, `busted` ASC
0.0591 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12748'
ORDER BY `chip_change` DESC, `busted` ASC
0.0177 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12747'
ORDER BY `chip_change` DESC, `busted` ASC
0.0119 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12746'
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` = '12745'
ORDER BY `chip_change` DESC, `busted` ASC
0.1955 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12744'
ORDER BY `chip_change` DESC, `busted` ASC
0.0622 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12743'
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` = '12736'
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` = '12735'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12734'
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` = '12733'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12732'
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` = '12731'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12727'
ORDER BY `chip_change` DESC, `busted` ASC
0.0118 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12726'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12723'
ORDER BY `chip_change` DESC, `busted` ASC
0.0774 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12722'
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` = '12721'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12720'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12719'
ORDER BY `chip_change` DESC, `busted` ASC
0.0651 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12718'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12717'
ORDER BY `chip_change` DESC, `busted` ASC
0.0152 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12716'
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` = '12715'
ORDER BY `chip_change` DESC, `busted` ASC
0.0136 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12714'
ORDER BY `chip_change` DESC, `busted` ASC
0.1690 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12713'
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` = '12712'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12711'
ORDER BY `chip_change` DESC, `busted` ASC
0.1675 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12710'
ORDER BY `chip_change` DESC, `busted` ASC
0.0101 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12709'
ORDER BY `chip_change` DESC, `busted` ASC
0.0104 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12708'
ORDER BY `chip_change` DESC, `busted` ASC
0.0102 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12707'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12706'
ORDER BY `chip_change` DESC, `busted` ASC
0.0567 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12705'
ORDER BY `chip_change` DESC, `busted` ASC
0.0104 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12704'
ORDER BY `chip_change` DESC, `busted` ASC
0.0248 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12702'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12701'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12700'
ORDER BY `chip_change` DESC, `busted` ASC
0.1625 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12699'
ORDER BY `chip_change` DESC, `busted` ASC
0.0164 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12698'
ORDER BY `chip_change` DESC, `busted` ASC
0.0160 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12697'
ORDER BY `chip_change` DESC, `busted` ASC
0.0689 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12696'
ORDER BY `chip_change` DESC, `busted` ASC
0.0228 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12695'
ORDER BY `chip_change` DESC, `busted` ASC
0.0913 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12694'
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` = '12693'
ORDER BY `chip_change` DESC, `busted` ASC
0.0762 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12692'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '285'
ORDER BY `busted` ASC, `current_chips` DESC
0.0203 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` = '285'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0777 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12755'
ORDER BY `chip_change` DESC, `busted` ASC
0.0248 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12754'
ORDER BY `chip_change` DESC, `busted` ASC
0.0636 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12753'
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` = '12752'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12751'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12750'
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` = '12749'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12748'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12747'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12746'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12745'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12744'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12743'
ORDER BY `chip_change` DESC, `busted` ASC
0.0360 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12736'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12735'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12734'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12733'
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` = '12732'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12731'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12727'
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` = '12726'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12723'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12722'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12721'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12720'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12719'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12718'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12717'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12716'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12715'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12714'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12713'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12712'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12711'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12710'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12709'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12708'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12707'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12706'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12705'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12704'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12702'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12701'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12700'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12699'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12698'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12697'
ORDER BY `chip_change` DESC, `busted` ASC
0.0245 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12696'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12695'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12694'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12693'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12692'
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` = '288'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2445
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.
Skytrain Leads Day 1d Counts Posted Saturday 4th May, 2024 at 21:48(UTC-7) by Lyle Bateman
Zeyu 'Skytrain' Huang was the only player on 1d to bag more than a million chips, but Romualdo Cusano wasn't too far away with 979k while Michael Baldwin bagged 801k for third place.
Day 1d Chips
Table
Seat
Player
Hometown
Chips
29
1
Zeyu 'Skytrain' Huang
Calgary, AB
1,048,000
20
4
Romualdo Cusano
n. Vancouver, BC
979,000
24
2
Michael Baldwin
Calgary, AB
801,000
29
3
Mason St. Martin
Calgary, AB
676,000
29
5
Sung Roh
Toronto, ON
510,000
29
7
Adam Crockett
n. Vancouver, BC
503,000
29
6
Kambiz Zamani
Hudson, MA, USA
434,000
21
6
Shawn Taghavi
Edmonton, AB
434,000
24
3
Clint Galloway
Edmonton, AB
387,000
25
4
Guanghui Li
Edmonton, AB
377,000
20
5
Kyle Kamachi
Surrey, BC
360,000
21
7
Jerry Li
Calgary, AB
282,000
29
2
Dolant Limbago
Calgary, AB
216,000
22
3
Tyler Thomas
Chestermere, AB
204,000
29
4
Sachin Sehgal
Calgary, AB
187000
25
3
Ivan Chuvyrov
Calgary, AB
185,000
20
9
Steven Arsenault
Calgary, AB
164,000
22
2
Dusty Speta
Crossfield, AB
145,000
29
9
Bill Duncan
Kamloops, BC
129,000
25
5
Jason McArthur
Calgary, AB
127,000
28
5
Marcus Culver
Whistler, BC
79,000
Day 1d is Over Posted Saturday 4th May, 2024 at 21:32(UTC-7) by Lyle Bateman
Day 1d is over with 21 players bagging chips during Level 18. Oleksander Lobur was the unfortunate bag bubble tonight taking 22nd place for $1,030. While 39th place is yet to report in, the rest of the payouts are below, with a few players who requested anonymity.
Place
Player
Hometown
Prize
22
Oleksandr Lobur
Ukraine
$1,030
23
Thomas Taylor
Calgary
$1,030
24
Leo Leclerc
Navin Mb
$1,030
25
Paul Sokoloff
London Uk
$905
26
Dnr
$905
27
Ryan Down
Calgary
$905
28
Adam Chipiuk
Edmonton
$809
29
Essan Saadeddine
Calgary
$809
30
Cody Koncz
Lethbridge
$809
31
Patrick Woelk
Abbotsford Bc
$737
32
Lonnie Gorrill
Calgary
$737
33
Manvir Dhaliwal
Calgary
$737
34
Krystian Hady
Calgary
$683
35
Ryan Teixeira
Edmonton
$683
36
Zishang Liu
Calgary
$683
37
Wesley Terpstra
$644
38
Dnr
$644
39
$644
40
Hassan Issa
Chilliwack Bc
$644
41
Ryan Parungao
Navin Mb
$644
42
Claire Leclerc
Calgary
$644
43
Austin Vickers
Calgary
$644
44
Zhi Yang
Richmond Bc
$644
45
Shane Brotherwood
Calgary
$644
46
Jaskaran Brar
Rocky View
$620
47
Palvinder Brar
Calgary
$620
48
Agostinho Gomes
Vancouver
$620
49
Jordan Johnstone
Chestermere
$620
50
Abhizer Rajkotwala
Vancouver
$620
51
Garrett Birch
Prince George Bc
$620
52
Cory Malenfaut
Regina
$620
53
John Smith
Vancouver
$620
54
Roza-Pereira Seadon
New Westminister Bc
$620
55
Nicholas Andreas
Medicine Hat
$607
56
Peter Svoboda
Calgary
$607
57
Kevin Kammavong
Calgary
$607
58
Fred Werezak
Desert Blume Ab
$607
59
Boawei Sun
Calgary
$607
60
Fred Parsons
Kamloops Bc
$607
61
Antonio Ma
Calgary
$607
62
Haven Taylor
Calgary
$607
Bubble to End of Day Posted Saturday 4th May, 2024 at 21:08(UTC-7) by Lyle Bateman
They are down to 22 left now in 1d after Thomas Taylor hit the rais for 23rd place. That leaves them just one player off the end of the night with Level 18 just underway.
21:07 (UTC-7)
Start of Level 18 Blinds: 6,000/12,000 Ante: 12,000
Two Away from End Posted Saturday 4th May, 2024 at 21:01(UTC-7) by Lyle Bateman
Leo Leclerc was the most recent casualty from 1d for 24th place, leaving them just two eliminations off the end of the day with just over five minutes to play in Level 17.
Three Off the End of the Day Posted Saturday 4th May, 2024 at 20:55(UTC-7) by Lyle Bateman
They are down to 24 players left now with just over 10 minutes to play in Level 17. That means they are only three eliminations away from the money spots. Paul Sokoloff, and DNR player, and Ryan Down are the recent busts.
Corrected Payout List Posted Saturday 4th May, 2024 at 20:47(UTC-7) by Lyle Bateman
There was a discrepancy on the payouts but it's been resolved now. Most of the earliest cahses were correct but some positions have changed slightly in the list below.
Place
Player
Hometown
Prize
C">28
C)">Adam Chipiuk
C">Edmonton
$809
C">29
C)">Essan Saadeddine
C">Calgary
$809
C">30
C)">Cody Koncz
C">Lethbridge
$809
C">31
C)">Patrick Woelk
C">Abbotsford Bc
$737
C">32
C)">Lonnie Gorrill
C">Calgary
$737
C">33
C)">Manvir Dhaliwal
C">Calgary
$737
C">34
C)">Krystian Hady
C">Calgary
$683
C">35
C)">Ryan Teixeira
C">Edmonton
$683
C">36
C)">Zishang Liu
C">Calgary
$683
C">37
C)">Wesley Terpstra
C">
$644
C">38
C)">Dnr
C">
$644
C">39
C)">
C">
$644
C">40
C)">Hassan Issa
C">Chilliwack Bc
$644
C">41
C)">Ryan Parungao
C">Navin Mb
$644
C">42
C)">Claire Leclerc
C">Calgary
$644
C">43
C)">Austin Vickers
C">Calgary
$644
C">44
C)">Zhi Yang
C">Richmond Bc
$644
C">45
C)">Shane Brotherwood
C">Calgary
$644
C">46
C)">Jaskaran Brar
C">Rocky View
$620
C">47
C)">Palvinder Brar
C">Calgary
$620
C">48
C)">Agostinho Gomes
C">Vancouver
$620
C">49
C)">Jordan Johnstone
C">Chestermere
$620
C">50
C)">Abhizer Rajkotwala
C">Vancouver
$620
C">51
C)">Garrett Birch
C">Prince George Bc
$620
C">52
C)">Cory Malenfaut
C">Regina
$620
C">53
C)">John Smith
C">Vancouver
$620
C">54
C)">Roza-Pereira
C">New Westminister Bc
$620
C">55
C)">Nicholas Andreas
C">Medicine Hat
$607
C">56
C)">Peter Svoboda
C">Calgary
$607
C">57
C)">Kevin Kammavong
C">Calgary
$607
C">58
C)">Fred Werezak
C">Desert Blume Ab
$607
C">59
C)">Boawei Sun
C">Calgary
$607
C">60
C)">Fred Parsons
C">Kamloops Bc
$607
C">61
C)">Antonio Ma
C">Calgary
$607
C">62
C)">Haven Taylor
C">Calgary
$607
1d Cashers so Far Posted Saturday 4th May, 2024 at 20:26(UTC-7) by Lyle Bateman
Day 1d Payouts to 30th Place
Place
Player
Hometown
Prize
30
PATRICK WOELK
PORT COQUITLAM
#,##0","3":1}">$809
31
LONNIE GORRILL
ABBOTSFORD BC
#,##0","3":1}">$737
32
MANVIR DHALIWAL
CALGARY
#,##0","3":1}">$737
33
KRYSTIAN HADY
CALGARY
#,##0","3":1}">$737
34
RYAN TEIXEIRA
CALGARY
#,##0","3":1}">$683
35
ZISHANG LIU
EDMONTON
#,##0","3":1}">$683
36
WESLEY TERPSTRA
CALGARY
#,##0","3":1}">$683
37
DNR
#,##0","3":1}">$644
38
ARMIN BAHMANPOUR
VANCOUVER
#,##0","3":1}">$644
39
HASSAN ISSA
CALGARY
#,##0","3":1}">$644
40
RYAN PARUNGAO
CHILLIWACK BC
#,##0","3":1}">$644
41
CLAIRE LECLERC
NAVIN MB
#,##0","3":1}">$644
42
AUSTIN VICKERS
CALGARY
#,##0","3":1}">$644
43
#,##0","3":1}">$644
44
ZHI YANG
RICHMOND BC
#,##0","3":1}">$644
45
SHANE BROTHERWOOD
CALGARY
#,##0","3":1}">$644
46
JASKARAN BRAR
ROCKY VIEW
#,##0","3":1}">$620
47
PALVINDER BRAR
CALGARY
#,##0","3":1}">$620
48
AGOSTINHO GOMES
VANCOUVER
#,##0","3":1}">$620
49
JORDAN JOHNSTONE
CHESTERMERE
#,##0","3":1}">$620
50
ABHIZER RAJKOTWALA
VANCOUVER
#,##0","3":1}">$620
51
GARRETT BIRCH
PRINCE GEORGE BC
#,##0","3":1}">$620
52
CORY MALENFAUT
REGINA
#,##0","3":1}">$620
53
JOHN SMITH
VANCOUVER
#,##0","3":1}">$620
54
ROZA-PEREIRA
NEW WESTMINISTER BC
#,##0","3":1}">$620
55
NICHOLAS ANDREAS
MEDICINE HAT
#,##0","3":1}">$607
56
PETER SVOBODA
CALGARY
#,##0","3":1}">$607
57
KEVIN Kammavong
CALGARY
#,##0","3":1}">$607
58
FRED WEREZAK
DESERT BLUME AB
#,##0","3":1}">$607
59
Boawei Sun
Calgary
#,##0","3":1}">$607
60
Fred Parsons
Kamloops BC
#,##0","3":1}">$607
61
Antonio Ma
Calgary
#,##0","3":1}">$607
62
Haven Taylor
Calgary
#,##0","3":1}">$607
20:24 (UTC-7)
Start of Level 17 Blinds: 5,000/10,000 Ante: 10,000
8 Off the End of Day at Final Break Posted Saturday 4th May, 2024 at 20:20(UTC-7) by Lyle Bateman
It doesn't look like Day 1d will go too much longer once players return from their break for Level 17. They are down to 29 left now and the bags will come out at 21. It seems likely that they'll play most of Level 17 at least but I'll be surprised if they make it as far as the end of Level 18.
12 Off the End of the Day Posted Saturday 4th May, 2024 at 20:06(UTC-7) by Lyle Bateman
There are just over 10 minutes remaining in Level 16 now with 33 players left in the game. That puts them 12 off the end of the night at 21 players and they have four scheduled levels after this one to get there.
19:45 (UTC-7)
Start of Level 16 Blinds: 4,000/8,000 Ante: 8,000
Down to 42 Left Posted Saturday 4th May, 2024 at 19:45(UTC-7) by Lyle Bateman
Payout So Far for Day 1d
Place
Player
Hometown
Prize
43
AUSTIN VICKERS
CALGARY
$644
44
ZHI YANG
RICHMOND BC
$644
45
SHANE BROTHERWOOD
CALGARY
$644
46
JASKARAN BRAR
ROCKY VIEW
$620
47
PALVINDER BRAR
CALGARY
$620
48
AGOSTINHO GOMES
VANCOUVER
$620
49
JORDAN JOHNSTONE
CHESTERMERE
$620
50
ABHIZER RAJKOTWALA
VANCOUVER
$620
51
GARRETT BIRCH
PRINCE GEORGE BC
$620
52
CORY MALENFAUT
REGINA
$620
53
JOHN SMITH
VANCOUVER
$620
54
ROZA-PEREIRA
NEW WESTMINISTER BC
$620
55
NICHOLAS ANDREAS
MEDICINE HAT
$607
56
PETER SVOBODA
CALGARY
$607
57
KEVIN Kammavong
CALGARY
$607
58
FRED WEREZAK
DESERT BLUME AB
$607
59
Boawei Sun
Calgary
$607
60
Fred Parsons
Kamloops BC
$607
61
Antonio Ma
Calgary
$607
62
Haven Taylor
Calgary
$607
Payouts So Far Posted Saturday 4th May, 2024 at 19:24(UTC-7) by Lyle Bateman
Day 1d Payouts So Far
Place
Player
Hometown
Prize
51
GARRETT BIRCH
PRINCE GEORGE BC
#,##0","3":1}">$620
52
CORY MALENFAUT
REGINA
#,##0","3":1}">$620
53
JOHN SMITH
VANCOUVER
#,##0","3":1}">$620
54
ROZA-PEREIRA
NEW WESTMINISTER BC
#,##0","3":1}">$620
55
NICHOLAS ANDREAS
MEDICINE HAT
#,##0","3":1}">$607
56
PETER SVOBODA
CALGARY
#,##0","3":1}">$607
57
KEVIN Kammavong
CALGARY
#,##0","3":1}">$607
58
FRED WEREZAK
DESERT BLUME
#,##0","3":1}">$607
59
Boawei Sun
Calgary
#,##0","3":1}">$607
60
Fred Parsons
Kamloops BC
#,##0","3":1}">$607
61
Antonio Ma
Calgary
#,##0","3":1}">$607
62
Haven Taylor
Calgary
#,##0","3":1}">$607
19:22 (UTC-7)
Start of Level 15 Blinds: 3,000/6,000 Ante: 6,000
In the Money Posted Saturday 4th May, 2024 at 19:10(UTC-7) by Lyle Bateman
I went for a quick dinner and when I returned they were already in the money in Day 1d. The field is down to 57 remaining now, but there is a line at the payout desk, so things are moving quickly. So far, Haven Taylor, Antonio Ma, Fred Parsons, Baowei Sun, and Fred Werezak have collected payouts with more to come shortly.
19:08 (UTC-7)
Start of Level 14 Blinds: 3,000/5,000 Ante: 5,000
Back from Dinner Posted Saturday 4th May, 2024 at 18:15(UTC-7) by Lyle Bateman
The dinner break is nearly over and there are 75 players returning to action in Level 13. That puts them 13 off the money spots for tonight, so it looks like the bubble play will start near the end of this level or the start of Level 14.
18:13 (UTC-7)
Start of Level 13 Blinds: 2,000/4,000 Ante: 4,000
Dinner Time with 81 Left Posted Saturday 4th May, 2024 at 17:31(UTC-7) by Lyle Bateman
They are down to 81 players left in 1d now with players heading out for dinner. They'll be back in action in Level 13 in about 45 minutes, with 19 players to go until the money spots.
15 Minutes to Dinner Posted Saturday 4th May, 2024 at 17:17(UTC-7) by Lyle Bateman
There are just under 15 minutes to go in Level 12 with the dinner break scheduled at the end of this level. They are down to 90 players left in the game so there will still be a way to go till the bubble once they return from dinner.
17:00 (UTC-7)
Start of Level 12 Blinds: 2,000/3,000 Ante: 3,000
99 Players Left in 1d Posted Saturday 4th May, 2024 at 16:54(UTC-7) by Lyle Bateman
1d is now down to less than 100 players left alive now with just over 5 minutes to play in Level 11. They'll go for dinner at the end of Level 12, and when they return from dinner there are 8 more levels on the schedule for today. The day will end early if they hit 21 players before the end of Level 20 and at this point, it looks like an even bet as to which endpoint will kick in.
Tentative Day 2 Prizes are In, $58k for the Winner Posted Saturday 4th May, 2024 at 16:46(UTC-7) by Lyle Bateman
The Day 2 prizes have been released, but they are based on the assumption that today's flight plays down to 21 players. For the time being, I'm not going to publish them until we get confirmation that they are official, but regardless of the finish tonight, it looks like 1st place tomorrow should be set to pocket at least $58k. If they play down to 21 today, then 57 players will be returning tomorrow with the min-cash spots starting at $1,374.
Day 1d Payouts are In Posted Saturday 4th May, 2024 at 16:41(UTC-7) by Lyle Bateman
The Day 1d payouts are now up and the 1d field is confirmed at 412 for 1,101 in total across all four flights. Players will start getting paid tonight at 62nd place, and at least 21 players will bag up at the end of the night.
Day 1d Payouts
Place
Prize
1-21
Day 2
22
$1,030
23
$1,030
24
$1,030
25
$905
26
$905
27
$905
28
$809
29
$809
30
$809
31
$737
32
$737
33
$737
34
$683
35
$683
36
$683
37
$644
38
$644
39
$644
40
$644
41
$644
42
$644
43
$644
44
$644
45
$644
46
$620
47
$620
48
$620
49
$620
50
$620
51
$620
52
$620
53
$620
54
$620
55
$607
56
$607
57
$607
58
$607
59
$607
60
$607
61
$607
62
$607
16:36 (UTC-7)
Start of Level 11 Blinds: 1,500/2,500 Ante: 2,500
Dow to 135 Left Posted Saturday 4th May, 2024 at 16:05(UTC-7) by Lyle Bateman
Level 10 has just begun and they are down to 135 players left alive. Among the players still in the game today are Lorne Voth, Sunny Lubana Allen Shen, Kali Shuali, Fay Barker, Jordan Banfield, Shane Brotherwood, Claire Leclerc, and Zeyu "Skytrain" Huang.
16:01 (UTC-7)
Start of Level 10 Blinds: 1,000/2,000 Ante: 2,000
Down to 162 Left in 1d Posted Saturday 4th May, 2024 at 15:43(UTC-7) by Lyle Bateman
The ya re down to 162 players left in Flight 1d now with a bit more than 15 minutes to play in Level 9. They'll go for a dinner break following Level 12 and then return to play until the end of Level 20, or they hit 21 players, whichever comes first.4
Day 1d and Day 2 prizes should be out shortly and I'll confirm all the numbers then.
1,100 Entries Cracked Posted Saturday 4th May, 2024 at 15:33(UTC-7) by Lyle Bateman
Entries are now closed for the 4-Flight and the unofficial total for 1d was 412 entries. That means the total field size hit 1,101 for total prizes of $363,330.
While those numbers are still yet to be confirmed, if they hold it will mean 62 players get a piece of the prize money from today, with at least 21 advancing to Day 2 on Sunday.
15:30 (UTC-7)
Start of Level 9 Blinds: 1,000/1,500 Ante: 1,500
Second Break Posted Saturday 4th May, 2024 at 15:17(UTC-7) by Lyle Bateman
Level 8 is coming to a close and that means there are just 15 minutes to get into the game. 1d is over 400 entries and the total field is nearing 1,100.
Final Level of Entry for 4-Flight Posted Saturday 4th May, 2024 at 14:47(UTC-7) by Lyle Bateman
The 4-Flight game is into the final level of entries now so there is about 45 minutes to get into this game. The total field is now 21 away from 1,100 and the 1d field is 10 away from 400 total entries.
14:45 (UTC-7)
Start of Level 8 Blinds: 600/1,200 Ante: 1,200
27 Entries from 1,100 Posted Saturday 4th May, 2024 at 14:42(UTC-7) by Lyle Bateman
The total field size for E3 is now up to 1,073 so they are inching ever closer to 1,100 total entries. This year is already more than 100 entries above last year, and with 45 minutes still left to enter, it looks like 1,100 isn't out of the question.
More than $350k in Prizes Posted Saturday 4th May, 2024 at 14:30(UTC-7) by Lyle Bateman
There is about an hour left to get into the game still, and the prize pool just capped $350k with 1,064 entries in total across all four flights. Day 1d has 375 entries alone now, and it looks like a decent bet to flirt with 400 before entries close at the start of Level 9. There are now about 15 minutes remaining in Level 7, and they'll take another break following Level 8 before entries close for good on the 4-Flight.
14:15 (UTC-7)
Start of Level 7 Blinds: 500/1,000 Ante: 1,000
More than $340k in Prizes Posted Saturday 4th May, 2024 at 14:03(UTC-7) by Lyle Bateman
The 4-flight field is now up to 1,031 for prizes of $340,230. With about 90 minutes left to enter the game, it looks possible the prize pool will crack $350k, though that would require another 28 entries before the beginning of Level 9. There are about 10 minutes remaining in Level 6 at the moment.
Nearing $335k in Prizes Posted Saturday 4th May, 2024 at 13:48(UTC-7) by Lyle Bateman
Level 6 is just beginning with the total field up to 1,015 and prizes of $334,950. Toby Wu, Michael Smith, Doug Lee, Shane Brotherwood, and Thomas Taylor are among the players I've spotted in the field today.
13:43 (UTC-7)
Start of Level 6 Blinds: 400/800 Ante: 800
More than 1,000 Entries Posted Saturday 4th May, 2024 at 13:36(UTC-7) by Lyle Bateman
The 4-Flight field just capped 1,000 entries with 315 on the board now for Day 1d. That also pushes the prize pool over $330k with just under two hours to go in registration.
300 Entries on the Board Posted Saturday 4th May, 2024 at 13:19(UTC-7) by Lyle Bateman
Day 1d just hit 300 entries for a total of 989 across all four flights so far. That puts the combined prizes at $326,370 with more than 2 hours left to get into this one. Among the other players I've spotted today in the mix are Antoine Saddleback, Kim Pham, Juss Viet, Stephen Dauphinais, Matt Kwong, Teo Sanchez, and Ryan Smith, but that is still FAR from a comprehensive list.
13:16 (UTC-7)
Start of Level 5 Blinds: 300/600 Ante: 600
Ahead of Last May Posted Saturday 4th May, 2024 at 13:02(UTC-7) by Lyle Bateman
The break following Level 4 is about to begin and the four-flight field is now ahead of last May's numbers with 972 total now. It looks pretty certain at this point that they'll end up with more than 1,000 entries, as they are less than 30 away from that now with 2.5 hours left to enter. While previous flights have tended to slow considerably as late entry ends, given this is the last chance for a bag in this event, it seems likely the reentries will be brisk right up until the final moment.
With 972 entries, the prizes now are a bit more than $320k.
16 Off May 2023 Posted Saturday 4th May, 2024 at 12:32(UTC-7) by Lyle Bateman
Level 4 has just begun and the 1d field is now up to 259 entries for 948 in total. That puts the prizes at $312,840 with about 3 hours left to enter the game.
At this point, beating last May's 964 seems like a lock, and the 4-day field could flirt with 1,000 entries by the start of Level 9 tonight.
12:30 (UTC-7)
Start of Level 4 Blinds: 300/500 Ante: 500
Less than 40 Entries Away from Last May's Total Posted Saturday 4th May, 2024 at 12:20(UTC-7) by Lyle Bateman
The field is up to 928 now across all four starting flights. Last May, this event saw a total of 964 entries so this year looks to be on pace to break that total with entries still open for more than 3 hours.
So far, I haven't had a good look around the room yet, but as expected, there are a lot of familiar faces out there today. For an early list, from my spot behind the computer, I can see Nicholas Peterson, Phil Wright, Dave Howat, Zeyu "Skytrain" Huang, Hari Aujla, and Claire Leclerc. Leclerc was among the players to cash in yesterday's flight 1b.
More than $300k in Prizes Posted Saturday 4th May, 2024 at 12:07(UTC-7) by Lyle Bateman
The action for Day 1d is now in Level 3 with the field already up to 229 entries. That puts the total field up to 918 across all four days so far for $302,940 in prizes.
12:02 (UTC-7)
Start of Level 3 Blinds: 200/400 Ante: 400
Day 1d is Set to go with 689 Entries Already Posted Saturday 4th May, 2024 at 03:15(UTC-7) by Lyle Bateman
Event #3: $400 4-Flight ($330 + $70)
Date: Day 1a/c: May 2/3, 2024, 4 PM, Day 1b/d: May 3/4, 2024, 11AM Start Stack: 20,000 Blinds: 30 Min Late Entry: 8 Levels (~8:30 PM/3:30 PM) Day 1 Ends: 20 Levels or 5% of the field (Level 20 should end about 3 AM/11:30 PM)
The 4-Flight is among the most popular events of the series, and previous editions of the game have crushed local field size records. In January of this year, the field across all 4 starting days topped out at an astonishing 1,715 entries while last May's numbers hit 964.
The first flight gets going at 4 PM on Thursday with two more flights on Friday and a final shot at a bag on Saturday morning. Day 2 will pay out the big money on Sunday, but 15%-5% on Day 1 will also be heading home with money as Day 1 play goes until there are 5% of the field left, or until the end of Level 20, whichever comes first.
Entries are open for the first 8 levels of play on Day 1, which will put the last chance to enter at either 8:30 PM for the late start days, or 3:30 PM for the early start days. Day 1b & c of this event will be my focus on Friday, but for today, Day 1a won't get much coverage until after Event #2 is complete.
03:12 (UTC-7)
Day 1D of WSOPC Deerfoot Inn & Casino Started Level: 1 Blinds: 100/200 Ante: 200
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.
£ GBP
$ USD
€ EUR
">28
">Edmonton
