0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0076 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-06'
AND `url` = 'https://www.maineventtravel.com/'
ORDER BY `views` DESC

0.0108 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-06'
AND `url` = 'https://www.maineventtravel.com/'

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.0121 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.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.0003 SECONDS: 
SELECT *
FROM `tours`
WHERE `display_on_homepage` = '1'
AND `active` = '1'
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.0016 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.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.0001 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.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.0057 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.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.0204 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.0195 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.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.0083 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.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.0073 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.0003 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.0026 SECONDS: 
SELECT tour_stops.*, ((ACOS(SIN(36.11502056411551 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(36.11502056411551 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-115.19811808150632 - venues.map_longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance
FROM `tour_stops`
JOIN `venues` ON `tour_stops`.`venue_id` = `venues`.`id`
WHERE `tour_stops`.`start_date` > '2016-05-15' AND `tour_stops`.`start_date` < '2016-06-04'
HAVING `distance` <= 10

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.0004 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.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 `white_label_versions`.`id`
FROM `white_label_versions`
WHERE `url` = 'maineventtravel.com'

0.0003 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
JOIN `white_label_inclusions` ON `white_label_inclusions`.`entity_id` = `news_articles`.`id`
WHERE `date` <= '2024-11-06'
AND `white_label_inclusions`.`entity_type` = 'news-home'
AND `white_label_inclusions`.`white_label_version_id` = 0

0.0017 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.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.0006 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.0001 SECONDS: 
SELECT *
FROM `rooms`
WHERE `id` = '152'

0.0001 SECONDS: 
SELECT *
FROM `uapi_rate_categories`
English
Your trip starts here...
Search anywhere using the form below, click here to search for events, or have a look at the calendar to see what's on!
Flights
From
To
Cabin Class & Travellers
1 Adult, Economy
Hotels
Staying near
Rooms
Guests
1 Adult


Rates

















Dates of Travel
Dates of Travel Close

Events, Flights & Hotels all in One Place!

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, 2025 7 Night 4* Sheraton Hotel San Jose for 1 or 2 Adults + Grand Event Buy-in + Adventure Package Costa Rica Poker Festival Accommodation + 1 x Grand Event Buy-in+ 1 x Adventure Day + Player's Party Entry €2189 €2089SAVE €100
Book Now
We are proud to be the official travel partners of
Irish Poker Festival
Costa Rica Poker Festival
888poker LIVE
GUKPT Grosvenor
Malta Poker Festival
EAPT
Grosvenor Goliath
Irish Poker Open
Irish Poker Tour
Dusk Till Dawn

My Calendar
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.