Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P8531
(An Untitled Masterwork)
Active
Public
Actions
Authored by
Addshore
on May 15 2019, 4:45 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F29057008: raw.txt
May 15 2019, 4:45 PM
2019-05-15 16:45:45 (UTC+0)
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
2019-05-15 16:45:45 (UTC+0)
Addshore
mentioned this in
T220826: Wikibase Special:EntityData has 2 parameters that do the same thing
.
May 15 2019, 5:12 PM
2019-05-15 17:12:45 (UTC+0)
Log In to Comment