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 = 453071444 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '4/7/2017' OR (SongInfo.ShowDate = '4/7/2017' AND SongInfo.ShowID < 453071444)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 144.6846
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)
U Street Music Hall     Washington, DC
 
Setlist
Friday
Setlist Changes
Shakedown Street and True Reflections cut from encore
Song Spread 
Live Collaboration
6  
Didn't I*, Free as a Bird*, Time for It*, Just a Little Bit, Wake the Funk Up, Never Too Late, Right on Time, La La, Roller, Dress, Whiskey, Dirty Down Low (Sex and Sugar), People*, The Spider Web*, Devil Woman*
*with Boyd Tinsley

The band did not play an encore due to time. It was slated to consist of Shakedown Street and True Reflections.
Song TitleTime  Last  Venue  Personnel 
Notes
1Didn't I  SD1 of 1Boyd
2Free as a Bird  SD1 of 1Boyd
3Time for It  SD1 of 1Boyd
4People  SD1 of 1Boyd
5The Spider Web  SD1 of 1Boyd
6Devil 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
487020514/3/2017 12:00:00 AM453071442Crystal Garden45155