Skip to content

Instantly share code, notes, and snippets.

@spjwebster

spjwebster/001_query.sql

Created November 20, 2011 22: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 spjwebster/1381005 to your computer and use it in GitHub Desktop.
Save spjwebster/1381005 to your computer and use it in GitHub Desktop.
Download ZIP
Analysis of jQuery googleapis.com usage based on HTTP Archive stats
Raw
001_query.sql
SELECT COUNT(DISTINCT pageid), URL
FROM requests
WHERE url LIKE 'https://ajax.googleapis.com/ajax/libs/jquery/%'
OR url LIKE 'http://ajax.googleapis.com/ajax/libs/jquery/%'
GROUP BY url
ORDER BY count DESC;
Raw
002_output.txt
+-------+----------------------------------------------------------------------------------------------------+
| count | url |
+-------+----------------------------------------------------------------------------------------------------+
| 945 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js |
| 460 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js |
| 285 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js |
| 270 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js |
| 247 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js |
| 231 | http://ajax.googleapis.com/ajax/libs/jquery/1.5.2/jquery.min.js |
| 192 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js |
| 173 | http://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js |
| 145 | http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js |
| 141 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js |
| 107 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js |
| 97 | http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js |
| 97 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js |
| 92 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.min.js |
| 85 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js |
| 83 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.3/jquery.min.js |
| 80 | http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js |
| 76 | https://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js |
| 68 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js |
| 63 | http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js |
| 58 | https://ajax.googleapis.com/ajax/libs/jquery/1.5.2/jquery.min.js |
| 51 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js?ver=3.2.1 |
| 46 | http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js |
| 42 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.1/jquery.min.js |
| 42 | http://ajax.googleapis.com/ajax/libs/jquery/1.6/jquery.min.js |
| 39 | https://ajax.googleapis.com/ajax/libs/jquery/1.6/jquery.min.js |
| 37 | http://ajax.googleapis.com/ajax/libs/jquery/1.7.0/jquery.min.js |
| 35 | https://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js |
| 34 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js?ver=1.4.4 |
| 33 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.3/jquery.min.js |
| 26 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.js |
| 26 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js?ver=1.4.2 |
| 25 | https://ajax.googleapis.com/ajax/libs/jquery/1.5.0/jquery.min.js |
| 22 | http://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.js |
| 21 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js?ver=1.3.2 |
| 20 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.3/jquery.min.js |
| 20 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js |
| 19 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.0/jquery.min.js |
| 18 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.js |
| 16 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.3/jquery.min.js |
| 15 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js |
| 14 | http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js?ver=3.2.1 |
| 13 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js?ver=1.4.4 |
| 13 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js?ver=MU |
| 13 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js?ver=1.6.1 |
| 13 | https://ajax.googleapis.com/ajax/libs/jquery/1.7.0/jquery.min.js |
| 12 | http://ajax.googleapis.com/ajax/libs/jquery/1.5.0/jquery.min.js |
| 12 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js?ver=MU |
| 12 | https://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js |
| 11 | https://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js |
| 11 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js?ver=1.6.1 |
| 10 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js?ver=3.2.1 |
| 10 | http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js?ver=3.2.1 |
| 10 | http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.js |
| 10 | https://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js |
| 8 | https://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js |
| 7 | http://ajax.googleapis.com/ajax/libs/jquery/1.5.2/jquery.min.js?ver=1.5.2 |
| 7 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js?ver=3.2.1 |
| 7 | http://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.min.js |
| 7 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.min.js |
| 6 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.js |
| 6 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js?ver=1.6.2 |
| 6 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.js |
| 5 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.js |
| 5 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.js |
| 5 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js?ver=3.2.1 |
| 4 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.js |
| 4 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.min.js?ver=3.2.1 |
| 4 | http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.js |
| 3 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.0/jquery.min.js |
| 3 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js?ver=3.2.1 |
| 3 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js?3.1.3 |
| 3 | http://ajax.googleapis.com/ajax/libs/jquery/1.6/jquery.min.js?ver=3.2.1 |
| 3 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.js |
| 3 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js?ver=3.2.1 |
| 3 | https://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.js |
| 3 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js?ver=3.1 |
| 3 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js?ver=1.6.4 |
| 3 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js?ver=3.2.1 |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.2.3/jquery.min.js |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.js |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js?ver=3.2.1 |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.0/jquery.min.js?ver=1.4.0 |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.3/jquery.js |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js?ver=3.2.1 |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.js |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js?ver=1.5.1 |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.5.2/jquery.js |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js?ver=1.5 |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js?ver=3.2.1 |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.js |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.js |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.6/jquery.min.js?ver=1.6 |
| 2 | http://ajax.googleapis.com/ajax/libs/jquery/1.6/jquery.min.js?ver=1.6.0 |
| 2 | https://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.js |
| 2 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.0/jquery.min.js |
| 2 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.js |
| 2 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js?ver=1.4.2 |
| 2 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.3/jquery.js |
| 2 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.js |
| 2 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js?ver=2.9.2 |
| 2 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js?ver=3.0.3 |
| 2 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js?ver=3.0.4 |
| 2 | https://ajax.googleapis.com/ajax/libs/jquery/1.6/jquery.js |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js?cver=3-0-0.354536628299817838 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.2/jquery.min.js |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.1/jquery.js |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.1/jquery.min.js?_=1321375013531 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.1/jquery.min.js?_=1321375643691 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.1/jquery.min.js?_=1321396181265 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js?1010121224 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js?r=2470 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js?ver=2.7.1 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.min.js?ver=3.1.4 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.min.js?ver=5704 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js?v=3e34e6c4dac7c92f085b4b803c88dfc3 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js?ver=1985 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.js?ver=1.4.4 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js?id=113191040 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js?ver=6.9.2.5243 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js?ver=3.0 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js?ver=3.0.5 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js?ver=3.2 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js?r=2456 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js?ver=3.2.1 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.5.2/jquery.min.js?ver=113 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js?ver=3.1.2 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js?ver=3.1.3 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js?ver=3.2.1 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js?15779 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js?5 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js? |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js?ver=1991 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js?ver=3.1.4 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.js?ver=3.2.1 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1.7.0/jquery.min.js?ver=3.2.1 |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js?ver=1.4+ |
| 1 | http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js?ver=3.1.3 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.2.3/jquery.min.js |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.3.0/jquery.min.js |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.3.1/jquery.min.js |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.3/jquery.min.js?v=1 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js?ver=3.0.1 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js?ver=3.1.3 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js?version=20101124 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js?ver=3.2.1 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.5.0/jquery.min.js?ver=3.1.2 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js?ver=1.3.2 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js?ver=3.2.1 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.5.2/jquery.js |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.5.2/jquery.min.js?ver=3.1.4 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js?ver=3.0 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js?ver=3.0.5 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js?ver=3.1.3 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js?ver=3.1.4 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js?v1 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js?ver=3.2.1 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.js |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.3/jquery.js |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.3/jquery.min.js?ver=3.2.1 |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.js |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.min.js |
| 1 | https://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js?cdv=214 |
+-------+----------------------------------------------------------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment