Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sTjeH-001ttJ-0h for pgsql-general@arkaria.postgresql.org; Tue, 16 Jul 2024 14:59:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sTjeF-001Q1I-NB for pgsql-general@arkaria.postgresql.org; Tue, 16 Jul 2024 14:59:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sTjeF-001Q16-A1 for pgsql-general@lists.postgresql.org; Tue, 16 Jul 2024 14:59:23 +0000 Received: from mail-oo1-xc33.google.com ([2607:f8b0:4864:20::c33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sTjeC-002Qfe-Eb for pgsql-general@lists.postgresql.org; Tue, 16 Jul 2024 14:59:22 +0000 Received: by mail-oo1-xc33.google.com with SMTP id 006d021491bc7-5ce74defe43so1373349eaf.2 for ; Tue, 16 Jul 2024 07:59:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721141958; x=1721746758; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=AQNRwXFH4AMvlh26CEQFEDm24LX2lhQsST0JOGICfRM=; b=nNjAU9Vj5dUcRtNPZW++riZ0BuRnpk5cXb5ZahQVr6lAlkjro4iKBeJ1+51F26h1iN 9jJNUEHWJiaP8OX0rpPeHt0L2yblCZG6Uq3yGCALoftoreW/ZS6fu7X1RpPOVLdHB7tq yf6vqBBqrVh2ZbByN/zVjCu8m42hqnRlCXWm8fdS0wexvPh5BeUMbzVTYuq7Hlk9yuop J+7rNbhNBnYCO2fxQmVqBmrzgDYBplC70HvNT6C7rKWIKMfo1Q3n8eGs912GjmIuQExU N2EGv4qvjKoyjhPpPH1Asx1lrwD3v/9HQ7pt277MwCwm7YOEbbP1NAbDpWJub4IPx8Cy CeVA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721141958; x=1721746758; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=AQNRwXFH4AMvlh26CEQFEDm24LX2lhQsST0JOGICfRM=; b=Gry3zL1Afz/ic87qz63x/aFz9DY/cFUybmUVwjFrTiup1otMPHhlllnhaMQBl8v3nc d4LlhSpVeqw0WfvMmT9z/yYYTjNsj6ktbmv2Ah2p594izhFqxQDnfvVtZxiwdt1ox8OC X5QPcHPfoHSCpyyjaS2Lxz5468NP5+96FuBPGYwZQ2G2+t2Ia39T1RoheHgQ6OPQD4pW cZJS2KSZiciDz34rLks27mSkTyPZaFbHSzimVKzZP5TU/F8g0V1KK53YyolcRRaQM1Gl I8KNQtwKx9yjcqUjbaibXnzxNtwJFfPbHvNpwGft28JbGqRLZdiW/kFAStzPkLod/0as I1TQ== X-Gm-Message-State: AOJu0Yx0jfRrz4tyk38TEEhmJtRVaG8/drlaeIDQaJ9y5Z9uUTlFsDVR mmTvMfA3wcSimvXEkcID9xpC5GDNb0NbFolsJvl7lUrfzTU8ni7SrF0jo3FSD9QmRWWUnQLiGlP M+LJpOwaAP/l/s4NB7cxQkDFSsLo= X-Google-Smtp-Source: AGHT+IGu13aKPBN9krU5RasnQUjy/NwwIBETC67ltpVx1jfwrZ/FhW4bXi9KMjH3wT/3FUnjczcPCNGIbn9+jRdjcO0= X-Received: by 2002:a05:6871:823:b0:25e:ee1:afb7 with SMTP id 586e51a60fabf-260bdd5b170mr1906915fac.9.1721141958251; Tue, 16 Jul 2024 07:59:18 -0700 (PDT) MIME-Version: 1.0 References: <1fd63ee5-a8a3-492e-a38d-82ff21da26b8@aklaver.com> In-Reply-To: <1fd63ee5-a8a3-492e-a38d-82ff21da26b8@aklaver.com> From: Anthony Apollis Date: Tue, 16 Jul 2024 16:59:06 +0200 Message-ID: Subject: Re: Code does Not Read in FY 2025 Data To: Adrian Klaver Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000079e19061d5e974b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000079e19061d5e974b Content-Type: text/plain; charset="UTF-8" I am using Postgres and SQL Server. Can you test the data pls. On Tue, 16 Jul 2024 at 16:45, Adrian Klaver wrote: > On 7/16/24 05:53, Anthony Apollis wrote: > > 1. The problem is the code below reads only data up until 2024, > > although the table has been updated with latest data that contains > > 2025, for some odd reason it is not pulling in or showing data when > > filtering for 2025 or even 2024 and later, which should contain all > > the latest data. > > 2. SQL: "SET DATEFIRST 7;-- Holding Period Query > > I don't recognize SET DATEFIRST 7 as Postgres command. > > What database are you running this on? > > Have not gone through the below fully, but this: > > "FY" IS NOT NULL AND "FY" >= 'FY24' > > and this > > WEEK_NUMBER."Date" < CURRENT_DATE > > would seem to be at odds if you want to reach into 2025. > > > > > SELECT > > > > 3. > > > > -- Holding Period Query > > SELECT > > WEEK_NUMBER."Week Number", > > WM_GH."Calendar day", > > WM_GH."Month/Week", > > WM_GH."Day name", > > WM_GH."Company", > > WM_GH."Material Code", > > WM_GH."Metric", > > WM_GH."Metric Value" > > FROM > > ( > > SELECT > > "Calendar day", > > "Month/Week", > > "Day name", > > "Company", > > "Material Code", > > "Metric", > > "Metric Value" > > FROM > > > > "Prod"."IMETA_Weekly_Metrics_in_Focus_Global_Stock_View_SAP_BW" AS > WM_GH > > WHERE > > WM_GH."Metric Focus" LIKE 'Weekly' > > AND WM_GH."Calendar day" <= ( > > SELECT MAX(WEEK_NUMBER."Date") AS "MAX DATE" > > FROM ( > > SELECT > > "Date", > > "Week number", > > COUNT("Date") OVER (PARTITION BY "Week > > number" ORDER BY "Week number") AS "Number of days", > > COUNT("Date") OVER (PARTITION BY "Week > > number" ORDER BY "Date") AS "Day number in weeks" > > FROM ( > > SELECT DISTINCT > > "Date", > > EXTRACT(WEEK FROM WEEK_NUMBER."Date") > > AS "Week number" > > FROM > > > > "dbo"."IMETA_Calendar_Days_Data_Table_Copy10" AS WEEK_NUMBER > > WHERE > > "FY" IS NOT NULL AND "FY" >= 'FY24' > > ) AS W_MAX > > ) AS WEEK_NUMBER > > WHERE > > WEEK_NUMBER."Date" < CURRENT_DATE > > AND "Number of days" = "Day number in weeks" > > ) > > ) AS WM_GH > > LEFT OUTER JOIN > > ( > > SELECT > > * > > FROM ( > > SELECT > > "Date", > > "Week number", > > COUNT("Date") OVER (PARTITION BY "Week number" > > ORDER BY "Week number") AS "Number of days", > > COUNT("Date") OVER (PARTITION BY "Week number" > > ORDER BY "Date") AS "Day number in weeks" > > FROM ( > > SELECT DISTINCT > > "Date", > > EXTRACT(WEEK FROM WEEK_NUMBER."Date") AS "Week > > number" > > FROM > > "dbo"."IMETA_Calendar_Days_Data_Table_Copy10" > > AS WEEK_NUMBER > > ) AS W_MAX > > ) AS WEEK_NUMBER > > WHERE > > WEEK_NUMBER."Date" < CURRENT_DATE > > ) AS WEEK_NUMBER > > ON > > WM_GH."Calendar day" = WEEK_NUMBER."Date" > > ORDER BY > > WM_GH."Calendar day" DESC; > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > --000000000000079e19061d5e974b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: base64 PGRpdiBkaXI9Imx0ciI+SSBhbSB1c2luZyBQb3N0Z3JlcyBhbmQgU1FMIFNlcnZlci7CoDxkaXY+ Q2FuIHlvdSB0ZXN0IHRoZSBkYXRhIHBscy48L2Rpdj48L2Rpdj48YnI+PGRpdiBjbGFzcz0iZ21h aWxfcXVvdGUiPjxkaXYgZGlyPSJsdHIiIGNsYXNzPSJnbWFpbF9hdHRyIj5PbiBUdWUsIDE2IEp1 bCAyMDI0IGF0IDE2OjQ1LCBBZHJpYW4gS2xhdmVyICZsdDs8YSBocmVmPSJtYWlsdG86YWRyaWFu LmtsYXZlckBha2xhdmVyLmNvbSI+YWRyaWFuLmtsYXZlckBha2xhdmVyLmNvbTwvYT4mZ3Q7IHdy b3RlOjxicj48L2Rpdj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJn aW46MHB4IDBweCAwcHggMC44ZXg7Ym9yZGVyLWxlZnQ6MXB4IHNvbGlkIHJnYigyMDQsMjA0LDIw NCk7cGFkZGluZy1sZWZ0OjFleCI+T24gNy8xNi8yNCAwNTo1MywgQW50aG9ueSBBcG9sbGlzIHdy b3RlOjxicj4NCiZndDvCoCAxLiBUaGUgcHJvYmxlbSBpcyB0aGUgY29kZSBiZWxvdyByZWFkcyBv bmx5IGRhdGEgdXAgdW50aWwgMjAyNCw8YnI+DQomZ3Q7wqAgwqAgwqBhbHRob3VnaCB0aGUgdGFi bGUgaGFzIGJlZW4gdXBkYXRlZCB3aXRoIGxhdGVzdCBkYXRhIHRoYXQgY29udGFpbnM8YnI+DQom Z3Q7wqAgwqAgwqAyMDI1LCBmb3Igc29tZSBvZGQgcmVhc29uIGl0IGlzIG5vdCBwdWxsaW5nIGlu IG9yIHNob3dpbmcgZGF0YSB3aGVuPGJyPg0KJmd0O8KgIMKgIMKgZmlsdGVyaW5nIGZvciAyMDI1 IG9yIGV2ZW4gMjAyNCBhbmQgbGF0ZXIsIHdoaWNoIHNob3VsZCBjb250YWluIGFsbDxicj4NCiZn dDvCoCDCoCDCoHRoZSBsYXRlc3QgZGF0YS48YnI+DQomZ3Q7wqAgMi7CoCDCoFNRTDogJnF1b3Q7 U0VUIERBVEVGSVJTVCA3Oy0tIEhvbGRpbmcgUGVyaW9kIFF1ZXJ5PGJyPg0KPGJyPg0KSSBkb24m IzM5O3QgcmVjb2duaXplIFNFVCBEQVRFRklSU1QgNyBhcyBQb3N0Z3JlcyBjb21tYW5kLjxicj4N Cjxicj4NCldoYXQgZGF0YWJhc2UgYXJlIHlvdSBydW5uaW5nIHRoaXMgb24/PGJyPg0KPGJyPg0K SGF2ZSBub3QgZ29uZSB0aHJvdWdoIHRoZSBiZWxvdyBmdWxseSwgYnV0IHRoaXM6PGJyPg0KPGJy Pg0KJnF1b3Q7RlkmcXVvdDsgSVMgTk9UIE5VTEwgQU5EICZxdW90O0ZZJnF1b3Q7ICZndDs9ICYj Mzk7RlkyNCYjMzk7PGJyPg0KPGJyPg0KYW5kIHRoaXM8YnI+DQo8YnI+DQpXRUVLX05VTUJFUi4m cXVvdDtEYXRlJnF1b3Q7ICZsdDsgQ1VSUkVOVF9EQVRFPGJyPg0KPGJyPg0Kd291bGQgc2VlbSB0 byBiZSBhdCBvZGRzIGlmIHlvdSB3YW50IHRvIHJlYWNoIGludG8gMjAyNS48YnI+DQo8YnI+DQom Z3Q7IDxicj4NCiZndDvCoCDCoCDCoFNFTEVDVDxicj4NCiZndDsgPGJyPg0KJmd0O8KgIDMuPGJy Pg0KJmd0OyA8YnI+DQomZ3Q7wqAgwqAgwqAtLSBIb2xkaW5nIFBlcmlvZCBRdWVyeTxicj4NCiZn dDvCoCDCoCDCoFNFTEVDVDxicj4NCiZndDvCoCDCoCDCoCDCoCDCoCBXRUVLX05VTUJFUi4mcXVv dDtXZWVrIE51bWJlciZxdW90Oyw8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgV01fR0guJnF1b3Q7 Q2FsZW5kYXIgZGF5JnF1b3Q7LDxicj4NCiZndDvCoCDCoCDCoCDCoCDCoCBXTV9HSC4mcXVvdDtN b250aC9XZWVrJnF1b3Q7LDxicj4NCiZndDvCoCDCoCDCoCDCoCDCoCBXTV9HSC4mcXVvdDtEYXkg bmFtZSZxdW90Oyw8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgV01fR0guJnF1b3Q7Q29tcGFueSZx dW90Oyw8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgV01fR0guJnF1b3Q7TWF0ZXJpYWwgQ29kZSZx dW90Oyw8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgV01fR0guJnF1b3Q7TWV0cmljJnF1b3Q7LDxi cj4NCiZndDvCoCDCoCDCoCDCoCDCoCBXTV9HSC4mcXVvdDtNZXRyaWMgVmFsdWUmcXVvdDs8YnI+ DQomZ3Q7wqAgwqAgwqBGUk9NPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgICg8YnI+DQomZ3Q7wqAg wqAgwqAgwqAgwqAgwqAgwqAgU0VMRUNUPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgICZxdW90O0NhbGVuZGFyIGRheSZxdW90Oyw8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgJnF1b3Q7TW9udGgvV2VlayZxdW90Oyw8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgJnF1b3Q7RGF5IG5hbWUmcXVvdDssPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgICZxdW90O0NvbXBhbnkmcXVvdDssPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgICZxdW90O01hdGVyaWFsIENvZGUmcXVvdDssPGJyPg0KJmd0O8KgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgICZxdW90O01ldHJpYyZxdW90Oyw8YnI+DQomZ3Q7wqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgJnF1b3Q7TWV0cmljIFZhbHVlJnF1b3Q7PGJyPg0KJmd0O8KgIMKg IMKgIMKgIMKgIMKgIMKgIEZST008YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8 YnI+DQomZ3Q7wqAgwqAgwqAmcXVvdDtQcm9kJnF1b3Q7LiZxdW90O0lNRVRBX1dlZWtseV9NZXRy aWNzX2luX0ZvY3VzX0dsb2JhbF9TdG9ja19WaWV3X1NBUF9CVyZxdW90OyBBUyBXTV9HSDxicj4N CiZndDvCoCDCoCDCoCDCoCDCoCDCoCDCoCBXSEVSRTxicj4NCiZndDvCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCBXTV9HSC4mcXVvdDtNZXRyaWMgRm9jdXMmcXVvdDsgTElLRSAmIzM5O1dlZWts eSYjMzk7PGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIEFORCBXTV9HSC4mcXVv dDtDYWxlbmRhciBkYXkmcXVvdDsgJmx0Oz0gKDxicj4NCiZndDvCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCBTRUxFQ1QgTUFYKFdFRUtfTlVNQkVSLiZxdW90O0RhdGUmcXVvdDspIEFT ICZxdW90O01BWCBEQVRFJnF1b3Q7PGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIEZST00gKDxicj4NCiZndDvCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCBTRUxFQ1Q8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgJnF1b3Q7RGF0ZSZxdW90Oyw8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgJnF1b3Q7V2VlayBudW1iZXImcXVvdDssPGJyPg0KJmd0 O8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIENPVU5UKCZxdW90 O0RhdGUmcXVvdDspIE9WRVIgKFBBUlRJVElPTiBCWSAmcXVvdDtXZWVrPGJyPg0KJmd0O8KgIMKg IMKgbnVtYmVyJnF1b3Q7IE9SREVSIEJZICZxdW90O1dlZWsgbnVtYmVyJnF1b3Q7KSBBUyAmcXVv dDtOdW1iZXIgb2YgZGF5cyZxdW90Oyw8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgQ09VTlQoJnF1b3Q7RGF0ZSZxdW90OykgT1ZFUiAoUEFSVElU SU9OIEJZICZxdW90O1dlZWs8YnI+DQomZ3Q7wqAgwqAgwqBudW1iZXImcXVvdDsgT1JERVIgQlkg JnF1b3Q7RGF0ZSZxdW90OykgQVMgJnF1b3Q7RGF5IG51bWJlciBpbiB3ZWVrcyZxdW90Ozxicj4N CiZndDvCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCBGUk9NICg8YnI+DQom Z3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgU0VMRUNUIERJ U1RJTkNUPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgICZxdW90O0RhdGUmcXVvdDssPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIEVYVFJBQ1QoV0VFSyBGUk9NIFdFRUtfTlVN QkVSLiZxdW90O0RhdGUmcXVvdDspPGJyPg0KJmd0O8KgIMKgIMKgQVMgJnF1b3Q7V2VlayBudW1i ZXImcXVvdDs8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgRlJPTTxicj4NCiZndDvCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoDxicj4NCiZndDvCoCDCoCDCoCZxdW90O2RibyZxdW90Oy4mcXVvdDtJTUVU QV9DYWxlbmRhcl9EYXlzX0RhdGFfVGFibGVfQ29weTEwJnF1b3Q7IEFTIFdFRUtfTlVNQkVSPGJy Pg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIFdIRVJF PGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgICZxdW90O0ZZJnF1b3Q7IElTIE5PVCBOVUxMIEFORCAmcXVvdDtGWSZxdW90OyAmZ3Q7PSAm IzM5O0ZZMjQmIzM5Ozxicj4NCiZndDvCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCApIEFTIFdfTUFYPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg ICkgQVMgV0VFS19OVU1CRVI8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgV0hFUkU8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg V0VFS19OVU1CRVIuJnF1b3Q7RGF0ZSZxdW90OyAmbHQ7IENVUlJFTlRfREFURTxicj4NCiZndDvC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCBBTkQgJnF1b3Q7TnVtYmVyIG9m IGRheXMmcXVvdDsgPSAmcXVvdDtEYXkgbnVtYmVyIGluIHdlZWtzJnF1b3Q7PGJyPg0KJmd0O8Kg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgICk8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgKSBBUyBX TV9HSDxicj4NCiZndDvCoCDCoCDCoExFRlQgT1VURVIgSk9JTjxicj4NCiZndDvCoCDCoCDCoCDC oCDCoCAoPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKgIFNFTEVDVDxicj4NCiZndDvCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAqPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKgIEZS T00gKDxicj4NCiZndDvCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCBTRUxFQ1Q8YnI+DQomZ3Q7 wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgJnF1b3Q7RGF0ZSZxdW90Oyw8YnI+DQom Z3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgJnF1b3Q7V2VlayBudW1iZXImcXVv dDssPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIENPVU5UKCZxdW90 O0RhdGUmcXVvdDspIE9WRVIgKFBBUlRJVElPTiBCWSAmcXVvdDtXZWVrIG51bWJlciZxdW90Ozxi cj4NCiZndDvCoCDCoCDCoE9SREVSIEJZICZxdW90O1dlZWsgbnVtYmVyJnF1b3Q7KSBBUyAmcXVv dDtOdW1iZXIgb2YgZGF5cyZxdW90Oyw8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgQ09VTlQoJnF1b3Q7RGF0ZSZxdW90OykgT1ZFUiAoUEFSVElUSU9OIEJZICZxdW90 O1dlZWsgbnVtYmVyJnF1b3Q7PGJyPg0KJmd0O8KgIMKgIMKgT1JERVIgQlkgJnF1b3Q7RGF0ZSZx dW90OykgQVMgJnF1b3Q7RGF5IG51bWJlciBpbiB3ZWVrcyZxdW90Ozxicj4NCiZndDvCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCBGUk9NICg8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgU0VMRUNUIERJU1RJTkNUPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgICZxdW90O0RhdGUmcXVvdDssPGJyPg0KJmd0O8KgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIEVYVFJBQ1QoV0VFSyBGUk9NIFdFRUtfTlVNQkVS LiZxdW90O0RhdGUmcXVvdDspIEFTICZxdW90O1dlZWs8YnI+DQomZ3Q7wqAgwqAgwqBudW1iZXIm cXVvdDs8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgRlJPTTxicj4N CiZndDvCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmcXVvdDtkYm8mcXVv dDsuJnF1b3Q7SU1FVEFfQ2FsZW5kYXJfRGF5c19EYXRhX1RhYmxlX0NvcHkxMCZxdW90Ozxicj4N CiZndDvCoCDCoCDCoEFTIFdFRUtfTlVNQkVSPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgICkgQVMgV19NQVg8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgwqAgwqAgKSBBUyBXRUVL X05VTUJFUjxicj4NCiZndDvCoCDCoCDCoCDCoCDCoCDCoCDCoCBXSEVSRTxicj4NCiZndDvCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCBXRUVLX05VTUJFUi4mcXVvdDtEYXRlJnF1b3Q7ICZsdDsg Q1VSUkVOVF9EQVRFPGJyPg0KJmd0O8KgIMKgIMKgIMKgIMKgICkgQVMgV0VFS19OVU1CRVI8YnI+ DQomZ3Q7wqAgwqAgwqBPTjxicj4NCiZndDvCoCDCoCDCoCDCoCDCoCBXTV9HSC4mcXVvdDtDYWxl bmRhciBkYXkmcXVvdDsgPSBXRUVLX05VTUJFUi4mcXVvdDtEYXRlJnF1b3Q7PGJyPg0KJmd0O8Kg IMKgIMKgT1JERVIgQlk8YnI+DQomZ3Q7wqAgwqAgwqAgwqAgwqAgV01fR0guJnF1b3Q7Q2FsZW5k YXIgZGF5JnF1b3Q7IERFU0M7PGJyPg0KJmd0OyA8YnI+DQo8YnI+DQotLSA8YnI+DQpBZHJpYW4g S2xhdmVyPGJyPg0KPGEgaHJlZj0ibWFpbHRvOmFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20iIHRh cmdldD0iX2JsYW5rIj5hZHJpYW4ua2xhdmVyQGFrbGF2ZXIuY29tPC9hPjxicj4NCjxicj4NCjwv YmxvY2txdW90ZT48L2Rpdj4NCg== --000000000000079e19061d5e974b--