Files F69952505

cope with both variable length uri_path (might or might not have /archive/ in) and that size may be NNNpx or prefix-NNNpx
No One
Actions

Authored By

	MatthewVernon
	Nov 6 2025, 11:25 AM

Size

342 B

Referenced Files

None

Subscribers

None

cope with both variable length uri_path (might or might not have /archive/ in) and that size may be NNNpx or prefix-NNNpx
View Options

	select slice(split(split(slice(split(uri_path, '/'),-1,1)[0], 'px-')[0],'-'),-1,1)[0] as thumbsize, count(*) as hits from wmf.webrequest where webrequest_source = 'upload' and year = 2025 and month = 10 and day = 24 and hour = 10 and http_status = '200' and uri_path like '/wikipedia/%/thumb/%' group by thumbsize order by hits desc limit 10;

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 22217833
Default Alt Text: cope with both variable length uri_path (might or might not have /archive/ in) and that size may be NNNpx or prefix-NNNpx (342 B)

Event Timeline