SELECT SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate, SongInfo.ShowID, ShowArtists.ShortName, ArtistCategories.CategoryName, DATEDIFF (D, SongInfo.ShowDate, ThisShow.ShowDate) NumDays, ShowInfo.TourID FROM SongInfo INNER JOIN SongInfo ThisShow ON ThisShow.SongID = SongInfo.SongID AND ThisShow.ShowID = 453056334 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID INNER JOIN ArtistCategories ON ShowArtists.ArtistCategoryID = ArtistCategories.CategoryID WHERE (SongInfo.ShowDate < '9/30/2006' OR (SongInfo.ShowDate = '9/30/2006' AND SongInfo.ShowID < 453056334)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 198.9774
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
Dave Matthews (Farm Aid 2006)
 
Poster
Ticket
All media for this show (2)

Saturday

Total Song Time
36 minutes and 21 seconds

Song Spread 
Dave Matthews - Some Devil
5  
Before These Crowded Streets
1  
Everyday
1  
Unreleased
1  
Stand Up
1  

Other artists include:
Willie Nelson
John Mellencamp
Neil Young
Jerry Lee Lewis with Roy Head
Los Lonely Boys
Gov't Mule
Steve Earle
Allison Moorer
Steel Pulse
Shelby Lynne
Nitty Gritty Dirt Band
Jimmy Sturr & his Orchestra
Pauline Reese
Danielle Evin
Song TitleTime  Last  Venue  Personnel 
Notes
1Everyday 3:50   2  7 of 16"You Can't Rollerskate in a Buffalo Herd" interpolation
2Save Me 3:35   2  1 of 4
3Stay or Leave 4:08   2  1 of 6
4Crush 5:36   2  7 of 17
5Sister 3:33   2  2 of 6
6Gravedigger 3:35   1  2 of 10
7Old Dirt Hill (Bring That Beat Back) 3:37   4  2 of 4
8Some Devil 4:00   2  1 of 4
9So Damn Lucky 4:27   2  1 of 10
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.
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
5519/23/2006 12:00:00 AM453056313DMBDMB787
5525/15/2006 12:00:00 AM453056320Dave soloDave Side Projects13886
55310/28/2005 12:00:00 AM453056235Dave & TimDave Side Projects33784
55411/13/2004 12:00:00 AM453056220Dave & FriendsDave Side Projects68679
7619/22/2006 12:00:00 AM453056312DMBDMB887
7625/15/2006 12:00:00 AM453056320Dave soloDave Side Projects13886
7635/5/2003 12:00:00 AM453056019Dave & TimDave Side Projects124475
7642/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects23886
76492/28/2001 12:00:00 AM453063291Trey Anastasio BandOpeners and Collaborators20401140
20517/27/2003 12:00:00 AM453055991DMBDMB116172
20529/19/2006 12:00:00 AM453056390Dave soloDave Side Projects1186
205310/30/2005 12:00:00 AM453056256Dave & TimDave Side Projects33584
20542/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects23886
20591279/8/2002 12:00:00 AM453055882Dave & Jason Mraz's BandDave Side Projects148332
2051012811/7/2003 12:00:00 AM453056043Dave and Friends & Emmylou HarrisDave Side Projects105875
22025/15/2006 12:00:00 AM453056320Dave soloDave Side Projects13886
220310/28/2005 12:00:00 AM453056235Dave & TimDave Side Projects33784
22042/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects23886
23325/15/2006 12:00:00 AM453056320Dave soloDave Side Projects13886
233310/28/2005 12:00:00 AM453056235Dave & TimDave Side Projects33784
23342/5/2006 12:00:00 AM453056321Dave & FriendsDave Side Projects23786
23525/15/2006 12:00:00 AM453056320Dave soloDave Side Projects13886
235310/28/2005 12:00:00 AM453056235Dave & TimDave Side Projects33784
23542/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects23886
2351012811/7/2003 12:00:00 AM453056043Dave and Friends & Emmylou HarrisDave Side Projects105875
23825/15/2006 12:00:00 AM453056320Dave soloDave Side Projects13886
238410/29/2005 12:00:00 AM453056234Dave & FriendsDave Side Projects33684
28914/29/2006 12:00:00 AM453056264DMBDMB15486
28925/13/2006 12:00:00 AM453056319Dave soloDave Side Projects14086
289310/30/2005 12:00:00 AM453056256Dave & TimDave Side Projects33584
28942/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects23886
30419/22/2006 12:00:00 AM453056312DMBDMB887
30425/15/2006 12:00:00 AM453056320Dave soloDave Side Projects13886
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
5514/18/1998 12:00:00 AM453054683DMBDMB308723
5529/29/2001 12:00:00 AM55Dave soloDave Side Projects18271
5531/20/1999 12:00:00 AM453054574Dave & TimDave Side Projects281016
55412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects102376
7614/21/2001 12:00:00 AM2DMBDMB19882
7622/26/2001 12:00:00 AM453056339Dave soloDave Side Projects20421
7633/19/2003 12:00:00 AM453055948Dave & TimDave Side Projects129170
76412/16/2003 12:00:00 AM453056048Dave & FriendsDave Side Projects101976
76492/28/2001 12:00:00 AM453063291Trey Anastasio BandOpeners and Collaborators20401140
20515/28/2002 12:00:00 AM453055851DMBDMB158612
20527/12/2002 12:00:00 AM453055902Dave soloDave Side Projects154166
20533/19/2003 12:00:00 AM453055948Dave & TimDave Side Projects129170
205412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects102376
20591279/8/2002 12:00:00 AM453055882Dave & Jason Mraz's BandDave Side Projects148332
2051012811/7/2003 12:00:00 AM453056043Dave and Friends & Emmylou HarrisDave Side Projects105875
22021/9/2004 12:00:00 AM453056065Dave soloDave Side Projects99579
22033/26/2003 12:00:00 AM453055955Dave & TimDave Side Projects128470
220412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects102376
23328/6/2003 12:00:00 AM453056038Dave soloDave Side Projects115175
233310/28/2005 12:00:00 AM453056235Dave & TimDave Side Projects33784
233411/8/2003 12:00:00 AM453056058Dave & FriendsDave Side Projects105775
23528/6/2003 12:00:00 AM453056038Dave soloDave Side Projects115175
235310/28/2005 12:00:00 AM453056235Dave & TimDave Side Projects33784
235411/8/2003 12:00:00 AM453056058Dave & FriendsDave Side Projects105775
2351012811/7/2003 12:00:00 AM453056043Dave and Friends & Emmylou HarrisDave Side Projects105875
23821/9/2004 12:00:00 AM453056065Dave soloDave Side Projects99579
238412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects102376
28916/2/2005 12:00:00 AM453056174DMBDMB48583
28922/28/2006 12:00:00 AM453056265Dave soloDave Side Projects21486
289310/28/2005 12:00:00 AM453056235Dave & TimDave Side Projects33784
28942/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects23886
30415/30/2006 12:00:00 AM453056266DMBDMB12387
30425/11/2006 12:00:00 AM453056332Dave soloDave Side Projects14286