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 = 453062228 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '10/18/2014' OR (SongInfo.ShowDate = '10/18/2014' AND SongInfo.ShowID < 453062228)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 118.8673
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
Ladysmith Black Mambazo (Dave guesting)
Carnegie Hall     New York, NY
 
Setlist
Saturday
Setlist Changes
none
Song Spread 
Live Collaboration
2  
Crash
1  
Originally, Paul Simon was scheduled to guest at this show, but when he had to back out, Dave filled in.
Song TitleTime  Last  Venue  Personnel 
Notes
1Cry Freedom  SD1 of 1DaveDave solo
2Homeless  SD1 of 1Abednego Mazibuko, Albert Mazibuko, Mfanafuthi Dlamini, Msizi Shabalala, Pius Shezi,
Sabelo Mthembu, Sibongiseni Shabalala, Thamsanqua Shabalala, Thulani Shabalala, Dave(more...)
3Diamonds on the Soles of Her Shoes  SD1 of 1Abednego Mazibuko, Albert Mazibuko, Bakithi Kumalo, Mfanafuthi Dlamini, Msizi Shabalala,
Pius Shezi, Sabelo Mthembu, Sibongiseni Shabalala, Thamsanqua Shabalala, Thulani Shabalala, Dave(more...)
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
716/6/2013 12:00:00 AM453057091DMB499120
725/2/1992 12:00:00 AM453055635Dave solo820457
734/11/2008 12:00:00 AM453056537Dave & Tim238197
741/12/2004 12:00:00 AM453056053Dave & Friends393277