Mensagem de cada filtro de edição

SQL

use ptwiki_p;

select 
	abuse_filter.af_id as "ID do filtro",
    abuse_filter.af_public_comments as "Descrição do filtro",
    Case
    abuse_filter_action.afa_consequence
    when "warn" then "Avisar" else "Impedir" as "Tipo",
    CASE
 	   abuse_filter_action.afa_parameters
 	   WHEN "" THEN 'abusefilter-disallowed'
	   ELSE abuse_filter_action.afa_parameters
	END as "Mensagem"
    from abuse_filter left join abuse_filter_action on abuse_filter_action.afa_filter = abuse_filter.af_id 
    where abuse_filter.af_enabled = true and (afa_consequence = "warn" or afa_consequence = "disallow");
SQL

Checking query status...
