FlaggedRevs editor autopromote

SQL

use dewiki_p;

select 
	frp_user_id, 
    -- frp_editComments
    IF (frp_user_params LIKE "%editComments%", regexp_replace(replace(concat(frp_user_params, ";"), "\n", ";"), ".*?editComments=(.*?);.*$", "\\1"), 0) as frp_editComments,
    -- frp_uniqueContentPages
    IF (frp_user_params LIKE "%uniqueContentPages%", (1+length(regexp_replace(replace(concat(frp_user_params, ";"), "\n", ";"), ".*?uniqueContentPages=(.*?);.*$", "\\1")) - length(replace(regexp_replace(replace(concat(frp_user_params, ";"), "\n", ";"), ".*?uniqueContentPages=(.*?);.*$", "\\1"), ",", ""))), 0) as frp_uniqueContentPages, 
	-- frp_totalContentEdits
	IF (frp_user_params LIKE "%totalContentEdits%", regexp_replace(replace(concat(frp_user_params, ";"), "\n", ";"), ".*?totalContentEdits=(.*?);.*$", "\\1"), 0) as frp_totalContentEdits,
	-- frp_reviewedEdits
	IF (frp_user_params LIKE "%reviewedEdits%", regexp_replace(replace(concat(frp_user_params, ";"), "\n", ";"), ".*?reviewedEdits=(.*?);.*$", "\\1"), 0) as frp_reviewedEdits,
	-- frp_revertedEdits
	IF (frp_user_params LIKE "%revertedEdits%", regexp_replace(replace(concat(frp_user_params, ";"), "\n", ";"), ".*?revertedEdits=(.*?);.*$", "\\1"), 0) as frp_revertedEdits,
    -- frp_emoted
    IF (frp_user_params LIKE "%demoted%", regexp_replace(replace(concat(frp_user_params, ";"), "\n", ";"), ".*?demoted=(.*?);.*$", "\\1"), 0) as frp_demoted    
from 
	flaggedrevs_promote 
limit 10
SQL

Checking query status...
