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 = 453072455 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '7/5/2017' OR (SongInfo.ShowDate = '7/5/2017' AND SongInfo.ShowID < 453072455)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 166.1358
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
Crystal Garden (Boyd guesting)
The Broadberry     Richmond, VA
 
Setlist
Wednesday
Attendance
20
Setlist Changes
none
Song Spread 
Live Collaboration
7  
Boyd Tinsley - True Reflections
1  
Song TitleTime  Last  Venue  Personnel 
Notes
1People  SD1 of 1Boyd
2Stop Drop and Roll  SD1 of 1Boyd
3Blitz  SD1 of 1Boyd
4Devil Woman  SD1 of 1Boyd
5Dream Captain  SD1 of 1Boyd
6Time for It  SD1 of 1Boyd
7Shakedown Street  SD1 of 1Boyd
8True Reflections  SD1 of 1Boyd
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
1516/15/2013 12:00:00 AM453057094DMB1481120
1553/29/2003 12:00:00 AM453056139Boyd solo521275
15121/12/1993 12:00:00 AM453055495C-ville Allstars894053
15225/22/2003 12:00:00 AM453056032Good Brother Earl51581142
1520514/15/2017 12:00:00 AM453071446Crystal Garden815155
15101293/31/2007 12:00:00 AM453056466Boyd & Joe Lawlor374993
4868205112/14/2016 12:00:00 AM453070415Crystal Garden2032155
4899852/27/2016 12:00:00 AM453066393Phil & Friends4942155
489920514/15/2017 12:00:00 AM453071446Crystal Garden815155