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%'
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
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
10781048
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
11661134
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
13201284
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
14631399
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
15181476
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
15511489
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
15731530
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.51749
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
19581859
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.52089
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
22112099
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
24642339
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
24642339
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.52479
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.52599
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
29922799
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
Your search results are valid for .
Go to checkoutMore 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.