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 = 453063323 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '10/11/2004' OR (SongInfo.ShowDate = '10/11/2004' AND SongInfo.ShowID < 453063323)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 108.1118
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
Vote for Change Finale (Dave guesting)
MCI Center     Washington, DC
 
Monday
Song Spread 
Live Collaboration
2  
 
This show was webcast live.
Song TitleTime  Last  Venue  Personnel 
Notes
1(What's So Funny 'Bout) Peace, Love and Understanding  SD1 of 1Eddie Vedder, Emily Robison, John Fogerty, Martie Maguire, Michael Stipe, Mike Mills,
Natalie Maines, Peter Buck, Dave(more...)
2People Have the Power  SD1 of 1Akil, Bonnie Raitt, Chali 2na, Cut Chemist, DJ Nu-Mark, Eddie Vedder, Emily Robison,
Jackson Browne, James Taylor, John Fogerty, John Mellencamp, Keb' Mo', Marc 7, Martie Maguire, Michael Stipe, Mike Mills, Natalie Maines, Peter Buck, Zaakir, Dave(more...)
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
42622/26/2001 12:00:00 AM453056339Dave solo13231