Paste P7888

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

Authored by phuedx on Wed, Dec 5, 3:19 PM.
+------------+----------+----------------+----------+----------------------+
| 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
;
phuedx created this paste.Wed, Dec 5, 3:19 PM