Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F57059
wikipedia_pvs.sql
Ironholds (Oliver Keyes)
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
Ironholds
Mar 6 2015, 5:19 PM
2015-03-06 17:19:04 (UTC+0)
Size
492 B
Referenced Files
None
Subscribers
None
wikipedia_pvs.sql
View Options
USE
wmf
;
SELECT
day
,
hour
,
parse_url
(
referer
,
'HOST'
)
AS
ref
,
uri_path
,
uri_query
,
geocoded_data
[
'country'
]
AS
country_name
,
user_agent
,
webrequest_source
,
COUNT
(
*
)
AS
pageviews
FROM
webrequest
WHERE
year
=
2015
AND
month
=
03
AND
day
BETWEEN
01
AND
06
AND
http_status
IN
(
304
,
200
)
AND
uri_host
=
'www.wikipedia.org'
AND
content_type
LIKE
(
'text/html%'
)
GROUP
BY
day
,
hour
,
parse_url
(
referer
,
'HOST'
),
uri_path
,
uri_query
,
geocoded_data
[
'country'
],
user_agent
,
webrequest_source
;
File Metadata
Details
Attached
Mime Type
text/plain
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
54745
Default Alt Text
wikipedia_pvs.sql (492 B)
Attached To
Mode
rPHAB4e12a375f3f4: Add JIRA as an authentication provider
Attached
Detach File
T90835: Investigate www.wikipedia.org traffic %
Attached
Detach File
Event Timeline
Log In to Comment