Skip to content

Instantly share code, notes, and snippets.

@spjwebster

spjwebster/001_query.sql

Created November 22, 2011 21:48
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/1387110 to your computer and use it in GitHub Desktop.
Save spjwebster/1387110 to your computer and use it in GitHub Desktop.
Download ZIP
Analysis of jQuery code.jquery.com usage based on HTTP Archive stats
Raw
001_query.sql
SELECT url, COUNT(DISTINCT pageid) AS count
FROM requests
WHERE url LIKE 'https://code.jquery.com/jquery-%'
OR url LIKE 'http://code.jquery.com/jquery-%'
GROUP BY url
ORDER BY count DESC;
Raw
002_output.txt
+--------------------------------------------------------------+-------+
| url | count |
+--------------------------------------------------------------+-------+
| http://code.jquery.com/jquery-1.4.2.min.js | 67 |
| http://code.jquery.com/jquery-latest.js | 48 |
| http://code.jquery.com/jquery-1.4.4.min.js | 20 |
| http://code.jquery.com/jquery-latest.min.js | 14 |
| http://code.jquery.com/jquery-1.4.3.min.js | 10 |
| http://code.jquery.com/jquery-1.6.1.min.js | 10 |
| http://code.jquery.com/jquery-1.5.2.min.js | 8 |
| http://code.jquery.com/jquery-latest.pack.js | 8 |
| http://code.jquery.com/jquery-1.5.1.min.js | 6 |
| http://code.jquery.com/jquery-1.6.2.min.js | 6 |
| http://code.jquery.com/jquery-1.6.4.min.js | 6 |
| http://code.jquery.com/jquery-1.7.min.js | 6 |
| http://code.jquery.com/jquery-1.5.min.js | 5 |
| http://code.jquery.com/jquery-1.4.2.js | 4 |
| http://code.jquery.com/jquery-1.5.js | 3 |
| http://code.jquery.com/jquery-latest.min.js?ver=3.2.1 | 3 |
| http://code.jquery.com/jquery-1.6.1.js | 2 |
| http://code.jquery.com/jquery-1.3.1.min.js | 1 |
| http://code.jquery.com/jquery-1.3.2.min.js | 1 |
| http://code.jquery.com/jquery-1.4.1.min.js | 1 |
| http://code.jquery.com/jquery-1.4.4.js | 1 |
| http://code.jquery.com/jquery-1.4.4.min.js?ver=1.4 | 1 |
| http://code.jquery.com/jquery-1.6.1.min.js?35 | 1 |
| http://code.jquery.com/jquery-1.6.1.min.js?48 | 1 |
| http://code.jquery.com/jquery-1.6.2.js | 1 |
| http://code.jquery.com/jquery-1.6.4.js | 1 |
| http://code.jquery.com/jquery-1.6.js | 1 |
| http://code.jquery.com/jquery-ui-1.8.1.custom.min.js?ver=3.0 | 1 |
+--------------------------------------------------------------+-------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment