0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0058 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-16' AND `url` = 'https://www.maineventtravel.com/tour/bsop' ORDER BY `views` DESC

0.0055 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour/bsop', 1, '2024-07-16')

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

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

0.0061 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.0005 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.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = '137'

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

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

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

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

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

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.

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