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 '8/28/2018' and '9/2/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/7/2018' and '9/2/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/25/2018' and '9/2/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 '9/1/2018' and '9/2/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 '8/25/2018' and '9/2/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 '8/24/2018' and '9/2/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 '' and '9/2/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 '8/31/2018' and '9/2/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 '8/25/2018' and '9/2/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/20/2018' and '9/2/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 '8/28/2018' and '9/2/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/28/2018' and '9/2/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 '8/28/2018' and '9/2/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/27/2018' and '9/2/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 '8/25/2018' and '9/2/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/24/2018' and '9/2/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 '8/24/2018' and '9/2/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/28/2018' and '9/2/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 '8/28/2018' and '9/2/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 '9/12/2015' and '9/2/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/28/2018' and '9/2/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 '8/24/2018' and '9/2/2018'