SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '2/25/2017' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '6/30/2010' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '6/14/2017' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/18/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/18/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/19/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '1/13/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/19/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/18/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/18/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/19/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/19/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/19/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '1/14/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/18/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/18/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '7/9/2016' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/19/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/19/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/19/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/18/2018' and '5/22/2018'
SQL = Select Count(ShowDate) as LastCount from ShowInfo WHERE ShowInfo.ArtistID = 1 AND SetUnknown = 0 AND Cancelled = 0 AND Rescheduled = 0 AND ShowInfo.ShowDate Between '5/18/2018' and '5/22/2018'