Skip to content

Instantly share code, notes, and snippets.

@mr-mig

mr-mig/Total Number Of Sites Using CDNs.sql

Created March 9, 2014 16:16
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 mr-mig/9450125 to your computer and use it in GitHub Desktop.
Save mr-mig/9450125 to your computer and use it in GitHub Desktop.
Download ZIP
SQL for Total number of sites using known CDNs, Mar 1 2014, httparchive
Raw
Total Number Of Sites Using CDNs.sql
select "Total Sites" as label,
count(distinct(pageid)) as count,
(100*count(distinct(pageid))/290835) as percent
from requests where pageid >= 14489007 and pageid <= 14802750
and url LIKE "%//ajax.googleapis.com/ajax/libs/%"
or url LIKE "%//yandex.st/%"
or url LIKE "%//ajax.aspnetcdn.com/ajax/%"
or url LIKE "%//cdn.jsdelivr.net/%"
or url LIKE "%//cdnjs.cloudflare.com/ajax/libs/%"
or url LIKE "%//code.jquery.com/%";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment