        
0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0138 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-09-30'
AND `url` = 'https://www.maineventtravel.com/venues/venue/245'
ORDER BY `views` DESC

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/venues/venue/245', 1, '2025-09-30')

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.0003 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.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.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.0003 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.0052 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.0002 SECONDS: 
SELECT *
FROM `venues`
WHERE `id` = '245'

0.0015 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_stops`.`venue_id` = '245'
ORDER BY `tour_stops`.`start_date` ASC

0.0090 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.0006 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

Banco Casino Bratislava

Upcoming Events at this Venue

Monday 6th - Sunday 12th October, 2025

Bratislava Poker Festival

The Bratislava Poker Festival 2025

FESTIVAL HIGHLIGHTS

€500,000 FESTIVAL GUARANTEE

Whether you're a seasoned player or just enjoy the game for fun and excitement, you're invited to join in on the action at this exciting new European poker festival.

With a range of events to suit all levels, this is the perfect opportunity to test your poker skills and compete against some of the best players in the game.

Get ready to experience the rush of adrenaline as you take on the challenge and vie for the amazing guarantees!

Find Hotels, Flights & More View Complete Schedule

Tuesday 18th - Sunday 23rd November, 2025

Bratislava has a great reputation when it comes to live poker. Driven by a great location in the heart of Bratislava and the upcoming makeover of the entire Banco Casino, the 2025 edition will shine like never before!

Find Hotels, Flights & More Full Schedule Coming Soon

Plan Your Journey to the Irish Open 2026

The Irish Open 2026 is set to return as Europe’s oldest and most iconic poker festival, combining world-class tournaments with Ireland’s legendary atmosphere and hospitality. Players can book their hotels, flights, and travel arrangements easily through Main Event Travel, the official travel partner of the event.

GUKPT Edinburgh 2025 — A Key Stop on the UK Circuit

The Grosvenor UK Poker Tour (GUKPT) Edinburgh runs from 9–19 October 2025 at Grosvenor Casino Edinburgh, with the prestigious £1,000 Main Event as the highlight of the ten-day festival. Known for its deep structures and competitive fields, the stop also features a variety of side events and satellites, making it a key date on the UK poker calendar. Main Event Travel, the official travel partner of the GUKPT, provides players with tailored hotel and travel packages to ensure a seamless experience. With Edinburgh’s unique cultural backdrop and only a few stops left before the Grand Final in London, this leg is set to be one of the standout moments of the season.

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

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.