0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0061 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-16' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/113' ORDER BY `views` DESC

0.0013 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/113', 1, '2024-07-16')

0.0005 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` = '113'

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '113'

0.0212 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` = '279' AND `published` = 1

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

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

0.0044 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` = '12363' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 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` = '12345' ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0045 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` = '12363' 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` = '12345' ORDER BY `chip_change` DESC, `busted` ASC

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

Translate
2024 PPT Series #2 Event #11: $2,000 High Roller ($1,600 + $200) Live Reporting - Day 1
1 New Update - Click to refresh
Live Updates - Day 1
High Roller Start Delayed Posted Sunday 14th April, 2024 at 16:32(UTC-7) by Lyle Bateman

The High Roller currently has two entries and the start is delayed as they wait to see if more players are interested. It remains to be seen if the HR will run or not tonight.

High Roller Starts Today Posted Sunday 14th April, 2024 at 13:19(UTC-7) by Lyle Bateman

Event #11: $2,000 High Roller ($1800 + $200)
Apr 14 - 4 PM
Starting Stack: 50k
Blinds: 40 Min
Late Entry: Until Start of Day 2

The first side event on Sunday is the High Roller. For $2,000 players get 50k in chips to play 40-minute levels. Day 1 plays for 9 levels before they bag up to return for the final day on Monday and players can late-reg up until cards go in the air for Day 2.

I'll be watching the endgame of this one tomorrow likely, but I probably won't have much time to watch it today until the Main Event finishes.

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.