0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0061 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-05-17'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-ppt2-e8/1A/updates'
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.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.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.0065 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024-ppt2-e8'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '110'
0.0209 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0049 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '274'
AND `published` = 1
0.0222 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0050 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '276'
AND `published` = 1
0.0215 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0049 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '278'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '110'
AND `name` = '1A'
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '274'
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` = '274'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0115 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12266'
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` = '12265'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12264'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12263'
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` = '12256'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12255'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12253'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12250'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12249'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12246'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12242'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12241'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12240'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12237'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12236'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12231'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12230'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12229'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12228'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12224'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12223'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12220'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12219'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12218'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12211'
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` = '12210'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12209'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12208'
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` = '12207'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12205'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12204'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12203'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12202'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12201'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12200'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12199'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12198'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12197'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12196'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12195'
ORDER BY `chip_change` DESC, `busted` ASC
0.0151 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12194'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12192'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12191'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12190'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12189'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12188'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12187'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12186'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12185'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12184'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12183'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12182'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12181'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12180'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12107'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '274'
ORDER BY `busted` ASC, `current_chips` DESC
0.0043 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` = '274'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12266'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12265'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12264'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12263'
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` = '12256'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12255'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12253'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12250'
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` = '12249'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12246'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12242'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12241'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12240'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12237'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12236'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12231'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12230'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12229'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12228'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12224'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12223'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12220'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12219'
ORDER BY `chip_change` DESC, `busted` ASC
0.0150 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12218'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12211'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12210'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12209'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12208'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12207'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12205'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12204'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12203'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12202'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12201'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12200'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12199'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12198'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12197'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12196'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12195'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12194'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12192'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12191'
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` = '12190'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12189'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12188'
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` = '12187'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12186'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12185'
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` = '12184'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12183'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12182'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12181'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12180'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12107'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '278'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2486
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.
Haven Taylor Leads Day 1a of Main Posted Saturday 13th April, 2024 at 03:31(UTC-7) by Lyle Bateman
The 2024 Pure Poker Tour ambassador is more than just a pretty face - Haven Taylor just bagged the chip lead from Day 1a of the Main Event. She bagged up 476k at the end of a marathon day.
Her closest competitor, Julius Roque, only managed to bag 247k with Karim Chatur close behind at 245k. The full qualifying stacks are below.
Player
Chips
Progress
Haven Taylor
476,000
249,500
Julius Roque
247,000
1,000
Karim Chatur
245,000
140,000
Ron Giles
208,000
23,000
Eric Wasylenko
203,000
155,000
Zeyu Huang
181,000
12,500
Shane Brotherwood
128,000
64,000
Tyler Panas
74,000
40,000
Keith Schultz
0
0
Keith Schultz Bubbles Day 2 Posted Saturday 13th April, 2024 at 02:48(UTC-7) by Lyle Bateman
The marathon Day 1a is finally over, and Keith Schultz was the unfortunate player to bubble Day 2 tonight. In the final hand he flopped an ace for the lead against Haven Taylor's . Taylor flopped a four and a backdoor club draw, and when the board ran out she sent Schultz to the rail as the final elimination of Day 1a.
Still on the Bubble Posted Saturday 13th April, 2024 at 02:38(UTC-7) by Lyle Bateman
They are up to Level 18 now and still on the bubble to the end of the day with nine players left. Short stacks keep doubling to survive and stay alive with Eric Wasylenko still leading. Tyler Panas just got his final 35k in with queen-jack for a race against the sevens of Wasy. Panas flopped a jack and held to take the double, and they play on.
02:34 (UTC-7)
Start of Level 18 Blinds: 5,000/10,000 Ante: 10,000
Brotherwood Doubles Posted Saturday 13th April, 2024 at 01:44(UTC-7) by Lyle Bateman
It was a huge hand that saw Tyler Panas open the middle, and Karim Chatur call before short stack Shane Brotherwood shoved the big blind for 35.5k. Panas reshoved, sending Chatur into the tank. He rolled over his ace-queen as he was deciding as he was the last to act.
He finally opted for the muck, sending Panas and Brotherwood off to the races with Panas on ace-king against pocket sevens for Brotherwood. The sevens held for the double, and Panas now looks to be the short stack at the table.
01:41 (UTC-7)
Start of Level 17 Blinds: 4,000/8,000 Ante: 8,000
Taylor Puts it on the Line Posted Saturday 13th April, 2024 at 01:35(UTC-7) by Lyle Bateman
Haven Taylor just put her tournament life on the line. She opened early only have Julius Roque three-bet from the button. It folded back to her and she shoved, sending Roque into the tank. Both players looked to have a very similar stack, but Roque elected to muck his hand and send the pot to Taylor uncontested.
Panas with Big Fold Posted Saturday 13th April, 2024 at 01:15(UTC-7) by Lyle Bateman
Eric Wasyenko opened the action from the middle with a raise to 12k. Tyler Panas came over the top to 29k from the button before Karim Chatur clicked the four-bet button for 46k.
Wasy got out of the way quickly, but Panas looked visibly pained as he considered his decision on the Day 2 bubble. He eventually mucked his hand and confirmed to me after the hand that he folded queens, putting Chatur on kings or aces. He may never know if it was the right fold, but regardless, he's still sitting at the table with a shot at Day 2.
01:04 (UTC-7)
Start of Level 16 Blinds: 3,000/6,000 Ante: 6,000
Bubble to End of Day 1a Posted Saturday 13th April, 2024 at 00:30(UTC-7) by Lyle Bateman
They are down to 9 players left now in the Main, which is the bubble to the end of the day. Frank Shi busted out in 10th and they are now breaking down to the final table of nine.
Player
Chips
Progress
Frank Shi
0
0
Wasylenko Leads Two from the End of Day Posted Saturday 13th April, 2024 at 00:12(UTC-7) by Lyle Bateman
Level 15 will be underway in a few minutes and Eric Wasylenko is the leader at the moment with 358k. He is the only player over 300k, but Julius Roque is second with 246k. Keith Schultz and Haven Taylor also have more than 200k in front of them now.
Player
Chips
Progress
Eric Wasylenko
358,000
0
Julius Roque
246,000
0
Keith Schultz
228,000
0
Haven Taylor
226,500
0
Ron Giles
185,000
0
Zeyu Huang
168,500
0
Tyler Panas
114,000
0
Karim Chatur
105,000
0
Frank Shi
82,500
0
Shane Brotherwood
64,000
0
00:08 (UTC-7)
Start of Level 15 Blinds: 2,500/5,000 Ante: 5,000
Down to 10 Posted Friday 12th April, 2024 at 23:48(UTC-7) by Lyle Bateman
They are down to 10 players left in 1a of the Main Event now with just over 10 minutes to play in Level 14. They'll head out for a break at the end of this level, assuming they make it that far, but it looks likely the night will end shortly after the break, if now before.
Roque and Taylor Leading Posted Friday 12th April, 2024 at 23:25(UTC-7) by Lyle Bateman
It looks like Julius Roque is the chip leader at the moment with about 280k in front of him, but tablemate and PPT ambassador Haven Taylor is pretty close behind with about 270k while Keith Schultz is down to about 230k now,
23:18 (UTC-7)
Start of Level 14 Blinds: 2,000/4,000 Ante: 4,000
Four Off the End of the Night Posted Friday 12th April, 2024 at 23:14(UTC-7) by Lyle Bateman
Level 13 has about 5 minutes left to play with the field now down to 12 and the planned stop tonight at 8. They have another break at the end of Level 14, but it's possible they'll push that back a level if they are still playing at the end of the next level.
Schultz Leading to Start Level 13 Posted Friday 12th April, 2024 at 22:31(UTC-7) by Lyle Bateman
After a quick look around at the break it looks like Keith Schultz is the chip leader with just over 300k, while Zeyu "Skytrain" Huang looks to be second with about 275k.
22:28 (UTC-7)
Start of Level 13 Blinds: 1,500/3,000 Ante: 3,000
Five Away from End of Day Posted Friday 12th April, 2024 at 22:24(UTC-7) by Lyle Bateman
The players are just heading out for what is almost certainly their last break of Day 1a. There are 13 players left alive with 8 players advancing tonight, so it seems likely they'll finish up sometime in the couple of levels after the break, though it's worth noting they are about 50 big blinds deep on average right now, so there's still a fair bit of play in the game.
Six off the End of Day 1a Posted Friday 12th April, 2024 at 22:10(UTC-7) by Lyle Bateman
The field is down to 14 players left now in Day 1a of the Main Event with just under 15 minutes to play in Level 12. They'll head out for a break following this level, and that will likely be the final break for today's flight given that they are only six eliminations away from the bags coming out.
21:44 (UTC-7)
Start of Level 12 Blinds: 1,500/2,500 Ante: 2,500
Down to Two Tables Posted Friday 12th April, 2024 at 21:17(UTC-7) by Lyle Bateman
There are 18 players left alive now with about 25 minutes left in Level 11. They are just breaking down to two tables at the moment and this puts them 10 players off the end of Day 1a.
Down to 20 Players Posted Friday 12th April, 2024 at 21:07(UTC-7) by Lyle Bateman
Level 11 has just begun and they are now down to 20 players left in action. Pete Fylyma, "Cowboy" Ron Giles, Keith Schultz, Julius Roque, Karim Chatur, Francis Fan, Haven Taylor, Hasan Al Ghunaim, Frank Shi, Shane Brotherwood, and Zeyu "Skytrain" Huang are among the players still alive in today's flight.
21:04 (UTC-7)
Start of Level 11 Blinds: 1,000/2,000 Ante: 2,000
8 Qualifiers from 1a Posted Friday 12th April, 2024 at 20:47(UTC-7) by Lyle Bateman
The numbers are now official and there will be 8 players bagging chips from Day 1a later tonight. There are currently still 23 players at the felt, and there is no hard stop for tonight's flight. They'll keep playing until there are just 8 players left with chips and Day 1b will follow the same process, playing until 12.5% of the field is reached.
59 Unofficial Entries for Day 1a Posted Friday 12th April, 2024 at 20:28(UTC-7) by Lyle Bateman
Level 10 is now underway and entries for the opening flight of the Main Event are now closed. The final (unofficial) number of entries looks to be 59 and if that holds, it should mean $55,490 will be in the prize pool from today's flight, and they'll play down to either 9 or 10 players left before they bag tonight.
As Level 10 begins, there are 23 players left in their seats.
20:26 (UTC-7)
Start of Level 10 Blinds: 1,000/1,500 Ante: 1,500
Some Stacks at Dinner Posted Friday 12th April, 2024 at 20:11(UTC-7) by Lyle Bateman
There are just over 10 minutes left to get into Day 1a of the Main Event today as the dinner break is ticking down to the end. I had a look around at the break for a few of the bigger stacks, and it looks like Frank Shi is the chip leader now with 210k. He looks to be the only one with more than 200k in front of him, but Keith Schultz isn't far away with 186.5k while Tyler Panas and Zeyu "Skytrain" Huang are both playing stacks in the 140k range.
Just Under an Hour Left to Enter 1a Posted Friday 12th April, 2024 at 19:29(UTC-7) by Lyle Bateman
There are about 10 minutes left in Level 9, and that means the entry desk will be shut down in less than an hour for Day 1a. There are still 56 entries on the board with 22 players left alive.
Today's flight is scheduled to end when they hit 12.5% of the field, which should be 8 or 9 players depending on rounding and new entries.
Final Level of Entries Posted Friday 12th April, 2024 at 18:58(UTC-7) by Lyle Bateman
Level 9 is just beginning now and this is the final level of poker to get into today's flight. Players who miss out on today still have a full 1b to play tomorrow if they wish, but it's likely we'll still see another few entries before thing shut down in a bit more than an hour from now.
18:57 (UTC-7)
Start of Level 9 Blinds: 600/1,200 Ante: 1,200
An Hour and 45 Left in Entries Posted Friday 12th April, 2024 at 18:38(UTC-7) by Lyle Bateman
There are about 20 minutes remaining in Level 8 now, which means the end of entries for today's flight is less than 2 hours away. There is about an hour left of poker before the dinner break following Level 9, and once they return from that for Level 10, the 1a field will be set.
Tonight's flight will play down to the money spots before they bag, which at this point looks like 8 players.
18:18 (UTC-7)
Start of Level 8 Blinds: 500/1,000 Ante: 1,000
More than $50k in Prizes Now Posted Friday 12th April, 2024 at 17:55(UTC-7) by Lyle Bateman
There ar just over 20 minutes left in Level 7 and the prize pool just clicked over $50k with 54 entries on the board. There are still 30 players in action with about 2.5 hours left to enter today's flight.
Wasy and Chatur Leading Posted Friday 12th April, 2024 at 17:39(UTC-7) by Lyle Bateman
Level 7 is about to begin and they are now into the final three levels of entry for Day 1. The field is up to 52 entries with 34 players in the game still.
After a quick look around the room on the break for some big stacks, it looks like Eric Wasylenko and Karim Chatur are sharing the lead right now, both with just over 100k. Meanwhile, Kyle Dery is flirting with the century at about 95k and Hasan Al Ghunaim, Joon Oark, and Frank Shi are playing 70-80k stacks.
17:34 (UTC-7)
Start of Level 7 Blinds: 400/800 Ante: 800
50 Entries to Start Level 6 Posted Friday 12th April, 2024 at 16:46(UTC-7) by Lyle Bateman
Level 6 has just begun and there are 50 entries on the clock now. 37 players are still active on five tables and there are still a bit more than 3.5 hours left to get into today's flight. Current prizes are sitting at $47,025 and will crack $50k with the next four entries.
16:44 (UTC-7)
Start of Level 6 Blinds: 300/600 Ante: 600
Giveaways Galore at PPT Calgary Posted Friday 12th April, 2024 at 16:14(UTC-7) by Lyle Bateman
As part of this PPT event, the Casino has been throwing in some extra juice in the form of tickets and swag, Earlier today, Eric Wasylenko picked up another PPT hoody and hat, as well as $50 for a gift card, to add to his growing collection while last night PPT ambassador Haven Taylor drew for a free $230 Turbo entry.
Congratulations to Keith Mather and good luck in the Turbo tonight! Check out Taylor's announcement at the Live Poker Updates Facebook Group.
$40k in Prizes to Start Level 5 Posted Friday 12th April, 2024 at 16:06(UTC-7) by Lyle Bateman
Level 5 has just begun and the field is now up to 43 entries with 38 players at the felt. There is now a fifth table open and immediate seating is available for new entries now. Shane Brotherwood, 3rd place in the Turbo last night, and Ryan Comely were among the more recent entries for the new table.
16:04 (UTC-7)
Start of Level 5 Blinds: 300/500 Ante: 500
Wasy Keeps Winning Posted Friday 12th April, 2024 at 15:27(UTC-7) by Lyle Bateman
As a thank you to players for coming out to the series, Pure Poker Tour has been putting on a few random draws for tickets and swag this week. PPT ambassador Haven Taylor just did one for today's event with a PPT hat, hoody, and gift card up for grabs.
After a table and seat number were drawn, it ended up that Eric Wasylenko, winner of last year's Player of the Year and the Feb Main Event, was in the winning seat. At this point, he may have a PPT cap and hoody for every day of the week!
Huang Leads at First Break Posted Friday 12th April, 2024 at 15:16(UTC-7) by Lyle Bateman
I had a quick look around the room on the break and it looks like Zeyu "Skytrain" Huang is the chip leader right now with about 73k in front of him. Nicholas Andreas looks to be second with about 63k, while the 2024 PPT ambassador, Haven Taylor, is sitting with about 50k to start Level 4.
15:14 (UTC-7)
Start of Level 4 Blinds: 200/400 Ante: 400
More than $30k in Prizes Posted Friday 12th April, 2024 at 14:57(UTC-7) by Lyle Bateman
There are just under 15 minutes left to play in Level 3 with the field up to 35 entries now. That puts the prizes at $32,918 and climbing.
Entries will be open for about 5.5 hours from now for today, so it's likely these numbers will at least double before then, and they'll do it all over again tomorrow for Day 1b before the qualifiers reconvene for Day 2 on Sunday.
Adam Lamers, Pete Fylyma, February's Main Event winner Eric Wasylenko, Ron Lauzon, Frank Shi, Joon Park, and Dino Rajabi are among the more recent entries to the game.
A Look at the Early Field in the Main Event Day 1a Posted Friday 12th April, 2024 at 14:42(UTC-7) by Lyle Bateman
14:36 (UTC-7)
Start of Level 3 Blinds: 200/300 Ante: 300
Three Full Tables Posted Friday 12th April, 2024 at 14:18(UTC-7) by Lyle Bateman
Level 2 still has about 10 minutes to play and the field is now at 27 players with three full tables of action. It's likely they'll open a new table soon to ensure seating for new entries.
Field Growing Posted Friday 12th April, 2024 at 14:03(UTC-7) by Lyle Bateman
Thet are up to 25 entries with about 25 minutes to play in Level 2 now. Among the recent entries I saw were Karim Chatur, who looks to be in for his first event of the series, as well as Julius Roque, the face of the PPT this year, Haven Taylor, Qingwei Meng, Glenn Tarasoff, Stephen Dauphinais, and a rare appearance of late from "Cowboy" Ron Giles.
$20k in Prizes to Start Level 2 Posted Friday 12th April, 2024 at 13:49(UTC-7) by Lyle Bateman
They are up to 22 entries now to start Level 2 of the opening flight of the Main Event. That puts the current prizes at just over $20k and climbing.
13:48 (UTC-7)
Start of Level 2 Blinds: 100/200 Ante: 200
Main Event Action is Underway! Posted Friday 12th April, 2024 at 13:10(UTC-7) by Lyle Bateman
Day 1a of the Main Event is now underway with 14 players in their seats to start. The clock was a bit more than five minutes late getting started today, but this still looks to be the best start of any early game so far this series. Zeyu Huang, Curtis Singleton, and Ali Khani are among the players in their seats early today.
13:08 (UTC-7)
Day 1A of 2024 PPT Series #2 Started Level: 1 Blinds: 100/100 Ante: 100
Five Minutes to Go till Main Event Posted Friday 12th April, 2024 at 12:56(UTC-7) by Lyle Bateman
The opening flight of the Main Event is just moments away from cards going in the air. There are 10 entries on the board before the game even starts which may well be the best start of any game so far this week.
Main Event Time! Posted Thursday 11th April, 2024 at 15:39(UTC-7) by Lyle Bateman
Event #8: $1,100 Main Event ($990 + $110) Day 1a: Apr 12 - 1 PM Day 1b: Apr 13 - 1 PM Day 2: Apr 14 - 12 Noon Day 3: Apr 15 - 12 Noon (if Required) Starting Stack: 30k Blinds: 40/60 Min Late Entry: 9 Levels (~8:30 PM)
With the arrival of Friday, it's now time for the big show. Day 1a of the Main Event kicks off at 1 PM on Fri, Apr 12. Players have nine levels to enter the game on Day 1, which should put the last chance to enter at around 830 PM on both starting days.
Blinds on Day 1 are 40 minutes long with that moving to 60 minutes for Day 2. Day 1 will play into the money and stop when the field hits 12.5% which means all players coming back for Day 2 will be guaranteed some sort of payday. That also means it is highly unlikely that the third day will be required - with everyone in the money on Day 2, it's likely that will play fairly quickly and they'll be able to finish it out Sunday night, but the Day 3 is still scheduled for Monday if required.
This will be my Main Focus for the day Friday, but I'll move over to the late Turbo game when Day 1a bags for the night.
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.
. Taylor flopped a four and a backdoor club draw, and when the board ran out 
she sent Schultz to the rail as the final elimination of Day 1a.
£ GBP
$ USD
€ EUR
