0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-26' AND `url` = 'https://www.maineventtravel.com/news/article/Dusk-Till-Dawn-Hosts-UKIPT-Nottingham-2024' ORDER BY `views` DESC

0.0091 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-12-26' AND `url` = 'https://www.maineventtravel.com/news/article/Dusk-Till-Dawn-Hosts-UKIPT-Nottingham-2024'

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.0003 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.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.0036 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.0037 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.0092 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.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` = '16' 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.0032 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.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.0032 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.0053 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.0039 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.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.0037 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.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.0006 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` = '28' 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.0032 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.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.0076 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.0074 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.0011 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.0025 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` = 'Dusk-Till-Dawn-Hosts-UKIPT-Nottingham-2024'

0.0011 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-12-26' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

0.0010 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.0006 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` = '1067'

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

English
Wednesday 16th October, 2024

Dusk Till Dawn Hosts UKIPT Nottingham 2024

By Kelly Saxby

Nottingham’s iconic Dusk Till Dawn poker club is gearing up to host the highly anticipated UK & Ireland Poker Tour (UKIPT) from November 8th to 18th, 2024. After the huge success of last year’s Main Event, which attracted over 1,200 entries, DTD is ready to welcome players from across the globe to Nottingham for this premier event on the poker calendar.

A £1,000,000 Main Event: The Crown Jewel

At the heart of the UKIPT festival is the Main Event, running from November 10th to 18th, with an eye-catching £1,000,000 guaranteed prize pool. The buy-in is set at £1,100, but for those looking to secure a seat at a lower cost, online and live satellite qualifiers are available through PokerStars and Dusk Till Dawn.

Featured Events: High Stakes and Exciting Tournaments

The UKIPT Nottingham festival offers more than just the Main Event, with a range of tournaments for players at different skill levels and bankrolls:

  • UKIPT Warm-Up: This £200+£30 event, running from November 8th to 10th, kicks off the festival with a £100,000 guarantee.
  • Luxon Pay High Roller: High-stakes players can take part in this event running November 13th-14th, with a £3,000+£200 buy-in and £100,000 guaranteed prize pool.
  • UKIPT Cup: Concluding the festival on November 17th-18th, this £300+£40 closing event still packs a punch with a £50,000 guaranteed prize pool.

From affordable buy-ins to major high-stakes games, the UKIPT Nottingham 2024 schedule caters to recreational and professional players alike.

Main Event Travel: Your Official Travel Partner

Main Event Travel is the Official Travel Partner, making it easier than ever to plan your trip to Nottingham. Whether you're seeking luxury or convenience, MET offers a variety of hotel options close to Dusk Till Dawn, offering competitive rates within close proximity to the action.

The Venue: Dusk Till Dawn – "The Home of UK Poker"

Dusk Till Dawn, Nottingham’s premier poker destination, has been the heart of the UK poker scene since it opened in 2007. With 45 tables and a history of hosting top-tier events such as the World Poker Tour (WPT), WSOP Circuit, and previous UKIPT editions, it’s no wonder Dusk Till Dawn has earned its reputation as a leading venue for poker in the UK. The club offers a welcoming atmosphere, exceptional facilities, and a world-class poker experience for all types of players.

How to Qualify for UKIPT Nottingham

PokerStars offers multiple ways to qualify for the UKIPT Nottingham Main Event, with online satellite qualifiers giving players a chance to win their £1,100 Main Event seats at a fraction of the buy-in cost. Additionally, live satellite events at Dusk Till Dawn provide further opportunities for players to secure their spot in this prestigious tournament.

A Must-Attend Event for Poker Players

Whether you’re a local player looking to prove your skills or an international pro chasing big prizes, the UKIPT Nottingham 2024 is shaping up to be a poker festival not to miss. The combination of Dusk Till Dawn’s renowned venue, exciting tournament lineup, and significant prize pools guarantees an unforgettable poker experience.

Photo Credit: PokerStars


Nottingham Hotels

