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

..

passive

feat: add shodanct passive source (#1796)

2026-06-16 15:24:59 +02:00

resolve

Add wildcard certificate detection in JSON output (#1665)

2025-11-05 21:49:07 +05:30

runner

feat: add shodanct passive source (#1796)

2026-06-16 15:24:59 +02:00

subscraping

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

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

testutils

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

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