Pure Poker Tour - 2024 PPT Series #4 - Live Updates

0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0074 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-09-26' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/189' ORDER BY `views` DESC

0.0102 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-09-26' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/189'

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` = '189'

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

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

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

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

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

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.

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.