Number of MediaWiki action API requests that use the mobileview module and the noimages parameter
ActivePublic
Actions

Authored by phuedx on Dec 5 2018, 3:19 PM.

Tags

Referenced Files

	F27391943: Number of MediaWiki action API requests that use the mobileview module and the noimages parameter
	Dec 5 2018, 3:19 PM

Subscribers

None

	+------------+----------+----------------+----------+----------------------+
	\| n \| n_mv \| pct_n_mv_of_n \| n_mv_ni \| pct_n_mv_ni_of_n_mv \|
	+------------+----------+----------------+----------+----------------------+
	\| 656646289 \| 4765948 \| 0.7258 \| 181993 \| 3.8186 \|
	+------------+----------+----------------+----------+----------------------+

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

Number of MediaWiki action API requests that use the mobileview module and the noimages parameterActivePublicActions