0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0064 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-wsopc-calgary-jan-event11-main/3/payouts'
ORDER BY `views` DESC

0.0088 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-wsopc-calgary-jan-event11-main/3/payouts'

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

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

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

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

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

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

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

0.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.0001 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.0063 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.0004 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-wsopc-calgary-jan-event11-main'

0.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '67'

0.0233 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0046 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '188'
AND `published` = 1

0.0232 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0042 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '189'
AND `published` = 1

0.0363 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` = '192'
AND `published` = 1

0.0241 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0046 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '193'
AND `published` = 1

0.0434 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0033 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '197'
AND `published` = 1

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '67'
AND `name` = '3'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2148
English
WSOPC Canada - Calgary Event #11: $1,700 Main Event ($1,515 + $185) Live Reporting - Day 3
WSOPC Canada - Calgary - Live Reporting Event #1: $400 Big 30 Stack ($330 + $70) Event #2: $600 PLO ($515 + $85) Event #3: $400 4-Flight ($330 + $70) Event #5: $400 Seniors ($330 + $70) Event #6: $400 Black Chip Bounty ($330 + $70) Event #7: $1,000 Two-Day $1k ($875 + $125) Event #8: $400 PLO Monster Stack ($330 + $70) Event #9: $400 Monster Stack NLH ($330 + $70) Event #10: $1,000 1k Turbo ($875 + $125) Event #11: $1,700 Main Event ($1,515 + $185) Event #12: $250 Flip & Go ($205 + $45) Event #13: $400 PLO Bounty ($330 + $70) Event #15: $250 Big 30 Stack ($200 + $50) Event #4: $600 Mystery Bounty ($515 + $85) Event #14: $2,200 High Roller ($1,965 + $235)
Current Level 33 Current Day 3
Blinds 150,000/300,000 Ante 300000
Entries 1,475 Remaining 1
Prize Pool (CAD) $CAD2,234,838 First Prize (CAD) $CAD334,891
Day 1A Day 1B Day 1C Day 2 Day 3
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Payouts
Place Player Prize (CAD)
1 Zhun (Singh) Chen $CAD334,891
2 Husanain Al Ghunaim $CAD206,978
3 Zofino Xavier $CAD158,104
4 Tommy Nguyen $CAD121,729
5 Garett Maybery $CAD94,473
6 Arif Dhalla $CAD73,911
7 Jackson Oniske $CAD58,295
8 Sopheak (Jason) Heang $CAD46,355
9 Sunny Lubana $CAD37,165
10 Lonnie Hallet $CAD30,046
11 Michael Mcwhirter $CAD30,046
12 Mark Aylward-Nally $CAD30,046
13 Makaya Wagabaza $CAD24,494
14 Graeme Frank $CAD24,494
15 Jorge Artiga-Pacheco $CAD24,494
16 Matt Hall $CAD20,138
17 Gordon Wong $CAD20,138
18 Danny Bajaj $CAD20,138
19 Ashkan Razavi $CAD16,698
20 Antonio De La Cruz $CAD16,698
21 Zeyu Huang $CAD16,698
22 Paul (Jaspal) Brar $CAD13,965
23 Matthew O'Brien $CAD13,965
24 Jacob Hobday $CAD13,965
25 Cindy Kerslake $CAD11,781
26 Aidan Tiefenbach $CAD11,781
27 Regan Duong $CAD11,781
28 Pavlo Vertiiko $CAD10,025
29 Colten Yamagishi $CAD10,025
30 Ahmed Edali $CAD10,025
31 Aleksei Ponomarev $CAD8,607
32 Colin Burton $CAD8,607
33 Joel Bullock $CAD8,607
34 David Quang $CAD7,455
35 Peter Griffin $CAD7,455
36 Weiping Gu $CAD7,455
37 Denys Chufarin $CAD6,516
38 Hui Li $CAD6,516
39 Rob Lothian $CAD6,516
40 Skyler York $CAD6,516
41 Bo Mitic $CAD6,516
42 Mehdi 'GitAndSos' Saeed $CAD6,516
43 Elliot Smith $CAD6,516
44 Anthony Williams $CAD6,516
45 Ricky Chow $CAD6,516
46 Shane Brotherwood $CAD5,747
47 Jay Glass $CAD5,747
48 Zbigniew Paszkowski $CAD5,747
49 Ali Razzaq $CAD5,747
50 Aamir Khan $CAD5,747
51 Nikolas Fabisiak $CAD5,747
52 Morgan Mclellan $CAD5,747
53 Sergei Gurin $CAD5,747
54 Josef Rosenthal $CAD5,747
55 Denton Wierzba $CAD5,115
56 Kelsey Korchinski $CAD5,115
57 Derek Dufour $CAD5,115
58 Andy Truong $CAD5,115
59 Xiao Ma $CAD5,115
60 Evan Horton $CAD5,115
61 Bash Ramahi $CAD5,115
62 Alex Bylicki $CAD5,115
63 Anders Povirk $CAD5,115
64 Christopher Alcindor $CAD4,595
65 Darnell Lewis $CAD4,595
66 Joel Kogan $CAD4,595
67 Naleen Narayan $CAD4,595
68 Jacob Johnstone $CAD4,595
69 Joseph Galle $CAD4,595
70 Allen Shen $CAD4,595
71 Jeffrey Reardon $CAD4,595
72 Gordon Goble $CAD4,595
73 Fraser 'Big Papi' Short $CAD4,166
74 Darcy Mcdonald $CAD4,166
75 Alemu Makonen $CAD4,166
76 Darlene Lee $CAD4,166
77 George Broumas $CAD4,166
78 Steven Desjarlais $CAD4,166
79 Ye Zhang $CAD4,166
80 Keagan Ballard $CAD4,166
81 Doug James $CAD4,166
82 Ryan Bierman $CAD3,813
83 Joon Park $CAD3,813
84 Shawn Leis $CAD3,813
85 Paul Sokoloff $CAD3,813
86 Thariq Ali $CAD3,813
87 Naomi Raznavi $CAD3,813
88 Shane Mchugh $CAD3,813
89 Stephen Dauphinais $CAD3,813
90 Eric Davis $CAD3,813
91 Chun-Tat Fu $CAD3,523
92 Ian Modder $CAD3,523
93 Christian Wallmuth $CAD3,523
94 Marco Carreira $CAD3,523
95 Leonardo Song-Carrillo $CAD3,523
96 Matthew Piasecki $CAD3,523
97 Peggy Malinowski $CAD3,523
98 Joey Basaraba $CAD3,523
99 Tony Le $CAD3,523
100 Rick Andreychuk $CAD3,286
101 Teo Sancez $CAD3,286
102 Robert Taylor $CAD3,286
103 James Sullivan $CAD3,286
104 Michael Khan $CAD3,286
105 Robert Wong $CAD3,286
106 Micheal Letal $CAD3,286
107 Morgan Davies $CAD3,286
108 Sean Taylor $CAD3,286
109 Cole Neufeld $CAD3,286
110 Benjamin Cooper $CAD3,286
111 Hien Vo $CAD3,286
112 Duff Charette $CAD3,286
113 Kyle Crego $CAD3,286
114 Martinus Kaspers $CAD3,286
115 Nicholas Milkovich $CAD3,286
116 Ha Van Nguyen $CAD3,286
117 Jackson Yang $CAD3,286
118 Robert Kliss $CAD3,286
119 Leanne Brown $CAD3,286
120 Joshua Clark $CAD3,286
121 Shawn Blair $CAD3,286
122 Jeremy Harper $CAD3,286
123 Jeff 'Ironman' Charlebois $CAD3,286
124 Darrell Moore $CAD3,286
125 Jolan Mancini $CAD3,286
126 Michael Farrow $CAD3,286
127 Michael Bernstein $CAD3,095
128 Lina Niu $CAD3,095
129 Shariq Khan $CAD3,095
130 Patrick 'Egptiom' Tardif $CAD3,095
131 Donald Cowie $CAD3,095
132 Yiwei Zhou $CAD3,095
133 Curtis Belliveau $CAD3,095
134 Jimmy Lee $CAD3,095
135 Dominick French $CAD3,095
136 Ran Yi $CAD3,095
137 Brandon Wammes $CAD3,095
138 Trent Sapach $CAD3,095
139 Aaron Gooden $CAD3,095
140 Faisal Al Qutub $CAD3,095
141 David Labchuk $CAD3,095
142 Ying Xi Zhang $CAD3,095
143 Nicholas Teeuwen $CAD3,095
144 Gordon Johnson $CAD3,095
145 Haven Taylor $CAD3,095
146 Rahul Sharm $CAD3,095
147 Clinton Cockburn $CAD3,095
148 Jonathan Camar $CAD3,095
149 Maxim Kogay $CAD3,095
150 Marc Lavergne $CAD3,095
151 Gabriel Croteau $CAD3,095
152 Jason Tran $CAD3,095
153 Dean May $CAD3,095
154 Matthew McLeish $CAD2,944
155 Gilbert Anderson $CAD2,944
156 Hassan Issa $CAD2,944
157 Adam Macsween $CAD2,944
158 Xinia Ketilson $CAD2,944
159 James Worth $CAD2,944
160 Mike Leah $CAD2,944
161 Tyler Panas $CAD2,944
162 Richard Mullen $CAD2,944
163 Sam Raz $CAD2,944
164 Don Lee $CAD2,944
165 Robert De la Cruz $CAD2,944
166 John Nielson $CAD2,944
167 Takumja Bergeron $CAD2,944
168 Taran Parmar $CAD2,944
169 Chris Hak $CAD2,944
170 Tyler Filz $CAD2,944
171 Warren Chu $CAD2,944
172 Graham Lupton $CAD2,944
173 Francis Fan $CAD2,944
174 Joshua Hopkins $CAD2,944
175 Eric Wallace $CAD2,944
176 Oleksandr Lobor $CAD2,944
177 Jayvee Lumahan $CAD2,944
178 Mario Lim $CAD2,944
179 Jodie Dunfiel $CAD2,944
180 Jonathan Yueh $CAD2,944
181 Dylan Boyer $CAD2,828
182 Leonard Little $CAD2,828
183 Paul (Palvinder) Brar $CAD2,828
184 Thi Ngo $CAD2,828
185 Dylan Payne $CAD2,828
186 Zennawi Petros $CAD2,828
187 Eric Wasylenko $CAD2,828
188 Dustin Stone $CAD2,828
189 Toufic Chehayer $CAD2,828
190 Simon Beaudoin $CAD2,828
191 Wayne Kelly $CAD2,828
192 Cody Cloutier $CAD2,828
193 Deven Lane $CAD2,828
194 Joshua Hoeber $CAD2,828
195 Lee Clark $CAD2,828
196 Jeremy Doll $CAD2,828
197 Ernest Martens $CAD2,828
198 Homan Mohammadi $CAD2,828
199 Pasquale Dicosmo $CAD2,828
200 Nicholas Peterson $CAD2,828
201 Jason Mcarthur $CAD2,828
202 Richard Hoffman $CAD2,828
203 Yu Liu $CAD2,828
204 Cody Mckay $CAD2,828
205 Donald Hart $CAD2,828
206 Prabakaran Sivabalasundaram $CAD2,828
207 Anthony Smith $CAD2,828
208 San Hwang $CAD2,744
209 Said Michailidis $CAD2,744
210 Raghav Sharma $CAD2,744
211 Arvhin Malinab $CAD2,744
212 Michael Campitelli $CAD2,744
213 Bradley Jackel $CAD2,744
214 Evan Casey $CAD2,744
215 Xinwei Jiang $CAD2,744
216 Paul Weenusk $CAD2,744
217 Mathieu Arseneau $CAD2,744
218 Daniel Lefebvre $CAD2,744
219 Eun Park $CAD2,744
220 Satoshi Taguchi $CAD2,744
221 Irtiza Malik $CAD2,744
222 Ryan Simmons $CAD2,744
223 Mason St Martin $CAD2,744

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
Your search results are valid for . More 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.