0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

0.0004 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.0005 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.0003 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.0065 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.0006 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.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'appt'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'appt'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = '105'

0.0011 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` = '105' ORDER BY `tour_stops`.`start_date` ASC

0.0113 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.0005 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.0003 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

APPT


Become The Next Asia Pacific Poker Tour Winner!

Whether you were already an Asia Pacific Poker Tour (APPT) fan, or you want to forge new memories at live events across the region, get ready because the APPT is back!

 
 

Upcoming Tour Stops

Wednesday 24th July - Monday 5th August, 2024

APPT Manila 15

Okada Manila, New Seaside Dr, Parañaque, 1701 Metro Manila, Philippines

Get ready for APPT Manila 15, an incredible poker experience brought to you by PokerStars. Hosted at the Okada Manila, a premier entertainment space, the Asia Pacific Poker Tour is back for another year of fun.

APPT Manila 2024 - PHP119 Million Guaranteed (Over $2 Million)

Okada Kickoff: July 24-25 - 16,500 PHP (PHP 3 million GTD)

APPT Open: July 25-28 - 60,000 PHP (PHP 20 million GTD)

APPT National: July 27-31- 40,000 PHP (PHP 10 million GTD)

APPT Super High Roller: July 31-August 1 - PHP500,000

APPT Freezeout Challenge: August 1 (PHP1,000,000 GTD)

APPT Main Event: August 1-5 - PHP80,000 (PHP55 million GTD)

APPT Single Day High Roller: August 2 - PHP165,000

APPT Mystery Bounty: August 4-5 - PHP40,000 – (PHP5 million GTD)

APPT High Roller: August 4-5 - PHP250,000 (PHP10 million GTD)

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

    Find Hotels, Flights & More       View Complete Schedule  

Friday 18th - Sunday 27th October, 2024

APPT Manila Championship

Okada Manila, New Seaside Dr, Parañaque, 1701 Metro Manila, Philippines

There is also the APPT Manila Championship taking place in October, including the Main Event and Super High Roller Championship.

APPT Manila Championship - PHP140 Million Guaranteed (Over $2.5 Million)

Okada KickoffOctober 18-19 - PHP25,000 (PHP10 million GTD) 

APPT Open Championship: October 19-23 - PHP90,000 (PHP25 million GTD)

APPT National Championship: October 21-24 - PHP60,000 (PHP15 million GTD)

APPT Super High Roller Championship: October 22-24 - PHP700,000

APPT Single Day High Roller:  October 23 - PHP250,000

APPT Main Event Championship: October 23-27 - PHP165,000 (PHP55 million GTD)

APPT Mystery Bounty Championship: October 25-27 - PHP50,000 (PHP10 million GTD)

APPT One Million Challenge Championship: October 26 - PHP1,000,000

APPT High Roller Championship: October 26-27 - PHP300,000  (PHP10 million GTD)

#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  
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.