0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0071 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-10-15' AND `url` = 'https://www.maineventtravel.com/news/article/Malta-lays-it-on-big-for-High-Rollers-this-Autumn-2024' ORDER BY `views` DESC

0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/Malta-lays-it-on-big-for-High-Rollers-this-Autumn-2024', 1, '2024-10-15')

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` = 'maineventtravel.com'

0.0002 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.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.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` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

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` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

0.0062 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.0036 SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date FROM `news_categories` JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` GROUP BY `news_categories`.`id`

0.0067 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '11' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0007 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` = 'news'

0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0038 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '16' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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` = 'news'

0.0005 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0031 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '18' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0005 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0033 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '19' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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` = 'news'

0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0053 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '22' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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` = 'news'

0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0037 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '23' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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` = 'news'

0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0035 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '27' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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` = 'news'

0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0034 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '28' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0028 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '29' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0073 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '30' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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` = 'news'

0.0005 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0053 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '31' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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` = 'news'

0.0005 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0017 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` = 'Malta-lays-it-on-big-for-High-Rollers-this-Autumn-2024'

0.0007 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 `date` <= '2024-10-15' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

0.0006 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` = 'news'

0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

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

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%article%'

English
Tuesday 10th September, 2024

Malta lays it on big for High Rollers this Autumn

By Mad Harper


A near-perfect poker opportunity is coming up in Malta this Autumn, especially if your bankroll lets you indulge in a few of the more elite events.

 

The two most important festivals in Malta’s packed poker calendar – the Malta Poker Festival and Battle of Malta – are running in tandem at the end of October, giving players the chance to experience first-class tournament action in a superb location.

 

Being Malta, the High Roller tournaments are at the more affordable end of the scale but still offer players the chance to win big, with prize pools up to €371k last Autumn.

 

The Main Event winners at both MPF and BOM festivals also won handsome six-figure sums in Autumn 2023 with prize pools up to €1.7 Million. 


Boom time for high stakes players

Both MPF and BOM have recognised although their audiences are typically more mid-stakes players, Malta’s convenient and sun-drenched location, luxury accommodation and lively nightlife, makes it a very attractive poker destination for more affluent players as well. 

 

To this end, both festivals have added Super High Roller tournaments to their schedules this Autumn. Each last just a couple of days – and the good news is that you can easily play both in a four-day spree.

The €2,500 Malta Poker Festival SHR  - hosted by Game of Gold’s Lukas Robinson - runs November 3-4 at Portomaso Casino while the two-day €2,700 BOM SHR kicks off just ten minutes’ walk away at Casino Malta on November 5.

 

If you want to keep your buy-ins around the €1k mark, then you could play both of the High Rollers instead: have a go in the MPF High Roller from November 2-3 and then head over to BOM for their HR event running November 3-4.

 

The festival’s main events also offer great value – the €550 MPF Grand Event runs October 27 to 4th November and comes with a €500k guarantee (and an opportunity to jump into the first Day 1 for only €400!)

While down the road, the BOM €600 buy-in Main Event is running October 30 to November 6. Between the two events there is €2 Million Guaranteed!  


Event highlights

Malta Poker Festival: 

€550 Main (€500k GPP) October 27 – November 4

€1,100 High Roller – November 2-3

€2,500 Super High Roller – November 3-4 - Hosted by Lukas Robinson

 

Battle Of Malta: 

€600 Main (€1.5 mill GPP) – October 30 –November 6

€1,100 High Roller –November 3-4

€2,700 Super High Roller – November 5-6


Go VIP and experience Malta poker in style!

 

Malta’s 5* Hilton sits next to Portomaso Casino and features sea views to one side and Portomaso's amazing marina to the other. Not only is this one of the most luxe hotels in the area, but it’s the gem of the island!

 

