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;