0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0065 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-09-13'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/179/391/chips'
ORDER BY `views` DESC

0.0006 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/179/391/chips', 1, '2024-09-13')

0.0003 SECONDS: 
SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, 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.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 `tour_stop_blogs`.`id` = '179'

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

0.0247 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0045 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '391'
AND `published` = 1

0.0242 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0041 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '393'
AND `published` = 1

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

0.0053 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '391'
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` = '391'
ORDER BY `busted` ASC, `current_chips` DESC

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

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

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

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

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

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

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2554
Translate
Deerfoot Inn and Casino Event #9: $400 Monster Stack NLH ($330 + $70) Live Reporting - Day 2
Deerfoot Inn and Casino - Live Reporting Event #1: $400 Big 30 Stack ($330 + $70) Event #2:$600 NLH/PLO Mixed ($515 + $85) Event #3: $400 4-Flight ($330 + $70) Event #4: $600 Mystery Bounty ($515 + $85) Event #5: $400 Seniors ($330 + $70) Event #7: $1,000 Two-Day $1k ($875 + $125) Event #8: $500 Progressive Knockout ($420 + $80) 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 ($210 + $40) Event #13: $400 PLO Bounty ($330 + $70) Event #14: $400 Ladies ($330 + $70) Event #16: $250 Big 30 Stack ($200 + $50) Event #15: $2,200 High Roller ($1,965 + $235) Event #6: $400 Black Chip Bounty ($330 + $70)
Current Level 33 Current Day 2
Blinds 200,000/400,000 Ante 400,000
Entries 881 Remaining 1
Prize Pool (CAD) $290,730 First Prize (CAD) $45,940
Day 1A Day 1B Day 2
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Chip Counts - Day 1A
Place Player Chips Progress
1 John Estner 1,140,000 1,100,000
2 Derek Holme 1,120,000 1,080,000
3 Michael Baldwin 1,115,000 1,075,000
4 Lapchi Duong 1,005,000 965,000
5 Qingwei Meng 995,000 955,000
6 Mike St. Pierre-Porter 960,000 920,000
7 Matthew Clark 890,000 850,000
8 TRyan Callahan 785,000 745,000
9 Daiel O'Leary 655,000 615,000
10 Abe Shawile 630,000 590,000
11 Jerry Nelner 585,000 545,000
12 Ron Schindelheim 560,000 520,000
13 Tedde Ballanger 550,000 510,000
14 Kyle Cook 375,000 335,000
15 Steve Desjarlais 200,000 160,000
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.