Holiday Inn Nottingham
The Holiday Inn Nottingham is a super convenient and affordable choice for players competing at the UKIPT 2023 final. It’s close to the city centre but only a 30-minute walk or eight-minute drive from Dusk Till Dawn. Located in the Marina area, the hotel has got all the usual mod cons including 24-hour reception and check-out service, free WiFi, restaurant, free parking and on-site gym. The 128 modern rooms come with en suite bathroom, hairdryer, direct dial telephone, TV, complimentary tea- and coffee-making facilities and iron. Double beds come as standard. The relaxed Eaton's Brasserie restaurant serves a continental-style buffet, set menu lunch and evening dinner from either the set menu or à la carte. The bar area has an outside terrace and shows live sport on a plasma-screen TV. 

St James Hotel
St James Hotel describes itself as “hidden-gem luxury” in the heart of Nottingham city centre right opposite the castle. This comfy, modern ’87-room hotel – part of the Best Western Collection brand – is handy for Nottingham train station and surrounded by local attractions including museums, historical sites and first-rate shopping. All rooms come with free WiFi, blackout blinds, hairdryer, satellite TV, tea- and coffee-making facilities and iron. The No/6 Bar & Lounge offers round-the-clock service and one of Nottingham's finest cocktail bars. Reception is open 24/7 and there’s also room service and an on-site fitness centre. There’s discounted parking nearby and it’s just 12 minutes’ drive/cab ride to Dusk Till Dawn.

 

 

SACO Nottingham – The Ropewalk
With a number of very affordable one- or two-bed apartments, SACO Nottingham The Ropewalk could be an ideal option for players who are keen to keep costs down. Each apartment has a separate sleeping area plus a sofa bed so great for sharing. The spacious bedrooms come with king-size beds and blackout blinds. The fully-equipped kitchens feature washer/dryers, microwave, dishwasher and everything you need for cooking plus there’s also a dining table and chairs. Each apartment has a smart TV and super-fast Wi-Fi. There’s car parking (both underground or external) at £15/day and it’s a 10-minute drive to the venue. Check-in from 4pm; check out at 11am.

Travelodge Nottingham Central
Ideally located close to the city centre, Travelodge Nottingham Central is another affordable option and lies close to Nottingham train station. All rooms feature a comfy king-size bed with four plump pillows and a cosy duvet, tea- and coffee-making facilities, freeview TV, desk and chair, hairdryer, and ensuite shower. There’s a bar/lounge, restaurant and breakfast buffet. The NCP Arndale car park is nearby (additional charge) and it’s an eight-minute drive to the venue. Check-in from 3pm; check out at midday.

Best Western Plus Nottingham City Centre
The 3* Best Western Plus Nottingham City Centre is another affordable player option. Each spacious, air-conditioned room features free Wi-Fi and flat-screen televisions – including Sky Sports – plus a seating area, work desk and private bathroom with free toiletries and a hairdryer. A full English breakfast buffet is available in the airy Conservatory Restaurant and the Lounge Bar is open daily from 5pm to 11pm. There’s no evening dining but the hotel has teamed up with Deliveroo for takeaway deliveries. Parking is available nearby and there is parking available onsite at £15.50 per day plus some electric charging points. It’s a 10-minute drive to the venue. Check-in from 3pm; check out at 11am.

Leonardo Hotel Nottingham
Situated less than five minutes' walk from the train station and Nottingham tramway, this four-star hotel (formerly a Jury’s Inn) enjoys a central city location. The large spacious air-conditioned rooms feature a workspace area, free Wi-Fi, ensuite bathroom with free toiletries and tea- and coffee-making facilities. All guests have access to the on-site fitness room. The onsite Innfusion restaurant serves international cuisine or more informal dining is available at the Inntro Bar. Reception is open 24/7. There is car parking just two minutes away and it’s a 10-minute drive to the venue. Check-in from 3pm; check out at 11am.

 

Crowne Plaza Nottingham

Situated in the centre of Nottingham. The various shopping facilities, restaurants, bars and nightclubs can be reached within only a few minutes on foot. This comfortable and air-conditioned hotel (below) is spread over 8 floors and comprises 210 rooms, of which 2 are suites. There is a foyer with a 24-hour reception desk, a hotel safe, a cloakroom, a gym, lifts and a bar. In addition, there is public Internet access and an air-conditioned à la carte restaurant. Room and laundry services are also available. A car park is on offer to guests arriving by car. 

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.