The number of "Action API" requests that use MobileFrontend's parse API extensions
No One
Actions

Authored By

	phuedx
	Nov 29 2018, 11:12 AM

Size

692 B

Referenced Files

None

Subscribers

None

The number of "Action API" requests that use MobileFrontend's parse API extensions
View Options

	+------------+---------+-------------+
	\| n \| n_mfmt \| n_mfmt_pct \|
	+------------+---------+-------------+
	\| 656646289 \| 619970 \| 0.0944 \|
	+------------+---------+-------------+



	select
	sum(1) as n,

	# Testing for %mobileformat% catches
	#
	# ?action=parse...&mobileformat&...
	# ?action=parse...&mobileformat=...&...
	#
	# The presence of the mobileformat parameter implies the presence of action=parse.
	sum(if(uri_query like '%mobileformat%', 1, 0)) as n_mfmt,

	round(100 * sum(if(uri_query like '%mobileformat%', 1, 0)) / sum(1), 4) as n_mfmt_pct
	from
	wmf.webrequest
	where
	year = 2018
	and month = 11
	and day = 28

	and uri_path = '/w/api.php'
	;

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 6742144
Default Alt Text: The number of "Action API" requests that use MobileFrontend's parse API extensions (692 B)