Michael added a comment.
In T342256#9028484 <https://phabricator.wikimedia.org/T342256#9028484>, @AndrewTavis_WMDE wrote: > 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 I think the limit is already large enough. I'm not sure by what is covered in `NOT agent_type = 'user'` vs. `agent_type = 'spider'`. TASK DETAIL https://phabricator.wikimedia.org/T342256 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Michael 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]
