DMBAlmanac.com

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 = 453056044 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '9/4/2003' OR (SongInfo.ShowDate = '9/4/2003' AND SongInfo.ShowID < 453056044)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC

AVERAGE QUERY TIME: 122.6256
TOTAL ITERATIONS: 1

DMBAlmanac.com

the dave matthews band tour almanac

home

Tours / Stats

Songs

Lyrics

Guests

Venues

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:

Dave Matthews (The Charlie Rose Show)

One Beacon Court New York, NY

Thursday

Song Spread

Dave Matthews - Some Devil

	Song Title	Time	Last	Venue	Personnel	Notes
1	Gravedigger		SD	1 of 1

All songs feature the lineup of Dave Matthews unless noted above.

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.

SongID	ArtistID	ShowDate	ShowID	ShortName	NumDays	TourID
205	1	7/27/2003 12:00:00 AM	453055991	DMB	39	72
205	2	8/6/2003 12:00:00 AM	453056038	Dave solo	29	75
205	3	5/5/2003 12:00:00 AM	453056019	Dave & Tim	122	75
205	9127	9/8/2002 12:00:00 AM	453055882	Dave & Jason Mraz's Band	361	32