The Hilton Malta boasts:

  • 3 pools, including one for adults and a salt-water pool
  • Indoor and outdoor jacuzzi, plus sauna, steam room and plunge pool
  • Luxury spa and treatments
  • Fitness centre
  • Tennis court
  • Executive lounge (9th floor sea views with breakfast, high tea and aperitivo)
  • Beach (man-made) and beach bar
  • Indulgent breakfast buffet with outdoor seating overlooking pool/sea
  • Indoor and outdoor eating balcony
  • On-site restaurants (including top rated Thai Blue Elephant)
  • Room service
  • Concierge service
  • Every room has a balcony and there are option to upgrade to a room or suite with jacuzzi on balcony
  • Located in a quiet and safe cul-de-sac area with further restaurants available in the marina steps away including sushi, seafood, steak and mediterranean cuisine
  • A mix of high end and convenience shops plus more restaurants a short walk away

 


MainEventTravel is offering the ultimate VIP experience for High Rollers with 5* MPF VIP Packages at the Hilton Malta available at the click of a button. These include the MPF Grand Event buy-in, but you can easily add-on a High Roller or a Super High Roller seat.

 

VIP Packages include:

  • 5, 6 or 7-nights King-size Bedroom with Balcony
    • 2 Queen Beds available on request
  • Best Breakfast Buffet on the island
  • Single or Double Occupancy
  • 1 x Grand Event buy-in valued €550
  • 1 or 2 VIP bracelets
  • Portomaso Casino drinks package of tea, coffee, soft drinks, water, house wine & beer
    •  30th October – 4th November inclusive
  • Complimentary Entrance to Level 22 Nightclub ‘All-in’ Player’s Party
  • VIP Concierge service
  • Executive Upgrade Available
  • Free Cancellation Options
  • Additional Buy-in add ons Available
  • Off the Felt excursions Available

 

MET also has exclusive special offers on rooms at 5* Hilton (pictured below) if you would like to extend your stay or book a room only. 


MET also has great rates on at Intercontinental (next to Casino Malta) and 4 and 5-star hotels nearby.

 

If you are looking for a bespoke trip we’ll happily arrange everything for you offline. Just email us direct with your requirements and we’ll sort the lot – flights, accommodation, buy-ins, VIP bracelets, off the felt activities etc: mpf@maineventtravel.com


MPF VIP Bracelets for all


Whether you choose to stay in the Hilton or elsewhere, the VIP bracelet at the Malta Poker Festival is a definite must for anyone putting in a few days or more at the event. VIP bracelet wearers get their own special MPF VIP registration queue as well as a Portomaso Casino drinks package including tea, coffee, water, sodas, house beer and wine, available at the table or at the bar, from 30th October – 4th November inclusive.

 

You also get free entry into the 22nd floor nightclub for the players party. The really good news is that the VIP bracelet is available to all (!) and can be purchased as a standalone option (head to the tournament list on our MPF page and purchase 1, 2, 3 or 4 bracelets.)



Advance Buy-ins

 

As MainEventTravel is Official Travel Partner for the Malta Poker Festival, all the MPF event buys-in are available to purchase direct on our website. Avoid the time and hassle of exchanging and carrying currency and pre-register for MPF events. 


#FinalTableFreeroll

 

Also, with MET as OTP this means ALL the MPF multi-day events – Grand Event, High Roller and Super High Roller included - are eligible for MET’s #FinalTableFreeroll promotion giving you the chance to win 100% of your travel costs back in travel credits.

 

The Battle of Malta Main Event is also included MET’s #FinalTableFreeroll.

 

Book your VIP Package, Hotel, or Flights with MET, tag @MainEventTravel and #FinalTableFreeroll on social media, click here for more info.

 


Off the Felt Activities

 

The Malta Poker Festival offers engaging activities hosted by Maureen Bloechlinger. Dates and details will be announced soon, with tickets available online at MainEventTravel.com.

 


Bespoke Poker Travel

 

MET, created by poker players, offers tailored travel packages. Email mpf@maineventtravel.com for customized packages.

 

Extend your stay in the Med!

 

Those after an extended stay in the Med could combine their Malta jolly with a trip to EPT Cyprus beforehand (October 9-20) or even a European city break with WPT Prime in Paris (October 14-28). Or you can just spend longer lapping up the sun in Malta – just change the dates on your hotel or flight booking to make it a longer stay.

 

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.