0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0097 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-09' AND `url` = 'https://www.maineventtravel.com/news/article/Roll-on-EPT-Prague-Hotel-Lowdown-for-your-December-Trip' ORDER BY `views` DESC

0.0120 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-09' AND `url` = 'https://www.maineventtravel.com/news/article/Roll-on-EPT-Prague-Hotel-Lowdown-for-your-December-Trip'

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.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 * 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.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.0060 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.0038 SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date FROM `news_categories` JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` GROUP BY `news_categories`.`id`

0.0075 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '11' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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` = 'news'

0.0004 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.0036 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '16' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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` = '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.0026 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '18' AND `news_articles`.`active` = 1 ORDER BY `date` 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` = 'news'

0.0004 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.0033 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '19' AND `news_articles`.`active` = 1 ORDER BY `date` 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` = 'news'

0.0004 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.0048 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '22' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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` = 'news'

0.0004 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.0033 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '23' AND `news_articles`.`active` = 1 ORDER BY `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.0038 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '27' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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` = 'news'

0.0004 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.0033 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '28' AND `news_articles`.`active` = 1 ORDER BY `date` 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` = 'news'

0.0004 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.0031 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '29' AND `news_articles`.`active` = 1 ORDER BY `date` 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` = 'news'

0.0004 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.0066 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '30' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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` = 'news'

0.0004 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.0050 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '31' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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` = 'news'

0.0004 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.0023 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 `url_name` = 'Roll-on-EPT-Prague-Hotel-Lowdown-for-your-December-Trip'

0.0010 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 `date` <= '2024-11-09' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

0.0009 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.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` = '906'

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%article%'

English
Monday 30th October, 2023

Roll on EPT Prague – Hotel Lowdown for your December Trip

By Mad Harper

 EPT Prague is actually two PokerStars festivals rolled into one – the mid-stakes Eureka Poker Tour and the EPT. The €1,100 Eureka Main Event gets underway on December 7 with the EPT Main Event kicking off four days later on December 11. The two-festival combo has been a mainstay of both the Eureka and EPT calendars for over a decade and gives players of all kinds the chance to join the action in the Czech capital. There are 60 different tourneys on the schedule including the €2,200 Eureka High Roller, €440 Eureka Cup, €10,300 EPT High Roller & €50k Super High Roller plus the €3k EPT Mystery Bounty.

Prague is a supremely affordable location with a ton of great accommodation options within easy walking distance of the riverside EPT venue. The best places to stay are hotels which lie between the city centre and the venue – so you can take advantage of Prague’s fantastic offering of bars, restaurants, clubs and sightseeing attractions as well as play poker.

MainEventTravel rates Prague highly as a poker destination; it’s a beautiful city and one of the few places where you can stay somewhere really fabulous for a very low price.

Below are six conveniently located hotels to whet your appetite.

Botanique Hotel Prague
The 4* Botanique Hotel Prague (pictured below) is a stylish, modern hotel with an eco-friendly approach. It’s just around the corner from the EPT venue and 20 minutes’ walk into Prague Old Town. The recently renovated and expanded gym is open 24/7 which is handy for players who feel the need to hit the treadmill in the middle of the night. The 214 spacious rooms are well-equipped with comfy beds, organic, vegan toiletries in the bathrooms, tea- and coffee-making facilities, minibar, flat-screen TVs & powerful Wi-Fi. The hotel’s commitment to being eco-friendly includes a self-service laundry and a free electric vehicle charging point in the underground car park. The hotel has an onsite Bistro & Bar serving local and fresh cuisine as well signature cocktails. Room service is available until 10pm and the Botanique Market vending machine in the lobby has a wide selection of snacks and drinks. The front desk is open round the clock. Check in from 3pm, check out by midday.

Mucha Hotel

The 4* Mucha Hotel (pictured below) is another modern hotel located close to the EPT venue and just 24 minutes’ walk to the city centre. The traditional exterior belies the stylish décor of the rooms which are all equipped with satellite TV, minibar, mood lighting options, free WiFi and tea- and coffee-making facilities. A well-stocked buffet breakfast is included in all room rates and gets rave reviews from guests. There is an onsite café/restaurant and the pavement terrace is great for people-watching and a revitalising coffee before you head off to the tournament. The front desk is open 24/7. Check in from 3pm, check out by 11am.

Hotel Opera

The 4* Hotel Opera (pictured below) is a palatial-looking, neo-renaissance family-owned hotel located just seven minutes’ walk from the EPT venue and less than 20 minutes into the centre of Prague. The hotel has been completely refurbished and all 67 rooms come with soundproofed windows, seating area, high-speed WiFi, satellite TV, a mini-bar and newly outfitted bathrooms. Other hotel amenities include an onsite restaurant, bar and fitness centre including sauna and jacuzzi. The restaurant serves traditional Czech dishes and international cuisine and there’s also a hotel bar where you can sample classic Czech beers. There’s also room service. The front desk is open 24/7. Check in from 2pm, check out by 11am.

Hotel Merkur
The 4* Hotel Merkur (pictured below) is a very affordable option, ideally located just seven minutes’ walk from the EPT and 18 minutes’ walk from Prague Old Town. The hotel dates back to the 1930s when it was built on the site of a 16th century brewery and lies close to the bustling Palladium shopping mall – handy for picking up snacks before you head to the tourney. The hotel’s spacious rooms are equipped with desk area, small flat screen TV, minibar and free Wifi. The Merkur Hotel has an onsite restaurant serving Czech and international cuisine. The buffet breakfast includes traditional homemade bread and pastries. Poker players hankering to get the synapses with a game of pre-tourney chess will appreciate the dedicated chess tables at the onsite Café Merkur. There is room service and a 24-hour front desk. Check in from 2pm, check out by 11am. 

Grandior Hotel Prague

The 5* Grandior Hotel Prague (pictured below) is a more luxurious option – a large, modern 393-room property with room service, 24-hour front desk and free Wifi throughout. The stylish, contemporary and spacious rooms are air-conditioned and come equipped with LCD satellite TV, flat screen TV, a minibar, writing desk, and free tea- and coffee-making facilities. The bathroom features L´Occitane toiletries, bathrobes, slippers and underfloor heating. A well-stocked breakfast buffet is on offer. The hotel has a large gym, open 24/7, with cardiovascular equipment and free weights. The Lobby Bar serves drinks, snacks and sandwiches while the hotel restaurant specialises in fine Czech and international cuisine. Check in from 3pm, check out by midday.

Hotel Planet Prague

Designed by a Spanish architect, the newly-opened 4* Hotel Planet (pictured below) is an unusual boutique hotel offering accommodation in 13 stylish and comfortably furnished rooms, all with unique views of the city. The EPT venue is just seven minutes’ walk and it’s an 18 minute walk into Prague Old Town. The entire hotel is located on the sixth floor of a traditional property (don’t worry, there’s a lift!) Although there is no onsite restaurant, free coffee is available and a full American breakfast is served for guests at a nearby restaurant. There is free WiFI throughout the hotel and each room is soundproofed and features a desk, tea- and coffee-making facilities, a fridge, minibar and flat-screen TV. Some of the rooms also come with a terrace. Shopping, restaurants, bars, cafes – including the historic Cafe Imperial – are minutes away by foot. The front desk is open from 8am to 10pm. Check-in is from 2pm, check-out by 10am.

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.