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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
