AndrewTavis_WMDE added a comment.
The following is running for me, and I can report the results, but please let
me know if there are other changes that should be made like a larger `LIMIT`,
etc:
SELECT
user_agent AS user_agent,
COUNT(*) AS count
FROM
wmf.webrequest
WHERE
year = 2023
AND month = 6
AND webrequest_source = 'text'
AND uri_host = 'www.wikidata.org'
AND NOT agent_type = 'user'
AND uri_query LIKE '%wbsearchentities%'
GROUP BY
user_agent
ORDER BY
count DESC
LIMIT
100
TASK DETAIL
https://phabricator.wikimedia.org/T342256
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: AndrewTavis_WMDE
Cc: AndrewTavis_WMDE, 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]
