Query Table without index

  • 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.

    Attachments:
    You must be logged in to view attached files.
  • 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
  • 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


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • 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,

  • 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) A socialist is someone who give you the shirt off *someone else's* back.

  • 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,

  • 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) A socialist is someone who give you the shirt off *someone else's* back.

  • 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?

  • brian.cook wrote:

    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


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • brian.cook wrote:

    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?

    What do you want done if it's positive to start, goes NULL, and then goes negative?

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • 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

  • 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


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • 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) A socialist is someone who give you the shirt off *someone else's* back.

  • 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

  • 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.

     

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply