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 = 453056931 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '7/9/2011' OR (SongInfo.ShowDate = '7/9/2011' AND SongInfo.ShowID < 453056931)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
20 | 1 | 6/25/2011 12:00:00 AM | 453056920 | DMB | 14 | 115 |
20 | 2 | 5/15/2006 12:00:00 AM | 453056320 | Dave solo | 1881 | 86 |
20 | 3 | 12/10/2010 12:00:00 AM | 453056858 | Dave & Tim | 211 | 113 |
20 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 1981 | 86 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | 6050 | 52 |
20 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | 5930 | 41 |
20 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | 3226 | 32 |
25 | 1 | 4/25/2009 12:00:00 AM | 453056619 | DMB | 805 | 103 |
25 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | 5564 | 31 |
25 | 3 | 7/6/2010 12:00:00 AM | 453056828 | Dave & Tim | 368 | 109 |
25 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | 5804 | 41 |
70 | 1 | 7/14/2010 12:00:00 AM | 453056782 | DMB | 360 | 110 |
70 | 2 | 11/11/2010 12:00:00 AM | 453056838 | Dave solo | 240 | 109 |
70 | 3 | 6/25/2011 12:00:00 AM | 453056927 | Dave & Tim | 14 | 114 |
70 | 4 | 1/16/2004 12:00:00 AM | 453056056 | Dave & Friends | 2731 | 77 |
90 | 1 | 3/11/2010 12:00:00 AM | 453056747 | DMB | 485 | 107 |
90 | 2 | 5/15/2006 12:00:00 AM | 453056320 | Dave solo | 1881 | 86 |
90 | 3 | 6/25/2011 12:00:00 AM | 453056927 | Dave & Tim | 14 | 114 |
90 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | 2429 | 79 |
90 | 74 | 9/7/2007 12:00:00 AM | 453063341 | Kenny Chesney | 1401 | 1146 |
90 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | 2801 | 75 |
141 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 4489 | 16 |
233 | 1 | 11/10/2010 12:00:00 AM | 453056849 | DMB | 241 | 112 |
233 | 2 | 4/13/2011 12:00:00 AM | 453056930 | Dave solo | 87 | 114 |
233 | 3 | 6/25/2011 12:00:00 AM | 453056927 | Dave & Tim | 14 | 114 |
233 | 4 | 2/5/2006 12:00:00 AM | 453056321 | Dave & Friends | 1980 | 86 |
235 | 2 | 11/18/2010 12:00:00 AM | 453056864 | Dave solo | 233 | 109 |
235 | 3 | 6/25/2011 12:00:00 AM | 453056927 | Dave & Tim | 14 | 114 |
235 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 1981 | 86 |
235 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | 2801 | 75 |
236 | 2 | 11/19/2009 12:00:00 AM | 453056751 | Dave solo | 597 | 104 |
236 | 3 | 6/25/2011 12:00:00 AM | 453056927 | Dave & Tim | 14 | 114 |
236 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 1981 | 86 |
289 | 1 | 9/7/2008 12:00:00 AM | 453056580 | DMB | 1035 | 98 |
289 | 2 | 9/30/2006 12:00:00 AM | 453056334 | Dave solo | 1743 | 86 |
289 | 3 | 6/25/2011 12:00:00 AM | 453056927 | Dave & Tim | 14 | 114 |
289 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 1981 | 86 |
343 | 1 | 11/20/2010 12:00:00 AM | 453056855 | DMB | 231 | 112 |
343 | 2 | 8/22/2010 12:00:00 AM | 453056830 | Dave solo | 321 | 109 |
343 | 3 | 6/25/2011 12:00:00 AM | 453056927 | Dave & Tim | 14 | 114 |
343 | 4 | 2/5/2006 12:00:00 AM | 453056322 | Dave & Friends | 1980 | 86 |