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 = 453063377 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '3/1/2013' OR (SongInfo.ShowDate = '3/1/2013' AND SongInfo.ShowID < 453063377)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 115.551
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
Brooks Young Band (Boyd guesting)
Revere Hotel     Boston, MA
 
Poster
All media for this show (1)
Friday
Total Song Time
22 minutes and 46 seconds
Song Spread 
Live Collaboration
2  
Misc Covers
1  
Song TitleTime  Last  Venue  Personnel 
Notes
1Miss You 9:03  SD1 of 1Brooks Young, Chaz Mitchell, Mike Liane, BoydLongest documented all-time version of this song 
2Hold onto Your Heart 5:29  SD1 of 1Brooks Young, Chaz Mitchell, Mike Liane, BoydLongest documented all-time version of this song 
3Crossroads 8:14  SD1 of 1Brooks Young, Chaz Mitchell, Mike Liane, BoydLongest documented all-time version of this song 
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
717712/10/2011 12:00:00 AM453056970Yukon Kornelius447114