0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0098 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-26' AND `url` = 'https://www.maineventtravel.com/venue/card-casino-bratislava' ORDER BY `views` DESC

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/venue/card-casino-bratislava', 1, '2024-04-26')

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.0004 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' 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 * 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.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.0065 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` = 'card-casino-bratislava'

0.0004 SECONDS:
SELECT * FROM `venues` WHERE `page_url` = 'card-casino-bratislava'

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

0.0103 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.0008 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'

English

Card Casino Bratislava


Slovakia's largest casino offers visitors the perfect place to relax, have fun and win big. With a wide selection of slots, live table games, tournament and cash poker games for local players as well as being able to cater for large international events, Card Casino is rapidly becoming a 'go to' location for poker tours.


Upcoming Events at this Venue

Tuesday 2nd - Monday 8th July, 2024

Poker Skills Events

Skill Poker Master

Main Event Buy-In: €320+30 with a GTD of €500,000

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 16th - Sunday 21st July, 2024

Bratislava Poker Festival

The Bratislava Poker Festival 2024

Bratislava is gearing up to host a poker festival that promises to be both exhilarating and memorable at the world-famous Card Casino.

The Festival opens with the ever popular €75,000 GTD Mystery Bounty, quickly followed by the massive €500,000 guaranteed Main Event which has a very affordable €700 entry fee, the Euro Omaha Championship has a €50,000 guarantee and will attract big hitters who will also be eyeing up the €60,000 GTD High Roller which will run over the closing weekend.

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

    Find Hotels, Flights & More       View Complete Schedule  
Latest News & Blogs

All change at the Vic!

With events being relocated due to refurb, MainEventTravel has your back with great accommodation options near all the Grosvenor Casinos selected.

Geraghty wins 888poker LIVE UKPL Manchester

Scottish player Jamie Geraghty has won the 888poker LIVE UKPL Manchester Main Event for the biggest cash of his live poker career. Geraghty won £30,610 after outlasting a 328-entry field – and beating Josh Radley heads-up.
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.