0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0054 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-27' AND `url` = 'https://www.maineventtravel.com/venue/dusk-till-dawn' ORDER BY `views` DESC

0.0818 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-07-27' AND `url` = 'https://www.maineventtravel.com/venue/dusk-till-dawn'

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.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.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0005 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.0069 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.0001 SECONDS:
SELECT * FROM `venues` WHERE `id` = 'dusk-till-dawn'

0.0004 SECONDS:
SELECT * FROM `venues` WHERE `page_url` = 'dusk-till-dawn'

0.0011 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_stops`.`venue_id` = '2' ORDER BY `tour_stops`.`start_date` ASC

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

English

Dusk Till Dawn


Dusk Till Dawn Nottingham is Europe's premier Poker venue based in Nottingham, offering 45 poker tables with a capacity to comfortably sit 450 players at any one time with varied buy-ins to suit all levels.

All games are dealer dealt by professionals trained to the highest standard, they hold a wide variety of cash games - Hold'em, Omaha and Dealers Choice with stakes as low as £1/£1 up to £5/£10 and you can reserve your tournament seat online in advance.

Their Cash Game ‘Spinner Promotion’ gives the opportunity to win prizes as big as £2,500. DTD also hosts quarterly Cash Game weekends with great guaranteed cash prizes of at least £15,000.

Dusk Till Dawn is the venue of choice for many poker festivals, hosting a variety of buy-in events throughout the year.

MainEventTravel.com is the Official Travel Partner of Dusk Till Dawn


Upcoming Events at this Venue

Tuesday 6th - Sunday 11th August, 2024

Dusk Till Dawn

DTD100

DTD100: 6TH - 11TH AUGUST 2024
£100+£20 Buy-In: £100,000 GTD
[Including 9 x £340 DTD Series Seats]

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 13th - Sunday 18th August, 2024

Dusk Till Dawn

DTD Series

DTD Series Main Event:
£100,000 GTD - £300+£40 Buy-In
[£5,300 DTD Championship Seat Inc]

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 21st - Monday 26th August, 2024

APAT

WCOAP 2024

Buy-In: £210

    Find Hotels, Flights & More       View Complete Schedule  


Friday 8th - Monday 18th November, 2024

UKIPT

UKIPT Nottingham

The final stop of the UK & Ireland Poker Tour will be returning this November, along with the massive £1,000,000 guaranteed Main Event. That means Nottingham is once again home to some of the biggest poker prize pools of the season.

And with Dusk Till Dawn Poker and Casino hosting for another year, players are sure to receive an unrivalled experience on the felt when the cards start flying. How can you be part of the last UKIPT stop of 2024 and get your hands on a share of that awesome guarantee?

UKIPT Cup: Dates TBC - £330

UKIPT Main Event: November 10-18 - £1,100 (£1,000,000 GTD)

UKIPT High Roller: Dates TBC - £2,200

Win Back Up to 100% of Your Tournament Travel Costs - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 29th November - Sunday 1st December, 2024

APAT

APAT Poker Squads Live 2024

7pm at Dusk Till Dawn 

Buy In: £120.00

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 18th - Sunday 22nd December, 2024

Dusk Till Dawn

Dusk Till Dawn Championship

£1M GTD: £5,000+£300 Buy-In

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 26th - Monday 30th December, 2024

Dusk Till Dawn

DTD Christmas Cup

Featured Tournaments

Holiday High Roller KO
23rd December - £500+£60 Buy-In

Festive Five Hundred
28th December - £500+£60 Buy-In

Christmas Shield
29th December - £100+£20 Buy-In

DTD Christmas Cup
30th December - £220+£30 Buy-In

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Saturday 18th - Monday 27th January, 2025

UK Poker Championships

UK Poker Championships

The UK Poker Championship returns live to Dusk Till Dawn in January 2025 with a £500,000 guaranteed Main Event prize pool.

    Find Hotels, Flights & More       Full Schedule Coming Soon  
Latest News & Blogs

Free Travel Credit and a Chance to Win up to £500 Value at Goliath

MainEventTravel.com is excited to be on-site at Goliath from 26th July offering FREE Poker Travel Credit to everyone who visits our stand.

Special Offers on London Poker Festival Packages Available Now!

MainEventTravel has exclusive offers on Accommodation + Buy-in Packages, along with Flights, Hotels and Buy-ins.
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.