Manuel added a comment.
fyi @Michael wrote this query as a starting point, but had difficulties to
run it using Superset:
SELECT
user_agent, COUNT(*) AS count
from wmf.webrequest
WHERE uri_host = 'www.wikidata.org'
AND webrequest_source = 'text'
AND uri_query LIKE '%wbsearchentities%'
AND NOT agent_type = 'spider'
LIMIT 100
GROUP BY user_agent
ORDER BY count DESC
TASK DETAIL
https://phabricator.wikimedia.org/T342256
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Manuel
Cc: Aklapper, Arian_Bozorg, Manuel, Michael, Astuthiodit_1, karapayneWMDE,
Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, Gq86,
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS,
Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
