0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0103 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-03-19' AND `url` = 'https://www.maineventtravel.com/destination/guide/malta-guide' ORDER BY `views` DESC

0.0166 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-03-19' AND `url` = 'https://www.maineventtravel.com/destination/guide/malta-guide'

0.0006 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.0117 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.0016 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.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` = 'page'

0.0003 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.0068 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.0004 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.0003 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'

English
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, but 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, don't panic 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.

2024 promises a feast of action on the island including the UDSO Cup Malta 2024 in January, the hugely successful Malta Poker Festival which takes place from April 22-29, the EAPT Eurasian Poker Tour which has an event from April 5-10 and Battle of Malta Poker in Full Bloom which is running April 3-10, with new events being announced throughout the year. 

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

- Mad Harper, December 2023

MainEventTravel.com is the Official Travel Partner of the Malta Poker Festival Spring 2024, head to MET's Special Offers page to book your VIP Package or the MPF Event Page for great rates on hotels nearby!

 

What's Hot in Malta


Events

Travel Search

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.