Skip to content

Instantly share code, notes, and snippets.

@eeeps
Last active October 23, 2015 16:02
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 eeeps/2c28d79bf8d3aa612525 to your computer and use it in GitHub Desktop.
Save eeeps/2c28d79bf8d3aa612525 to your computer and use it in GitHub Desktop.
SELECT pages.rank, pages.pageid, pages.url
FROM [httparchive:runs.2013_11_15_pages] AS pages
JOIN (
SELECT pageid, url FROM [httparchive:runs.2013_11_15_requests]
WHERE REGEXP_MATCH(url, r'lazyload')
) AS reqs
ON reqs.pageid = pages.pageid
WHERE rank IS NOT NULL
GROUP BY pages.pageid, pages.rank, pages.url
ORDER BY pages.rank ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment