0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0122 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-13'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/179/391/updates'
ORDER BY `views` DESC
0.0004 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.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '179'
0.0271 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0078 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '391'
AND `published` = 1
0.0302 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0051 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '393'
AND `published` = 1
0.0248 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0051 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '394'
AND `published` = 1
0.0057 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_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` = '391'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '16874'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 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.0058 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.0058 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.0055 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.0049 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.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` = '16874'
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` = '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.0058 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.0056 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.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2554
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
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
Deerfoot Inn and Casino
Event #9: $400 Monster Stack NLH ($330 + $70)
Live Reporting - Day 2
289 Entries for First Monster Flight Posted Wednesday 14th August, 2024 at 02:56(UTC-8) by Lyle Bateman
John Estner leads the way into Day 2 after the opening salvo at the Monster Stack. He was one of four players to bag just over 1 million while Quinwei Meng rounds out the top five stack as close a million as possible without hitting it. Full counts for the advancing players are posted in Chip Counts.
289 entries meant they got just shy of $100k in prizes for Day 1a and 44 players were set to get a piece of it. The top 15 stacks went through to Day 2, but 44-16 got paid out tonight -- See below for a look at who cashed Day 1a.
Cashing Players for Day 1a of the Monster Stack
Place
Player
Hometown
Prize
16
Prabhsimran Cheema
Surrey, Bc
$950
17
David Molloy
Calgary, Ab
$950
18
Lorne Willmet
White Rock, Bc
$846
19
Xinrui Cui
Edmonton, Ab
$846
20
Nicholas Peterson
Courtenay, Bc
$846
21
Al Idriess
Calgary, Ab
$846
22
Ragnar Parn
Revelstoke, Bc
$846
23
Frederic Parsons
Kamloops, Bc
$846
24
Fat Wong
Calgary, Ab
$846
25
Christopher Hodgins
Calgary, Ab
$846
26
Ksenia Shuali
Vancouver, Bc
$846
27
Gaetano Buda
Kleinburg, On
$806
28
Cristituto Costales
Edmonton, Ab
$806
29
Joshua Mammon
Richmond, Bc
$806
30
Marc Kudjick
Quebec
$806
31
Johnson Phanyaseng
Waterloo, On
$806
32
Adam Lamers
Calgary, Ab
$806
33
Terrel Gaskin
Edmonton, Ab
$806
34
Lawrence Gerrard
Okotoks, Ab
$806
35
Robert Limpert
Grande Prarie, Ab
$806
36
Don Fujita
Calgary, Ab
$806
37
Mei Ge
Vancouver, Bc
$806
38
Robert Murphy
Surrey, Bc
$806
39
Shawn Blair
Toronto, On
$806
40
Julius Roque
Lethbridge, Ab
$806
41
Kevin Wilson
Chilliwack, Bc
$806
42
Kam Lee
Calgary, Ab
$806
43
Qi Luo
Winnipeg, Mb
$806
44
Chad Riddell
Calgary, Ab
$806
Player
Chips
Progress
John Estner
1,140,000
0
Derek Holme
1,120,000
0
Michael Baldwin
1,115,000
0
Lapchi Duong
1,005,000
0
Qingwei Meng
995,000
0
255 Entries in Level 8 Posted Tuesday 13th August, 2024 at 14:12(UTC-8) by Lyle Bateman
There are 255 entries in the game so far today with about 3 hours left to enter today's flight. The current prizes are just shy of $85k and it's likely that will push near $100k before entries shutter for the day with at least that much added again tomorrow.
I won't be watching much of this one today as I'll be over in Chrome for the $1k action, but I'll update numbers, Day 1 cashes, and qualifying stacks at the end of the night, and I should be on the floor for most of Day 1b tomorrow.
14:10 (UTC-8)
Day 1A of Deerfoot Inn and Casino Started Level: 8 Blinds: 600/1,200 Ante: 1,200
Who Will Tame this Circuit Monster? Posted Tuesday 13th August, 2024 at 03:02(UTC-8) by Lyle Bateman
Event #9:
$400 Monster($330 + $70)
Date:
Day 1a: Aug 13, 2024, 11 am Day 1b: Aug 14, 2024, 11 am Day 2: Aug 15, 2024, noon
Blinds:
30/45 Min
Start Stack:
40,000
Late Entry:
12 Levels (~6:15 pm)
Day 1 Ends:
24 Levels (~12:45 am) or 5% of Field
The Monster is coming over the hill! Tuesday marks the opening flight of the Monster Stack with action getting underway at 11 am. Wednesday is a repeat of Tuesday for Day 1b.
Players get a monster 40k stack to start the day, and Day 1 levels will play for 30 minutes. Players have 12 levels of poker to buy in or rebuy, and, including breaks, that should put the last chance to enter each Day 1 flight at about 6:15 pm. Day 1 will play for a maximum of 24 levels with a hard stop at about 12:45 am, but they'll bag up early if the field hits 5% earlier than that. This will be a Day 1 payout out event, so players who finish between 15% and 5% will get some money as they leave.
I won't likely have eyes on Day 1a of this one, except to report numbers and the final results and stacks at the end of the day as my main Tuesday focus is Day 2 of the $1k followed by the Turbo $1k. However, I should be around for most of Wednesday's Day 1b and all of Day 2 on Thursday.
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.