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 = 453063322 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '8/30/2004' OR (SongInfo.ShowDate = '8/30/2004' AND SongInfo.ShowID < 453063322)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 97.6938
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
Santana (Dave guesting)
Westin Century Plaza Hotel & Spa     Los Angeles, CA
 
Monday
Song Spread 
Studio Collaboration
1  
Live Collaboration
1  
Song TitleTime  Last  Venue  Personnel 
Notes
1Love of My Life  SD1 of 1Andy Vargas, Benny Rietveld, Bill Ortiz, Carlos Santana, Chester Thompson, Christopher Scott,
Dennis Chambers, Jeff Cressman, Karl Perazzo, Myron Dove, Raul Rekow, Steve Vai, Tony Lindsay, Dave(more...)
2Africa Bamba  SD1 of 1Andy Vargas, Benny Rietveld, Bill Ortiz, Carlos Santana, Chester Thompson, Christopher Scott,
Dennis Chambers, Jeff Cressman, Karl Perazzo, Myron Dove, Raul Rekow, Steve Vai, Tony Lindsay, 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
6415/18/2001 12:00:00 AM15DMB12002
6433/14/1999 12:00:00 AM453054613Dave & Tim199616
64414/8/2000 12:00:00 AM453063287Santana16051139