JAllemandou added a comment.
Results look correct to me with that query:
SELECT
agent_type,
count(1) as count
FROM
webrequest
WHERE
year = 2016
AND month = 5
AND day = 10
AND uri_host LIKE "%wikidata.org"
AND is_pageview
AND pageview_info['page_title'] = "Special:RecentChangesLinked"
GROUP BY agent_type
ORDER BY count
LIMIT 999999;
----------------------------------------------
agent_type count
spider 72
user 91328
What has changed:
- include wikidata.org as well as www.wikidata.org
- filter for pageview only (instead of all requests)
- filter pageview title instead of uri (there are multiple ways to query the
same page with mediawiki).
TASK DETAIL
https://phabricator.wikimedia.org/T135164
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: JAllemandou
Cc: Lydia_Pintscher, JAllemandou, Aklapper, madhuvishy, Addshore, Zppix,
D3r1ck01, Izno, Wikidata-bugs, aude, Mbch331, jeremyb
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
