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 = 453067400 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '7/11/2016' OR (SongInfo.ShowDate = '7/11/2016' AND SongInfo.ShowID < 453067400)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 146.9486
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)
Ballroom (Fête Music Hall)     Providence, RI
 
Poster
Setlist
All media for this show (2)
Monday
Setlist Changes
none
Song Spread 
Live Collaboration
5  
S: Free as a Bird, La La, Dress, This Old House, People*, Let Me Be Your God* » Dream Captain*, Wake the Funk Up, Roller, Jam**, Shakedown Street*
E: Devil Woman*

*with Stanley Jordan & Boyd Tinsley
**with Stanley Jordan
Song Title  Time  Last  Venue  Personnel 
Notes
1People  SD1 of 1Stanley Jordan, Boyd
2Let Me Be Your God » SD1 of 1Stanley Jordan, Boyd
3Dream Captain  SD1 of 1Stanley Jordan, Boyd
4Shakedown Street  SD1 of 1Stanley Jordan, Boyd
5Devil Woman  SD1 of 1Stanley Jordan, Boyd
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
486720516/23/2016 12:00:00 AM453067404Crystal Garden182155
4899852/27/2016 12:00:00 AM453066393Phil & Friends1352155
489920516/12/2016 12:00:00 AM453067402Crystal Garden292155