Skip to content

Instantly share code, notes, and snippets.

@rviscomi

rviscomi/http-archive-spf.sql

Created May 11, 2017 15:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rviscomi/fea9332656a29cbd84985837458749dc to your computer and use it in GitHub Desktop.
Save rviscomi/fea9332656a29cbd84985837458749dc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
http-archive-spf.sql
SELECT pages.rank AS rank, libs.url AS url FROM
(SELECT url FROM httparchive:scratchspace.2017_04_15_js_libs WHERE lib.name = 'SPF') AS libs JOIN
(SELECT url, rank FROM httparchive:runs.latest_pages) AS pages ON pages.url = libs.url
ORDER BY
rank ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment