zhwiki: abusefilter actions

Fork of zhwiki: AbuseFilter::getConsequencesForFilters by Xiplus

This query is marked as a draft This query has been published by Xiplus.

SQL

# https://gerrit.wikimedia.org/g/mediawiki/extensions/AbuseFilter/+/389b6f3dc812a8c7b91827556abb98aa5f09f7e0/includes/AbuseFilter.php#556
USE zhwiki_p;
SELECT af_id
	, warn.afa_consequence AS `warn`, warn.afa_parameters AS `warn_parm`
	, disallow.afa_consequence AS `disallow`, disallow.afa_parameters AS `disallow_parm`
FROM abuse_filter
LEFT JOIn abuse_filter_action AS warn ON warn.afa_filter = af_id AND warn.afa_consequence = 'warn'
LEFT JOIn abuse_filter_action AS disallow ON disallow.afa_filter = af_id AND disallow.afa_consequence = 'disallow'

SQL

Checking query status...