Files F28329865

raw.txt
No One
Actions

Authored By

	dr0ptp4kt
	Mar 5 2019, 10:59 AM

Size

383 B

Referenced Files

None

Subscribers

None

raw.txt
View Options

	from (
	select
	year,
	month,
	day,
	referer_class,
	sum(view_count) over (partition by year, month, day, referer_class)
	/
	sum(view_count) over (partition by year, month, day) as ratio
	from
	projectview_hourly
	where year > 2016
	and project = 'id.wikipedia'
	and access_method = 'mobile web'
	and agent_type = 'user') t1
	select distinct *
	order by referer_class, year, month, day
	limit 20000
	;

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 7154524
Default Alt Text: raw.txt (383 B)

Event Timeline