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 = 453056646 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 < '7/28/2009' OR (SongInfo.ShowDate = '7/28/2009' AND SongInfo.ShowID < 453056646)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 382.9961
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:SummaryShowsSongsGuestsSlotsLiberationsMediaSong Chart
Dave Matthews Band
DTE Energy Music Theatre     Clarkston, MI
 
Poster
Setlist
Ticket
All media for this show (3)
Tuesday
Total Song Time
2 hours and 13 minutes and 43 seconds
Setlist Changes
Still Water added
Opening Act
Old Crow Medicine Show
Song Rarity Rank: 19 of 54
Song Spread 
Big Whiskey and the GrooGrux King
9  
Under the Table and Dreaming
4  
Crash
2  
Remember Two Things
1  
Before These Crowded Streets
1  
Busted Stuff
1  
Cover Songs
1  
Song Title   [ ]Time  Last  Tour  Venue  Personnel 
Notes
1Proudest Monkey »7:27   4  3 of 121 of 3Jamaican Farewell interpolation
2Satellite 4:50   4  3 of 123 of 8
3Funny the Way It Is 5:21   30 of 561 of 5
4You Never Know 8:20   7  2 of 31 of 3Carter solo intro
5One Sweet World 7:12   5  3 of 71 of 2Swim Naked outro
 Shotgun [tease]  1:03  SD  Dave, Carter, Stefanchorus (lyrics)
