wikipedia_pvs.sql
Ironholds (Oliver Keyes)
Actions

Authored By

	Ironholds
	Mar 6 2015, 5:02 PM

Size

453 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,
	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;

File Metadata

Mime Type: text/plain
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 54732
Default Alt Text: wikipedia_pvs.sql (453 B)

Event Timeline