Page MenuHomePhabricator
Authored By
Addshore
May 15 2019, 4:45 PM
Size
413 B
Referenced Files
None
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

File Metadata

Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
7457765
Default Alt Text
raw.txt (413 B)

Event Timeline