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 = 453055609 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 < '11/24/1992' OR (SongInfo.ShowDate = '11/24/1992' AND SongInfo.ShowID < 453055609)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 297.7105
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:SummaryShowsSongsGuestsSlotsLiberationsMediaSong Chart
Dave Matthews Band
Trax     Charlottesville, VA
 
Tuesday
Song Rarity Rank: 20 of 47
Song Spread 
Under the Table and Dreaming
8  
Crash
4  
Cover Songs
3  
Remember Two Things
2  
Misc Release
2  
Unreleased
2  
Before These Crowded Streets
1  
Boyd Tinsley - True Reflections
1  
Song TitleTime  Last  Tour  Venue  Personnel 
Notes
1Granny  SD3 of 103 of 33Dave solo
2Pay for What You Get   2  13 of 249 of 22Dave, Carter
3Spotlight   13 of 2010 of 16
4The Maker  SD10 of 176 of 11
5Angel from Montgomery   2  17 of 2510 of 18Kristin Asbury
6The Best of What's Around   4  19 of 2315 of 27
7Typical Situation   3  15 of 2012 of 29
8Dancing Nancies   4  23 of 3318 of 44
9People People   20  6 of 78 of 9Dave, Carter, Roi, Stefan, Peter
10Tripping Billies   2  27 of 3918 of 44
11One Sweet World   3  20 of 3016 of 40
12Help Myself   17 of 2612 of 30
13Two Step   2  25 of 3714 of 34Kristin Asbury
Set Break
14Halloween   2  7 of 195 of 22
15Lie in Our Graves   2  21 of 3314 of 39Dave, Carter, Roi, Boyd
16So Much to Say   2  23 of 3212 of 25
17Warehouse   2  26 of 3417 of 39
18Satellite   2  23 of 3015 of 29
19True Reflections  SD27 of 3916 of 42Kristin Asbury
20Lover Lay Down   3  19 of 2814 of 24Dave, Carter, Roi, Stefan, Peter, Kristin Asbury
21Recently   2  26 of 2920 of 40
22Ants Marching   3  23 of 2914 of 42
23All Along the Watchtower   21 of 2516 of 24
All songs feature the lineup of Dave Matthews, Carter Beauford, LeRoi Moore, Stefan Lessard, Peter Griesar, and Boyd Tinsley unless noted above.
Rarity  Rank  Tour  So Far 
Song  20 of 476.4968.300
Guest  4 of 66.5576.185
Opener  2 of 586.00076.500
Closer  3 of 657.33351.000
Encore  11 of 1224.57130.600
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
3111/18/1992 12:00:00 AM453055607DMBDMB656
325/2/1992 12:00:00 AM453055635Dave soloDave Side Projects20657
4111/10/1992 12:00:00 AM453055604DMBDMB1456
425/2/1992 12:00:00 AM453055635Dave soloDave Side Projects20657
5111/18/1992 12:00:00 AM453055607DMBDMB656
525/2/1992 12:00:00 AM453055635Dave soloDave Side Projects20657
6111/18/1992 12:00:00 AM453055607DMBDMB656
629/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
8111/17/1992 12:00:00 AM453055606DMBDMB756
829/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
9111/17/1992 12:00:00 AM453055606DMBDMB756
929/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
11111/18/1992 12:00:00 AM453055607DMBDMB656
1129/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
12111/17/1992 12:00:00 AM453055606DMBDMB756
1229/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
13111/18/1992 12:00:00 AM453055607DMBDMB656
1329/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
1418/4/1992 12:00:00 AM453055685DMBDMB11256
1629/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
17111/17/1992 12:00:00 AM453055606DMBDMB756
1729/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
20111/10/1992 12:00:00 AM453055604DMBDMB1456
2029/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
21111/18/1992 12:00:00 AM453055607DMBDMB656
2129/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
22111/18/1992 12:00:00 AM453055607DMBDMB656
2229/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
23111/18/1992 12:00:00 AM453055607DMBDMB656
2429/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
29111/18/1992 12:00:00 AM453055607DMBDMB656
9625/2/1992 12:00:00 AM453055635Dave soloDave Side Projects20657
98111/18/1992 12:00:00 AM453055607DMBDMB656
SongIDArtistIDShowDateShowIDShortNameCategoryNameNumDaysTourID
313/14/1991 12:00:00 AM453056860DMBDMB62165
325/2/1992 12:00:00 AM453055635Dave soloDave Side Projects20657
413/14/1991 12:00:00 AM453056860DMBDMB62165
425/2/1992 12:00:00 AM453055635Dave soloDave Side Projects20657
513/14/1991 12:00:00 AM453056860DMBDMB62165
525/2/1992 12:00:00 AM453055635Dave soloDave Side Projects20657
618/31/1991 12:00:00 AM453056808DMBDMB45165
629/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
818/31/1991 12:00:00 AM453056808DMBDMB45165
825/2/1992 12:00:00 AM453055635Dave soloDave Side Projects20657
913/14/1991 12:00:00 AM453056860DMBDMB62165
929/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
1118/31/1991 12:00:00 AM453056808DMBDMB45165
1129/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
1218/31/1991 12:00:00 AM453056808DMBDMB45165
1229/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
1314/5/1992 12:00:00 AM453055729DMBDMB23356
1329/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
14110/21/1991 12:00:00 AM453056605DMBDMB40065
15110/21/1991 12:00:00 AM453056605DMBDMB40065
16110/22/1991 12:00:00 AM453055864DMBDMB39965
1629/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
17110/22/1991 12:00:00 AM453055864DMBDMB39965
1729/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
2018/31/1991 12:00:00 AM453056808DMBDMB45165
2025/2/1992 12:00:00 AM453055635Dave soloDave Side Projects20657
2112/13/1992 12:00:00 AM453055738DMBDMB28556
2129/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
2213/1/1992 12:00:00 AM453055741DMBDMB26856
2229/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
2319/1/1992 12:00:00 AM453055697DMBDMB8456
2415/26/1992 12:00:00 AM453055649DMBDMB18256
2429/11/1992 12:00:00 AM453055702Dave soloDave Side Projects7457
29110/31/1992 12:00:00 AM453055597DMBDMB2456
30111/17/1992 12:00:00 AM453055606DMBDMB756
9618/31/1991 12:00:00 AM453056808DMBDMB45165
9625/2/1992 12:00:00 AM453055635Dave soloDave Side Projects20657
98110/22/1991 12:00:00 AM453055864DMBDMB39965
121111/26/1991 12:00:00 AM453056168DMBDMB36465