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 = 453069410 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 < '10/12/2016' OR (SongInfo.ShowDate = '10/12/2016' AND SongInfo.ShowID < 453069410)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 129.184
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
Dave Matthews
Standing Rock Indian Reservation     Fort Yates, ND
 
Wednesday
Song Spread 
Before These Crowded Streets
1  
Dave played unplugged with a woman holding a microphone in front of him.

This set may be incomplete, but this is probably it.
Song TitleTime  Last  Venue  Personnel 
Notes
1Don't Drink the Water   2  1 of 1This Land Is Your Land interpolation
All songs feature the lineup of Dave Matthews unless noted above.
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
4919/2/2016 12:00:00 AM453065436DMBDMB402154
49210/11/2016 12:00:00 AM453068423Dave soloDave Side Projects11154
49310/1/2016 12:00:00 AM453067405Dave & TimDave Side Projects111154
49412/13/2003 12:00:00 AM453056046Dave & FriendsDave Side Projects468776
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
4914/18/1998 12:00:00 AM453054683DMBDMB675223
4927/1/1998 12:00:00 AM453056508Dave soloDave Side Projects667823
4931/19/1999 12:00:00 AM453054573Dave & TimDave Side Projects647616
49412/13/2003 12:00:00 AM453056046Dave & FriendsDave Side Projects468776