0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0092 SECONDS:
SELECT `views` FROM `page_views` WHERE `date` = '2024-02-22' AND `url` = 'https://www.maineventtravel.com/venue/the-casino-at-portomaso' LIMIT 1

0.0013 SECONDS:
REPLACE INTO `page_views` (views, `date`, `url`) VALUES (views + 1, '2024-02-22', 'https://www.maineventtravel.com/venue/the-casino-at-portomaso')

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.0006 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.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.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.0111 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` = 'the-casino-at-portomaso'

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

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

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

English

The Casino at Portomaso



Upcoming Events at this Venue

Friday 5th - Wednesday 10th April, 2024

EAPT

EAPT Malta

Main Event €560 Buy-in  with €200? gursnteed plus 5 × €5K EAPT Grand Final Packages

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

    Find Hotels, Flights & More       View Complete Schedule  

Monday 22nd - Monday 29th April, 2024

Malta Poker Festival

Malta Poker Festival Spring 2024

MPF Spring features a €300K guaranteed Grand Event powered by Unibet DSO

 MainEventTravel.com is the Official Travel Partner of MPF for Spring 2024

Looking to add days to a VIP Package? We can tailor your trip to you, email mpf@maineventtravel.com 

#FinalTableFreeroll Eligible Event - Win Back 100% of Your Tournament Travel Costs

Major Events
March 2024
Sat 16th MPF Grand Event Day 1 London at The Casino at Portomaso Buy In: £430 + £45.00
April 2024
Tue 23rd Grand Event Buy In at The Casino at Portomaso Buy In: €500 + €50.00
Tue 23rd Sviten Special at The Casino at Portomaso Buy In: €200 + €30.00
Tue 23rd MPF Texas Classic at The Casino at Portomaso Buy In: €180 + €20.00
Wed 24th MPF Grand Event Day 1A Powered by UDSO at The Casino at Portomaso Buy In: €500 + €50.00
Wed 24th Betsson One Bullet at The Casino at Portomaso Buy In: €150 + €20.00
Wed 24th HORSE 5 MIX hosted by Jeanne David at The Casino at Portomaso Buy In: €200 + €30.00
Thu 25th MPF Grand Event Day 1B Powered by UDSO at The Casino at Portomaso Buy In: €500 + €50.00
Thu 25th Bounty Hunter Days Malta at The Casino at Portomaso Buy In: €200 + €30.00
Fri 26th MPF Grand Event Day 1C Powered by UDSO at The Casino at Portomaso Buy In: €500 + €50.00
Fri 26th Mystery Bounty Day 1 at The Casino at Portomaso Buy In: €200 + €30.00
Fri 26th PLO Knight Crusaders at The Casino at Portomaso Buy In: €270 + €30.00
Fri 26th Super Highroller at The Casino at Portomaso Buy In: €2250 + €250.00
Fri 26th Friday 2 Stack hosted by Rolf Arne Bechstrom (€10 Cancer Research Reg Free Included) at The Casino at Portomaso Buy In: €200 + €30.00
Sat 27th MPF Grand Event Day 1D Powered by UDSO at The Casino at Portomaso Buy In: €500 + €50.00
Sat 27th Super Highroller Final Day at The Casino at Portomaso Buy In: €2250 + €250.00
Sat 27th Ladies First! Hosted by KerryJane Craigie and powered by LIPS at The Casino at Portomaso Buy In: €180 + €20.00
Sat 27th APAT Maltese Championship Day 1 at The Casino at Portomaso Buy In: €100 + €20.00
Sat 27th MPF Grand Event Day 1E Turbo powered by UDSO at The Casino at Portomaso Buy In: €500 + €50.00
Sun 28th MPF Grand Event Day 1F Turbo Powered by UDSO at The Casino at Portomaso Buy In: €500 + €50.00
Sun 28th The Hendon Mob Championship Day 1 at The Casino at Portomaso Buy In: €220 + €30.00
Sun 28th MPF Seniors Event hosted by Buddy from Global Poker Community at The Casino at Portomaso Buy In: €270 + €30.00
Sun 28th MPF Highroller Day 1 at The Casino at Portomaso Buy In: €1000 + €100.00
Sun 28th Deepstack Sponsored Event TBA at The Casino at Portomaso Buy In: €220 + €30.00
Mon 29th Bounty Hunter Days Progressive Closer at The Casino at Portomaso Buy In: €150 + €20.00
Mon 29th MPF Highroller Day 2 & Final Table at The Casino at Portomaso Buy In: €1000 + €100.00
Mon 29th MPF Last Chance at The Casino at Portomaso Buy In: €200 + €30.00
May 2024
Wed 1st Ladies First Buy In at The Casino at Portomaso Buy In: €130 + €20.00
    Find Hotels, Flights & More       View Complete Schedule  

Monday 22nd - Monday 29th April, 2024

Unibet DeepStack Open

MPF UDSO Malta Spring 2024

Malta Poker Festival and Unibet DeepStack Open are teaming up again from April 22nd to 29th for the MPF Grand Event Powered by USDO!

With 1444 entries during last MPF UDSO Grand Event : we’re getting ready to break new records this time !

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       View Complete Schedule  

Saturday 27 April, 2024

APAT

APAT Mediterranean Championship 2024

1pm at the Portomaso Casino

Buy In: €120

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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. 

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

Get the Hotel Lowdown for GUKPT Blackpool 10th - 17th March

With just a couple of weeks before the GUKPT kicks off in the popular Lancashire seaside resort of Blackpool, now is the time to book!

Last Chance to Book Exclusive, Deeply Discounted Rooms at Clayton Ballsbridge for Irish Open

MET still has a few rooms available for Irish Open players at an exclusive, discounted rate of €179 per night Single B&B and €189 per night Double B&B.
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.