0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0063 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-wsopc-calgary-jan-event3-4flight/1A/chips'
ORDER BY `views` DESC

0.0006 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024-wsopc-calgary-jan-event3-4flight/1A/chips', 1, '2024-07-27')

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.0002 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.0002 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.0003 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0004 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0005 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.0002 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.0064 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-event3-4flight'

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

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

0.0742 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0048 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '172'
AND `published` = 1

0.0229 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0037 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '173'
AND `published` = 1

0.0777 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0035 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '174'
AND `published` = 1

0.0227 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0548 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '177'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '59'
AND `name` = '1A'

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

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

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

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` = '7524'
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` = '7510'
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` = '7503'
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` = '7493'
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` = '7488'
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` = '7481'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2148
English
WSOPC Canada - Calgary Event #3: $400 4-Flight ($330 + $70) Live Reporting - Day 2
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 2
Blinds 200,000/400,000 Ante 400000
Entries 1,715 Remaining 2
Prize Pool (CAD) $CAD565,950 First Prize (CAD) $CAD84,909
Day 1A Day 1B Day 1C Day 1D Day 2
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Chip Counts - Day 1A
Place Player Chips Progress
1 Kevin Kammavong 815,000 785,000
2 Dylan Ellis 736,000 706,000
3 Teo Sanchez 497,000 467,000
4 MIke Admussen 495,000 465,000
5 Todd Oakley 491,000 461,000
6 Shane Brotherwood 464,000 434,000
7 Mike Letal 450,000 420,000
8 Bash Ramahi 429,000 399,000
9 Antoine Saddleback 348,000 318,000
10 Tom Lobas 259,000 229,000
11 Andrew Van Graans 212,000 182,000
12 Dilip Lulla 163,000 133,000
13 Trent Hopper 156,000 126,000
14 Michael Collins 95,000 65,000

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.