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 = 453079539 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '4/27/2018' OR (SongInfo.ShowDate = '4/27/2018' AND SongInfo.ShowID < 453079539)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 180.8661
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 (Concert for Peace & Justice)
Riverwalk Amphitheater     Montgomery, AL
 
Poster
All media for this show (1)
Friday
Song Spread 
Before These Crowded Streets
1  
Away from the World
1  
Come Tomorrow
1  
Lineup: The Roots, Dave Matthews, Usher, Common, Brittany Howard, Jon Batiste, Kirk Franklin, Tasha Cobbs, Robert Glasper, Valerie June, Greg Phillinganes, Alabama State University Choir
Song TitleTime  Last  Venue  Personnel 
Notes
1Mercy  SD1 of 1
2Samurai Cop (Oh Joy Begin)  SD1 of 1
3Don'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
4912/3/2018 12:00:00 AM453077478DMB835156
4924/20/2018 12:00:00 AM453079538Dave solo75156
4931/28/2018 12:00:00 AM453079475Dave & Tim895156
49412/13/2003 12:00:00 AM453056046Dave & Friends524976
49305511/13/2016 12:00:00 AM453068410Dave & Carlos Varela5301154
72319/24/2017 12:00:00 AM453075474DMB2153154
72324/20/2018 12:00:00 AM453079538Dave solo75156
72331/14/2018 12:00:00 AM453074457Dave & Tim1035156
7238710/10/2014 12:00:00 AM453057207Hugh Masekela & Vusi Mahlasela12951130
72310249/4/2014 12:00:00 AM453057206Dave, Tim & Rashawn1331122
487312/3/2018 12:00:00 AM453077478DMB835156
487324/20/2018 12:00:00 AM453079538Dave solo75156
487331/28/2018 12:00:00 AM453079475Dave & Tim895156
4873305511/13/2016 12:00:00 AM453068410Dave & Carlos Varela5301154
4873305811/1/2016 12:00:00 AM453068422Joshua Bell5421154