0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

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

0.0066 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.0003 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.0002 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.0010 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.0070 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.0004 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

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       View Complete Schedule  

Friday 15th - Monday 25th November, 2024

Cambodia

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

Mark your calendar for another unforgettable experience at NagaWorld Integrated Resort in Phnom Pehn.

Get ready to explore a city that’s rich in history thanks to its unique landmarks, from the Royal Palace to the Independence Monument. Of course, Cambodia is also famous for its poker, which is why we’re excited to welcome you back to a world-class venue that knows how to put on a show.

APPT NagaWorld Kickoff: November 15-16, 2024 - $400 ($50,000 GTD)

APPT National: November 16-19 - $900 ($150,000 GTD)

APPT Mystery Bounty: November 18-20, 2024 - $600 ($100,000 GTD)

APPT Cambodia Super High Roller: November 20-21, 2024 - $10,000

APPT Cambodia Main Event: November 21-25, 2024 - $1,650 ($500,000 GTD)

APPT High Roller: November 24-25, 2024 - $5,000 ($200,000 GTD)

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  
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.