0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0081 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-05-19' AND `url` = 'https://www.maineventtravel.com/tour/wpt-prime' ORDER BY `views` DESC

0.0087 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-05-19' AND `url` = 'https://www.maineventtravel.com/tour/wpt-prime'

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.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0063 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.0004 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.0005 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.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'wpt-prime'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'wpt-prime'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = '138'

0.0013 SECONDS:
SELECT tour_stops.*, 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_stops` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE tour_stops.end_date > CURDATE() AND tour_stops.active = 1 AND `tour_id` = '138' ORDER BY `tour_stops`.`start_date` ASC

0.0081 SECONDS:
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name` FROM `news_articles` LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id` WHERE `news_articles`.`active` = '1' ORDER BY `news_articles`.`date` DESC

0.0008 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` = 'news'

0.0006 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0004 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

WPT Prime


The evolution of the World Poker Tour® continues with the launch of WPT® Prime, which pairs the premier poker tournament experience of a WPT Main Tour stop with affordable buy-ins accessible to more players around the globe.

Just like Main Tour players, WPT Prime players can expect action clocks, winner trophies, and in-depth event coverage from the WPT digital content team. WPT Prime Main Events will also contribute towards the WPT Player of the Year leaderboard, which will award $30,000 in prizes at the end of Season XX.

WPT, World Poker Tour and Spade Card Design are registered trademarks of WPT Enterprises, Inc. All Rights Reserved.

Upcoming Tour Stops

Friday 31st May - Monday 10th June, 2024

WPT Prime Sanremo

Casino Sanremo, Corso degli Inglesi, 18, Sanremo, Italy

€1100 Buy In 

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 15th - Monday 19th August, 2024

WPT Prime Taiwan

Asia Poker Arena, 10491, Taiwan, Taipei City, Zhongshan District, Section 1, Jianguo N Rd, 80?b1

Buy-in: TWD 33000

Win Back Up to 100% of Your Tournament Travel Costs - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 11th - Monday 16th September, 2024

WPT Prime UK

Dusk Till Dawn, Redfield Way, Boulevard Retail Park, Lenton, Nottingham, NG7 2UW

Buy-in: £1100

#FinalTableFreeroll Eligible Event - Click Here for Details on How You Can Win Back 100% of Your Tournament Travel Costs

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 26th - Monday 30th September, 2024

WPT Prime Liechenstein

Grand Casino Liechtenstein, Selemad 10, 9487 Gamprin, Liechtenstein

Buy-in: CHF 1100

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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.