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" end 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...
