Paste P7867

Number of MediaWiki action API requests that use MobileFrontend's parse module extension
ActivePublic

Authored by phuedx on Thu, Nov 29, 11:08 AM.
+------------+---------+-------------+
| 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'
;
phuedx created this paste.Thu, Nov 29, 11:08 AM
phuedx edited the content of this paste. (Show Details)Thu, Nov 29, 11:12 AM
phuedx changed the title of this paste from The number of "Action API" requests that use MobileFrontend's parse API extensions to The number of MediaWiki action API requests that use MobileFrontend's parse API extension.Fri, Nov 30, 11:56 AM
phuedx changed the title of this paste from The number of MediaWiki action API requests that use MobileFrontend's parse API extension to Number of MediaWiki action API requests that use MobileFrontend's parse module extension.Fri, Nov 30, 1:33 PM
phuedx edited the content of this paste. (Show Details)