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 = 453056689 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '6/5/2009' OR (SongInfo.ShowDate = '6/5/2009' AND SongInfo.ShowID < 453056689)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 217.8367
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 Band (Today Show)
Rockefeller Plaza     New York, NY
 
Friday
Weather
Rain
Total Song Time
22 minutes
Sound Check
So Much to Say (no Tim)
Funny the way it is
Crash Into Me
Why I am
Ants Marching
So Much to Say
So Much to Say (again)
Song Spread 
Big Whiskey and the GrooGrux King
3  
Crash
2  
Under the Table and Dreaming
1  
 
Song TitleTime  Last  Venue  Personnel 
Notes
1So Much to Say 4:08  SD1 of 1
2Funny the Way It Is 4:11  SD1 of 1
3Crash into Me 4:36  SD1 of 1
4Why I Am 3:50  SD1 of 1aired out of order
5Ants Marching 5:15  SD1 of 1snare intro
6Alligator Pie  SD1 of 1not aired
All songs feature the lineup of Dave Matthews, Carter Beauford, Stefan Lessard, Boyd Tinsley, Rashawn Ross, Tim Reynolds, and Jeff Coffin 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.
SongIDArtistIDShowDateShowIDShortNameNumDaysTourID
1716/1/2009 12:00:00 AM453056692DMB4104
1729/20/2005 12:00:00 AM453056242Dave solo135484
17310/26/2008 12:00:00 AM453056610Dave & Tim22297
17412/19/2003 12:00:00 AM453056050Dave & Friends199576
2115/29/2009 12:00:00 AM453056641DMB7106
2125/13/2006 12:00:00 AM453056319Dave solo111986
2135/5/2003 12:00:00 AM453056019Dave & Tim222375
4615/29/2009 12:00:00 AM453056641DMB7106
4625/15/2006 12:00:00 AM453056320Dave solo111786
46310/26/2008 12:00:00 AM453056610Dave & Tim22297
46144/29/1996 12:00:00 AM453055126Dave, Boyd & Stefan478531
4691168/18/1995 12:00:00 AM453089621Dave, Roi & Stefan504041
57916/5/2009 12:00:00 AM453056643DMB0106