0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0070 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-22' AND `url` = 'https://www.maineventtravel.com/news/article/MPF-Ladies-First-hosted-by-Kj-once-again-and-MET-has-a-VIP-Package-up-for-grabs-for-two-ladies' ORDER BY `views` DESC

0.0019 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/MPF-Ladies-First-hosted-by-Kj-once-again-and-MET-has-a-VIP-Package-up-for-grabs-for-two-ladies', 1, '2024-12-22')

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.0004 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

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

0.0008 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.0034 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.0040 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.0096 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.0008 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.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` = '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.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` = '18' 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.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` = '19' 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.0059 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.0043 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.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.0040 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.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` = '28' 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` = '29' 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.0088 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.0056 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.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.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` = 'MPF-Ladies-First-hosted-by-Kj-once-again-and-MET-has-a-VIP-Package-up-for-grabs-for-two-ladies'

0.0006 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-12-22' 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` = '1059'

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

English
Tuesday 24th September, 2024

Win Malta Poker Festival Ladies First VIP Package for Yourself and a Gal Pal!

By Kelly Saxby

Newly Appointed PokerStars Ambassador Kerryjane Craigie is once again hosting the Malta Poker Festival Ladies First Event this Autumn 2024. And MainEventTravel.com has a VIP Package up for grabs to celebrate! 



As the Global Poker awards nominated Malta Poker Festival returns for the Autumn edition in October, so does one of the most well-known advocates of women in poker. Kerryjane Craigie, fondly known as Kj, hosts the Ladies First! Women’s event during MPF, which now boasts a whopping €10,000 GPP plus an added Main Event Entry + Accommodation Package to the Women’s Winter Festival £100k GPP Main Event taking place at the Hippodrome this November!


Kj is a one of the most passionate champions of women in poker you’ll have the pleasure to meet. On hosting the event, she shares: “Malta Poker Festival offers the perfect blend of expertly run events and Mediterranean charm. I’m thrilled to be part of it once again and can’t wait to welcome everyone back for this exciting edition!”

MPF Founder Ivonne Montealegre, echoes the sentiment, saying: “Kj’s leadership is invaluable, and her commitment to elevating women in poker is unmatched. We are thrilled to have her back for this Autumn edition and to be partnering with The Hippodrome and Pokerstars to create a satellite event during MPF so players can go to the Women’s’ Winter Festival in London."


€10K Guaranteed Prize Pool, Womens ‘ Winter Festival Festival Package, and Satellite to the event 

Ladies First!  brings with it the first ever €10,000 guaranteed prize pool, raising the stakes and drawing even more top female poker talent to Malta.Kj and other representatives of the Womens Poker Association will host a lunch prior to the start of the event. 

Ladies First! takes place Saturday 2nd November at 14:00 at Portomaso Casino Malta and features a €200 buy-in, a 25k starting stack, 25 minute-blind levels and unlimited re-entries during the first 10 levels. 

In addition to the coveted title, trophy and cash, the tournament winner will walk away with a Package to the Women’s Winter Festival supported by PokerStars at The Hippodrome in London this November that includes a £400 Main Event entry and 3 nights in London —an extraordinary bonus that further enhances the value of this unique tournament.

To top off the women’s weekend in Malta, MPF is also hosting a satellite on Sunday 3rd November into the Women’s Winter Festival in London. The satellite features a €60 buy-in, 15k starting stack, 20 minute levels and unlimited re-entries through level 8, but that’s not all! This event has 10 x £400 Women’s Winter Festival  Main Event Seats ADDED to the prize pool, this is a £4k value on top of the seats generated from buy-ins. 

This partnership between Pokerstars and MPF is unique and shows how much support Women in Poker are getting through the efforts of the two WPA board members.


Win a Ladies Event VIP Package

Main Event Travel has joined both Ivonne and Kj in efforts to promote MPF, The Hippodrome and Women’s Events on multiple occasions over the past years and 2024 is no exception.

In addition to Ladies Event VIP Packages beng available for purchase online (along with Grand Event VIP Packages, plus Hotels, Flights, Buy-ins and Off the Felt activities) MET has teamed up with MPF to send to two lucky ladies to Malta to take part in all of the fun! 

Entering is easy and every woman who shares the promotion of these events is in with a chance for themselves and a gal pal to head to Malta 30th October for 5 nights for this trip of a lifetime for TWO which includes:

  • 5 nights 5* Hilton Bed & Breakfast for 2
  • 2 x Ladies First entries
  • 2 x €200 MainEventTravel.com credits  
  • 2 X VIP Bracelets
  • 2 X Casino Drinks Packages
  • 2 x Players Party Entries

