SELECT
  count(*) as count, userAgent
FROM wmf_raw.apiaction 
WHERE wiki = "wikidatawiki"
AND array_contains(map_keys(params),'action')
AND params["action"] = "wbeditentity"
AND array_contains(map_keys(params),'clear')
AND year = 2017
AND month = 7
GROUP BY userAgent
ORDER BY count
LIMIT 999999;