0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour/appt', 1, '2024-04-28')

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.0003 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.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.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.0064 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 `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.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '105'

0.0018 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.0082 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.0006 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
  1. Home
  2. Events
  3. APPT

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 Kickoff: October 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  
UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.