0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0065 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-07-21' AND `url` = 'https://www.maineventtravel.com/venue/the-casino-at-portomaso' ORDER BY `views` DESC

0.0101 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-07-21' AND `url` = 'https://www.maineventtravel.com/venue/the-casino-at-portomaso'

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.0001 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.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.0001 SECONDS:
SELECT * FROM `venues` WHERE `id` = 'the-casino-at-portomaso'

0.0005 SECONDS:
SELECT * FROM `venues` WHERE `page_url` = 'the-casino-at-portomaso'

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

0.0117 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'

English

The Casino at Portomaso


Portomaso Casino Malta has quickly established itself as a definite must for locals and tourists alike and is home to the Malta Poker Festival. Portomaso Casino offers a variety of gaming options from slot machines to poker games and poker tournaments.

The table games on offer include Roulette, Black Jack and Punto Banco, with a choice of money stakes for all types of players. The concept behind the Casino is to make patrons feel at home, while providing them with an exciting gaming experience in a luxurious environment. Our Casino in Malta hosts regular international poker tournaments and special gaming events.

The atmosphere in the Casino is always vibrant, especially during the evening, where patrons may enjoy an exquisite dinner in the brasserie or simply a refreshing drink in our newly refurbished lounge area.


Upcoming Events at this Venue

Monday 15th - Sunday 21st September, 2025

The Festival

The Festival Malta

The Portomaso Casino will once again open its doors for us in September, to make sure that players can have one final stop to end the summer in pure fashion. Great weather, epic sceneries, and many hospitality events will be once again part of this stop.

    Find Hotels, Flights & More       View Complete Schedule  

Monday 27th October - Monday 3rd November, 2025

Malta Poker Festival

Malta Poker Festival Autumn 2025

The GPI award nominated poker festival is confirmed to return this Autumn 2025. 

    Find Hotels, Flights & More       View Complete Schedule  

Saturday 01 November, 2025

APAT

APAT Malta

5pm 

Buy-in: €120

    Find Hotels, Flights & More       Full Schedule Coming Soon  
Latest News & Blogs

Main Event Travel Brings the Heat to Goliath with Texas Throw ’Em Giveaway!

Main Event Travel is gearing up for another incredible appearance at Goliath, taking place at Grosvenor Casino in Coventry. From 31st July to 3rd August, we’ll be on-site with our signature stand — and this year, we’re bringing something new and exciting to the table: Texas Throw ’Em, a high-energy darts-based poker game with great prizes on the line.

High Stakes and Summer Vibes: Irish Poker Tour Hits Dublin

The Irish Poker Tour returns to Dublin from July 23rd to 27th, bringing top-tier poker action, diverse tournaments, and a vibrant atmosphere to the city. With MainEventTravel simplifying trip bookings, players can focus on the game while enjoying everything Dublin has to offer this summer.
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.