0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0112 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-10-09' AND `url` = 'https://www.maineventtravel.com/tour/dusk-till-dawn' ORDER BY `views` DESC

0.0154 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-10-09' AND `url` = 'https://www.maineventtravel.com/tour/dusk-till-dawn'

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.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0006 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.0046 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.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.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'dusk-till-dawn'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'dusk-till-dawn'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = '2'

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

0.0087 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.0003 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

Dusk Till Dawn


Dusk Till Dawn Poker & Casino 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. Try your luck at DTD's electronic gaming, Live Blackjack and Roulette or watch one of the 24 plasma screens showing major sporting events. Have a snack or meal in the bar area or call on the quick and efficient valets!

Upcoming Tour Stops

Friday 10th - Sunday 12th October, 2025

Big Weekender

Dusk Till Dawn, Redfield Way, Boulevard Retail Park, Lenton, Nottingham, NG7 2UW

MONSTER STACK | FRI 10TH OCT
£12,500 GTD | £50+£10 BUY-IN
[INC 9 x £280 DTD250 SEATS]

DTD250 [1-DAY EVENT] | SAT 11TH OCT

£40,000 GTD | £250+£30 BUY-IN
[INC 3 x £1,500 WSOP-C MAIN SEATS]

DTD250 [1-DAY EVENT] | SUN 12TH OCT
£20,000 GTD | £125+£25 BUY-IN
[INC 2 x £1,500 WSOP-C MAIN SEATS]

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 28th October - Sunday 2nd November, 2025

DTD125

Dusk Till Dawn, Redfield Way, Boulevard Retail Park, Lenton, Nottingham, NG7 2UW

DTD125 | 28th OCT - 2nd NOV
£100,000 GTD | £125+£25 BUY-IN
[INC 8 x £1,500 WSOP-C SEATS]

ONLINE MEGA SAT | 27th Oct | 8.05PM

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 17th December, 2025 - Sunday 4th January, 2026

DTD Christmas Cup 2025

Dusk Till Dawn, Redfield Way, Boulevard Retail Park, Lenton, Nottingham, NG7 2UW

Main Event: £220+£30 Buy-In

    Find Hotels, Flights & More       Full Schedule Coming Soon  
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.