ChrisJr404 292032eef4 fix(crtsh): drop unused certificate metadata from SQL query (#1773) (#1787) ...

The Postgres query inherited the verbatim form crt.sh's web UI uses to
render its certificate browser. subfinder consumes NAME_VALUE only, so
GROUP BY sub.CERTIFICATE on multi-KB DER blobs, the four x509_*
function calls per group, the correlated LEFT JOIN LATERAL into
ct_log_entry, and the trailing ORDER BY ENTRY_TIMESTAMP are all
discarded.

Replacing the WITH/JOIN with a direct DISTINCT NAME_VALUE preserves the
result set (verified parity on iana.org: 24 unique names from both
queries) and lets the LIMIT 10000 clause bound unique subdomains
instead of raw certificate rows. The downstream SplitSeq + Extractor
path is unchanged.

Co-authored-by: Chris (ChrisJr404) <11917633+ChrisJr404@users.noreply.github.com>

2026-06-16 15:29:27 +02:00

..

sources

fix(crtsh): drop unused certificate metadata from SQL query (#1773) (#1787)

2026-06-16 15:29:27 +02:00

agent.go

fix timeout flag not working for crtsh source

2026-02-02 18:13:11 +03:00

doc.go

refactor: move v2 module code to root directory for cleaner structure

2025-07-10 15:27:42 +02:00

extractor.go

refactor: move v2 module code to root directory for cleaner structure

2025-07-10 15:27:42 +02:00

types.go

fix(ratelimit): honour -rl global fallback and -rls duration (#1434)

2026-03-10 09:47:09 -07:00

utils.go

refactor: move v2 module code to root directory for cleaner structure

2025-07-10 15:27:42 +02:00