SELECT SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate, SongInfo.ShowID, ShowArtists.ShortName, ArtistCategories.CategoryName, DATEDIFF (D, SongInfo.ShowDate, ThisShow.ShowDate) NumDays, ShowInfo.TourID FROM SongInfo INNER JOIN SongInfo ThisShow ON ThisShow.SongID = SongInfo.SongID AND ThisShow.ShowID = 453075455 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID INNER JOIN ArtistCategories ON ShowArtists.ArtistCategoryID = ArtistCategories.CategoryID WHERE (SongInfo.ShowDate < '10/4/2017' OR (SongInfo.ShowDate = '10/4/2017' AND SongInfo.ShowID < 453075455)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 175.3925
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 (Lampedusa 2017)
Aladdin Theater     Portland, OR
 
Wednesday
Song Spread 
Cover Songs
2  
Busted Stuff
1  
Unreleased
1  
Studio Collaboration
1  
Away from the World
1  
Come Tomorrow
1  
After Refugee, the five performers took turns playing songs.
Song TitleTime  Last  Venue  Personnel 
Notes
1Refugee   1  1 of 1Brandi Carlile, Emmylou Harris, Patty Griffin, Steve Earle
2My Antonia   1  1 of 1Emmylou Harris
3Mercy   1  1 of 1
4Bartender   30  1 of 1
5Sister   31  1 of 1
6Samurai Cop (Oh Joy Begin)   1  1 of 1
7Angel from Montgomery   163  1 of 1Brandi Carlile, Emmylou Harris, Patty Griffin, Steve Earle
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.
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
6519/3/2016 12:00:00 AM453065437DMBDMB3962154
6524/13/2011 12:00:00 AM453056930Dave soloDave Side Projects2366114
6536/17/2017 12:00:00 AM453071424Dave & TimDave Side Projects1095154
6542/4/2006 12:00:00 AM453056258Dave & FriendsDave Side Projects426086
65212/20/2000 12:00:00 AM453055865Dave & Emmylou HarrisDave Side Projects643615
9819/6/2015 12:00:00 AM453060248DMBDMB759128
9824/14/1996 12:00:00 AM453055124Dave soloDave Side Projects784331
98312/11/2009 12:00:00 AM453056730Dave & TimDave Side Projects2854104
98127/3/1993 12:00:00 AM453089752C-ville AllstarsCarter Side Projects885953
98153/10/1994 12:00:00 AM453089625Dave & BoydDMB860952
98797/11/2012 12:00:00 AM453068417Brandi CarlileOpeners and Collaborators19111150
98101415/4/1993 12:00:00 AM453079541Boyd & Co.Boyd Side Projects89191132
11116/3/2015 12:00:00 AM453060215DMBDMB854128
111210/3/2017 12:00:00 AM453075454Dave soloDave Side Projects13154
1115110/14/2001 12:00:00 AM453063294Emmylou HarrisOpeners and Collaborators58341140
1111012811/7/2003 12:00:00 AM453056043Dave and Friends & Emmylou HarrisDave Side Projects508075
30419/3/2016 12:00:00 AM453065437DMBDMB3962154
30424/8/2011 12:00:00 AM453056929Dave soloDave Side Projects2371114
30435/7/2017 12:00:00 AM453071412Dave & TimDave Side Projects1505154
72319/24/2017 12:00:00 AM453075474DMBDMB103154
723210/3/2017 12:00:00 AM453075454Dave soloDave Side Projects13154
72339/16/2017 12:00:00 AM453072474Dave & TimDave Side Projects183154
7238710/10/2014 12:00:00 AM453057207Hugh Masekela & Vusi MahlaselaOpeners and Collaborators10901130
72310249/4/2014 12:00:00 AM453057206Dave, Tim & RashawnDMB1126122
487319/3/2016 12:00:00 AM453065437DMBDMB3962154
4873210/3/2017 12:00:00 AM453075454Dave soloDave Side Projects13154
487336/18/2017 12:00:00 AM453071425Dave & TimDave Side Projects1085154
4873305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects3251154
4873305811/1/2016 12:00:00 AM453068422Joshua BellOpeners and Collaborators3371154
15939210/3/2017 12:00:00 AM453075454Dave soloDave Side Projects13154
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
6516/19/2000 12:00:00 AM453054398DMBDMB631613
6523/8/1999 12:00:00 AM453056428Dave soloDave Side Projects678562
6531/29/1999 12:00:00 AM453054581Dave & TimDave Side Projects682316
65412/12/2003 12:00:00 AM453056045Dave & FriendsDave Side Projects504576
65212/20/2000 12:00:00 AM453055865Dave & Emmylou HarrisDave Side Projects643615
98110/22/1991 12:00:00 AM453055864DMBDMB947965
9824/5/1993 12:00:00 AM453055539Dave soloDave Side Projects894853
9834/22/1993 12:00:00 AM453055550Dave & TimDave Side Projects893153
98121/6/1993 12:00:00 AM453056967C-ville AllstarsCarter Side Projects903753
98153/10/1994 12:00:00 AM453089625Dave & BoydDMB860952
98797/29/2011 12:00:00 AM453063350Brandi CarlileOpeners and Collaborators22591149
98101415/4/1993 12:00:00 AM453079541Boyd & Co.Boyd Side Projects89191132
11116/3/2015 12:00:00 AM453060215DMBDMB854128
11122/26/2001 12:00:00 AM453056339Dave soloDave Side Projects60641
1115110/14/2001 12:00:00 AM453063294Emmylou HarrisOpeners and Collaborators58341140
1111012811/7/2003 12:00:00 AM453056043Dave and Friends & Emmylou HarrisDave Side Projects508075
30415/30/2006 12:00:00 AM453056266DMBDMB414587
30425/11/2006 12:00:00 AM453056332Dave soloDave Side Projects416486
304310/27/2006 12:00:00 AM453056382Dave & TimDave Side Projects399586
72315/18/2012 12:00:00 AM453056974DMBDMB1965117
72324/24/2012 12:00:00 AM453057017Dave soloDave Side Projects1989116
72337/15/2012 12:00:00 AM453057034Dave & TimDave Side Projects1907116
7238710/10/2014 12:00:00 AM453057207Hugh Masekela & Vusi MahlaselaOpeners and Collaborators10901130
72310249/4/2014 12:00:00 AM453057206Dave, Tim & RashawnDMB1126122
487315/7/2016 12:00:00 AM453067393DMBDMB5152154
487326/6/2016 12:00:00 AM453067401Dave soloDave Side Projects4851154
487337/6/2016 12:00:00 AM453067395Dave & TimDave Side Projects4551154
4873305511/13/2016 12:00:00 AM453068410Dave & Carlos VarelaDave Side Projects3251154
4873305811/1/2016 12:00:00 AM453068422Joshua BellOpeners and Collaborators3371154
15939210/3/2017 12:00:00 AM453075454Dave soloDave Side Projects13154