0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0064 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/event/costa-rica-poker-festival-2025'
ORDER BY `views` DESC
0.0092 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/event/costa-rica-poker-festival-2025'
0.0004 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.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 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.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 `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.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.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.0038 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` = 'costa-rica-poker-festival-2025'
0.0024 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` = 'costa-rica-poker-festival-2025'
0.0001 SECONDS: SELECT *
FROM `tours`
WHERE `id` = '189'
0.0001 SECONDS: SELECT *
FROM `tours`
WHERE `id` = '2594'
0.0016 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` = '2594'
ORDER BY `tour_stops`.`start_date` ASC
0.0008 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1537'
0.0011 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1537'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1538'
0.0012 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1538'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1539'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1539'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1495'
0.0011 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1495'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1496'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1496'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1497'
0.0011 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1497'
0.0008 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1498'
0.0011 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1498'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1499'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1499'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1500'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1500'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1540'
0.0011 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1540'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1541'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1541'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1501'
0.0011 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1501'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1502'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1502'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1503'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1503'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1504'
0.0011 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1504'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1505'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1505'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1506'
0.0011 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1506'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1542'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1542'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1543'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1543'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1544'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1544'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1546'
0.0011 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1546'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1547'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1547'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1548'
0.0011 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1548'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1549'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1549'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1550'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1550'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1551'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1551'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1552'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1552'
0.0007 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1553'
0.0010 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1553'
0.0008 SECONDS: SELECT *
FROM `buy_ins`
WHERE `event_id` = '1554'
0.0012 SECONDS: SELECT *
FROM `events`
WHERE `shared_inventory_event_id` = '1554'
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` = 'SJO'
0.0069 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.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.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.0008 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` = 2594 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` = '282'
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` = '152'
AND `date` >= '2025-01-27'
AND `date` < '2025-02-03'
0.0002 SECONDS: SELECT *
FROM `rooms`
WHERE `id` = '152'
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.
at Sheraton Hotel San Jose, 350 Metros Oeste Multiplaza, 27, San José Province, San José, 10203, Costa Rica
SHARE
Enjoy a $100,000 GPP $550 Grand Event, a High Roller, Mystery Bounty, 5 Card PLO Bounty, Ladies Event, Seniors Event and more!
And some amazing adventures including White-Water Rafting, Island Tour, Zipline , Volcano & Coffee Plantation, Surf Lessons , Golf In San Jose
*Adventures are organised by a 3rd party supplier nominated by CRPF. MET acts as a payment provider. Contact details will be provided 7 days prior to your adventure. For specific dates email info@maineventtravel.com.
Jump to...
Travel Search
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!
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.