0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0072 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-10-14' AND `url` = 'https://www.maineventtravel.com/tour/asian-poker-tour' ORDER BY `views` DESC

0.0112 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-10-14' AND `url` = 'https://www.maineventtravel.com/tour/asian-poker-tour'

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

0.0001 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.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` = 'asian-poker-tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'asian-poker-tour'

0.0010 SECONDS:
SELECT * FROM `tours` WHERE `id` = '66'

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

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

English

Asian Poker Tour


The Asian Poker Tour (APT) was founded in 2008. Since its first tournament held in May of 2008 in Manila, Philippines, it has grown year on year to become one of the leading poker tours around the World.

The APT has staged more than 70 major events – and numerous smaller tournaments – mainly in the Asia-Pacific region. The tour has visited the Philippines, Macau, Korea, Cambodia, Vietnam, India, Australia, London, New Caledonia and Cambodia.

To date, APT events combined have generated over $20 Million in prize money.

Upcoming Tour Stops

Monday 28th October - Thursday 7th November, 2024

APT Manila

City of Dreams Manila, Diosdado Macapagal Blvd, Parañaque, Manila, Philippines

KEY EVENTS

  • APT Main Event (PHP 100M/~USD 1.7M GTD): Oct 31-Nov 6 – PHP 85k/~USD 1,510 buy-in
  • Philippines National Cup (PHP 4M/~USD 71k GTD): Oct 28-29 – PHP 12k/~USD 210 buy-in
  • Mystery Bounty Hunter – Sponsored by Natural8 (PHP 6M/~USD 106k GTD): Oct 29-30 – PHP 20k/~USD 355 buy-in
  • APT Super High Roller (PHP 15M/~USD 267k GTD): Oct 30-31 – PHP 600k/~USD 10.6k buy-in
  • APT High Roller (PHP 15M/~USD 267k GTD): Nov 6-7 – PHP 200k/~USD 3.5k buy-in
  • Mini Main Event (PHP 5M/~USD 89k GTD): Nov 6-7 – PHP 25k/~USD 445 buy-in

#FinalTableFreeroll Eligible Events

    Find Hotels, Flights & More       View Complete Schedule  

Friday 8th - Sunday 17th November, 2024

APT Phu Quoc, Vietnam 2024

Corona Resort & Casino Phu Quoc, Bai Dai Area, Ganh Dau Commune, Phu Quoc City, Kien Giang Province, Vietnam

This marks the first APT New Era visit to Phu Quoc following an 18-month hiatus, and the tours third visit overall. 

KEY EVENTS

  • APT Main Event (VND 25BN/~USD 1M GTD): Nov 11-16 – VND 36M/~USD 1,450 buy-in
  • Vietnam National Cup (VND 5BN/~USD 200K GTD): Nov 8-10 – VND 9M/~USD 360 buy-in
  • APT Super High Roller (VND 3BN/~USD 120K GTD): Nov 9 – VND 120M/~USD 4.8K buy-in
  • Sunday Super Stack (VND 1.5BN/~USD 60K GTD): Nov 10 – VND 12M/~USD 480 buy-in
  • Zodiac Classic (VND 2.5BN/~USD 100K GTD): Nov 14-15 – VND 50M/~USD 2K buy-in
  • Baby Superstar: Nov 15 – VND 120M/~USD 4.8K buy-in
  • Double Stack (VND 2.5BN/~USD 100K GTD): Nov 15-16 – VND 11M/~USD 440 buy-in
  • APT High Roller (VND 2.5BN/~USD 100K GTD): Nov 16-17 – VND 80M/~USD 3.2K buy-in
  • Mini Main Event (VND 1.5BN/~USD 60K GTD): Nov 16-17 – VND 12M/~USD 480 buy-in

#FinalTableFreeroll Eligible Events

    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.