Paste P8531

(An Untitled Masterwork)
ActivePublic
Actions

Authored by Addshore on May 15 2019, 4:45 PM.

Tags

None

Referenced Files

	F29057008: raw.txt
	May 15 2019, 4:45 PM

Subscribers

None

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

Event Timeline

Addshore created this paste.May 15 2019, 4:45 PM

Addshore mentioned this in T220826: Wikibase Special:EntityData has 2 parameters that do the same thing.May 15 2019, 5:12 PM