# 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`

    , tag.afa_consequence AS `tag`, tag.afa_parameters AS `tag_parm`

    , block.afa_consequence AS `block`, block.afa_parameters AS `block_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'

LEFT JOIn abuse_filter_action AS tag ON tag.afa_filter = af_id AND tag.afa_consequence = 'tag'

LEFT JOIn abuse_filter_action AS block ON block.afa_filter = af_id AND block.afa_consequence = 'block'