Addshore added a comment. I have reduced the above query to only show what we want to look at:
SELECT CONCAT(LPAD(year, 4 ,0), '-', LPAD(month, 2, 0), '-', LPAD(day, 2, 0)) as day, regexp_extract(uri_path, '^/wiki/Special:EntityData/.+(\\..+)$', 1) AS format, agent_type, COUNT(1) as count FROM wmf.webrequest WHERE webrequest_source = 'text' AND year = 2015 AND month = 12 AND day = 22 AND http_status = 200 AND normalized_host.project_class = 'wikidata' AND uri_path rlike '^/wiki/Special:EntityData/.*$' GROUP BY year, month, day, agent_type, regexp_extract(uri_path, '^/wiki/Special:EntityData/.+(\\..+)$', 1) ORDER BY day, format, agent_type LIMIT 100000; TASK DETAIL https://phabricator.wikimedia.org/T64874 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: Nuria, JAllemandou, Halfak, hoo, Addshore, Ricordisamoa, Aklapper, drdee, Tnegrin, QChris, ezachte, Lydia_Pintscher, daniel, Wikidata-bugs, aude, Mbch331 _______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs