Skip to content

Instantly share code, notes, and snippets.

@eeeps
Last active Oct 23, 2015
Embed
What would you like to do?
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