0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

0.0005 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.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.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'the-festival'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'the-festival'

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

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

0.0128 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

The Festival


The Festival Series combines the best of poker, casino and sports betting - all in one scene. Promising to provide the best experience we can by listening to you - the player. We are constantly adding exciting elements you want to see to our next events. Yes, there’s the possibility of winning big cash, but more importantly, you get to meet old and new friends.

At our first Bratislava stop we introduced competitive Roulette and Blackjack tournaments and also had competitive Sportsbetting events - all while hosting many different formats of poker cash games and tournaments that we know and love. Our events run 24/7 throughout the 7-day festival. Whether you're an amateur or a professional - you’re welcome to join our family of players and punters.

Upcoming Tour Stops

Friday 31st May - Sunday 9th June, 2024

The Festival Rozvadov 2024

Kings Casino, Rozvadov 7 348 06 Rozvadov Czechia

The Festival Series will go to Rozvadov, offering a 10-day poker extravaganza with a plethora of mixed games events. The Festival Series is not just about poker; they try to create a complete experience. Hospitality is at the core of their event, and in Rozvadov, they are taking it up a notch. With King's Casino's support, they believe that they can bring all our poker events and hospitality events to another level.

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

    Find Hotels, Flights & More       View Complete Schedule  

Sunday 8th - Sunday 15th September, 2024

The Festival Malta 2024

The Casino at Portomaso, Portomaso, Malta

For the first time in The Festival Series history, it was time to head to the Rock in 2023. Malta was scheduled just before the opening of the summer, and Portomaso Casino would get a taste of all the mixed games action that The Festival Series brings along. It would turn out to be a great success, resulting in big playing fields in mixed games such as the 8-Game, H.O.R.S.E, and the PLO tournaments. 

#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  

Monday 18th - Sunday 24th November, 2024

The Festival Bratislava 2024

Banco Casino Bratislava, Hodžovo námestie 568/2, 811 06 Bratislava, Slovakia

The first stop will be back where it all began at Banco Casino in Bratislava. 

The Festival Series is already looking forward to returning after just completing an amazing third trip to Banco Casino. 

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.