Files F27464691

HQL for number of self-unblocks per wiki in a given year
No One
Actions

Authored By

	Tgr
	Dec 10 2018, 3:17 AM

Size

287 B

Referenced Files

None

Subscribers

None

HQL for number of self-unblocks per wiki in a given year
View Options

	SELECT
	wiki_db,
	COUNT(*) cnt
	FROM
	mediawiki_history
	WHERE
	snapshot='2018-11'
	AND event_entity='user'
	AND event_type='alterblocks'
	AND event_user_text=user_text
	AND date_format(event_timestamp, 'yyyy')=<year>
	GROUP BY wiki_db
	ORDER BY cnt DESC
	LIMIT 1000;

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 6799236
Default Alt Text: HQL for number of self-unblocks per wiki in a given year (287 B)

Event Timeline