0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0124 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-24' AND `url` = 'https://www.maineventtravel.com/tour/bsop' 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/bsop'

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.0119 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.0011 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.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` = 'page'

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

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

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

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

0.0125 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.0014 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.0007 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

BSOP


The Brazilian Series of Poker (BSOP) is a tour organized by PokerStars. The first BSOP tournament took place in Sao Paulo in 2008 and has visited several destinations across Brazil. It has also held events in Uruguay and Argentina.

Upcoming Tour Stops

Thursday 30th May - Tuesday 4th June, 2024

BSOP Natal, RN

SEHRS Natal Grand Hotel,

The Brazilian Poker Championship, after 6 years, returns to the splendid Natal. The city, which was the scene of one of the most surprising stages in 2015, hosts the BSOP again, for another stage in one of the most beautiful beach destinations in the country.

The venue for the competition will be the Sehrs Natal Grand Hotel, which has hosted major stages of the BSOP in recent years. The resort was highly praised by the participants and has a high standard of leisure and comfort structure to accommodate the participants and their families.

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 23rd - Wednesday 31st July, 2024

BSOP Sao Paulo, Winter Millions

Sheraton Sao Paulo WTC Hotel, Av. das Nações Unidas, 12559 - Brooklin Novo, São Paulo - SP, 04578-903

Brazil's winter will heat up with the BSOP WINTER MILLIONS. The fantastic event of the month of July returns with many more tournaments. In addition, there will be 12 MILLION reais in guaranteed prize pool throughout the festival, with R$ 4 MILLION in the main event. The BSOP WINTER MILLIONS will take place in the grand Golden Hall of the WTC Sheraton.

The BSOP Winter Millions is confirmed to take place in the city of São Paulo, between the 23rd and 31st of July.

The BSOP will be held at the luxurious WTC Sheraton to accommodate the more than one hundred poker tables that will host the thirty-eight tournaments over eight days of competition.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 9th - Wednesday 16th October, 2024

BSOP - LAPT Rio de Janeiro

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.

The stage will be held between the 9th and 16th of October at the luxurious Windsor Marapendi hotel The Windsor Marapendi, in addition to being sophisticated, has a privileged location facing the sea of Barra da Tijuca.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 15th - Friday 29th November, 2024

BSOP Millions 2024

Sheraton Sao Paulo WTC Hotel, Av. das Nações Unidas, 12559 - Brooklin Novo, São Paulo - SP, 04578-903

Get ready for the BSOP Millions 2024. The biggest poker tournament ever held in the southern hemisphere will once again take place in the wonderful Golden Hall of the WTC Sheraton.

The BSOP Millions 2024 will take place in the city of São Paulo, between the 15th and 29th of November.

The BSOP returns to the luxurious WTC Sheraton to accommodate the more than 170 poker tables that will host the more than 100 tournaments over the course of fifteen days of competition.

    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.