Top 10 pages exported to PDF (via the Electron-based render service)
No One
Actions

Authored By

	phuedx
	Nov 1 2017, 11:13 AM

Size

680 B

Referenced Files

None

Subscribers

None

Top 10 pages exported to PDF (via the Electron-based render service)
View Options

	!set outputformat table

	with titles as (
	select
	# "/api/rest_v1/page/pdf/".length + 1
	substr(uri_path, 23) as title
	from
	wmf.webrequest
	where
	year = M
	and month = N
	and day = O
	and hour >= P
	and hour < Q
	and webrequest_source = 'text'
	and uri_path like "/api/rest_v1/page/pdf%"
	and agent_type = "user"
	),
	grouped_titles as (
	select
	title,
	count(*) as n
	from titles
	group by title
	order by n desc

	# We limit here in order to minimize the performance impact of running the reflect UDF below.
	limit 10
	)

	select
	reflect("java.net.URLDecoder", "decode", title, "utf-8") as title,
	n
	from
	grouped_titles

	;

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 5055375
Default Alt Text: Top 10 pages exported to PDF (via the Electron-based render service) (680 B)