0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0065 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-05-23' AND `url` = 'https://www.maineventtravel.com/destination/articles/malta-guide/clubs-malta' ORDER BY `views` DESC

0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/malta-guide/clubs-malta', 1, '2024-05-23')

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.0005 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.0002 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0066 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.0004 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.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.0015 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.0002 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.0035 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`

Monday 8th January, 2024

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 top DJs mixing it up.

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 one of the top hang out spots for poker players when tournaments are on. It’s located right on the promenade in St Julian’s and has an outstanding selection of drinks and great cocktails as well as live sports – including coverage of all the summer’s GAA action, football (English Premiership, Champions League, Internationals, La Liga, SPL), rugby (European Cup, Internationals), golf, boxing and all other major sporting events. There’s also live music, karaoke nights 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.

Native Bar and Diner 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.

Cafe del Mar is a glamorous beach club offering a bar, restaurant & pool with DJ music – plus outstanding sea and sunset views. You can spend all day here chilling out on sunbeds by the pool before 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 the 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. From summer day parties by the pool to wintery club nights inside, Aria Complex provides a truly unforgettable experience for all seasons.

Gianpula is near Rabat in the valley below Malta's old capital Mdina. With both indoor and outdoor nightclubs, the club is open year-round. Gianpula is sited in an old farmhouse with large grounds and has served as one of Malta's foremost nightclubs for the last 40+ years. Surrounded by a garden and complete with 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. A taxi pick-up and drop-off point are available in the Gianpula Village car park.

Other good nightspots include Twenty Two, Footloose Fun Bar, Fuego Salsa Bar and So City Club.

What's Hot in Malta


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.