Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P7888
Number of MediaWiki action API requests that use the mobileview module and the noimages parameter
Active
Public
Actions
Authored by
phuedx
on Dec 5 2018, 3:19 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
MobileFrontend
Referenced Files
F27391943: Number of MediaWiki action API requests that use the mobileview module and the noimages parameter
Dec 5 2018, 3:19 PM
2018-12-05 15:19:40 (UTC+0)
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
;
Event Timeline
phuedx
created this paste.
Dec 5 2018, 3:19 PM
2018-12-05 15:19:40 (UTC+0)
Log In to Comment