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 = 453073455 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '8/26/2017' OR (SongInfo.ShowDate = '8/26/2017' AND SongInfo.ShowID < 453073455)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 244.1053
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
Secret Stash (Creating Equilibrium)
Squaw Valley Ski Resort     Olympic Valley, CA
 
Poster
All media for this show (1)
Saturday
Opening Act
Allen Stone
Dispatch
Song Spread 
Misc Covers
13  
Cover Songs
3  
Live Collaboration
2  
Song TitleTime  Last  Venue  Personnel 
Notes
1Do Ya  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played
2Train in Vain  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefan
3Walk of Life  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played
4Up on Cripple Creek  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played by Secret Stash
5Sledgehammer  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played by Secret Stash
6Touch of Grey  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played by Secret Stash
7Back in the U.S.S.R.  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played
8Go Your Own Way  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played
9Kiss Me Deadly  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played
10Good Times Bad Times  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played by Secret Stash
11T.N.T.  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played
12Root Down  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played by Secret Stash
13Man in the Box  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played
14Rocket Man  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played
15R.O.C.K. in the U.S.A. (A Salute to 60's Rock)  SD1 of 1Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played
16We're Not Gonna Take It  SD1 of 1Dee Snider, Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played by Secret Stash
17I Wanna Rock  SD1 of 1Dee Snider, Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played by Secret Stash
18Highway to Hell  SD1 of 1Dee Snider, Mike McCready, Nate Ruess, Sully Erna, Stefanfirst time played by Secret Stash
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
24542/5/2006 12:00:00 AM453056321Dave & Friends422086
52072/28/2015 12:00:00 AM453061228Yukon Kornelius910127
54917/17/2015 12:00:00 AM453060234DMB771128
56472/28/2015 12:00:00 AM453061228Yukon Kornelius910127
66883/13/2011 12:00:00 AM453056925Secret Stash2358114
68616/29/2013 12:00:00 AM453057101DMB1519120
2827849/29/2012 12:00:00 AM453063359Dispatch17921150
4893852/26/2016 12:00:00 AM453066392Phil & Friends5472155