To enter:

  • FOLLOW MET and MPF on social media (FB or X)
  • JOIN MET’s Offers & Promotions Facebook Group
  • SHARE any Ladies First VIP Package Giveaway post to your own Facebook or X page
  • TAG the Gal Pal you’ll take with you in your shared post
  • COMMENT below the designated giveaway post pinned to the top of METs Offers & Promotions Group telling us which platform you shared on and the gal pal you’ll take.

We want every entry to be eligible so please read the Ts & Cs so you don’t miss out!

Enter before midnight 29th September.

Drawing takes place on MET’s Facebook LIVE Tuesday 1st October .

Please make sure your entry meets eligibility, failure to skip any of the requirements may deem your entry void:

  • FOLLOW BOTH MainEventTravel AND The Malta Poker Festival on Facebook or X.
  • SHARE ANY Ladies First VIP Package Giveaway Promotional Post from MET’s FB or X Page to your own page
  • TAG the Gal Pal you will take with you IN THE POST YOU SHARE TO YOUR SOCIAL MEDIA
  • Comment below the DESIGNATED GIVEAWAY POST PINNED TO TOP of the MET Facebook Offers & Promotions Page to let us know which platform you shared on and who you have nominated to take with you

IMPORTANT

  • Check your privacy settings when you share, if we can’t see your post we can’t validate your entry
  • Tags are valid only when they are ‘live’ ie highlighted/change colour, failure to do such may invalidate your entry.
  • In order to track entries, only comments below the DESIGNATED GIVEAWAY POST PINNED TO TOP of MET Facebook Offers & Promotions Page will be reviewed for entry

 One entry can be made per person. You can be tagged in multiple entries.

Ps. Whilst Packages won are non-transferable, IF you have purchased a VIP Package or pre-paid hotel on cancellation via MET and you win the prize, we will happily refund per your purchase terms.

VIP Packages and Hotels

MET has exclusive Poker VIP Packages at the 5* Hilton Malta and 3* Valentina Hotels available for purchase online, including:

  • 5 to 7 nights Bed & Breakfast
  • Single or Double Occupancy
  • Grand Event and/or Ladies Event buy-ins
  • VIP bracelets
  • Casino drinks package including tea, coffee, soft drinks, water, house wine & beer
  • Complimentary Entrance to Level 22 Nightclub ‘All-in’ Player’s Party
  • VIP Concierge service and more

MET also has flights to Malta from around the world and Hotels nearby to suit every budget.  

Bespoke Poker Travel

If you would like MET to tailor a bespoke package to your requirements, email mpf@maineventtravel.com.

Advance Buy-ins

Buy-ins can be purchased online at MainEventTravel.com to avoid the time and hassle of exchanging and carrying currency.

Off the Felt Activities

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

Join Ladies First this Autumn

The MPF Ladies First Poker Tournament is set to be a celebration of women’s skill, camaraderie, and the growing influence of female players in poker. Don’t miss out on this fantastic opportunity to join Kj and a host of female players and be part of an unforgettable event this Autumn in Malta!

Malta Poker Festival 

The MPF has been a booming success story since it first launched in 2018. Field sizes and prize pools have soared with players of many nationalities coming from around the world to relish the chance to enjoy poker in a top tourist destination at a great time of the year.

MPF released a huge schedule for this Autumn’s extravaganza at Portomaso Casino. There are some 30 tournaments taking place from October 27 to November 4, including the €550 Grand Event, €1,100 Unibet DSO GOLD High Roller, a €2,500 Super High Roller hosted by Game of Gold’s Lukas Robinson, plus the Hendon Mob Championship, The Luxon Pay Mystery Bounty, Svitven Special, Seniors and more.

Ladies First! Hosted by Kerrjane Craigie has been running for 5 years and has seen champions such as Chris Read that had back to back wins.  

Kerryjane Craigie and PokerStars Women’s Winter Festival

Kj’s list of accolades is a long one. In addition to her PokerStars Ambassador for Women in Poker role, she founded the Ladies that Poker at Hippodrome Club, she is the Raise It Up Program Manager for WPA International (Women’s Poker Association), and she has just been tipped as a Hall of Fame nominee.

Her excitement for the Women’s Winter Festival  is matched by that of welcoming players to her home turf! This inaugural four-day festival will run 21st-24th November at the iconic Hippodrome Casino, London. This event is being hosted to take positive action and enable more women to the live poker arena by offering a £100,000 guaranteed Main Event, which includes three starting flights and a £400 buy-in.  The side events are equally exciting and offer a 50/50 tournament that is set to an equal playing field of men and women.

Women’s Winter Festival London Hotels and ATOL Protected Flights are available along with the full schedule here.

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.