Alexey Migutsky mr-mig

🐒

🍌 🔨 🖥

Me 🔨 codez

mr-mig / Top CDNs Serving JS Libs.sql

Last active August 29, 2015 13:57

Top CDNs Serving JS libs - Mar 1 2014, httparchive

	select "Google"as name, count(distinct(pageid)) as count,
	(100*count(distinct(pageid))/78160) as percent
	from requests where pageid >= 14489007 and pageid <= 14802750
	and url LIKE "%//ajax.googleapis.com/ajax/libs/%"
	UNION
	select "Yandex" as name, count(distinct(pageid)) as count,
	(100*count(distinct(pageid))/78160) as percent
	from requests where pageid >= 14489007 and pageid <= 14802750
	and url LIKE "%//yandex.st/%"
	UNION

mr-mig / Most Popular jQuery versions from Google CDN.sql

Last active August 29, 2015 13:57

SQL for Most popular jQuery versions from Google CDN - Mar 1 2014, httparchive.org

	select SUBSTRING(
	url FROM POSITION("/libs/jquery/" IN url) + 13
	FOR
	LOCATE("/jquery", url, POSITION("/libs/jquery/" IN url) + 13) - (POSITION("/libs/jquery/" IN url) + 13)
	) as version,
	count(distinct(pageid)) as count,
	(100*count(distinct(pageid))/59977) as percent
	from requests where pageid >= 14489007 and pageid <= 14802750
	and url LIKE "%//ajax.googleapis.com/ajax/libs/jquery/%.min.js"
	group by version order by count desc;

mr-mig / Number Of Sites Using jQuery From Google CDN.sql

Last active August 29, 2015 13:57

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/%"

mr-mig / gist:5695199

Created June 2, 2013 22:36

test gist