0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

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

0.0064 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.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.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` = 'page'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'dusk-till-dawn'

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

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

0.0021 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.0122 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.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.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.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

Wednesday 2nd - Sunday 6th April, 2025

High Roller Weekend

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

1DAY1K | £100,000 GTD
SUN 6TH APRIL| £1,000+£100
5 X €1,150 IRISH OPEN SEATS ADDED

HIGH ROLLER [1-DAY EVENT] | £50,000 GTD
SAT APRIL 5TH | £500+£60

IRISH OPEN SAT | 5 X £1,500 PACKAGES GTD
SUN APRIL 6TH | £50+£10 [2RL]

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 16th - Sunday 20th April, 2025

DTD Easter Cup

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

MONSTER STACK | £10,000 GTD
18TH APRIL | £50+£10
[GTE INC 5 X £280 DTD250 SEATS]

EASTER CUP [1-DAY EVENT] | £50,000 GTD

19TH APRIL| £250+£30
[GTE INC 5 X £1,100 UKPC MASTERS SEATS]

EASTER SHIELD [1-DAY EVENT] | £25,000 GTD
20TH APRIL | £125+£25
[GTE INC 2 X £1,100 UKPC MASTERS SEAT]

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 29th April - Sunday 4th May, 2025

DTD125

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

DTD125 | 29TH APRIL - 4TH MAY
£100,000 GTD | £125+25 BUY-IN
[INC 9 x £1,100 UKPC MASTERS SEATS]

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 18th - Monday 29th December, 2025

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.