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,
    user_editcount,
    datediff(now(), str_to_date(user_registration, "%Y%m%d%H%i%S")) as days_since_registration
FROM 
	flaggedrevs_promote,
    user
    LEFT JOIN (SELECT ufg_user FROM user_former_groups WHERE ufg_group="autoreview") as ufg ON ufg_user=user_id 
    LEFT JOIN (SELECT ug_user FROM user_groups WHERE ug_group="autoreview") as ug ON ug_user=user_id 
WHERE
    frp_user_id = user_id 
	AND ufg_user IS NULL
    AND ug_user IS NULL
    AND user_editcount > 300
    AND user_registration IS NOT NULL
LIMIT 1000
SQL

Checking query status...
