Skip to content

Instantly share code, notes, and snippets.

@mr-mig

mr-mig/Total Number Of Wordpress-powered Sites.sql

Created March 9, 2014 17:08
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/9450898 to your computer and use it in GitHub Desktop.
Save mr-mig/9450898 to your computer and use it in GitHub Desktop.
Download ZIP
Total number of Wordpress-powered sites - Mar 1 2014
Raw
Total Number Of Wordpress-powered Sites.sql
select count(distinct(pageid)) as count,
(100*count(distinct(pageid))/290835) as percent
from requests where pageid >= 14489007 and pageid <= 14802750
and url LIKE "%jquery-migrate%.js\\?ver=%"
or url LIKE "%jquery-migrate%.js\\?v=%";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment