0.0006 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

0.0009 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.0005 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0010 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0008 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.0004 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

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

0.0003 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0220 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.0010 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.0008 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.0003 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'lapt'

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

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

0.0035 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.0198 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.0022 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.0011 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

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

Friday 19th - Tuesday 23rd April, 2024

LAPT Panama

Hotel El Panamá by Faranda Grand, Calle Eusebio A. Morales &, Av. Central España Edificio 111, Panamá, Panama

Taking place at the luxurious Hotel El Panamá by Faranda Grand, this tournament will bring together some of the world's best players to compete for the coveted LAPT Panamá title and massive prize pool.

What’s more, participants will also have the opportunity to explore the vibrant Panamá City and its stunning natural beauty. Whether you're a seasoned player or a newcomer to the game, LAPT Panamá is not to be missed.

Mark your calendars, and get ready for an unforgettable week of poker, excitement, and adventure.

LAPT Main Event: April 19-23 – $1,500

LAPT High Roller Single Day: April 21– $3,000

LAPT NLH High Roller: April 22-23 – $3,000

LAPT NLH 6 Handed Mystery K.O.: April 21-23 – $1,000

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

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

Win Back Up to 100% of Your Tournament Travel Costs - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       View Complete Schedule  

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  
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.