0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

0.0006 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.0007 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

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

0.0003 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.0118 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.0007 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.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'dusk-till-dawn'

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

0.0020 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.0161 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.0014 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.0004 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 24th - Sunday 28th April, 2024

Cash Game Week

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

The Cash Game Week returns from 24th - 28th April with £15,000 IN GUARANTEED CASH GIVEAWAYS including £5,000 in Cash Giveaways and A £10,000 RAFFLE DRAW.

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 30th April - Sunday 5th May, 2024

DTD100

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

£100+£20 Buy-In Main Event: £100,000 GTD

The DTD100 is a regular multi-day event offering a huge £100,000 prizepool

[Inc 9 x £340 DTDSeries Seats]

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 4th - Sunday 9th June, 2024

DTD100

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

£100+£20 Buy-In: £100,000 GTD
[Including 9 x £340 DTD Series Seats]

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 18th - Sunday 23rd June, 2024

DTD Series

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

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

DTD Series High Roller:

£50,000 GTD - £1,000+£100 Buy-In

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 18th - Sunday 22nd December, 2024

Dusk Till Dawn Championship

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

Coming Soon.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 26th - Monday 30th December, 2024

DTD Christmas Cup

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

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