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 = 453067407 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '7/29/2016' OR (SongInfo.ShowDate = '7/29/2016' AND SongInfo.ShowID < 453067407)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 124.8584
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)
Lafayette's     West Palm Beach, FL
 
Poster
All media for this show (1)
Friday
Song Spread 
Unreleased
1  
Live Collaboration
1  
S: People, Free As a Bird, La La, Dress, This Old House, Let Me Be Your God, Dream Captain, Wake the Funk Up, Devil Woman*, Roller, Shakedown Street, Jam*

*with Boyd Tinsley
Song TitleTime  Last  Venue  Personnel 
Notes
1Devil Woman  SD1 of 1Boyd
 Improv/Jam  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
12715/11/2016 12:00:00 AM453065393DMB792154
12729/11/1992 12:00:00 AM453055702Dave solo872257
12731/15/2014 12:00:00 AM453057148Dave & Tim926122
127412/13/2003 12:00:00 AM453056046Dave & Friends461276
12773/16/2013 12:00:00 AM453057075Yukon Kornelius1231119
127121/12/1993 12:00:00 AM453055495C-ville Allstars859953
127205/6/2001 12:00:00 AM453056944Jazzfest Superjam55631
127261/16/1994 12:00:00 AM453063247The Samples82301133
1273110/15/1994 12:00:00 AM453063256Phish79581133
127852/26/2016 12:00:00 AM453066392Phil & Friends1542155
12720458/3/2012 12:00:00 AM453057047Boyd & Tucker Rogers1456116
12791168/18/1995 12:00:00 AM453089621Dave, Roi & Stefan765141
487020517/22/2016 12:00:00 AM453067406Crystal Garden72155