0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-dev`

0.0185 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-04-26'
AND `url` = 'https://dev.maineventtravel.com/destination/guide/malta-guide'
ORDER BY `views` DESC

0.0051 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://dev.maineventtravel.com/destination/guide/malta-guide', 1, '2025-04-26')

0.0003 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'dev.maineventtravel.com'

0.0031 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.0013 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` = 'dev.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.0074 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` = 'dev.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.0025 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.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` = 'dev.maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0002 SECONDS: 
SELECT destinations.*, uapi_airports.name as airport_name
FROM `destinations`
LEFT JOIN `uapi_airports` ON `destinations`.`uapi_code` = `uapi_airports`.`airport_code`
WHERE `url` = 'malta-guide'

0.0027 SECONDS: 
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(35.91469885216256 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(35.91469885216256 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((14.49832554589841 - venues.map_longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance, venues.name as venue_name, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, tours.logo as tour_logo, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo
FROM `venues`
LEFT JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id`
JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
WHERE `tour_stops`.`active` = '1'
AND tour_stops.end_date > CURDATE()
HAVING `distance` <= 10
ORDER BY `tour_stops`.`start_date` ASC

0.0002 SECONDS: 
SELECT `news_articles`.`url_name`, `news_articles`.`main_image`, `news_articles`.`meta_description`, `news_articles`.`title`
FROM `news_article_destinations`
JOIN `news_articles` ON `news_article_destinations`.`news_article_id` = `news_articles`.`id`
WHERE `news_articles`.`active` = 1
AND `destination_id` = 3
ORDER BY `news_article_destinations`.`display_order`

0.0017 SECONDS: 
SELECT `uapi_airports`.*, `uapi_cities`.`name` as `city`, `uapi_countries`.`name` as `country`
FROM `uapi_airports`
JOIN `uapi_countries` ON `uapi_countries`.`country_code` = `uapi_airports`.`country_code`
JOIN `uapi_cities` ON `uapi_cities`.`city_code` = `uapi_airports`.`reference_city`
WHERE `airport_code` = 'MLA'
  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found
English
  1. Home
  2. Destination Guide - Malta
Destination Guide Malta

There has never been a better time to visit Malta. Not only is this gorgeous Mediterranean island full of beautiful beaches and world-famous historic sites, it’s also home to a thriving poker scene.

 

Culture abounds in Malta - the islands have some of the oldest buildings ever created – the Hypogeum, Tarxien Ruins and the Megalithic Temples are all nearly 1000 years older than Stonehenge and the Pyramids of Giza in Egypt.

 

If culture’s not your thing, panic not though – because Malta is also a perfect destination for a chilled-out poker holiday. Malta’s balmy climate means mild winters and an average of 12 hours of sunshine in the summer. Malta also enjoys the highest sea temperature in Europe, so it’s ideal if you enjoy swimming, water sports or just splashing around in the crystal-clear waters of the Med.

 

Malta also hosts numerous world-class poker tournaments. The European Poker Tour was the first major event to take place in Malta but many others have followed suit. The MPN Poker Tour, Unibet Open, Unibet Deepstack Open and CashGameFestival have all held events in Malta – and 888poker WPTDeepStacks is making its debut on the island in April. That’s all in addition to the perennially record-breaking Battle of Malta which takes place every year in October.

WCOOP champion Steven van Zadelhoff has lived in Malta for nine years and has found it the perfect place to play online. He said: “Malta is just great! What I love best about living here is that I have very little distraction so it's super efficient to grind a lot of poker. I live one minute from my supermarket and three minutes from my gym. And my sunny terrace is awesome!”

Raketech CEO Michael Holmberg, originally from Sweden, is another long-term Malta resident who is bringing up his family here. He said: “I first moved here during my ten-year stint at PokerStars and I really love it. There are so many things to enjoy about Malta - 300 days of sunshine a year, the Mediterranean lifestyle, and it’s the only Mediterranean country where English is the main language. It also has a really friendly atmosphere and it’s very safe so it’s great for families.”

For poker players who want to combine playing poker with a sun-drenched beach holiday, there’s really nowhere better than Malta – so don’t delay! Book your trip soon at MainEventTravel.com!

What's Hot in Malta

Bars and Clubs in Malta There’s certainly no shortage of places to drink and dance in Malta; from cosy family-run wine bars to giant nightclubs, Malta has it all. Highly recommended is Café del Mar where you can enjoy a fab day lazing by the pool in the sun before hotting it up in the evening with top DJs mixing it up.
Eating out in Malta The heart of Malta's thriving nightlife scene is St Julians which lies about half hour north of the capital city of Valletta. This is where the three main casinos are all located – Casino Malta, Portomaso and Dragonara – and the area is heaving with great places to eat out.
Things to do in Malta With its superbly sunny weather (more than 300 days a year), expansive beaches, thriving nightlife and 7,000 years of incredible history – including some of the oldest human structures in the world, there is a huge amount to see and do in Malta. It is also a place of stunning natural beauty.

Events

Travel Search

Your trip starts here...
Search anywhere using the form below, click here to search for events, or have a look at the calendar to see what's on!
Flights
From
To
Cabin Class & Travellers
1 Adult, Economy
Hotels
Staying near
Rooms
Guests
1 Adult


Rates
Dates of Travel
Dates of Travel Close
UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
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.