SELECT SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate, SongInfo.ShowID, ShowArtists.ShortName, ArtistCategories.CategoryName, DATEDIFF (D, SongInfo.ShowDate, ThisShow.ShowDate) NumDays, ShowInfo.TourID FROM SongInfo INNER JOIN SongInfo ThisShow ON ThisShow.SongID = SongInfo.SongID AND ThisShow.ShowID = 453070412 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID INNER JOIN ArtistCategories ON ShowArtists.ArtistCategoryID = ArtistCategories.CategoryID WHERE (SongInfo.ShowDate < '12/8/2016' OR (SongInfo.ShowDate = '12/8/2016' AND SongInfo.ShowID < 453070412)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 201.7149
TOTAL ITERATIONS: 1
DMBAlmanac.com
   the dave matthews band tour almanac
 home | contact | submit | support us | about
Tours / Stats Songs Lyrics Guests Venues Search Discography Lists  
 · 1991 · 1992 · 1993 · 1994 · 1995 · 1996 · 1997 · 1998 · 1999 · 2000 · 2001 · 2002 · 2003 · 2004 · 2005 · 2006 · 2007 · 2008 · 2009 · 2010 · 
 · 2011 · 2012 · 2013 · 2014 · 2015 · 2016 · 2017 · 2018 · 2019 · 2020 · 2021 · 2022 · 2023 · 2024 · 2025 · 2026 ·  		Live
Setlist
Tour:SummaryShowsSongsGuestsMedia
Crystal Garden (Boyd guesting)
The Mercury Room     Edmonton, AB, CAN
 
Poster
All media for this show (1)
Thursday
Song Spread 
Live Collaboration
5  
Just a Little Bit, Firecracker, Free as a Bird, Roller, Dress, Didn't I*, People Are People*, Let Me Be Your God*, Mayfield » This Old House, Right on Time, La La, The Miracle, Dream Captain*, Devil Woman*

*with Boyd Tinsley
Song TitleTime  Last  Venue  Personnel 
Notes
1Didn't I  SD1 of 1Boyd
2People  SD1 of 1Boyd
3Let Me Be Your God   1  1 of 1Boyd
4Dream Captain  SD1 of 1Boyd
5Devil Woman  SD1 of 1Boyd
All statistical information and computations copyright ©2002, Matias Nino and Rob Bokon. No portion of dmbalmanac.com may be reproduced without permission. Portions of the site, specifically lyrics and songtitles are copyright Colden Grey, Ltd., Bama Rags Records, Red Light Management, RCA and/or BMG. Show posters are copyright their respective artists.
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
4867205112/7/2016 12:00:00 AM453070411Crystal GardenOpeners and Collaborators12155
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
486720514/12/2016 12:00:00 AM453067394Crystal GardenOpeners and Collaborators2402155
486820514/12/2016 12:00:00 AM453067394Crystal GardenOpeners and Collaborators2402155
487020514/12/2016 12:00:00 AM453067394Crystal GardenOpeners and Collaborators2402155
490120517/11/2016 12:00:00 AM453067400Crystal GardenOpeners and Collaborators1502155
9905205112/3/2016 12:00:00 AM453070410Crystal GardenOpeners and Collaborators52155