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 = 453063356 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '7/7/2012' OR (SongInfo.ShowDate = '7/7/2012' AND SongInfo.ShowID < 453063356)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 93.1004
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
Brandi Carlile (Dave guesting)
Alpine Valley Music Theatre     East Troy, WI
 
Saturday
Total Song Time
4 minutes and 16 seconds
Song Spread 
Cover Songs
1  
Song TitleTime  Last  Venue  Personnel 
Notes
1Angel from Montgomery 4:16  SD3 of 3Brandi Carlile, 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
9818/26/2001 12:00:00 AM53DMB39682
9824/14/1996 12:00:00 AM453055124Dave solo592831
98312/11/2009 12:00:00 AM453056730Dave & Tim939104
98127/3/1993 12:00:00 AM453089752C-ville Allstars694453
98153/10/1994 12:00:00 AM453089625Dave & Boyd669452
98799/17/2011 12:00:00 AM453063352Brandi Carlile2941149
98101415/4/1993 12:00:00 AM453079541Boyd & Co.70041132