0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

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

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

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

0.0117 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.0007 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.0005 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.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'lapt'

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

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

0.0019 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.0132 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.0015 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.0008 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

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.