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%'

English
Mon 27th January - Mon 3rd February, 2025

Costa Rica Poker Festival

at Sheraton Hotel San Jose, 350 Metros Oeste Multiplaza, 27, San José Province, San José, 10203, Costa Rica

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 RaftingIsland TourZipline 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

Offers & Packages

7 Night 4* Sheraton Hotel San Jose for 1 or 2 Adults + Grand Event Buy-in + Adventure Package
FREE cancellation before 17th Dec 2024
Mon 27th Jan to Mon 3rd Feb
Single or Double - King Bed (2 Queens on Advance Request) - 2 Adults
Bed and Breakfast for 1 or 2 Guests
Costa Rica Poker Festival Accommodation + 1 x Grand Event Buy-in+ 1 x Adventure Day + Player's Party Entry
2499 2299
Buy In FAQ

Major Events

Tue
28
Pura Vida Bounty BUY-IN Sheraton Hotel San Jose + Buy In Now
Wed
29
CR Main Event Day 1A BUY-IN Sheraton Hotel San Jose + Buy In Now
Wed
29
Tico Cup NL Holdem BUY-IN Sheraton Hotel San Jose + Buy In Now
Wed
29
Pacuare River White-Water Rafting Tour ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Wed
29
Poas Volcano Park & Doka Coffee Plantation ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Wed
29
Tortuga Island Tour ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Wed
29
Surf Lessons At Central Pacific ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Wed
29
Jaco Zipline Tour ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Wed
29
Golf In San Jose ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Thu
30
Pura Vida PLO Bounty 5 Card BUY-IN Sheraton Hotel San Jose + Buy In Now
Thu
30
CR Main Event Day 1B BUY-IN Sheraton Hotel San Jose + Buy In Now
Thu
30
Pacuare River White-Water Rafting Tour ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Thu
30
Poas Volcano National Park & Doka Coffee Plantation Tour ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Thu
30
Tortuga Island Tour ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Thu
30
Surf Lessons At Central Pacific ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Thu
30
Jaco Zipline Tour ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Thu
30
Golf in San Jose ADVENTURE DAY Sheraton Hotel San Jose + Buy In Now
Fri
31
CR Main Event Day 1C BUY-IN Sheraton Hotel San Jose + Buy In Now
Fri
31
LuxonPay Mystery Bounty Day1 BUY-IN Sheraton Hotel San Jose + Buy In Now
Fri
31
Texas Turbo BUY-IN Sheraton Hotel San Jose + Buy In Now
Sat
1
CR Main Event Day 1D BUY-IN Sheraton Hotel San Jose + Buy In Now
Sat
1
LIPS Costa Rica Championship Hosted by Chris Read BUY-IN Sheraton Hotel San Jose + Buy In Now
Sat
1
CR Main Event Day 1E Turbo BUY-IN Sheraton Hotel San Jose + Buy In Now
Sun
2
CR Main Event Day 1F Turbo BUY-IN Sheraton Hotel San Jose + Buy In Now
Sun
2
CR Seniors Event BUY-IN Sheraton Hotel San Jose + Buy In Now
Sun
2
CR Highroller BUY-IN Sheraton Hotel San Jose + Buy In Now
Sun
2
CR Turbo BUY-IN Sheraton Hotel San Jose + Buy In Now
Mon
3
Super Highroller BUY-IN Sheraton Hotel San Jose + Buy In Now
Mon
3
CR Last Chance BUY-IN Sheraton Hotel San Jose + 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.