0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0074 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-04-26'
AND `url` = 'https://www.maineventtravel.com/tour/lapt'

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

0.0003 SECONDS: 
SELECT *
FROM `tours`
WHERE `page_url` = 'lapt'

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

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

0.0074 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.0006 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
  1. Home
  2. Events
  3. LAPT

LAPT


Be Part Of The Latin American Poker Tour Again!

It's time for the return of live poker tournaments unlike any other on offer in Latin America. The Latin American Poker Tour (LAPT) is back to create more unforgettable tournaments and life-long memories for thousands of players.

 

Upcoming Tour Stops

Wednesday 14th - Wednesday 21st August, 2024

LAPT Mexico City

Casino Royal Yak Hippodrome of the Americas, Av. Industria Militar s/n-Acceso 1, Col. Residencial, Militar, Miguel Hidalgo, 11200 Ciudad de México, CDMX, Mexico

Get ready for the first-ever LAPT México.

That’s right. The LAPT finally heads north to México City this August and will be held at the newly-refurbished Casino Royal Yak Hippodrome of the Americas. Situated in the heart of the city, it’s the perfect place for the LAPT to do its thing in México’s historic capital.

The chance to make history as the first-ever LAPT México champion is calling.

LAPT Main Event: Date TBC – $1,500

LAPT High Roller Single Day 3K: Date TBC – $3,000

LAPT NLH High Roller: Date TBC – $3,000

LAPT NLH 6 Handed Mystery K.O.: Date TBC – $1,000

LAPT NLH High Roller Single Day P.K.O.: Date TBC – $3,000

#FinalTableFreeroll Eligible Event
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Wednesday 9th - Wednesday 16th October, 2024

BSOP - LAPT Rio de Janiero

Windsor Marapendi, Rio de Janiero

The meeting of the two biggest poker events in Latin America BSOP – LAPT, lands in the "wonderful city" to make history! And there is nothing more pleasurable than playing poker surrounded by natural and historical beauties, in the most famous Brazilian city in the world. Rio de Janeiro has hosted other stages of the BSOP and LAPT in previous seasons.

A unique and different city from all the others in the country, with a splendid landscape and unique cultural values, Rio is a tourist and historical landmark with its wonderful beaches, mountains and stories.

LAPT Main Event: Dates TBC – R$ 7,500 ($1,500*)

LAPT Single Day 3K: Dates TBC – R$ 15,000 (*$3,000*)

LAPT NLH High Roller: Dates TBC – R$ 15,000 ($3,000*)

LAPT NLH 6 Handed Mystery K.O: Dates TBC – R$ 5,000 ($1,000 *)

LAPT NLH Single Day High Roller P. K.O.: Dates TBC– R$ 15,000 ($3,000*)

#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  
Tuesday 10th - Sunday 15th December, 2024

LAPT Montevideo

Hotel Sofitel Montevideo Casino Carrasco and Spa, Rambla República de México 6451, 11500 Montevideo, Departamento de Montevideo, Uruguay

A week of non-stop action on the live felt awaits. Whether you’re a newcomer to the game or are competing to become the next LAPT champion, there’s an event to suit all hands – and a player experience like no other.

The event will be held at the stunning Hotel Sofitel Montevideo Casino Carrasco and Spa. Known for its luxury suites and beautiful sea views, it’s the perfect place to relax and unwind while you’re away from the tables.

Will we see you at the final LAPT stop of 2024?

LAPT Main Event: Dates TBC – $1,500

LAPT High Roller Single Day: Dates TBC – $3,000

LAPT NLH High Roller: Dates TBC – $3,000

LAPT NLH 6 Handed Mystery K.O.: Dates TBC – $1,000

LAPT NLH High Roller Progressive K.O.: Dates TBC – $3,000

Entries and prizes will be paid and received in U.S. Dollars (USD $).

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details
    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.