SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.86ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.48ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.35ms | INSERT INTO "regulation"("filehash","filehash_count","source_year","source_title","source_topic","accessed_date","source_url","page_count","file_pages","pdf","source_subtopic","text_bytes","source_local_title","notes","source_id","review_state","normalise_check","file_uid","source_country","translation_status","filehash_dupe","normalised_filename","zero_length_pdf","file_languages","private") VALUES (NULL,NULL,'2026','Ordinance No 2013:251: Environmental Assessment (Consolidated 2026-06-04)(Swedish)',2,'2026-08-12','https://www.riksdagen.se/sv/dokument-och-lagar/dokument/svensk-forfattningssamling/miljoprovningsforordning-2013251_sfs-2013-251/',NULL,NULL,'regulation.pdf.9ad020d2655c6ca7.R01TRFMtSnVuIDI2LTUwLnBkZg==.pdf',15,NULL,'Miljöprövningsförordning (2013:251)',NULL,'GMSDS-Jun 26-50',NULL,NULL,NULL,107,NULL,'F',NULL,'F','||','F')RETURNING "id"; | 1.74ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.57ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.26ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.37ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 13.74ms | SELECT "regulation"."source_id", "regulation"."source_topic", "regulation"."source_subtopic", "regulation"."source_country", "regulation"."source_title", "regulation"."source_year", "regulation"."accessed_date", "regulation"."pdf", "regulation"."private", "regulation"."id" FROM "regulation" WHERE ("regulation"."id" IS NOT NULL) ORDER BY "regulation"."private", "regulation"."id" DESC, "regulation"."id" LIMIT 20 OFFSET 0; | 11.89ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 4) LIMIT 1 OFFSET 0; | 0.33ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 18) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0; | 0.31ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 107) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 25) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 36) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 82) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 53) LIMIT 1 OFFSET 0; | 0.27ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.46ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 60) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 5) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 51) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 11) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 4) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 18) LIMIT 1 OFFSET 0; | 0.24ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0; | 0.24ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 1) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 20) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 108) LIMIT 1 OFFSET 0; | 0.23ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 7.17ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.77ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.71ms | INSERT INTO "regulation"("filehash","filehash_count","source_year","source_title","source_topic","accessed_date","source_url","page_count","file_pages","pdf","source_subtopic","text_bytes","source_local_title","notes","source_id","review_state","normalise_check","file_uid","source_country","translation_status","filehash_dupe","normalised_filename","zero_length_pdf","file_languages","private") VALUES (NULL,NULL,'2026','Royal Decree No 679/2014: Regime For The Control Of Foreign Trade In Defense Materials, Other Materials, And Dual-Use Items And Technologies (Consolidated 2026-05-30)(Spanish)',3,'2026-08-12','https://www.boe.es/buscar/pdf/2014/BOE-A-2014-8926-consolidado.pdf',NULL,NULL,'regulation.pdf.bceea22714d16354.R01TRFMtSnVuIDI2LTU5LnBkZg==.pdf',9,NULL,'Real Decreto 679/2014, de 1 de agosto, por el que se aprueba el Reglamento de control del comercio exterior de material de defensa, de otro material y de productos y tecnologías de doble uso.',NULL,'GMSDS-Jun 26-59',NULL,NULL,NULL,105,NULL,'F',NULL,'F','||','F')RETURNING "id"; | 3.89ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.65ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.24ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.30ms | SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL); | 18.92ms | SELECT "regulation"."source_id", "regulation"."source_topic", "regulation"."source_subtopic", "regulation"."source_country", "regulation"."source_title", "regulation"."source_year", "regulation"."accessed_date", "regulation"."pdf", "regulation"."private", "regulation"."id" FROM "regulation" WHERE ("regulation"."id" IS NOT NULL) ORDER BY "regulation"."private", "regulation"."id" DESC, "regulation"."id" LIMIT 20 OFFSET 0; | 12.51ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0; | 0.37ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 49) LIMIT 1 OFFSET 0; | 0.22ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 51) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 60) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 52) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 25) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0; | 0.37ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 105) LIMIT 1 OFFSET 0; | 0.16ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0; | 1.16ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 82) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0; | 0.19ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 107) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 4) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 18) LIMIT 1 OFFSET 0; | 0.17ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0; | 0.22ms | SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0; | 0.20ms | SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 36) LIMIT 1 OFFSET 0; | 0.21ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 53) LIMIT 1 OFFSET 0; | 0.18ms | SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 5) LIMIT 1 OFFSET 0; | 0.20ms | INSERT INTO "search_hit"("hit_uri","search_uri","hit_timestamp","user_agent") VALUES ('https://chemreg.net/regulations/39-1_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2026-08-12 04:18:57','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36')RETURNING "id"; | 7.55ms | INSERT INTO "search_hit"("hit_uri","search_uri","hit_timestamp","user_agent") VALUES ('https://chemreg.net/regulations/14-11_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2026-08-12 04:19:01','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36')RETURNING "id"; | 0.41ms | INSERT INTO "search_hit"("hit_uri","search_uri","hit_timestamp","user_agent") VALUES ('https://chemreg.net/regulations/2-127_gmsds.pdf','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2026-08-12 04:19:22','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36')RETURNING "id"; | 0.68ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.99ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.54ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.63ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.64ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.24ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.32ms | PRAGMA foreign_keys=ON; | 0.51ms | SELECT 1; | 0.39ms | SELECT "wiki_page"."id", "wiki_page"."slug", "wiki_page"."title", "wiki_page"."body", "wiki_page"."tags", "wiki_page"."can_read", "wiki_page"."can_edit", "wiki_page"."changelog", "wiki_page"."html", "wiki_page"."render", "wiki_page"."is_active", "wiki_page"."created_on", "wiki_page"."created_by", "wiki_page"."modified_on", "wiki_page"."modified_by" FROM "wiki_page" WHERE ("wiki_page"."slug" = 'wiki-menu') LIMIT 1 OFFSET 0; | 0.92ms | SELECT "wiki_page"."id", "wiki_page"."slug", "wiki_page"."title", "wiki_page"."body", "wiki_page"."tags", "wiki_page"."can_read", "wiki_page"."can_edit", "wiki_page"."changelog", "wiki_page"."html", "wiki_page"."render", "wiki_page"."is_active", "wiki_page"."created_on", "wiki_page"."created_by", "wiki_page"."modified_on", "wiki_page"."modified_by" FROM "wiki_page" WHERE ("wiki_page"."slug" = 'index') LIMIT 1 OFFSET 0; | 0.10ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.81ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.24ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.92ms | INSERT INTO "regulation"("filehash","filehash_count","source_year","source_title","source_topic","accessed_date","source_url","page_count","file_pages","pdf","source_subtopic","text_bytes","source_local_title","notes","source_id","review_state","normalise_check","file_uid","source_country","translation_status","filehash_dupe","normalised_filename","zero_length_pdf","file_languages","private") VALUES (NULL,NULL,'2026','Regulation (EC) No 1272/2008: Classification, Labelling And Packaging Of Substances And Mixtures (Consolidated 2026-05-01)(English)',1,'2026-08-12','https://eur-lex.europa.eu/legal-content/EN/TXT/PDF/?uri=CELEX:02008R1272-20260501',NULL,NULL,'regulation.pdf.8b40b1321e6911af.R01TRFMtSnVuIDI2LTkzLnBkZg==.pdf',39,NULL,'Regulation (EC) No 1272/2008: Classification, Labelling And Packaging Of Substances And Mixtures (Consolidated 2026-05-01)(English)',NULL,'GMSDS-Jun 26-93',NULL,NULL,NULL,38,NULL,'F',NULL,'F','||','F')RETURNING "id"; | 1.07ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.64ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.22ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.37ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 1.23ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.30ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.41ms | INSERT INTO "regulation"("filehash","filehash_count","source_year","source_title","source_topic","accessed_date","source_url","page_count","file_pages","pdf","source_subtopic","text_bytes","source_local_title","notes","source_id","review_state","normalise_check","file_uid","source_country","translation_status","filehash_dupe","normalised_filename","zero_length_pdf","file_languages","private") VALUES (NULL,NULL,'2026','Regulation (EU) No 2022/2127: Granting A Union Authorisation For The Biocidal Product Family Ecolab UA BPF 1-Propanol In Accordance With Regulation (EU) No 528/2012 (Consolidated 2026-04-20)(English)',1,'2026-08-12','https://eur-lex.europa.eu/legal-content/EN/TXT/PDF/?uri=CELEX:02022R2127-20260420',NULL,NULL,'regulation.pdf.846b91bebffe8f95.R01TRFMtSnVuIDI2LTk2LnBkZg==.pdf',52,NULL,'Regulation (EU) No 2022/2127: Granting A Union Authorisation For The Biocidal Product Family Ecolab UA BPF 1-Propanol In Accordance With Regulation (EU) No 528/2012 (Consolidated 2026-04-20)(English)',NULL,'GMSDS-Jun 26-96',NULL,NULL,NULL,38,NULL,'F',NULL,'F','||','F')RETURNING "id"; | 0.97ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 0.90ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.54ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.57ms | INSERT INTO "regulation"("filehash","filehash_count","source_year","source_title","source_topic","accessed_date","source_url","page_count","file_pages","pdf","source_subtopic","text_bytes","source_local_title","notes","source_id","review_state","normalise_check","file_uid","source_country","translation_status","filehash_dupe","normalised_filename","zero_length_pdf","file_languages","private") VALUES (NULL,NULL,'2026','Regulation (EU) No 2021/1119: Establishing The Framework For Achieving Climate Neutrality (Consolidated 2026-04-07)(English)',2,'2026-08-12','https://eur-lex.europa.eu/legal-content/EN/TXT/PDF/?uri=CELEX:02021R1119-20260407',NULL,NULL,'regulation.pdf.b80ba2b9d501f89a.R01TRFMtSnVuIDI2LTk4LnBkZg==.pdf',15,NULL,'Regulation (EU) No 2021/1119: Establishing The Framework For Achieving Climate Neutrality (Consolidated 2026-04-07)(English)',NULL,'GMSDS-Jun 26-98',NULL,NULL,NULL,38,NULL,'F',NULL,'F','||','F')RETURNING "id"; | 1.24ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 1.00ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 0.50ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 0.44ms | INSERT INTO "regulation"("filehash","filehash_count","source_year","source_title","source_topic","accessed_date","source_url","page_count","file_pages","pdf","source_subtopic","text_bytes","source_local_title","notes","source_id","review_state","normalise_check","file_uid","source_country","translation_status","filehash_dupe","normalised_filename","zero_length_pdf","file_languages","private") VALUES (NULL,NULL,'2026','Government Decree No 112/2026/ND-CP: International Exchanges, Greenhouse Gas Emission Mitigation Results And Carbon Credits (Vietnamese)',2,'2026-08-12','https://datafiles.chinhphu.vn/cpp/files/vbpq/2026/4/112-ndcp.signed.pdf',NULL,NULL,'regulation.pdf.ae3336278122414a.R01TRFMtSnVuIDI2LTk5LnBkZg==.pdf',15,NULL,'Nghị định Chính phủ số 112/2026/ND-CP: Trao đổi quốc tế, kết quả giảm phát thải khí nhà kính và tín chỉ carbon',NULL,'GMSDS-Jun 26-99',NULL,NULL,NULL,128,NULL,'F',NULL,'F','||','F')RETURNING "id"; | 0.80ms |
|
