andydavies/gist:3cdcca42bd9f4289424c

## gistfile1.txt
select pages.url, pages.rank, req.url
from [httparchive:runs.latest_requests] as req
join (
  select url, rank, pageid, reqFont from [httparchive:runs.latest_pages]
) as pages on pages.pageid = req.pageid
where lower(req.mimetype) contains "font"
and pages.rank <= 100 and pages.reqFont > 0
order by pages.rank
	select pages.url, pages.rank, req.url
	from [httparchive:runs.latest_requests] as req
	join (
	select url, rank, pageid, reqFont from [httparchive:runs.latest_pages]
	) as pages on pages.pageid = req.pageid
	where lower(req.mimetype) contains "font"
	and pages.rank <= 100 and pages.reqFont > 0
	order by pages.rank