0.0006 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0079 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-03-29' AND `url` = 'https://www.maineventtravel.com/tour/appt' ORDER BY `views` DESC

0.0135 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-03-29' 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.0004 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0004 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.0007 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.0042 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.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.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'appt'

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

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` = '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.0007 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.0004 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

Friday 2nd - Tuesday 13th May, 2025

APPT Cambodia

Nagaworld Integrated Resort, Samdach Hun Sen Park, Samdech Techo, Phnom Penh 120101, Cambodia

APPT is back again at the vibrant streets of Phnom Penh as we bring another exceptional poker experience to the first tournament of the series.

Are you ready to claim the first APPT title of the year?

APPT Cambodia 2025 – Over $1.5 Million Guaranteed

NagaWorld Kickoff: May 2-3, 2025 ($50,000 GTD)

Mystery Bounty: May 3-5, 2025 ($100,000 GTD)

APPT National: May 5-7, 2025 ($150,000 GTD)

APPT Main Event: May 8-11, 2025 ($1,000,000 GTD)

Survivor Knockout ($1K Bounty): May 11-12, 2025 ($75,000 GTD)

APPT High Roller: May 11-12, 2025 ($150,000 GTD)

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 23rd July - Monday 4th August, 2025

APPT Manila

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

Brace yourselves for the most-anticipated APPT Event of the Year! Join us as we return to Cove Manila, the biggest and most exciting tournament venue you’ll ever attend in the Philippines.

Think you can seize the title?

Key Dates

APPT Main Event: July 31-August 4 - 80,000

APPT Manila 2025 – Over 140 Million Guaranteed ($2.4 Million)

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

APPT National: July 24-26- 35,000 (10 million GTD)

APPT Open: July 26-28 - 55,000 (15 million GTD)

PokerStars Red Dragon: July 28-30 - 65,000 (20 million GTD)

APPT Super High Roller: July 30-31 - 500,000 (10 million GTD)

APPT One Million Challenge Championship: July 30-August 1 - 1,000,000

APPT Main Event: July 31-August 4 - 80,000 55 million GTD)

APPT Single Day High Roller: August 1 - 200,000

APPT Mystery Bounty: August 3-4 - 40,000 (5 million GTD)

APPT High Roller: August 3-4 - 250,000 (10 million GTD)

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 16th - Monday 27th October, 2025

APPT Manila Championship

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

We’re doubling the fun as APPT Championship returns for its 2nd series! Don’t miss the last APPT event of the year and step up your game by taking home the title for 2025.

Key Dates

APPT Manila Championship - 152.6Million Guaranteed (Over $2.6 Million)

    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.