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 = 453063252 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '8/20/1994' OR (SongInfo.ShowDate = '8/20/1994' AND SongInfo.ShowID < 453063252)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 93.8128
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
Blues Traveler (Roi guesting)
 
Saturday

Total Song Time
4 minutes and 52 seconds

Song Spread 
Live Collaboration
1  

S: Mulling It Over » But Anyway, Crash Burn » What's for Breakfast, Hook, Low Rider » Go Outside & Drive, 100 Years*, Look Around, Optimistic Thought, The Good the Bad and the Ugly, Love & Greed, Gina, Crystal Flame

*with LeRoi Moore

click here for DMB's set
Song TitleTime  Last  Venue  Personnel 
Notes
1100 Years 4:52  SD1 of 1Bobby Sheehan, Brendan Hill, Chan Kinchla, John Popper, RoiLongest 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
363294/30/1994 12:00:00 AM453063251Blues Traveler1121133