Paste P7873

Number of MediaWiki action API requests that use the mobileview module with the mobileformat parameter
ActivePublic

Authored by phuedx on Fri, Nov 30, 1:33 PM.
+------------+----------+----------------+----------+-------------------+
| 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
;
phuedx created this paste.Fri, Nov 30, 1:33 PM
phuedx edited the content of this paste. (Show Details)Tue, Dec 4, 1:56 PM
phuedx changed the title of this paste from Number of MediaWiki action API requests that use the mobileview module to Number of MediaWiki action API requests that use the mobileview module and the noimages parameter.
phuedx changed the title of this paste from Number of MediaWiki action API requests that use the mobileview module and the noimages parameter to Number of MediaWiki action API requests that use the mobileview module with the noimages parameter.
phuedx changed the title of this paste from Number of MediaWiki action API requests that use the mobileview module with the noimages parameter to Number of MediaWiki action API requests that use the mobileview module with the mobileformat parameter.Wed, Dec 5, 2:59 PM