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 = 453063318 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '6/30/2004' OR (SongInfo.ShowDate = '6/30/2004' AND SongInfo.ShowID < 453063318)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 110.7013
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
Keller Williams (Dave guesting)
The Molson Amphitheatre     Toronto, ON, CAN
 
Wednesday
Song Spread 
Cover Songs
1  
Set: All Along the Watchtower*, ?, ?, ?, Word Up, ?, ?

* with Dave Matthews
Song TitleTime  Last  Venue  Personnel 
Notes
1All Along the Watchtower  SD3 of 4Keller Williams, Dave
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
9619/24/2003 12:00:00 AM453056042DMB28072
96210/24/2002 12:00:00 AM453055916Dave solo61532
9633/28/2003 12:00:00 AM453055956Dave & Tim46070
96134/9/1993 12:00:00 AM453055542Dave & Carter410053
96232/5/1993 12:00:00 AM453055506Ritz Power Jam41631132
96314/21/1994 12:00:00 AM453063250Phish37231133