Files F27464617

HQL for number of self-unblocks per wiki in 2018
No One
Actions

Authored By

	Tgr
	Dec 10 2018, 3:11 AM

Size

285 B

Referenced Files

None

Subscribers

None

HQL for number of self-unblocks per wiki in 2018
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')=2018
	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: 6799200
Default Alt Text: HQL for number of self-unblocks per wiki in 2018 (285 B)

Event Timeline