0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0075 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-10-15' AND `url` = 'https://www.maineventtravel.com/event/malta-poker-festival-autumn-2024' ORDER BY `views` DESC

0.0106 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-10-15' AND `url` = 'https://www.maineventtravel.com/event/malta-poker-festival-autumn-2024'

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.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'USD'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'GBP'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'USD'

0.0002 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.0003 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' 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.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.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.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` = 'page'

0.0069 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.0002 SECONDS:
SELECT tour_stops.*, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, uapi_airports.name as airport_name, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stops` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `uapi_airports` ON `tour_stops`.`uapi_code` = `uapi_airports`.`airport_code` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `tour_stops`.`id` = 'malta-poker-festival-autumn-2024'

0.0023 SECONDS:
SELECT tour_stops.*, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, uapi_airports.name as airport_name, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stops` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `uapi_airports` ON `tour_stops`.`uapi_code` = `uapi_airports`.`airport_code` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `tour_stops`.`page_url` = 'malta-poker-festival-autumn-2024'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = '110'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = '2503'

0.0015 SECONDS:
SELECT tour_stops.*, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stops` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE tour_stops.end_date > CURDATE() AND tour_stops.active = 1 AND `tour_id` = '2503' ORDER BY `tour_stops`.`start_date` ASC

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1437'

0.0011 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1437'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1438'

0.0011 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1438'

0.0009 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1439'

0.0013 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1439'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1440'

0.0011 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1440'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1441'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1441'

0.0008 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1442'

0.0013 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1442'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1443'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1443'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1444'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1444'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1491'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1491'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1492'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1492'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1493'

0.0011 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1493'

0.0008 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1494'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1494'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1445'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1445'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1446'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1446'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1447'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1447'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1555'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1555'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1448'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1448'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1460'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1460'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1461'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1461'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1462'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1462'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1463'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1463'

0.0008 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1449'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1449'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1450'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1450'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1451'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1451'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1464'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1464'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1556'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1556'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1557'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1557'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1452'

0.0011 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1452'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1453'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1453'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1454'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1454'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1455'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1455'

0.0008 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1457'

0.0014 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1457'

0.0008 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1465'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1465'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1456'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1456'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1458'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1458'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1459'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1459'

0.0002 SECONDS:
SELECT `uapi_airports`.*, `uapi_cities`.`name` as `city`, `uapi_countries`.`name` as `country` FROM `uapi_airports` JOIN `uapi_countries` ON `uapi_countries`.`country_code` = `uapi_airports`.`country_code` JOIN `uapi_cities` ON `uapi_cities`.`city_code` = `uapi_airports`.`reference_city` WHERE `airport_code` = 'MLA'

0.0108 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 `news_articles`.`active` = '1' ORDER BY `news_articles`.`date` DESC

0.0010 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.0007 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.0009 SECONDS:
SELECT packages.*, currencies.name as currency_name, currencies.ISO_4217_code as currency_code, currencies.symbol as currency_symbol, hotels.name as hotel_name, hotels.main_image as hotel_image, hotels.description as hotel_description, rooms.board_extras as board_extras, rooms.room_type as room_type, rooms.max_occupancy as occupancy, tour_stops.name as tour_stop_name, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS tour_stop_logo, tours.name as tour_name, tours.logo as tour_logo FROM `packages` LEFT JOIN `currencies` ON `currencies`.`id` = `packages`.`currency_id` LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `packages`.`tour_stop_id` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `rooms` ON `rooms`.`id` = `packages`.`room_id` LEFT JOIN `hotels` ON `hotels`.`id` = `rooms`.`hotel_id` WHERE packages.available_until > CURDATE() AND `tour_stops`.`id` = 2503 AND `packages`.`active` = 1 ORDER BY `packages`.`special_price` 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` = 'package'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '275' ORDER BY `days` DESC

0.0007 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '132' AND `date` >= '2024-10-30' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '132'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '276' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '133' AND `date` >= '2024-10-30' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '133'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '272' ORDER BY `days` DESC

0.0007 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '110' AND `date` >= '2024-10-31' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '110'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '253' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '132' AND `date` >= '2024-10-30' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '132'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '271' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '111' AND `date` >= '2024-10-31' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '111'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '254' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '133' AND `date` >= '2024-10-30' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '133'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '273' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '110' AND `date` >= '2024-10-30' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '110'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '274' ORDER BY `days` DESC

0.0007 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '111' AND `date` >= '2024-10-30' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '111'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '255' ORDER BY `days` DESC

0.0007 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '110' AND `date` >= '2024-10-30' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '110'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '256' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '111' AND `date` >= '2024-10-30' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '111'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '258' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '110' AND `date` >= '2024-10-29' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '110'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '259' ORDER BY `days` DESC

0.0007 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '111' AND `date` >= '2024-10-29' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '111'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '261' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '110' AND `date` >= '2024-10-29' AND `date` < '2024-11-05'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '110'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '257' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '150' AND `date` >= '2024-10-30' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '150'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '262' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '111' AND `date` >= '2024-10-29' AND `date` < '2024-11-05'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '111'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '260' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '150' AND `date` >= '2024-10-29' AND `date` < '2024-11-04'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '150'

0.0002 SECONDS:
SELECT * FROM `package_cancellation_policies` WHERE `package_id` = '263' ORDER BY `days` DESC

0.0006 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `room_nights` JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id` WHERE `availability` >0 AND `room_id` = '150' AND `date` >= '2024-10-29' AND `date` < '2024-11-05'

0.0001 SECONDS:
SELECT * FROM `rooms` WHERE `id` = '150'

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%all-events%'

English
Sun 27th October - Mon 4th November, 2024

Malta Poker Festival Autumn 2024

at The Casino at Portomaso, Portomaso, Malta

Features a €550 buy-in €500K GPP Main Event 

Looking for a bespoke Package? Email mpf@maineventtravel.com 

Upgrade your visit with a VIP Bracelet! 

#FinalTableFreeroll Eligible Events

Jump to...

Travel Search

Offers & Packages

5 Night 3* Hotel Valentina VIP Package for 1 + 1 Ladies First Buy-in
Malta Poker Festival - Bed & Breakfast + 1 x Ladies First Event Buy-In + 1 x Casino Drinks Package + 1 x Nightclub Entry + Concierge Service
FREE cancellation before 3rd Oct 2024
Wed 30th Oct to Mon 4th Nov
Superior - Single - 1 Adult
Bed and Breakfast Basis
1078 1048
5 Night 3* Hotel Valentina VIP Package for 2 + 1 Ladies First Buy-in
Malta Poker Festival - Bed & Breakfast + 1 x Ladies First Event Buy-In + 2 x Casino Drinks Packages + 2 x Nightclub Entries + Concierge Service
FREE cancellation before 3rd Oct 2024
Wed 30th Oct to Mon 4th Nov
Superior - Double - 2 Adults
Bed and Breakfast Basis
1166 1134
4 Night 5* Hilton VIP Package for 1 + 1 Ladies First Buy-in
Malta Poker Festival - Bed & Breakfast + 1 x Ladies First Event Buy-In + 1 x Casino Drinks Package + 1 x Nightclub Entry + Concierge Service
FREE cancellation before 3rd Oct 2024
Thu 31st Oct to Mon 4th Nov
Single Occupancy - 1 King Bed - 1 Adult
Bed & Breakfast
1320 1284
5 Night 3* Hotel Valentina VIP Package for 1 + 1 Grand Event Buy-In
Malta Poker Festival - Bed & Breakfast + 1 x Grand Event Buy-In + 1 x Casino Drinks Package + 1 x Nightclub Entry + Concierge Service
FREE cancellation before 3rd Oct 2024
Wed 30th Oct to Mon 4th Nov
Superior - Single - 1 Adult
Bed and Breakfast Basis
1463 1399
4 Night 5* Hilton VIP Package for 2 + 1 Ladies First Buy-in
Malta Poker Festival - Bed & Breakfast + 1 x Ladies First Event Buy-In + 2 x Casino Drinks Packages + 2 x Nightclub Entries + Concierge Service
FREE cancellation before 3rd Oct 2024
Thu 31st Oct to Mon 4th Nov
Double Occupancy – 1 King Bed - 2 Adults
Bed & Breakfast - 2 Queens on request subject to availability
1518 1476
5 Night 3* Hotel Valentina VIP Package for 2 + 1 Grand Event Buy-In
Malta Poker Festival - Bed & Breakfast + 1 x Grand Event Buy-In + 2 x Casino Drinks Package + 2 x Nightclub Entries + Concierge Service
FREE cancellation before 3rd Oct 2024
Wed 30th Oct to Mon 4th Nov
Superior - Double - 2 Adults
Bed and Breakfast Basis
1551 1489
5 Night 5* Hilton VIP Package for 1 + 1 Ladies First Buy-in
Malta Poker Festival - Bed & Breakfast + 1 x Ladies First Event Buy-In + 1 x Casino Drinks Package + 1 x Nightclub Entry + Concierge Service
FREE cancellation before 4th Oct 2024
Wed 30th Oct to Mon 4th Nov
Single Occupancy - 1 King Bed - 1 Adult
Bed & Breakfast
1573 1530
5 Night 5* Hilton VIP Package for 2 + 1 Ladies First Buy-in
Malta Poker Festival - Bed & Breakfast + 1 x Ladies First Event Buy-In + 2 x Casino Drinks Packages + 2 x Nightclub Entries + Concierge Service
FREE cancellation before 4th Oct 2024
Wed 30th Oct to Mon 4th Nov
Double Occupancy – 1 King Bed - 2 Adults
Bed & Breakfast - 2 Queens on request subject to availability
1798.5 1749
5 Night 5* Hilton VIP Package for 1 + 1 Grand Event Buy-In
Malta Poker Festival - Bed & Breakfast + 1 x Grand Event Buy-In + 1 x Casino Drinks Package + 1 x Nightclub Entry + Concierge Service
FREE cancellation before 3rd Oct 2024
Wed 30th Oct to Mon 4th Nov
Single Occupancy - 1 King Bed - 1 Adult
Bed & Breakfast
1958 1859
5 Night 5* Hilton VIP Package for 2 + 1 Grand Event Buy-In
Malta Poker Festival - Bed & Breakfast + 1 x Grand Event Buy-In + 2 x Casino Drinks Package + 2 x Nightclub Entries + Concierge Service
FREE cancellation before 3rd Oct 2024
Wed 30th Oct to Mon 4th Nov
Double Occupancy – 1 King Bed - 2 Adults
Bed & Breakfast - 2 Queens on request subject to availability
2183.5 2089
6 Night 5* Hilton VIP Package for 1 + 1 Grand Event Buy-In
Malta Poker Festival - Bed & Breakfast + 1 x Grand Event Buy-In + 1 x Casino Drinks Package + 1 x Nightclub Entry + Concierge Service
FREE cancellation before 3rd Oct 2024
Tue 29th Oct to Mon 4th Nov
Single Occupancy - 1 King Bed - 1 Adult
Bed & Breakfast
2211 2099
6 Night 5* Hilton VIP Package for 2 + 1 Grand Event Buy-In
Malta Poker Festival - Bed & Breakfast + 1 x Grand Event Buy-In + 2 x Casino Drinks Package + 2 x Nightclub Entries + Concierge Service
FREE cancellation before 3rd Oct 2024
Tue 29th Oct to Mon 4th Nov
Double Occupancy – 1 King Bed - 2 Adults
Bed & Breakfast - 2 Queens on request subject to availability
2464 2339
7 Night 5* Hilton VIP Package for 1 + 1 Grand Event Buy-In
Malta Poker Festival - Bed & Breakfast + 1 x Grand Event Buy-In + 1 x Casino Drinks Package + 1 x Nightclub Entry + Concierge Service
FREE cancellation before 3rd Oct 2024
Tue 29th Oct to Tue 5th Nov
Single Occupancy - 1 King Bed - 1 Adult
Bed & Breakfast
2464 2339
5 Night 5* Hilton VIP & Executive Club Package for 2 + 1 Grand Event Buy-In
Malta Poker Festival - Bed & Breakfast + 1 x Grand Event Buy-In + 2 x Hotel EXECUTIVE CLUB Access + 2 x Casino Drinks Package + 2 x Nightclub Entries + Concierge Service
FREE cancellation before 3rd Oct 2024
Wed 30th Oct to Mon 4th Nov
Executive – Double Occupancy – 1 King Bed - 2 Adults
Bed & Breakfast - Lounge Entry -2 Queens on Request Subject to Availability
2623.5 2479
7 Night 5* Hilton VIP Package for 2 + 1 Grand Event Buy-In
Malta Poker Festival - Bed & Breakfast + 1 x Grand Event Buy-In + 2 x Casino Drinks Package + 2 x Nightclub Entries + Concierge Service
FREE cancellation before 3rd Oct 2024
Tue 29th Oct to Tue 5th Nov
Double Occupancy – 1 King Bed - 2 Adults
Bed & Breakfast - 2 Queens on request subject to availability
2744.5 2599
6 Night 5* Hilton VIP & Executive Club Package for 2 + 1 Grand Event Buy-In
Malta Poker Festival - Bed & Breakfast + 1 x Grand Event Buy-In + 2 x Hotel EXECUTIVE CLUB Access + 2 x Casino Drinks Package + 2 x Nightclub Entries + Concierge Service
FREE cancellation before 3rd Oct 2024
Tue 29th Oct to Mon 4th Nov
Executive – Double Occupancy – 1 King Bed - 2 Adults
Bed & Breakfast - Lounge Entry -2 Queens on Request Subject to Availability
2992 2799
7 Night 5* Hilton VIP & Executive Club Package for 2 + 1 Grand Event Buy-In
Malta Poker Festival - Bed & Breakfast + 1 x Grand Event Buy-In + 2 x Hotel EXECUTIVE CLUB Access + 2 x Casino Drinks Package + 2 x Nightclub Entries + Concierge Service
FREE cancellation before 3rd Oct 2024
Tue 29th Oct to Tue 5th Nov
Executive – Double Occupancy – 1 King Bed - 2 Adults
Bed & Breakfast - Lounge Entry -2 Queens on Request Subject to Availability
3360.5 3149
Buy In FAQ

Major Events

Sun
27
MPF Grand Event Day 1A Special Price The Casino at Portomaso + Buy In Now
Tue
29
MPF Grand Event Day 1B The Casino at Portomaso + Buy In Now
Tue
29
Sviten Special hosted by Eva The Casino at Portomaso + Buy In Now
Tue
29
MPF Texas The Casino at Portomaso + Buy In Now
Wed
30
MPF Grand Event Day 1C The Casino at Portomaso + Buy In Now
Wed
30
Betsson One Bullet The Casino at Portomaso + Buy In Now
Wed
30
HORSE 5 Mix The Casino at Portomaso + Buy In Now
Wed
30
The Hendon Mob Championship Day 1 The Casino at Portomaso + Buy In Now
Wed
30
1 VIP Bracelet - upgrade includes Casino Drinks Package (tea/coffee/soda/water/house beer & wine) from 30th Oct - 4th Nov inclsuive + VIP Registration Access, Free Players Party Nightclub Entry The Casino at Portomaso + Buy In Now
Wed
30
2 VIP Bracelets - upgrade includes Casino Drinks Package (tea/coffee/soda/water/house beer & wine) from 30th Oct - 4th Nov inclusive + VIP Registration Access, Free Players Party Nightclub Entry The Casino at Portomaso + Buy In Now
Wed
30
3 VIP Bracelets - upgrade includes Casino Drinks Package (tea/coffee/soda/water/house beer & wine) from 30th Oct - 4th Nov inclusive + VIP Registration Access, Free Players Party Nightclub Entry The Casino at Portomaso + Buy In Now
Wed
30
4 VIP Bracelets - upgrade includes Casino Drinks Package (tea/coffee/soda/water/house beer & wine) from 30th Oct - 4th Nov inclusive + VIP Registration Access, Free Players Party Nightclub Entry The Casino at Portomaso + Buy In Now
Thu
31
MPF Grand Event Day 1D The Casino at Portomaso + Buy In Now
Thu
31
Bounty Hunter Days Malta The Casino at Portomaso + Buy In Now
Thu
31
MPF Halloween Special Edition The Casino at Portomaso + Buy In Now
Fri
1
10am - Private Bus Charter Hosted by Globetrotting Poker The Casino at Portomaso + Buy In Now
Fri
1
MPF Grand Event Day 1E The Casino at Portomaso + Buy In Now
Fri
1
LuxonPay Mystery Bounty Day 1 The Casino at Portomaso + Buy In Now
Fri
1
PLO Knight Crusaders hosted by Mayoman The Casino at Portomaso + Buy In Now
Fri
1
MPF Grand Event Day 1F The Casino at Portomaso + Buy In Now
Fri
1
MPF Grand Event Day 1G Turbo The Casino at Portomaso + Buy In Now
Sat
2
Ladies First! Hosted by KerryJane Craigie The Casino at Portomaso + Buy In Now
Sat
2
APAT Maltese Championship Day 1 The Casino at Portomaso + Buy In Now
Sat
2
Highroller UDSO Gold Day 1 The Casino at Portomaso + Buy In Now
Sat
2
MPF Grand Event Day 1H Turbo The Casino at Portomaso + Buy In Now
Sun
3
09.45am - Private Catamaran Adventure Hosted by Globetrotting Poker The Casino at Portomaso + Buy In Now
Sun
3
Turbo Showdown The Casino at Portomaso + Buy In Now
Sun
3
MPF Seniors Event hosted by Andreas Hoivold The Casino at Portomaso + Buy In Now
Sun
3
Highroller UDSO GOLD Day2 and FT The Casino at Portomaso + Buy In Now
Sun
3
MPF Deepstack The Casino at Portomaso + Buy In Now
Sun
3
Super Highroller hosted by Lukas Robinson The Casino at Portomaso + Buy In Now
Sun
3
Super Highroller Day2 hosted by Lukas Robinson The Casino at Portomaso + Buy In Now
Sun
3
MPF 8 Game The Casino at Portomaso + Buy In Now
Mon
4
Bounty Hunter Days Progressive Closer The Casino at Portomaso + Buy In Now
Mon
4
Win the Button The Casino at Portomaso + Buy In Now
Mon
4
MPF Last Chance The Casino at Portomaso + Buy In Now
   Download Full Schedule  
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.