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/22/2018' and '6/27/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/23/2018' and '6/27/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/1/2018' and '6/27/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/26/2018' and '6/27/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/22/2018' and '6/27/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/26/2018' and '6/27/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/23/2018' and '6/27/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/23/2018' and '6/27/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/3/1993' and '6/27/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/26/2018' and '6/27/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/22/2018' and '6/27/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/26/2018' and '6/27/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/23/2018' and '6/27/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/23/2018' and '6/27/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/26/2018' and '6/27/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/22/2018' and '6/27/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/26/2018' and '6/27/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/23/2018' and '6/27/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/26/2018' and '6/27/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/26/2018' and '6/27/2018'