Skip to content

Instantly share code, notes, and snippets.

@Fitblip

Fitblip/FlowersToTheWorld.sql

Created May 17, 2017 22:36
Show Gist options
  • Save Fitblip/12267aec541f8f87dd8573aa2bca3780 to your computer and use it in GitHub Desktop.
Save Fitblip/12267aec541f8f87dd8573aa2bca3780 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
FlowersToTheWorld.sql
SELECT
url,
COUNT(*) AS total_certs
FROM
[ctl-lists:certificate_data.scan_data]
WHERE
(REGEXP_MATCH(all_dns_names,r'.*flowers-to-the-world.*'))
GROUP BY
url
ORDER BY
total_certs DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment