0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0075 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-01-23' AND `url` = 'https://www.maineventtravel.com/tour/bsop' ORDER BY `views` DESC

0.0106 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-01-23' AND `url` = 'https://www.maineventtravel.com/tour/bsop'

0.0004 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.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.0039 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` = 'bsop'

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

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

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

Thursday 6th - Tuesday 11th February, 2025

BSOP Costa do Sauípe

Sauípe Sol Grand Premium, BA-099, Km 74 - s/n - Linha Verde, Mata de São João - BA, 48282-970, Brazil

One of the most beautiful and famous beaches in Brazil, COSTA DO SAUÍPE in BAHIA, is the perfect setting for the first stage of BSOP Season 2025.
The Sauípe Sol Grand Premium will be the home of the BSOP this summer, with lots of sun and a paradise beach, there couldn't be a better place to meet friends and still be able to compete for the title of BSOP champion!!!

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 13th - Wednesday 19th March, 2025

BSOP São Paulo

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

More details to follow.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 1st - Tuesday 6th May, 2025

BSOP Gramado

Wish Serrano Resort & Convention Gramado, Av. das Hortênsias, 1480 - Centro, Gramado - RS, 95670-000, Brazil

More details to follow.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 22nd - Thursday 31st July, 2025

BSOP Winter Millions

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

More details to follow

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 1st - Wednesday 8th October, 2025

BSOP Foz do Iguaçu

Wish Foz do Iguaçu, Av. das Cataratas, 6845 - Tamandua, Foz do Iguaçu - PR, 85853-000, Brazil

More details to follow

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 14th - Saturday 29th November, 2025

BSOP Millions

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

More details to follow.

    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.