SELECT SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate, SongInfo.ShowID, ShowArtists.ShortName, DATEDIFF (D, SongInfo.ShowDate, ThisShow.ShowDate) NumDays, ShowInfo.TourID FROM SongInfo INNER JOIN SongInfo ThisShow ON ThisShow.SongID = SongInfo.SongID AND ThisShow.ShowID = 453070415 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '12/14/2016' OR (SongInfo.ShowDate = '12/14/2016' AND SongInfo.ShowID < 453070415)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 192.4198
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)
Divan Orange     Montreal, QC, CAN
 
Poster
All media for this show (1)
Wednesday
Song Spread 
Live Collaboration
5  
Unreleased
1  
Just a Little Bit, Firecracker, Free as a Bird, Wake the Funk Up, Dress, People Are People*, Let Me Be Your God*, Didn't I*, The Miracle, La La, Roller, Never Too Late, Billy Miller, Improv Jam*, Dream Captain*, Devil Woman*

*with Boyd Tinsley
Song TitleTime  Last  Venue  Personnel 
Notes
1People  SD1 of 1Boyd
2Let Me Be Your God  SD1 of 1Boyd
3Didn't I  SD1 of 1Boyd
 Improv/Jam  SD1 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.
SongIDArtistIDShowDateShowIDShortNameNumDaysTourID
12718/29/2016 12:00:00 AM453065434DMB1072154
12729/11/1992 12:00:00 AM453055702Dave solo886057
12731/15/2014 12:00:00 AM453057148Dave & Tim1064122
127412/13/2003 12:00:00 AM453056046Dave & Friends475076
12773/16/2013 12:00:00 AM453057075Yukon Kornelius1369119
127121/12/1993 12:00:00 AM453055495C-ville Allstars873753
127205/6/2001 12:00:00 AM453056944Jazzfest Superjam57011
127261/16/1994 12:00:00 AM453063247The Samples83681133
1273110/15/1994 12:00:00 AM453063256Phish80961133
127852/26/2016 12:00:00 AM453066392Phil & Friends2922155
12720458/3/2012 12:00:00 AM453057047Boyd & Tucker Rogers1594116
127205112/13/2016 12:00:00 AM453070414Crystal Garden12155
12791168/18/1995 12:00:00 AM453089621Dave, Roi & Stefan778941
4867205112/13/2016 12:00:00 AM453070414Crystal Garden12155