0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0061 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-06-19' AND `url` = 'https://www.maineventtravel.com/venue/the-casino-at-portomaso' ORDER BY `views` DESC

0.0084 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-06-19' 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.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.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.0005 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.0001 SECONDS:
SELECT * FROM `venues` WHERE `id` = 'the-casino-at-portomaso'

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

0.0010 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.0072 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.0009 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'

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

Sunday 8th - Sunday 15th September, 2024

The Festival

The Festival Malta 2024

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 28th October - Monday 4th November, 2024

Malta Poker Festival

Malta Poker Festival Autumn 2024

Malta is a Poker Hot Spot in October and MET currently has VIP Packages and Hotels on Exclusive Discounted Early Bird rates. Buy-ins available when schedule announced. 

Looking for a bespoke Package? Email mpf@maineventtravel.com 

Win Back Up to 100% of Tournament Travel Booked with MET in #FinalTableFreeroll

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Saturday 02 November, 2024

APAT

APAT Maltese Open Championship

Nov 02, 2024, 05:00pm

Portomaso Casino, St Julian’s, Malta,

Buy In: €120

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

MET Continues Partnership with Malta Poker Festival Autumn 2024

MPF is set to be another smash hit this Autumn and MainEventTravel.com is on hand to get you there with VIP Packages, Hotels, Flights, Buy-ins, and more.

2024 EPT Barcelona Hotels

Huge numbers are expected at this year's EPT Barcelona after 2023's sensational festival which attracted over 2,100 entries for the €5,300 Main Event and featured more than 60 different tournaments.
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.