6Squirm 5:03  SD16 of 331 of 2Mr. Okra outro
7Lying in the Hands of God 10:04   19 of 331 of 1Longest documented version played at the time of this show 
8Burning Down the House 4:14   3  10 of 171 of 1
9Lie in Our Graves 10:45   18  5 of 173 of 5
10Alligator Pie 4:35   3  26 of 431 of 1
11Jimi Thing 14:07   3  16 of 344 of 9Up for the Down Stroke interpolation; Sexy M.F. outro
12Seven 4:29  SD20 of 461 of 6
13Dancing Nancies »10:50   5  6 of 184 of 10
14Warehouse 9:28   36, TD 1 of 23 of 8stop-time intro
15Why I Am 3:50  SD28 of 541 of 5
16Shake Me Like a Monkey 3:59   3  22 of 501 of 4
17Still Water [partial]  1:09   2 of 21 of 1Dave, Carter, Stefan, Tim
18Don't Drink the Water 6:15   3  13 of 242 of 7
19You & Me 4:33   16 of 421 of 6
20Time Bomb 6:09  SD14 of 221 of 2Longest documented version played at the time of this show first time played as an encore closer; first and second verses switched
All songs feature the lineup of Dave Matthews, Carter Beauford, Stefan Lessard, Boyd Tinsley, Rashawn Ross, Tim Reynolds, and Jeff Coffin unless noted above.
Rarity  Rank  Tour  So Far 
Song  19 of 542.1352.328
Guest  6 of 61.7321.732
Opener  3 of 69.83315.500
Closer  3 of 819.66710.333
Encore  15 of 287.8675.636
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
515/9/2009 12:00:00 AM453056627DMBDMB80103
524/14/1996 12:00:00 AM453055124Dave soloDave Side Projects485331
533/9/2007 12:00:00 AM453056406Dave & TimDave Side Projects87291
542/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects127086
1117/24/2009 12:00:00 AM453056639DMBDMB4106
1125/12/2006 12:00:00 AM453056318Dave soloDave Side Projects117386
11310/26/2008 12:00:00 AM453056610Dave & TimDave Side Projects27597
11412/17/2003 12:00:00 AM453056049Dave & FriendsDave Side Projects205076
11151/14/1994 12:00:00 AM453055373Dave & BoydDMB567463
1217/22/2009 12:00:00 AM453056638DMBDMB6106
12211/20/2002 12:00:00 AM453055947Dave soloDave Side Projects244232
1233/1/2007 12:00:00 AM453056402Dave & TimDave Side Projects88091
1917/25/2009 12:00:00 AM453056630DMBDMB3106
1924/14/1996 12:00:00 AM453055124Dave soloDave Side Projects485331
1934/21/2007 12:00:00 AM453056465Dave & TimDave Side Projects82993
1942/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects127086
19144/29/1996 12:00:00 AM453055126Dave, Boyd & StefanDMB483831
2017/22/2009 12:00:00 AM453056638DMBDMB6106
2025/15/2006 12:00:00 AM453056320Dave soloDave Side Projects117086
2037/6/2009 12:00:00 AM453056712Dave & TimDave Side Projects22104
2042/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects127086
201412/15/1994 12:00:00 AM453055332Dave, Boyd & StefanDMB533952
20154/14/1995 12:00:00 AM453055192Dave & BoydDMB521941
2091279/8/2002 12:00:00 AM453055882Dave & Jason Mraz's BandDave Side Projects251532
2216/26/2009 12:00:00 AM453056683DMBDMB32106
2225/15/2006 12:00:00 AM453056320Dave soloDave Side Projects117086
2235/20/2008 12:00:00 AM453056597Dave & TimDave Side Projects43497
2241/16/2004 12:00:00 AM453056056Dave & FriendsDave Side Projects202077
22134/9/1993 12:00:00 AM453055542Dave & CarterDMB595453
221510/29/1994 12:00:00 AM453089864Dave & BoydDMB538663
4417/24/2009 12:00:00 AM453056639DMBDMB4106
44310/26/2008 12:00:00 AM453056610Dave & TimDave Side Projects27597
4917/25/2009 12:00:00 AM453056630DMBDMB3106
49210/19/2008 12:00:00 AM453056609Dave soloDave Side Projects28297
49310/26/2008 12:00:00 AM453056610Dave & TimDave Side Projects27597
49412/13/2003 12:00:00 AM453056046Dave & FriendsDave Side Projects205476
20217/19/2009 12:00:00 AM453056636DMBDMB9106
44537/28/2007 12:00:00 AM453056507Dave & TimDave Side Projects73193
55717/25/2009 12:00:00 AM453056630DMBDMB3106
57137/6/2009 12:00:00 AM453056712Dave & TimDave Side Projects22104
57417/25/2009 12:00:00 AM453056630DMBDMB3106
57937/6/2009 12:00:00 AM453056712Dave & TimDave Side Projects22104
58017/25/2009 12:00:00 AM453056630DMBDMB3106
58637/6/2009 12:00:00 AM453056712Dave & TimDave Side Projects22104
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
513/14/1991 12:00:00 AM453056860DMBDMB671165
525/2/1992 12:00:00 AM453055635Dave soloDave Side Projects629657
534/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects594153
542/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects127086
1118/31/1991 12:00:00 AM453056808DMBDMB654165
1129/11/1992 12:00:00 AM453055702Dave soloDave Side Projects616457
1134/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects594153
11412/15/2003 12:00:00 AM453056047Dave & FriendsDave Side Projects205276
11151/14/1994 12:00:00 AM453055373Dave & BoydDMB567463
1218/31/1991 12:00:00 AM453056808DMBDMB654165
1229/11/1992 12:00:00 AM453055702Dave soloDave Side Projects616457
1234/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects594153
1918/31/1991 12:00:00 AM453056808DMBDMB654165
1924/14/1996 12:00:00 AM453055124Dave soloDave Side Projects485331
1939/26/1994 12:00:00 AM453055276Dave & TimDave Side Projects541952
19410/29/2005 12:00:00 AM453056234Dave & FriendsDave Side Projects136884
191412/15/1994 12:00:00 AM453055332Dave, Boyd & StefanDMB533952
2018/31/1991 12:00:00 AM453056808DMBDMB654165
2025/2/1992 12:00:00 AM453055635Dave soloDave Side Projects629657
2034/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects594153
20412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects205576
201412/15/1994 12:00:00 AM453055332Dave, Boyd & StefanDMB533952
20153/10/1994 12:00:00 AM453089625Dave & BoydDMB561952
2091279/8/2002 12:00:00 AM453055882Dave & Jason Mraz's BandDave Side Projects251532
2213/1/1992 12:00:00 AM453055741DMBDMB635856
2229/11/1992 12:00:00 AM453055702Dave soloDave Side Projects616457
2234/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects594153
22412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects205576
22134/9/1993 12:00:00 AM453055542Dave & CarterDMB595453
22153/10/1994 12:00:00 AM453089625Dave & BoydDMB561952
44112/16/1994 12:00:00 AM453056378DMBDMB533845
4432/8/1996 12:00:00 AM453054997Dave & TimDave Side Projects491927
4914/18/1998 12:00:00 AM453054683DMBDMB411923
4927/1/1998 12:00:00 AM453056508Dave soloDave Side Projects404523
4931/19/1999 12:00:00 AM453054573Dave & TimDave Side Projects384316
49412/13/2003 12:00:00 AM453056046Dave & FriendsDave Side Projects205476
20214/7/2002 12:00:00 AM453055753DMBDMB266912
37316/10/2006 12:00:00 AM453056273DMBDMB114487
44513/24/2007 12:00:00 AM453056420DMBDMB85793
44533/8/2007 12:00:00 AM453056397Dave & TimDave Side Projects87391
55718/1/2008 12:00:00 AM453056587DMBDMB36198
57116/6/2009 12:00:00 AM453056644DMBDMB52106
57136/25/2009 12:00:00 AM453056713Dave & TimDave Side Projects33104
57416/12/2009 12:00:00 AM453056651DMBDMB46106
57715/29/2009 12:00:00 AM453056641DMBDMB60106
57815/27/2009 12:00:00 AM453056640DMBDMB62106
57914/14/2009 12:00:00 AM453056612DMBDMB105103
57936/25/2009 12:00:00 AM453056713Dave & TimDave Side Projects33104
58015/30/2009 12:00:00 AM453056642DMBDMB59106
58314/14/2009 12:00:00 AM453056612DMBDMB105103
58415/5/2009 12:00:00 AM453056624DMBDMB84103
58616/6/2009 12:00:00 AM453056644DMBDMB52106
58637/6/2009 12:00:00 AM453056712Dave & TimDave Side Projects22104