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 = 453064382 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '12/12/2009' OR (SongInfo.ShowDate = '12/12/2009' AND SongInfo.ShowID < 453064382)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 89.5037
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
Barenaked Ladies (Yukon Kornelius guesting)
 
Saturday

Total Song Time
3 minutes and 12 seconds

Song Spread 
Live Collaboration
1  

S: Who Needs Sleep?, Get in Line, Maybe Katie, Adlib, The Old Apartment, Every Subway Car, Testing 123, Leave, Blame It on Me, On the Lookout, Too Little Too Late, Another Heartbreak, Falling for the First Time, Long Way Back Home, Four Seconds, Sound of Your Voice, You Run Away, One Week, It's All Been Done, Pinch Me, If I Had $1000000
E: God Rest Ye Merry Gentlemen » We Three Kings, Feliz Navidad*

*with Yukon Kornelius
Song TitleTime  Last  Venue  Personnel 
Notes
1Felíz Navidad 3:12  SD1 of 1Adam Gardner, Ed Robertson, Eric Fawcett, Jim Creeggan, Kevin Hearn, Tyler Stewart, StefanLongest documented all-time version of this song 
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