0.0005 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0149 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2025-04-04'
AND `url` = 'https://www.maineventtravel.com/live-reporting/pure-poker-tour-toc-super-high-roller-2023/1/updates'
ORDER BY `views` DESC
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.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.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0005 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.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.0003 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.0038 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'pure-poker-tour-toc-super-high-roller-2023'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '53'
0.0274 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '164'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '53'
AND `name` = '1'
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '164'
ORDER BY `busted` ASC, `current_chips` DESC
0.0068 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` = '164'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7166'
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` = '7165'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7164'
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` = '7163'
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` = '7162'
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` = '7161'
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` = '7160'
ORDER BY `chip_change` DESC, `busted` ASC
0.0166 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7159'
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` = '7158'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7157'
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` = '7156'
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` = '7155'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7154'
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` = '7153'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7152'
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` = '7151'
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` = '7150'
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` = '7149'
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` = '7148'
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` = '7147'
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` = '7146'
ORDER BY `chip_change` DESC, `busted` ASC
0.0176 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7145'
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` = '7143'
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` = '7142'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7141'
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` = '7140'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7139'
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` = '7138'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7137'
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` = '7136'
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` = '7135'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7134'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7113'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7080'
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` = '7075'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7062'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7052'
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` = '7047'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7045'
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` = '7043'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7038'
ORDER BY `chip_change` DESC, `busted` ASC
0.0092 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7023'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '164'
ORDER BY `busted` ASC, `current_chips` DESC
0.0063 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` = '164'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7166'
ORDER BY `chip_change` DESC, `busted` ASC
0.0085 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7165'
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` = '7164'
ORDER BY `chip_change` DESC, `busted` ASC
0.0171 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7163'
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` = '7162'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7161'
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` = '7160'
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` = '7159'
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` = '7158'
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` = '7157'
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` = '7156'
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` = '7155'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7154'
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` = '7153'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7152'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7151'
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` = '7150'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7149'
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` = '7148'
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` = '7147'
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` = '7146'
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` = '7145'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7143'
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` = '7142'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7141'
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` = '7140'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7139'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7138'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7137'
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` = '7136'
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` = '7135'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7134'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7113'
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` = '7080'
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` = '7075'
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` = '7062'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7052'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7047'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7045'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7043'
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` = '7038'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7023'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '164'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2249
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Daniel Lefebvre Wins Third Straight High Roller on PPT Posted Monday 4th December, 2023 at 19:46(UTC-7) by Lyle Bateman
Daniel Lefebvre has been having a great end to his 2023, at least in High Roller branded events on the PPT. This was his third straight victory after taking down the High Roller games in Sept here at Yellowhead and October in Calgary. Now he's added this Super High Roller to the list.
It was a great run for Lefebvre who ran pure in several spots to get there for huge pots. He was getting cards at the right time for most of the day, but also made disciplined laydowns to preserve his stack when needed. He used aggression to his advantage, shoving blind-on-blind against the card-dead Josh Starborn for much of the final table, and used his big stack to pressure other players as well.
This was the fourth career win for the 2018 SIGA Champion and will push his lifetime earnings close to $225k.
Josh Starborn Out in 2nd Place for $15,420 Posted Monday 4th December, 2023 at 19:30(UTC-7) by Lyle Bateman
Level 21: 10000/20000/20000 Entries: 2/22
Josh Starborn was card-dead for a lot of the day, but in a way, it paid off for him. He nursed the short stack through the bubble and managed to ladder up to second place over DJ Sharma, but he just couldn't stop the Daniel Lefebvre freight train.
In one of the final hands, Starborn flopped two pair and tried to lay the trap for Lefebvre but the board ran out to Broadway for Lefebvre to take a big pot.
Shortly after, the money went in with Lefebvre on pocket fours against the ace-six for Starborn and the race was on. Lefebvre turned a set on .
Player
Chips
Progress
Daniel Lefebvre
1,100,000
360,000
Josh Starborn
0
0
Blinds to 20 Minutes Posted Monday 4th December, 2023 at 19:09(UTC-7) by Lyle Bateman
Level 21: 10000/20000/20000 Entries: 2/22
The blinds have dropped to 20 minutes with the new level now that they are heads up.
Back and Forth Posted Monday 4th December, 2023 at 19:05(UTC-7) by Lyle Bateman
Level 20: 10000/15000/15000 Entries: 2/22
Daniel Lefebvre was up over 900k after he hit a five on the river to cap Josh Starborn's turned deuce with 50k of value on the river. In the next hand, Starbor doubled back when he hit a ten with his jack-ten and held.
They just chopped a massive pot in a very odd runout. Starborn was in with ace-king against ace-ten for Lefebvre and Starborn flopped it with ace-king-king. After a brick turn, the river came the case ace, giving them both aces full of kings.
Level 21 is about to begin with blinds at 10k/20k/20k.
Player
Chips
Progress
Daniel Lefebvre
740,000
40,000
Josh Starborn
360,000
40,000
DJ Sharma Out in 3rd Place for $8,330 Posted Monday 4th December, 2023 at 18:54(UTC-7) by Lyle Bateman
Level 20: 10000/15000/15000 Entries: 2/22
DJ Sharma limped to trap blind on blind against Daniel Lefebvre, and he snapped off the call with ace-ten when Lefebvre shoved his big blind with . The gave Sharma 2nd pair but ran out to the baby flush for Lefebvre.
Player
Chips
Progress
Daniel Lefebvre
700,000
260,000
Josh Starborn
400,000
20,000
DJ Sharma
0
0
Starborn Doubles Posted Monday 4th December, 2023 at 18:34(UTC-7) by Lyle Bateman
Level 20: 10000/15000/15000 Entries: 3/22
Josh Starborn has been having a rough time in the big blind today as Daniel Lefebvre has been shoving a lot and hes been waking up with garbage and forced to fold. It just happened again, but he found this time and made the call.
He was behind the ace-queen of Lefebvre, but a nine in the window held and gave him the double.
Player
Chips
Progress
Daniel Lefebvre
440,000
180,000
Josh Starborn
380,000
166,000
DJ Sharma
280,000
30,000
Lefebvre Back to Lead Posted Monday 4th December, 2023 at 18:22(UTC-7) by Lyle Bateman
Level 19: 6000/12000/12000 Entries: 3/22
The board was already out reading and DJ Sharma was facing a bet of about 50k from Daniel Lefebvre with a big pot in the middle already. He put in the call, but mucked when Lefebvre showed queen-eight for turned second pair.
Player
Chips
Progress
Daniel Lefebvre
620,000
254,000
DJ Sharma
250,000
270,000
Sharma Folds the Ace Posted Monday 4th December, 2023 at 18:15(UTC-7) by Lyle Bateman
Level 19: 6000/12000/12000 Entries: 3/22
It's not all shoves and action here tonight - there are also some solid folds going on. DJ Sharma just raised the small blind to 26k, then tanked for a bit when Daniel Lefebvre three-bet the big blind to 73k. After a few seconds, he rolled over the as he mucked his hand and sent the uncontested pot to Lefebvre.
Starborn Doubles through Lefebvre Posted Monday 4th December, 2023 at 18:04(UTC-7) by Lyle Bateman
Level 19: 6000/12000/12000 Entries: 3/22
Josh Starborn looked down and saw an ace on the button and decided to shove without looking at his second card. Daniel Lefebvre called with more and was in decent shape with pocket sixes as Starborn's second card turned out to be a deuce.
It didn't matter, however, as the ace came in the window on the board of .
Player
Chips
Progress
DJ Sharma
520,000
58,000
Daniel Lefebvre
366,000
56,000
Josh Starborn
214,000
64,000
"About Time I won a Flip" Posted Monday 4th December, 2023 at 17:57(UTC-7) by Lyle Bateman
Level 19: 6000/12000/12000 Entries: 3/22
DJ Sharma limped then snap-called when Daniel Lefebvre shoved the small blind. It was a flip between ace-king for Sharma and sixes for Lefebvre, and Sharma turned the king for the double to the lead.
Player
Chips
Progress
DJ Sharma
462,000
204,000
Daniel Lefebvre
422,000
268,000
Josh Starborn
150,000
2,000
Back in Action for Level 19 Posted Monday 4th December, 2023 at 17:49(UTC-7) by Lyle Bateman
Level 19: 6000/12000/12000 Entries: 3/22
They are back at the felt for Level 19 now with blinds at 6k/12k/12k and Daniel Lefebvre leading.
Lefebvre with Huge Double Posted Monday 4th December, 2023 at 17:39(UTC-7) by Lyle Bateman
Level 18: 5000/10000/10000 Entries: 3/22
In the final hand of Level 18, DJ Sharma just sent a double to the stack of Daniel Lefebvre. Sharma raised to 26k from the small blind and Lefebvre called from the big.
The flop was and Sharma fired 26k again. Lefebvre called to the turn where Sharma bet 46k. Lefebvre flatted to the river where Sharma checked, then snap-called when Lefebvre shoved.
"Straight," said Lefebvre, turning over the ace-three for the wheel. Sharma slammed his pocket aces down in frustration and sent a huge double to Lefebvre, who is now playing more than half the total chips.
Player
Chips
Progress
Daniel Lefebvre
690,000
210,000
DJ Sharma
258,000
192,000
Josh Starborn
152,000
28,000
Johnny Yu Bubbles Super High Roller Posted Monday 4th December, 2023 at 17:23(UTC-7) by Lyle Bateman
Level 18: 5000/10000/10000 Entries: 3/22
It was a cooler that sent Johnny Yu to the rail in 4th place today on the bubble. He woke up with ace-queen and shoved it, but ran into the aces of DJ Sharma. The aces held and Yu was forced out on the bubble in a brutal spot.
Player
Chips
Progress
Daniel Lefebvre
480,000
40,000
DJ Sharma
450,000
240,000
Josh Starborn
180,000
70,000
Johnny Yu
0
0
Lefebvre Bullying a Bit Posted Monday 4th December, 2023 at 17:15(UTC-7) by Lyle Bateman
Level 18: 5000/10000/10000 Entries: 4/22
In the first hand, Johnny Yu raised his button to 25k and DJ Sharma called from the small blind. Big blind Daniel Lefebvre asked how much Yu had behind, and got the answer of about 230k before shoving the big stack and getting folds from both his opponents.
The next hand was a limped family pot to the flop. It checked to Sharma on the button, and he stabbed for 26k. Only Lefebvre called to the turn and both players checked it to the river.
Lefebvre fired a bet of 85k and sent Sharma into the tank for a bit. "You trying to buy it, Daniel?" he asked, but eventually sent his cards to the muck.
Player
Chips
Progress
Daniel Lefebvre
440,000
80,000
Johnny Yu
220,000
59,000
DJ Sharma
210,000
10,000
Josh Starborn
110,000
90,000
Yu Up to Average Posted Monday 4th December, 2023 at 16:58(UTC-7) by Lyle Bateman
Level 18: 5000/10000/10000 Entries: 4/22
Daniel Lefebvre shoved his button with the big stack, and Johnny Yu snap-called from the big blind with pocket nines. Lefebvre was drawing thin to an ace with ace-nine, and couldn't get there on a board of .
Player
Chips
Progress
Daniel Lefebvre
360,000
120,000
Johnny Yu
279,000
97,000
Yu Doubles Posted Monday 4th December, 2023 at 16:42(UTC-7) by Lyle Bateman
Level 17: 4000/8000/8000 Entries: 4/22
Johnny Yu shoved under the gun for 76k and Daniel Lefebvre reshoved the big stack from the small blind to isolate.
Johnny Yu: Daniel Lefebvre:
Board:
It was a coin flip between the pair of sixes for Yu and the overcards for Lefebvre. Yu was in danger of being counterfeited after the turn but managed to hold the clean board and take down the double.
There are now about 8 minutes remaining in Level 17 and blinds will increase to 5k/10k/10k on the next level for an average stack of 27.5 big blinds.
Player
Chips
Progress
Daniel Lefebvre
480,000
150,000
Johnny Yu
182,000
111,000
Sharma Gets Some Back Posted Monday 4th December, 2023 at 16:17(UTC-7) by Lyle Bateman
Level 17: 4000/8000/8000 Entries: 4/22
After a raise from Daniel Lefebvre under the gun and a call from DJ Sharma in the big blind, the flop came and Sharma check-called a bet of 11k. Both players checked the turn, and Sharma check-called for 31k on the river.
Lefebvre showed down jack-eight but Sharma turned a king for top pair and the win.
Player
Chips
Progress
Daniel Lefebvre
630,000
50,000
DJ Sharma
200,000
90,000
Lefebvre Pushing 700k Posted Monday 4th December, 2023 at 16:10(UTC-7) by Lyle Bateman
Level 16: 3000/6000/6000 Entries: 4/22
DJ Sharma is down some chips after a couple of hands that didn't go his way. In the first, he doubled up Josh Starborn when his fours couldn't hold against Starborn's ace-deuce.
In the next hand, Johnny Yu raised the button to 12k and Sharma called from the small blind as did Daniel Lefebvre from the big. It checked to Yu on the flop and he continued for 15k but Sharma put in the check-raise to 36k.
Lefebvre called while Yu got out of the way before the hit the turn. Sharma checked, then snap-called the 30k bet from Lefebvre. He checked again on the river, then tank-folded to a shove from the big stacked Lefebvre.
Player
Chips
Progress
Daniel Lefebvre
680,000
205,000
Josh Starborn
200,000
39,000
DJ Sharma
110,000
200,000
Johnny Yu
71,000
57,000
Lefebvre Takes it with Ace-High Posted Monday 4th December, 2023 at 16:00(UTC-7) by Lyle Bateman
Level 16: 3000/6000/6000 Entries: 4/22
The action has been pretty slow so far this level but chip leader Daniel Lefebvre just took a small-ish one from DJ Sharma. Lefebvre opened under the gun to 12k and Sharma called from the big blind.
Lefebvre continued for 8k after a check from Sharma on the flop. Sharma called to the turn and both players checked it through the river.
"Ten high," said Sharma before Lefebvre showed ace-high for the win.
Player
Chips
Progress
Daniel Lefebvre
550,000
10,000
DJ Sharma
310,000
18,000
Back in Action Posted Monday 4th December, 2023 at 15:30(UTC-7) by Lyle Bateman
Level 16: 3000/6000/6000 Entries: 4/22
They are back at the felt for Level 16 now with blinds at 3k/6k/6k.
Final Four Players Posted Monday 4th December, 2023 at 15:24(UTC-7) by Lyle Bateman
Break Time with Lefebvre Leading Posted Monday 4th December, 2023 at 15:22(UTC-7) by Lyle Bateman
Level 16: 3000/6000/6000 Entries: 4/22
Daniel Lefebvre is in the lead at the break following Level 15. They are still on the bubble to the money and will be back in action for Level 16 in about 7 minutes.
Player
Chips
Progress
Daniel Lefebvre
465,000
75,000
DJ Sharma
292,000
112,000
Josh Starborn
161,000
31,000
Johnny Yu
128,000
23,000
Bubble to the Money Posted Monday 4th December, 2023 at 14:55(UTC-7) by Lyle Bateman
Level 15: 2500/5000/5000 Entries: 4/22
Daniel Lefebvre is stacking more chips after sending Ali Khani to the rail in 5th place to put the game on the bubble to the money spots. The winner of the last two High Rollers had kings against ace-deuce suited for Khani and his short stack. Lefebvre turned kings full and he now has the big lead on the bubble.
Player
Chips
Progress
Daniel Lefebvre
540,000
75,000
Ali Khani
0
0
Down to 5 Left Posted Monday 4th December, 2023 at 14:48(UTC-7) by Lyle Bateman
Level 15: 2500/5000/5000 Entries: 5/22
They are two from the money now after Mike Kim hit the rail in 6th place. He had the chip lead to start the day, but then ran into the High Roller wizard Daniel Lefebvre and his flush. Kim couldn't recover from that confrontation, but he will be taking the PLO trophy back to Vancouver with him anyway.
Player
Chips
Progress
Mike Kim
0
0
Lefebvre Leads Posted Monday 4th December, 2023 at 14:13(UTC-7) by Lyle Bateman
Level 14: 2000/4000/4000 Entries: 6/22
Daniel Lefebvre is on his way to his third straight win in games branded as "High Rollers" here on the PPT. He's won the last two high roller games in Calgary in Oct and here at Yellowhead in Sept, and now he's chip leading the Super High Roller today with 6 left.
He just ran out to a flush against Mike Kim for a huge double to stack up more than 400k.
Player
Chips
Progress
Daniel Lefebvre
465,000
393,000
DJ Sharma
180,000
70,000
Josh Starborn
130,000
0
Johnny Yu
105,000
58,500
Mike Kim
105,000
200,500
Ali Khani
50,000
31,000
Three Places Paid Posted Monday 4th December, 2023 at 13:59(UTC-7) by Lyle Bateman
Level 14: 2000/4000/4000 Entries: 6/22
Three players from the Super High Roller will walk away with money in their pockets, and the winner is set to grab $23,275. The Payouts tab lists all the spots for today, and there are still six players left in the hunt for one of the three paid spots today.
Down to 6 Posted Monday 4th December, 2023 at 13:55(UTC-7) by Lyle Bateman
Level 13: 1500/3000/3000 Entries: 7/22
There are six players left in the game now after Andrew Goertz lost his chips near the end of Level 13. I missed the action as I was writing up the previous hand while it happened.
Player
Chips
Progress
Andrew Goertz
0
0
Quang Hits the Rail Posted Monday 4th December, 2023 at 13:53(UTC-7) by Lyle Bateman
Level 13: 1500/3000/3000 Entries: 7/22
David Quang ran into a race for his life but his pocket eights couldn't win it. Josh Starborn woke up with ace-jack suited and ran out to a straight to send Quang packing today.
Player
Chips
Progress
Josh Starborn
130,000
63,000
David Quang
0
0
Quick Day for Both Day 2 Entries Posted Monday 4th December, 2023 at 13:34(UTC-7) by Lyle Bateman
The day didn;t go well for either of the two new entries this morning. Nicholas Peterson lasted a little longer than Hugh Armstrong, but Peterson, along with Colten Yamagishi just hit the rail after DJ Sharma hit a set of sevens to crack jacks for Peterson and suited overs for Yamagishi.
Player
Chips
Progress
Colten Yamagishi
0
0
Nicholas Peterson
0
0
First Bust of the Day Posted Monday 4th December, 2023 at 13:23(UTC-7) by Lyle Bateman
It was a quick day today for Hugh Armstrong who jumped into the SHR this morning, but he didn't survive long with his 17 big blinds to start the day and he was the first exit from the field today.
Player
Chips
Progress
Nicholas Peterson
50,000
0
Hugh Armstrong
0
0
22 Entries for Super High Roller Posted Monday 4th December, 2023 at 13:16(UTC-7) by Lyle Bateman
Level 13: 1500/3000/3000 Entries: 12/22
There were a couple of extra entries this morning to bring the total to 22 entries with 12 players still alive and battling. Action is now underway in Level 13, and they'll play today until a winner is decided.
Mike Kim Leads After Day 1 Posted Monday 4th December, 2023 at 05:15(UTC-7) by Lyle Bateman
Mike Kim Pictured in the Main Event
The Super High Roller stacks are in and Mike Kim is leading the way into Dat 2 with more than 300k. The next biggest stack belongs to Johnny Yu but he has barely half the chips of Kim.
Entries are open on this one until the start of Day 2 so I expect a few more players to jump into this one before the cards go in the air tomorrow. It's likely I'll be late to the floor as the Main Event finished pretty late, but I should be around shortly after the start.
Table
Seat
Player
Chips
8
6
Eric Wasylenko
37,500
8
2
Ali Khani
81,000
9
2
David Quang
67,500
8
5
Daniel Lefebvre
72,000
8
4
Andrew Goertz
46,000
10
5
DJ Sharma
110,000
10
7
Josh Starborn
67,000
10
2
Johnny Yu
163,500
9
8
Mikw Kim
305,500
9
7
Colten Yamagisho
50,000
20 Entries on Day 1 Posted Monday 4th December, 2023 at 00:11(UTC-7) by Lyle Bateman
10 players remain from the 20 entries to enter today. I still don't have the stacks yet, and entries are open until the start of day tomorrow. I'll publish the Day 1 stacks and Day 2 seats later after the Main Event ends.
Dinner Time Posted Sunday 3rd December, 2023 at 19:10(UTC-7) by Lyle Bateman
Level 6: 300/600/600 Entries: 8/13
The Super High Rollers are off for their dinner break with 13 entries and 8 players still alive. They'll be back at the felt in about 25 minutes for Level 7 with blinds at 400/800/800 and an average stack of just over 100 big blinds.
13 High Roller Entries Posted Sunday 3rd December, 2023 at 18:28(UTC-7) by Lyle Bateman
Level 6: 300/600/600 Entries: 8/13
There are 13 entries for the Super High Roller now with 8 players at the tables. I expect the numbers to grow in the SHR slowly as the night goes on, as I suspect some people who might have played it are over in the $340 Freezeout and plan to enter this one later once that one is finished.
Full Table Posted Sunday 3rd December, 2023 at 16:41(UTC-7) by Lyle Bateman
Level 3: 200/300/300 Entries: 9/10
There is one full table of players in the Super High Roller now with 10 entries and 9 players at the felt. A dealer is waiting to open a new table if they get another player in the game, but for the time being, the 9 players are sitting on a single full table.
There are just under 10 minutes to play until the first break of the day.
Nearly a Full Table Posted Sunday 3rd December, 2023 at 15:58(UTC-7) by Lyle Bateman
Level 2: 100/200/200 Entries: 7/8
They are up to 8 entries in the Super High Roller now, but only 7 players in action right now. There are just over 10 minutes left in Level 2.
Seven High Rollers Posted Sunday 3rd December, 2023 at 15:15(UTC-7) by Lyle Bateman
Level 1: 100/100/100 Entries: 7/7
The High Roller field is up to 7 now with about 15 minutes to play in Level 1.
Super High Rollers in Action Posted Sunday 3rd December, 2023 at 15:13(UTC-7) by Lyle Bateman
The Super High Roller is now underway with 6 players in their seats to start. Entries are open throughout today and up until Day 2 begins tomorrow.
14:58 (UTC-7)
Day 1 of Tournament of Champions Started Level:Blinds: 0/0 Ante: 0
Late Start for the Super High Roller Posted Sunday 3rd December, 2023 at 14:39(UTC-7) by Lyle Bateman
The Super High Roller is still waiting to get started with 4 players in the field so far. They are waiting for a fifth entry before they start the game, so the action is still waiting.
High Rollers Hit the Felt Posted Sunday 3rd December, 2023 at 12:41(UTC-7) by Lyle Bateman
It's the final day of entries here for the 2023 Pure Poker Tour. There will still be poker action tomorrow as the Main Event and the Super High Roller finish, but entries for those are already closed, or will be closing before the start of Day 2 for High Roller game. A few players may well enter this one tomorrow morning before the action begins, but most of the entry action will be happening today.
The game gets going at 2 pm today and players get 50k in chips for their $2,500 buy-in. Blinds are 40 minutes throughout the event and Day 1 plays 12 levels before they bag for the night.
Daniel Lefebvre has been in town for some events this week, and it seems likely we'll see him in this game. He's been running very hot in the big games on the PPT as he's won the last two High Roller games on the Tour so he'll no doubt be looking to go three-for-three.
I'll try to keep an eye on this one a bit today, but most of my attention will be on Day 2 of the Main Event as they play down to the final table.
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.
.
. The 
gave Sharma 2nd pair but ran out to the baby flush for Lefebvre.
this time and made the call.
and DJ Sharma was facing a bet of about 50k from Daniel Lefebvre with a big pot in the middle already. He put in the call, but mucked when Lefebvre showed queen-eight for turned second pair.
as he mucked his hand and sent the uncontested pot to Lefebvre.
and Sharma fired 26k again. Lefebvre called to the 
turn where Sharma bet 46k. Lefebvre flatted to the 
flop. It checked to Sharma on the button, and he stabbed for 26k. Only Lefebvre called to the 
turn and both players checked it to the 
river.
turn, and Sharma check-called for 31k on the 
river, then tank-folded to a shove from the big stacked Lefebvre.
turn and both players checked it through the 
river.
£ GBP
$ USD
€ EUR
