0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0065 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-23'
AND `url` = 'https://www.maineventtravel.com/'
ORDER BY `views` DESC
0.0131 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-23'
AND `url` = 'https://www.maineventtravel.com/'
0.0006 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.0136 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`.`active` = '1'
ORDER BY `start_date` ASC
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` = 'tour'
0.0004 SECONDS: SELECT *
FROM `tours`
WHERE `display_on_homepage` = '1'
AND `active` = '1'
AND `festival` = '0'
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.0018 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_on_homepage` = '1'
LIMIT 30
0.0005 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0041 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.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 `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0003 SECONDS: SELECT `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.0289 SECONDS: SELECT `tours`.`name`, `tours`.`id`, SUM(CASE When tour_stops.end_date > curdate() Then 1 Else 0 End ) as total_stops
FROM `tours`
LEFT JOIN `tour_stops` ON `tours`.`id` = `tour_stops`.`tour_id`
GROUP BY `tours`.`id`
ORDER BY `total_stops` DESC
LIMIT 24
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0430 SECONDS: SELECT `tours`.`name`, `tours`.`id`, SUM(CASE When tour_stops.end_date > curdate() Then 1 Else 0 End ) as total_stops
FROM `tours`
LEFT JOIN `tour_stops` ON `tours`.`id` = `tour_stops`.`tour_id`
GROUP BY `tours`.`id`
ORDER BY `total_stops` 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` = 'tour'
0.0151 SECONDS: SELECT `country`, SUM(CASE When tour_stops.end_date > curdate() Then 1 Else 0 End ) as total_stops
FROM `venues`
JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id`
WHERE `country` != ""
GROUP BY `country`
ORDER BY `total_stops` DESC
LIMIT 12
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0105 SECONDS: SELECT `country`, count(tour_stops.venue_id) as total_stops
FROM `venues`
JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id`
WHERE `country` != ""
GROUP BY `country`
ORDER BY `total_stops` DESC
0.0004 SECONDS: SELECT `rooms`.*, `hotels`.`name` as `hotel_name`, `hotels`.`main_image` as `hotel_image`, `currencies`.`symbol` as `currency_symbol`, `currencies`.`ISO_4217_code` as `currency_code`, `hotels`.`map_longitude` as `hotel_map_longitude`, `hotels`.`map_latitude` as `hotel_map_latitude`
FROM `rooms`
JOIN `hotels` ON `hotels`.`id` = `rooms`.`hotel_id`
JOIN `currencies` ON `hotels`.`currency_id` = `currencies`.`id`
WHERE `promote` = 1
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.0005 SECONDS: SELECT `packages`.*, `tour_stops`.`start_date` as `tour_stop_start`, `currencies`.`ISO_4217_code` as `currency_code`, `tour_stops`.`tour_id` as `tour_id`, `tour_stops`.`end_date` as `tour_stop_end`, `tour_stops`.`name` as `tour_stop_name`, `tour_stops`.`id` as `tour_stop_id`, `currencies`.`symbol` as `currency_symbol`
FROM `packages`
JOIN `tour_stops` ON `tour_stops`.`id` = `packages`.`tour_stop_id`
JOIN `currencies` ON `currencies`.`id` = `packages`.`currency_id`
WHERE packages.available_until > CURDATE()
AND `promote` = 1
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `white_label_versions`.`id`
FROM `white_label_versions`
WHERE `url` = 'maineventtravel.com'
0.0004 SECONDS: SELECT `news_articles`.*
FROM `news_articles`
JOIN `white_label_inclusions` ON `white_label_inclusions`.`entity_id` = `news_articles`.`id`
WHERE `date` <= '2024-11-23'
AND `white_label_inclusions`.`entity_type` = 'news-home'
AND `white_label_inclusions`.`white_label_version_id` = 0
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` = '1070'
0.0001 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` = '1069'
0.0026 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`.`active` = '1'
AND `tour_stops`.`end_date` > curdate()
ORDER BY `start_date` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0009 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `room_nights`
JOIN `rooms` ON `rooms`.`id` = `room_nights`.`room_id`
WHERE `availability` >0
AND `room_id` = '152'
AND `rooms`.`min_stay` <= 7
AND `rooms`.`max_stay` >= 7
AND `date` >= '2025-01-27'
AND `date` < '2025-02-03'
0.0002 SECONDS: SELECT *
FROM `rooms`
WHERE `id` = '152'
0.0002 SECONDS: SELECT *
FROM `uapi_rate_categories`
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.
MainEventTravel.com provides you with the opportunity to book flights, hotels and buy ins (where permitted by local regulations) to poker events around the world. There are a number of new features that we will be adding in the coming weeks, but please get in touch if there is anything that you think we could improve upon, or that would benefit our community.
We hope that you find the site practical and easy to use. We would really appreciate any feedback that you provide us about the site, which will assist us in being the premier travel site for poker players throughout the world.
Special Offer 27th Jan - 3rd Feb, 20257 Night 4* Sheraton Hotel San Jose for 1 or 2 Adults + Grand Event Buy-in + Adventure PackageCosta Rica Poker Festival
Accommodation + 1 x Grand Event Buy-in+ 1 x Adventure Day + Player's Party Entry$2499$2299SAVE $200
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.
£ GBP
$ USD
€ EUR
