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 = 453056740 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '2/28/2010' OR (SongInfo.ShowDate = '2/28/2010' AND SongInfo.ShowID < 453056740)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
11 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
11 | 2 | 5/12/2006 12:00:00 AM | 453056318 | Dave solo | 1388 | 86 |
11 | 3 | 12/11/2009 12:00:00 AM | 453056730 | Dave & Tim | 79 | 104 |
11 | 4 | 12/17/2003 12:00:00 AM | 453056049 | Dave & Friends | 2265 | 76 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | 5889 | 63 |
17 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
17 | 2 | 9/20/2005 12:00:00 AM | 453056242 | Dave solo | 1622 | 84 |
17 | 3 | 12/11/2009 12:00:00 AM | 453056730 | Dave & Tim | 79 | 104 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | 2263 | 76 |
19 | 1 | 2/23/2010 12:00:00 AM | 453056738 | DMB | 5 | 107 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | 5068 | 31 |
19 | 3 | 12/11/2009 12:00:00 AM | 453056730 | Dave & Tim | 79 | 104 |
19 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 1485 | 86 |
19 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 5053 | 31 |
21 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
21 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | 1387 | 86 |
21 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | 2491 | 75 |
46 | 1 | 2/23/2010 12:00:00 AM | 453056738 | DMB | 5 | 107 |
46 | 2 | 5/15/2006 12:00:00 AM | 453056320 | Dave solo | 1385 | 86 |
46 | 3 | 12/11/2009 12:00:00 AM | 453056730 | Dave & Tim | 79 | 104 |
46 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 5053 | 31 |
46 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | 5308 | 41 |
47 | 1 | 4/18/2009 12:00:00 AM | 453056615 | DMB | 316 | 103 |
47 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | 1387 | 86 |
47 | 3 | 10/28/2005 12:00:00 AM | 453056235 | Dave & Tim | 1584 | 84 |
47 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 1485 | 86 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 5053 | 31 |
49 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
49 | 2 | 10/19/2008 12:00:00 AM | 453056609 | Dave solo | 497 | 97 |
49 | 3 | 12/11/2009 12:00:00 AM | 453056730 | Dave & Tim | 79 | 104 |
49 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | 2269 | 76 |
90 | 1 | 2/19/2010 12:00:00 AM | 453056735 | DMB | 9 | 107 |
90 | 2 | 5/15/2006 12:00:00 AM | 453056320 | Dave solo | 1385 | 86 |
90 | 3 | 12/11/2009 12:00:00 AM | 453056730 | Dave & Tim | 79 | 104 |
90 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | 1933 | 79 |
90 | 74 | 9/7/2007 12:00:00 AM | 453063341 | Kenny Chesney | 905 | 1146 |
90 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | 2305 | 75 |
92 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
96 | 2 | 12/16/2006 12:00:00 AM | 453056410 | Dave solo | 1170 | 86 |
96 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | 490 | 97 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | 6169 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | 6232 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | 5792 | 1133 |
96 | 45 | 4/30/2005 12:00:00 AM | 453086573 | Gov't Mule | 1765 | 1144 |
96 | 63 | 6/30/2004 12:00:00 AM | 453063318 | Keller Williams | 2069 | 1143 |
233 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
233 | 2 | 11/19/2009 12:00:00 AM | 453056751 | Dave solo | 101 | 104 |
233 | 3 | 2/24/2010 12:00:00 AM | 453056820 | Dave & Tim | 4 | 109 |
233 | 4 | 2/5/2006 12:00:00 AM | 453056321 | Dave & Friends | 1484 | 86 |
279 | 1 | 8/30/2008 12:00:00 AM | 453056575 | DMB | 547 | 98 |
445 | 3 | 7/28/2007 12:00:00 AM | 453056507 | Dave & Tim | 946 | 93 |
549 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
571 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | 107 | 104 |
571 | 3 | 2/24/2010 12:00:00 AM | 453056820 | Dave & Tim | 4 | 109 |
574 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
574 | 3 | 12/12/2009 12:00:00 AM | 453056728 | Dave & Tim | 78 | 104 |
576 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
576 | 3 | 12/10/2009 12:00:00 AM | 453056729 | Dave & Tim | 80 | 104 |
579 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
579 | 3 | 2/17/2010 12:00:00 AM | 453056818 | Dave & Tim | 11 | 109 |
583 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
585 | 3 | 2/24/2010 12:00:00 AM | 453056820 | Dave & Tim | 4 | 109 |
586 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | 3 | 107 |
586 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | 107 | 104 |
586 | 3 | 2/24/2010 12:00:00 AM | 453056820 | Dave & Tim | 4 | 109 |