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 = 453063333 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '4/20/2006' OR (SongInfo.ShowDate = '4/20/2006' AND SongInfo.ShowID < 453063333)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 138.0893
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
Robert Randolph & The Family Band (Boyd guesting)
Charlottesville Pavilion     Charlottesville, VA
 
Thursday
Song Spread 
Live Collaboration
5  
Stand Up
1  
Song TitleTime  Last  Venue  Personnel 
Notes
1Nobody  SD1 of 1Danyel Morgan, Jason Crosby, Marcus Randolph, Robert Randolph, Boyd
2Louisiana Bayou  SD1 of 1Danyel Morgan, Jason Crosby, Marcus Randolph, Robert Randolph, Boyd
3Papa Was a Rolling Stone  SD1 of 1Danyel Morgan, Jason Crosby, Marcus Randolph, Robert Randolph, Boyd
4Soul Refreshing  SD1 of 1Danyel Morgan, Jason Crosby, Marcus Randolph, Robert Randolph, Boyd
5Roll Up  SD1 of 1Danyel Morgan, Jason Crosby, Marcus Randolph, Robert Randolph, Boyd
6Whole Lotta Love  SD1 of 1Danyel Morgan, Jason Crosby, Marcus Randolph, Robert Randolph, Boyd
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
295112/15/2005 12:00:00 AM453056252DMB12685
436696/10/2005 12:00:00 AM453063329Galactic3141144