I am needing to pull data from a database that I did not create or own admin of.
The table is not Indexed, and I need to find and compare the FailureCount Column hourly for each unique ControlPointName indicating the difference or change of the value from hour to hour.
With the table not having an index, I am not sure what I should do here.
I assume creating a temp table and I will be dumping this to a Excel spreadsheet so it can be emailed daily.
The Year and Month will be a variable later. For now I am just using it to get the initial data values I need and will adjust the code later for a variable.
Thank you for any help.
Below is the Database structure
USE [tmdsDatabaseStatistics]
GO
/****** Object: Table [dbo].[tblStatisticsLocationHour] Script Date: 08/17/2022 07:19:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblStatisticsLocationHour](
[ControlPointName] [nvarchar](50) NULL,
[StationNumber] [int] NULL,
[codeline] [int] NULL,
[SubName] [nvarchar](50) NULL,
[Year] [int] NULL,
[Month] [int] NULL,
[Day] [int] NULL,
[Hour] [int] NULL,
[OutOfSyncCount] [int] NULL,
[RecallLocalCount] [int] NULL,
[RecallRemoteCount] [int] NULL,
[IndicationCount] [int] NULL,
[ControlFailCount] [int] NULL,
[ControlPointStatusDownCount] [int] NULL,
[ControlSentCount] [int] NULL,
[FailureCount] [int] NULL,
[ResyncCount] [int] NULL,
[ControlDeliveryCount] [int] NULL,
[RecallRetryCount] [int] NULL,
[ResendCount] [int] NULL,
[FowardFlushCount] [int] NULL
) ON [PRIMARY]
GO
This is the simple query of what data I need before the compare;
SELECT [ControlPointName]
,[StationNumber]
,[codeline]
,[SubName]
,[Year]
,[Month]
,[Day]
,[Hour]
,[FailureCount]
FROM [tmdsDatabaseStatistics].[dbo].[tblStatisticsLocationHour] WITH (NOLOCK)
Where Year = '2022' and month = '8'
order by ControlPointName, Day, Hour
This is a sample of the data table
(No column name)
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','19','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','1','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','15','0','11','0','15','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','2','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','4','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','3','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','0','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','20','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','4','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','15','0','10','0','16','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','5','23','0','13','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','5','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','6','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','0','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','20','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','7','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','15','0','12','0','11','0','0','0','0','0','0','1','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','16','0','11','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','8','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','13','0','10','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','14','0','12','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','16','0','11','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','19','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','9','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','16','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','10','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','13','0','11','0','15','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','17','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','11','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','14','0','11','0','15','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','12','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','6','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','12','0','12','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','13','0','11','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','13','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','2','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','14','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','0','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','21','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','15','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','2','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','4','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','7','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','8','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','14','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','15','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','18','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT ' E HAZEN','1','492','ZAP LINE','2022','8','16','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','1','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','2','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','3','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','4','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','5','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','6','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','7','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','8','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','9','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','10','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','11','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','9','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','10','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','11','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','12','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','13','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','14','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','15','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','16','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','17','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','18','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','19','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','20','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','21','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','22','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','12','23','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','0','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','1','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','2','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','3','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','4','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','5','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','6','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','7','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','8','0','0','0','0','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','9','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','10','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','11','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','12','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','13','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','14','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','15','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','16','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','17','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','18','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','19','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','20','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','21','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','22','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','13','23','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','0','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','1','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','2','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','3','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','4','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','5','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','6','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','7','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','8','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','9','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','10','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','11','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','12','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','13','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','14','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','15','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','16','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','17','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','18','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','19','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','20','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','21','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','22','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','14','23','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','0','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','1','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','2','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','3','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','4','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','5','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','6','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','7','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','8','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','9','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','10','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','11','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','12','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','13','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','14','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','15','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','16','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','17','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','18','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','19','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','20','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','21','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','22','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','15','23','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','0','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','1','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','2','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','3','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','4','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','5','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','6','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','7','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','8','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','9','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','10','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','11','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','12','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','13','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','14','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','15','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','16','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','17','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','18','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','19','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','20','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','21','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','22','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '.8','1','608','NOYES','2022','8','16','23','0','0','0','0','0','0','0','1','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','0','0','9','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','1','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','2','0','11','0','15','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','4','0','12','0','11','0','0','0','0','0','0','1','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','5','0','11','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','6','0','9','0','16','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','7','0','12','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','8','0','10','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','11','0','11','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','12','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','13','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','14','0','11','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','15','0','10','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','17','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','19','0','10','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','22','0','11','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','1','23','0','11','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','1','0','8','0','16','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','2','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','3','0','12','0','15','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','4','0','11','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','5','0','9','0','15','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','6','0','11','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','7','0','11','0','15','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','8','0','11','0','15','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','12','0','10','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','13','0','11','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','14','0','11','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','15','0','11','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','16','0','10','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','17','0','11','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','18','0','11','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','2','23','0','11','0','11','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','1','0','11','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','2','0','11','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','4','0','10','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','5','0','10','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','6','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','7','0','10','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','8','0','12','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','9','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','10','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','11','0','11','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','12','0','11','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','13','0','9','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','14','0','7','0','15','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','15','0','10','0','17','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','16','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','17','0','9','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','18','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','19','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','20','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','21','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','22','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','3','23','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','0','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','1','0','10','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','2','0','11','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','3','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','4','0','9','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','5','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','6','0','10','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','7','0','10','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','8','0','12','0','14','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','9','0','8','0','15','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','10','0','10','0','13','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','11','0','12','0','12','0','0','0','0','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','12','0','11','0','14','0','2','0','3','5','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','13','0','11','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','14','0','11','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','15','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','16','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','17','0','9','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','18','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','19','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','20','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','21','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','22','0','11','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','4','23','0','9','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','0','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','1','0','9','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','2','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','3','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','4','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','5','0','9','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','6','0','11','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','7','0','9','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','8','0','11','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','9','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','10','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','11','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','12','0','9','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','13','0','12','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','14','0','10','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','15','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','16','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','17','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','18','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','19','0','11','0','11','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','20','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','21','0','9','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','22','0','11','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','5','23','0','11','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','0','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','1','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','2','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','3','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','4','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','5','0','11','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','6','0','8','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','7','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','8','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','9','0','11','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','10','0','12','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','11','0','9','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','12','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','13','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','14','0','11','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','15','0','10','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','16','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','17','0','11','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','18','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','19','0','11','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','20','0','11','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','21','0','11','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','22','0','9','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','6','23','0','10','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','0','0','10','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','1','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','2','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','3','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','4','0','11','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','5','0','10','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','6','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','7','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','8','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','9','0','10','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','10','0','12','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','11','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','12','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','13','0','12','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','14','0','10','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','15','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','16','0','11','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','17','0','11','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','18','0','10','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','19','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','20','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','21','0','11','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','22','0','11','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','7','23','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','0','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','1','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','2','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','3','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','4','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','5','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','6','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','7','0','11','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','8','0','11','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','9','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','10','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','11','0','9','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','12','0','12','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','13','0','9','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','14','0','12','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','15','0','10','0','16','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','16','0','10','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','17','0','10','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','18','0','10','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','19','0','10','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','20','0','9','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','21','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','22','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','8','23','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','0','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','1','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','2','0','11','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','3','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','4','0','11','0','11','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','5','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','6','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','7','0','10','0','16','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','8','0','11','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','9','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','10','0','11','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','11','0','10','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','12','0','11','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','13','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','14','0','10','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','15','0','11','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','16','0','9','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','17','0','11','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','18','0','11','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','19','0','10','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','20','0','10','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','21','0','12','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','22','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','9','23','0','9','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','0','0','11','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','1','0','11','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','2','0','11','0','13','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','3','0','9','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','4','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','5','0','11','0','15','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','6','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','7','0','8','0','16','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','8','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','9','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','10','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','11','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','12','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','13','0','11','0','11','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','14','0','12','0','12','0','0','0','3','0','0','0','0','0', UNION ALL"
"SELECT '0.9','1','757','MARSHALL','2022','8','10','15','0','10','0','14','0','0','0','3','0','0','0','0','0', UNION ALL"
I have attached the csv if the above is not usable.
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner
August 17, 2022 at 1:40 pm
Here is what I have tried. However there is no change in the failures listed in the sample so the change column should be a zero not a one. I think that is due to me putting a +1 at the end of my code.
SELECT TOP (1000) g1.ControlPointName
,g1.StationNumber
,g1.codeline
,g1.SubName
,g1.Year
,g1.Month
,g1.Day
,g1.Hour
,g1.FailureCount,
(g2.FailureCount - g1.FailureCount) as Change
FROM tmdsDatabaseStatistics.dbo.tblStatisticsLocationHour g1 INNER JOIN tmdsDatabaseStatistics.dbo.tblStatisticsLocationHour g2 WITH (NOLOCK) ON g2.FailureCount = g1.FailureCount + 1
Where g1.Year = '2022' and g1.month = '8'
order by day, hour
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner
August 17, 2022 at 1:45 pm
Your test data appears to contain two different line types, the rows for "E Hazen" being different than the rest. Save us some time and tell us which set of rows will work for your example table.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 17, 2022 at 1:53 pm
Hi Jeff,
First thank you for responding,
The first column is the name of the locations. some are represented as a decimal representing the mile post of a location, however it is all text values.
Is that what your are asking?
If so, then the resulting query I am trying to get would be for each unique named location per hour.
Thanks,
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner
If I understand the problem correctly, I think all you need is a standard LAG. You may need to adjust the PARTITIONing columns and/or the ORDER BY:
DECLARE @month int
DECLARE @year int
SET @year = 2022
SET @month = 8
SELECT /* note: TOP (1000) moved to below; adjust it/remove it there as needed */
g.ControlPointName
,g.StationNumber
,g.codeline
,g.SubName
,g.Year
,g.Month
,g.Day
,g.Hour
,g.FailureCount
,ISNULL(g.FailureCount - LAG(FailureCount, 1) OVER(PARTITION BY g.ControlPointName, g.StationNumber, g.codeline, g.SubName ORDER BY g.Day, g.Hour), 0) AS Change
FROM (SELECT TOP (1000) * FROM dbo.tblStatisticsLocationHour) AS g
WHERE g.Year = @year and g.Month = @month
ORDER BY g.ControlPointName, g.StationNumber, g.codeline, g.SubName, g.day, g.hour
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
August 17, 2022 at 3:34 pm
A Follow up question or the Order by. Running the command gives me the results. There are some that are a negative number and tried ordering it both Asc and Desc to display the Largest positive number first.
I tried using both Case and Sign commands. It errors out as the Change Column does not exist in the table.
Thanks,
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner
August 17, 2022 at 4:41 pm
There are some that are a negative number
That seems logical, if it went from 1 to 0, the change would be -1.
display the Largest positive number first.
Could you explain this further? Do you mean largest per combination of { g.ControlPointName, g.StationNumber, g.codeline, g.SubName }? That is, for any day and any hour? Or the largest per day for that combo? Or the largest overall for any combo?
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
August 17, 2022 at 5:34 pm
Here is an example where it goes from a NULL value to a Positive number then a Negative number in a three hour period.
WD 1116.0 (HILINE)1413HI LINE2022816386610
WD 1116.0 (HILINE)1413HI LINE2022816286618661
WD 1116.0 (HILINE)1413HI LINE202281610-8661
So, I need to show the Larger positive numbers and then the Negative number for each result. and then if it goes to a NULL the next hour.
Does that help?
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner
August 17, 2022 at 8:22 pm
Hi Jeff,
First thank you for responding,
The first column is the name of the locations. some are represented as a decimal representing the mile post of a location, however it is all text values.
Is that what your are asking?
If so, then the resulting query I am trying to get would be for each unique named location per hour.
Thanks,
Ah... that explains it. It looked like a "data impurity" and needed to ask.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 17, 2022 at 8:26 pm
Here is an example where it goes from a NULL value to a Positive number then a Negative number in a three hour period.
WD 1116.0 (HILINE)1413HI LINE2022816386610
WD 1116.0 (HILINE)1413HI LINE2022816286618661
WD 1116.0 (HILINE)1413HI LINE202281610-8661So, I need to show the Larger positive numbers and then the Negative number for each result. and then if it goes to a NULL the next hour.
Does that help?
What do you want done if it's positive to start, goes NULL, and then goes negative?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2022 at 12:49 pm
I need to show for example that at hour null/zero it was a value of '0' and lets say at hour one it climbs to the positive number and then when the value changes to a negative number at hour three and then when it goes back to a null/zero at hour four.
Any of the additional null/zero values do not need to be shown. Only the changed values.
Thank you
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner
August 18, 2022 at 1:57 pm
You also say you always want to show the largest positive number first. To be honest, that doesn't make any sense because it seems to provide no value in what you seems to be asking, which is a running account of differences by date/time. If I'm wrong on that, you'll need to make a visual for me to understand this one.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2022 at 2:25 pm
It sounds like maybe you need to make this adjustment to the code?:
...
WHERE g.Year = @year and g.Month = @month AND g.FailureCount <> 0
...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
August 18, 2022 at 2:37 pm
Jeff,
Here is an example of the data for one location for a single days statistics with some explanation;
As for query output for a single day, it generates almost 95000 lines of data, which obviously is not a realistic amount of lines to review for anyone.
The day Starts with the 8661 FailureCount in this example.
WD 1116.0 (HILINE)1413HI LINE2022816086610
They swap servers and then the count resets to 0 at hour 1. And shows a Change In FailureCount with the -8661 Change.
WD 1116.0 (HILINE)1413HI LINE202281610-8661
At Hour 2 then the FailureCount goes back to 8661 showing a change of 8661.
WD 1116.0 (HILINE)1413HI LINE2022816286618661
Then in hour 3 thru 23 no change in the FailureCount is detected, and that info is not needed to be reported beyond the first change to 0 again.
WD 1116.0 (HILINE)1413HI LINE2022816386610
Ignore all the other lines unless a change in value.
WD 1116.0 (HILINE)1413HI LINE2022816486610
WD 1116.0 (HILINE)1413HI LINE2022816586610
WD 1116.0 (HILINE)1413HI LINE2022816686610
WD 1116.0 (HILINE)1413HI LINE2022816786610
WD 1116.0 (HILINE)1413HI LINE2022816886610
WD 1116.0 (HILINE)1413HI LINE2022816986610
WD 1116.0 (HILINE)1413HI LINE20228161086610
WD 1116.0 (HILINE)1413HI LINE20228161186610
WD 1116.0 (HILINE)1413HI LINE20228161286610
WD 1116.0 (HILINE)1413HI LINE20228161386610
WD 1116.0 (HILINE)1413HI LINE20228161486610
WD 1116.0 (HILINE)1413HI LINE20228161586610
WD 1116.0 (HILINE)1413HI LINE20228161686610
WD 1116.0 (HILINE)1413HI LINE20228161786610
WD 1116.0 (HILINE)1413HI LINE20228161886610
WD 1116.0 (HILINE)1413HI LINE20228161986610
WD 1116.0 (HILINE)1413HI LINE20228162086610
WD 1116.0 (HILINE)1413HI LINE20228162186610
WD 1116.0 (HILINE)1413HI LINE20228162286610
WD 1116.0 (HILINE)1413HI LINE20228162386610
Thanks
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner
August 18, 2022 at 3:36 pm
Scott,
WHERE g.Year = @year and g.Month = @month AND g.FailureCount <> 0
Only returns lines with the High FailureCount values. It does not return any lines with the changed values.
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply