0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-05-05' AND `url` = 'https://www.maineventtravel.com/tour/asian-poker-tour' ORDER BY `views` DESC

0.0102 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-05-05' 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.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.0038 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.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.0002 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.0076 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.0003 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

Friday 1st - Sunday 10th August, 2025

APT Incheon

Paradise Casino Incheon, Yeongjonghaeannam-ro 321beon-gil, Jung-gu, Incheon, South Korea

The APT Incheon 2025 is running at the prestigious Paradise City resort in partnership with Paradise Group, with the festival packing 96 tournaments (including satellites) into the schedule.

    Find Hotels, Flights & More       View Complete Schedule  

Friday 26th September - Sunday 5th October, 2025

APT Jeju

Landing Casino, Shinhwa World, 304 38 Sinhwayeoksa-ro, South Korea

The schedule has been released. 

    Find Hotels, Flights & More       View Complete Schedule  

Friday 14th - Sunday 30th November, 2025

APT Championship

Asia Poker Arena, 10491, Taiwan, Taipei City, Zhongshan District, Section 1, Jianguo N Rd, 80?b1

Full schedule has been released. 

    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.