0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0091 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-09' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-ppt4' ORDER BY `views` DESC

0.0117 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-09' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-ppt4'

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.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.0003 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.0061 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-ppt4'

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

0.0272 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0058 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '405' AND `published` = 1

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

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '189' AND `name` = '2024-PPT-4-Series'

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

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

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` = '17522' 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` = '17391' 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` = '405' ORDER BY `busted` ASC, `current_chips` DESC

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

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

0.0003 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2616

English
Pure Poker Tour - 2024 PPT Series #4 PPT Series #4 Live Reporting - Day 2024-PPT-4-Series

Current Level 0 Current Day 2024-PPT-4-Series
Blinds - Ante -
Entries 0 Remaining 0
Prize Pool (CAD) $0 First Prize (CAD) $0
1 New Update - Click to refresh
Live Updates - Day 2024-PPT-4-Series
PPT #4 is Dedicated to the Memory of Ryan Snyder Posted Friday 20th September, 2024 at 17:17(UTC-7) by Lyle Bateman

In light of the devastating news about our friend and fellow player Ryan "Snides" Snyder, Joanne and the PPT staff have decided to dedicate this series to his memory. While the official announcement has not yet been made, PPT staff will make the announcement this weekend and plan to have a tribute to Ryan next weekend during the Main Event. All local players are encouraged to come by on Saturday next week for the tribute.

We also realize this is a very difficult time for his family and the emotional burden is huge right now. As such, we want to help a bit with some of the physical burden by helping to raise money for funeral and travel expenses to get Ryan home and properly laid to rest. For those who are able, please visit the GoFundMe page and donate what you can to help Ryan's family during this very difficult time.

Please join me once again in sending our thoughts to Ryan's family; he will be sorely missed by many people.

Pure Poker Tour #4 is On Deck! Posted Friday 13th September, 2024 at 11:32(UTC-7) by Lyle Bateman

It's time for the fourth edition of the Pure Poker Tour for 2024! Trophy events for the series run for 10 days from Sep 19 - Sep 30 with the High Roller closing out the series on the 30th.

Among the highlights of the schedule are the ever-popular 6-Max and 8-Max games, as well as Mixed and PLO Big Bounty action for 4-card lovers. Team lovers will get a chance to party on the opening weekend (there will be poker on the side as well) as that event plays out alongside Day 1b of the Mystery Bounty.

Perhaps the biggest change to the schedule this time around is the addition of the first-ever Flip & Go game on the PPT. Flip rounds start right from the opening day with Day 2 action scheduled for Wed, Sep 25. The Flip rounds are crazy pineapple with players all-in before the flop. There is a discard round on the flop and then the rest of the board runs out to determine a winner. Players can play multiple flips and take more than one stack to Day 2.

Players who win one flip on the 8-handed tables will start Day 2 with 160k, or 80 big blinds. All players on Day 2 are in the money, and Day 2 plays out as a regular MTT format with the added bonus of a guaranteed payout. There will be six days of flip rounds before Day 2 on Wednesday, and flips will be running throughout each day once 8 players register.

For players who love the flip variance and quick action, there will also be single hand flip satellites to the Main Event running throughout the series making for a quick way to win your set to the Main. Follow along with my live reporting for PokerPro, powered by Main Event Travel, for details on all 16 trophy events over the next couple of weeks.


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.