Skip to content

Instantly share code, notes, and snippets.

@mr-mig
Last active August 29, 2015 13:57
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/9447496 to your computer and use it in GitHub Desktop.
Save mr-mig/9447496 to your computer and use it in GitHub Desktop.
SQL for number of sites using jQuery from Google CDN - Mar 1 2014, httparchive
SELECT "jquery" AS name,
count(distinct(pageid)) AS count,
(100*count(distinct(pageid))/290835) AS percent
FROM requests WHERE pageid <= 14802750 AND pageid >= 14489007
AND url LIKE "%//ajax.googleapis.com/ajax/libs/jquery/%"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment