Number of MediaWiki action API requests that use the mobileview module
No One
Actions

Authored By

	phuedx
	Dec 4 2018, 1:56 PM

Size

903 B

Referenced Files

None

Subscribers

None

Number of MediaWiki action API requests that use the mobileview module
View Options

	+------------+----------+----------------+----------+-------------------+
	\| n \| n_mv \| pct_n_mv_of_n \| n_mv_mf \| pct_n_mv_of_n_mv \|
	+------------+----------+----------------+----------+-------------------+
	\| 656646289 \| 4765973 \| 0.7258 \| 6627 \| 0.139 \|
	+------------+----------+----------------+----------+-------------------+

	select
	n as n,
	n_mv as n_mv,
	round(100 * n_mv / n, 4) as pct_n_mv_of_n,
	n_mv_mf as n_mv_mf,
	round(100 * n_mv_mf / n_mv, 4) as pct_n_mv_of_n_mv
	from (
	select
	count(*) as n,
	count(if(uri_query like '%mobileview%', 1, null)) as n_mv,
	count(if(uri_query like '%mobileview%' and uri_query like '%mobileformat%', 1, null)) as n_mv_mf
	from
	wmf.webrequest
	where
	year = 2018
	and month = 11
	and day = 28
	and uri_path = '/w/api.php'
	) as numbers
	;

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 6768167
Default Alt Text: Number of MediaWiki action API requests that use the mobileview module (903 B)