0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0074 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-may-wsopc-calgary-event-11/1C/chips'
ORDER BY `views` DESC

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024-may-wsopc-calgary-event-11/1C/chips', 1, '2024-11-22')

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.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.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.0037 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0005 SECONDS: 
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024-may-wsopc-calgary-event-11'

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '125'

0.0346 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0101 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '299'
AND `published` = 1

0.0405 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0105 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '301'
AND `published` = 1

0.0501 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0072 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '304'
AND `published` = 1

0.0291 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0060 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '306'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '125'
AND `name` = '1C'

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

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

0.0060 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` = '304'
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` = '13447'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0301 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13419'
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` = '13418'
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` = '13415'
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` = '13410'
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` = '13409'
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` = '13408'
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` = '13407'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13405'
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` = '13398'
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` = '13386'
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` = '13397'
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` = '13396'
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` = '13395'
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` = '13394'
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` = '13393'
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` = '13392'
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` = '13391'
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` = '13390'
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` = '13384'
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` = '13383'
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` = '13382'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13379'
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` = '13378'
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` = '13376'
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` = '13375'
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` = '13374'
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` = '13373'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2445

    

Open Modal

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.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(1)
  • 888poker UK Poker League(0)
  • APAT(2)
  • APPT(1)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(0)
  • Aspers Casino Westfield Stratford City(3)
  • Battle Of Malta(0)
  • Borgata Poker(0)
  • Bratislava Poker Festival(0)
  • British Poker Series(5)
  • BSOP(1)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(3)
  • EPT(4)
  • Estrellas Poker Tour(0)
  • Eureka Poker Tour(1)
  • France Poker Series(0)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(5)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(1)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(8)
  • Kings of Tallinn(0)
  • Kings of Vilnius(1)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(13)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Festival(1)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • UKIPT(0)
  • Unibet DeepStack Open(3)
  • Venetian Deepstack Extravaganza(3)
  • Women's Winter Festival(1)
  • WPT(4)
  • WPT Prime(2)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(16)
  • WSOP International Circuit(4)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(0)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

WSOPC Deerfoot Inn & Casino Event #11: $1,700 Main Event ($1,515 + $185) Live Reporting - Day 2

WSOPC Deerfoot Inn & Casino - Live Reporting

Event #11: $1,700 Main Event ($1,515 + $185) See other events

Event #1: $400 Big 30 Stack ($330 + $70) Event #2 $800 NLH/PLO Mix ($700 + $100) Event #3: $400 4-Flight ($330 + $70) Event #4: $600 Mystery Bounty ($515 + $85) Event #5: $400 Seniors ($330 + $70) Event #6: $400 Black Chip Bounty ($230 + $100 + $70) Event #7: $1,000 1k ($875 + $125) Event #8: $400 PLO ($330 + $70) Event #9: $400 Monster Stack ($330 + $70) Event #10: $1,000 1k Turbo ($875 + $125) Event #11: $1,700 Main Event ($1,515 + $185) Event #12: $250 Flip & Go ($210 + $40) Event #13: $400 PLO Bounty ($330 + $70) Event #14: $400 Ladies ($330 + $70) Event #15: $2,200 High Roller ($1,965 + $235) Event #16: $400 Big 30 Stack ($330 + $70) WSOP Main Event Satellite

WSOPC Deerfoot Inn & Casino - Live Reporting Event #1: $400 Big 30 Stack ($330 + $70) Event #2 $800 NLH/PLO Mix ($700 + $100) Event #3: $400 4-Flight ($330 + $70) Event #4: $600 Mystery Bounty ($515 + $85) Event #5: $400 Seniors ($330 + $70) Event #6: $400 Black Chip Bounty ($230 + $100 + $70) Event #7: $1,000 1k ($875 + $125) Event #8: $400 PLO ($330 + $70) Event #9: $400 Monster Stack ($330 + $70) Event #10: $1,000 1k Turbo ($875 + $125) Event #11: $1,700 Main Event ($1,515 + $185) Event #12: $250 Flip & Go ($210 + $40) Event #13: $400 PLO Bounty ($330 + $70) Event #14: $400 Ladies ($330 + $70) Event #15: $2,200 High Roller ($1,965 + $235) Event #16: $400 Big 30 Stack ($330 + $70) WSOP Main Event Satellite

---

Current Level 35 Current Day 2

---

Blinds 300,000/600,000 Ante 600000

Entries 911 Remaining 1

---

Prize Pool (CAD) $CAD1,380,165 First Prize (CAD) $CAD228,734

Chip Leaders Day 2

1	Nicholas Teeuwen		36,400,000
2	David Labchuk		4,800,000

Day 1A Day 1B Day 1C Day 2

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Chip Counts - Day 1C

Place	Player		Chips	Progress
1	Nate Drury		1,300,000	1,260,000
2	Qi Xi Huang		1,275,000	1,235,000
3	Kenneth Der		876,000	836,000
4	Nohad Teliani		650,000	610,000
5	Thomas Taylor		645,000	605,000
6	Ryan Down		629,000	589,000
7	Chaudhary Faisal		586,000	546,000
8	DJ Sharma		539,000	499,000
9	Ki Nam		537,000	497,000
10	Paul Brar		534,000	494,000
11	Dustin Centanni		529,000	489,000
12	Pav Braich		518,000	478,000
13	Aaron Quon		514,000	474,000
14	David Labchuk		510,000	470,000
15	Joon 'Huge Hammer' Park		508,000	468,000
16	Darlene Lee		494,000	454,000
17	Varanpreet Sidhu		493,000	453,000
18	Jeff Bryde		465,000	425,000
19	Trevor Shishkin		463,000	423,000
20	Shawn Taghavi		461,000	421,000
21	Jack Hardcastle		417,000	377,000
22	Cody McKay		360,000	320,000
23	Manfred Gunter		356,000	316,000
24	Hua Zang		332,000	292,000
25	Julius Roque		331,000	291,000
26	Kwong Shing Au		313,000	273,000
27	Glenn Tarasoff		310,000	270,000
28	Tyler Panas		300,000	260,000
29	Bryan Maenevin		270,000	230,000
30	Tyler Hurman		269,000	229,000
31	Jolnar Teliani		255,000	215,000
32	Duff Charette		249,000	209,000
33	Jason Heang		240,000	200,000
34	Roman Gallivan		239,000	199,000
35	Andrew Goosen		233,000	193,000
36	Benjamin Veinstin		228,000	188,000
37	Tedde Ballanger		213,000	173,000
38	Shane Chief		201,000	161,000
39	Chris Clisby		195,000	155,000
40	Hari Aujla		180,000	140,000
41	Griffin Ristevski		173,000	133,000
42	Leslie Sam		173,000	133,000
43	Mark Inglis		172,000	132,000
44	Johnny Yu		144,000	104,000
45	Robert Dore		122,000	82,000
46	Eric Davis		71,000	31,000
47	Tuan Luu		61,000	21,000

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter