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 = 453063267 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '3/18/1997' OR (SongInfo.ShowDate = '3/18/1997' AND SongInfo.ShowID < 453063267)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 86.6445
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
Agents of Good Roots (Dave guesting)
Trax     Charlottesville, VA
 
Tuesday
Total Song Time
10 minutes and 19 seconds
Song Spread 
Live Collaboration
1  
S: Eric, I Gotta Move, Jakob, Lightning Man, Two Bucks in Cash, Redman Hoedown, John, Shortchange, Upspin, Where'd You Get That Vibe?, Exodus of Left, Free as a Bird, No Time for a Good Time, One Strange Land, Sultans of Swing, Mercury Jones, Shot Down, I'm in Love, Shine on Mama, What I Need
E: Riders on the Storm*

*with Dave Matthews & Josh "Knuckles" Harvey
Song TitleTime  Last  Venue  Personnel 
Notes
1Riders on the Storm 10:19  SD1 of 1Andrew Winn, Brian Jones, J.C. Kuhl, Josh Harvey, Stewart Myers, DaveLongest documented all-time version of this song 
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