0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-dev`

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

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

0.0007 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.0003 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.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` = 'dev.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` = '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.0030 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.0013 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.0002 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.0008 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 `url_name` = 'clubs-malta'

0.0001 SECONDS:
SELECT `news_categories`.* FROM `news_article_categories` LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` WHERE `news_article_categories`.`news_article_id` = '517'

0.0019 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`

  -  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
Friday 27th April, 2018

Bars and Clubs in Malta

By Mad Harper

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 live music and top DJs.

The ubiquitous Hugo’s brand offers numerous places to eat and drink so don’t miss Hugo’s Lounge, Hugo’s Passion, Hugo’s Pub, Hugo's Bacco and Hugo’s Terrace.

Corks Irish bar is where all the poker players hang out when poker tournaments are on. It’s located right on the promenade in St Julians and has an outstanding selection of drinks and great cocktails as well as live sports, live music and a pool table. It’s a gorgeous little bar with very quirky Prohibition-style interior, definitely the place to enjoy the craic while you’re in Malta!

The Thirsty Barber was the first Prohibition-style bar in Malta and it still has a great vibe – as well as some of the best cocktails on the island. The bar boasts a unique cocktail list, developed by a team of top mixologists, with a wide choice of Prohibition-era cocktails, martinis and champagne cocktails, some of which are also to share.

The Dubliner is another great Irish bar in St Julian’s which first opened in 2004. It’s a cosy, welcoming Irish pub – with professionally served Guinness of course – along with a great restaurant offering a choice of snacks, pub-grub and a fine selection of main courses.

Funky Monkey in Gzira is a very chilled club with a hippy vibe. Recommended for its live music and parties, it’s a great place to enjoy drinks with friends in the sun on the large open-air terrace!

Native Bar is in St. Julians is open pretty much all day and night. During the day, enjoy background music and the chance to watch live sports, and stay on as the bar switches gear in the evenings and the salsa vibe kicks in. Dance the night away to Latino and Reggaeton; it’s a great atmosphere with fun guaranteed.

In Valletta, Bridge Bar, Trabuxu Wine Bar and Loop Bar are all favourites for Raketech CEO Michael Holmberg who has lived on the island for six years.

Cafe del Mar is the #1 place to party in Malta. Located in Qawra on St Pauls Bay, you can spend all day here chilling out on sunbeds by the infinity pool before enjoying the club's legendary sunsets, then picking up the pace with DJs and live music in the evenings. Café del Mar attracts world-class DJs and hosts some great festivals including Annie Mac’s Lost and Found in May and Earth Garden at the beginning of June.

Aria Complex, located on the outskirts of Malta's throbbing nightlife scene in St Julian’s, attracts a wide mix of clubbers with different music events, live concerts and top DJs. The venue has a pool and terrace so you can spend the day here relaxing in the sun, before the atmosphere hots up in the evenings.

Gianpula is near Rabat in the valley below Malta's old capital Mdina. It’s an old farmhouse with large grounds and has served as one of Malta's foremost open air nightclubs for the last 25 years. Surrounded by a garden and complete with a a swimming pool, seven bars and a state of the art sound and lighting system, this a great venue. The Terrace overlooks the whole club and is particularly popular in the summer when it serves as the club VIP area. Gianpula has hosted the world’s top DJs including Tiesto, Sasha, Erick Morillo, Nick Warren and Roger Sanchez.



What's Hot in Malta


Events

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.