(An Untitled Masterwork)
ActivePublic
Actions

Authored by Addshore on May 14 2019, 5:29 PM.

Tags

None

Referenced Files

	F29052137: raw.txt
	May 14 2019, 5:29 PM

Subscribers

None

	SELECT
	IF( uri_query RLIKE 'revision=', 'revision', IF( uri_query RLIKE 'oldid=', 'oldid', 'none' )),
	COUNT(*) AS requests
	FROM wmf.webrequest
	WHERE uri_host = 'www.wikidata.org'
	AND year = 2019
	AND month = 05
	AND day = 05
	AND uri_path RLIKE '^/wiki/Special:EntityData'
	GROUP BY
	IF( uri_query RLIKE 'revision=', 'revision', IF( uri_query RLIKE 'oldid=', 'oldid', 'none' ))
	ORDER BY requests DESC
	LIMIT 9999

(An Untitled Masterwork)ActivePublicActions