INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES ('https://chemreg.net/regulations/gmsds-feb20-993.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 01:58:36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES ('https://chemreg.net/regulations/17-65_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 01:58:38','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES ('https://chemreg.net/regulations/22-220_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 01:59:14','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=20')RETURNING "id";

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES ('https://chemreg.net/regulations/2-22_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 01:59:17','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=20')RETURNING "id";

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES ('https://chemreg.net/regulations/22-21_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 01:59:38','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=20')RETURNING "id";

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES ('https://chemreg.net/regulations/30-87_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 01:59:43','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES ('https://chemreg.net/regulations/2-11_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 01:59:44','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES (NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 06:13:28',NULL)RETURNING "id";

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES (NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 06:13:28',NULL)RETURNING "id";

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES ('https://chemreg.net/regulations/14-11_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 06:13:28','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES ('https://chemreg.net/regulations/2-123_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 06:13:30','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";

SELECT "relay_log"."id", "relay_log"."normalised_filename", "relay_log"."file_uid", "relay_log"."process_status", "regulation"."id", "relay_log"."posted", "relay_log"."post_status_code", "relay_log"."first_seen", "relay_log"."last_seen", "relay_log"."plone_created", "relay_log"."plone_first_modified", "relay_log"."metadata_updated", "relay_log"."metadata_status_code", "relay_log"."pages_processed", "relay_log"."page_count", "relay_log"."html_conversion", "relay_log"."html_conversion_returncode", "relay_log"."html_ping_code", "relay_log"."published" FROM "relay_log", "regulation" WHERE ("relay_log"."regulation_id" = "regulation"."id") ORDER BY "relay_log"."id" DESC;

SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic";

SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic";

SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country";

SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL);

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;

SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0;

SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 52) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 77) LIMIT 1 OFFSET 0;

SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0;

SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 128) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 80) LIMIT 1 OFFSET 0;

SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 40) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 50) LIMIT 1 OFFSET 0;

SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 11) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 63) LIMIT 1 OFFSET 0;

SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 5) LIMIT 1 OFFSET 0;

SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 24) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 101) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 115) LIMIT 1 OFFSET 0;

SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0;

SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 19) LIMIT 1 OFFSET 0;

SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0;

SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 36) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 7) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 209) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 85) LIMIT 1 OFFSET 0;

SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 25) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 21) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 71) LIMIT 1 OFFSET 0;

SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 26) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 136) LIMIT 1 OFFSET 0;

SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 55) LIMIT 1 OFFSET 0;

SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0;

SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 10) LIMIT 1 OFFSET 0;

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES (NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 08:31:33',NULL)RETURNING "id";

INSERT INTO "search_hit"("hit_uri","user_agent","hit_timestamp","search_uri") VALUES ('https://chemreg.net/regulations/2-123_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','2025-05-27 08:31:35','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";

SELECT "regulation"."id", "regulation"."source_id", "regulation"."file_uid", "regulation"."pdf", "relay_log"."id" FROM "regulation" LEFT JOIN "relay_log" ON ("regulation"."id" = "relay_log"."regulation_id") WHERE (("regulation"."id" > 0) AND ("regulation"."pdf" IS NOT NULL)) ORDER BY "regulation"."id" DESC;

SELECT "account"."account", "account"."id" FROM "account" WHERE ("account"."id" IS NOT NULL) ORDER BY "account"."account", "account"."id";

SELECT "auth_user"."id", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."password", "auth_user"."registration_key", "auth_user"."reset_password_key", "auth_user"."registration_id" FROM "auth_user" WHERE ("auth_user"."email" = 'phil@xfr.co.uk') LIMIT 1 OFFSET 0;

SELECT "auth_membership"."id", "auth_membership"."user_id", "auth_membership"."group_id" FROM "auth_membership" WHERE ("auth_membership"."user_id" = 2);

SELECT "auth_group"."id", "auth_group"."role", "auth_group"."description" FROM "auth_group" WHERE ("auth_group"."id" = 11) LIMIT 1 OFFSET 0;

SELECT "auth_user"."id", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."password", "auth_user"."registration_key", "auth_user"."reset_password_key", "auth_user"."registration_id" FROM "auth_user" WHERE ("auth_user"."id" = 2) LIMIT 1 OFFSET 0;

INSERT INTO "auth_event"("description","user_id","origin","time_stamp","client_ip") VALUES ('User 2 Logged-in',2,'auth','2025-05-27 13:35:12','81.111.225.26')RETURNING "id";

SELECT "regulation"."id", "regulation"."source_id", "regulation"."file_uid", "regulation"."pdf", "relay_log"."id" FROM "regulation" LEFT JOIN "relay_log" ON ("regulation"."id" = "relay_log"."regulation_id") WHERE (("regulation"."id" > 0) AND ("regulation"."pdf" IS NOT NULL)) ORDER BY "regulation"."id" DESC;