0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0064 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-06-21' AND `url` = 'https://www.maineventtravel.com/destination/articles/malta-guide/MainEventTravelcom-Continues-Travel-Partnership-with-MaltaPoker-Festival-forSpring-2024' ORDER BY `views` DESC

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/malta-guide/MainEventTravelcom-Continues-Travel-Partnership-with-MaltaPoker-Festival-forSpring-2024', 1, '2024-06-21')

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.0003 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.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 * 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.0071 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.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.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` = '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.0016 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` = 'MainEventTravelcom-Continues-Travel-Partnership-with-MaltaPoker-Festival-forSpring-2024'

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` = '925'

0.0042 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.0003 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`

English
Wednesday 3rd January, 2024

MainEventTravel.com Continues Travel Partnership with Malta Poker Festival for Spring 2024

By Kelly Saxby

MainEventTravel.com is delighted to announce its continued partnership with the highly anticipated Malta Poker Festival for Spring 2024. MET will provide travel solutions to players making their way to the esteemed event, including exclusive VIP Packages.

The Malta Poker Festival has seen huge success and is recognised as one of the premier poker tournaments in Europe.

MET Retail Sales Consultant Kelly Saxby expressed enthusiasm about the ongoing partnership with the Malta Poker Festival for Spring 2024. "We are thrilled to continue our role as the Official Travel Partner of the Malta Poker Festival this coming April. Malta has become a premier destination for poker enthusiasts, hosting numerous exciting events each year. The constant sunshine, breathtaking coastline, alfresco dining, and vibrant nightlife make it an ideal place for a #Playcation!”

Enjoy the VIP Experience

MET will once again be offering some fantastic accommodation options situated just minutes away from the Portomaso Casino and looks forward to welcoming players who take advantage of our Special Offer VIP Grand Event Packages at 5* Hilton Malta and 3* Valentina Hotel Malta which include:

  • 5- or 6-night’s Bed & Breakfast for 1 or 2
  • 1 x Grand Event buy-in valued €550
  • 1 or 2 VIP bracelets
  • Casino drinks package tea, coffee, soft drinks, water, house wine & beer 24 – 29 April inclusive
  • Entrance to Level 22 Nightclub ‘All-in’ Player’s Party
  • VIP Concierge service

MET also has some of the best room rates going at the Hilton Malta, along with loads of options nearby to suit every budget.

Tournaments

Players making their way to MPF in the Spring can expect a fantastic array of events to choose from at a variety of buy-in levels. The €550 buy-in flagship Grand Event smashed the €300,000 guarantee last Spring, and we hope to do the same again this April.

MainEventTravel.com prides itself on helping players competing at poker events all around the world and providing top class service with all their travel needs, no matter their budget, location or length of stay.

Ivonne Montealegre, MPF Founder and Event Director said "Partnering with MainEventTravel as the Official Travel Partner for the Malta Poker Festival offers an unparalleled opportunity for attendees. Enjoy the most competitive rates and exclusive benefits, including the thrilling #FinalTableFreeroll . Say goodbye to long queues and hello to exceptional value, all while securing your spot with our special Early Bird promotions. We highly recommend booking through MainEventTravel.com, ensuring a seamless experience where the promised high standards of hotels are not just met, but exceeded. Experience the festival with ease luxury, knowing every detail of your journey is meticulously taken care of by the experts in travel."

Early Bird Bookings

A limited number of VIP Packages are available at an exclusive discounted rate. Head to MainEventTravel.com > Special Offers to take advantage of this limited- time Early Bird Offer. 

Advance Buy-in

In addition to providing packages, hotels, and flights, MainEventTravel.com will also have buy-ins available for purchase online. Avoid queues and register for the €550 Grand Event - powered by Unibet DSO saving you exchanging and carrying loads of currency in advance of your trip. All buy-ins will be available as soon as the full schedule is announced!

#FinalTableFreeroll 

The MPF Grand Event is one of the many #FinalTableFreeroll Eligible Events in 2024. Simply book your VIP Package, Hotel or Flights with MET, tag @MainEventTravel #FinalTableFreeroll on socials, and you’ll be in with a shot to win back up to 100% of your Tournament Travel! Head to MainEventTravel.com > Promotions for more info. 

Bespoke Poker Travel

MET is the Poker Travel site created by Poker Players who know what matters to you! Looking for a bespoke travel package? Email mpf@maineventtravel.com with your requirements and we can create a travel package tailored to you!

 



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.