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 = 453090930 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '6/30/2022' OR (SongInfo.ShowDate = '6/30/2022' AND SongInfo.ShowID < 453090930)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 159.5012
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
Dave Matthews (private show)
Esmé     Chicago, IL
 
Thursday
Song Spread 
Before These Crowded Streets
1  
Dave Matthews - Some Devil
1  
The setlist below is incomplete.
Song TitleTime  Last  Venue  Personnel 
Notes
1Save Me  SD1 of 1
2Don't Drink the Water  SD1 of 1
All songs feature the lineup of Dave Matthews unless noted above.
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
4916/29/2022 12:00:00 AM453089888DMB18169
4923/26/2022 12:00:00 AM453090916Dave solo968167
4932/20/2022 12:00:00 AM453089833Dave & Tim1308167
49412/13/2003 12:00:00 AM453056046Dave & Friends677476
49305511/13/2016 12:00:00 AM453068410Dave & Carlos Varela20551154
23519/3/2021 12:00:00 AM453089714DMB3008164
23525/22/2022 12:00:00 AM453090923Dave solo398167
23532/19/2022 12:00:00 AM453089832Dave & Tim1318167
23542/4/2006 12:00:00 AM453056258Dave & Friends599086
235305511/13/2016 12:00:00 AM453068410Dave & Carlos Varela20551154
2351012811/7/2003 12:00:00 AM453056043Dave and Friends & Emmylou Harris681075