Ores goodfaith scores for reverted edits

SQL

USE fiwiki_p;
SELECT 
 	rc_timestamp, 
    rc_title, 
    rc_this_oldid as rev_id, 
    rc_user_text, 
    oresm_name, 
    oresc_probability, 
    concat("https://fi.wikipedia.org/w/index.php?diff=prev&oldid=", rc_this_oldid) as url
 FROM (
   SELECT 
   		r1.rev_page, 
   		r1.rev_id AS max_rev_id, 
   		MAX(r2.rev_id) AS min_rev_id, 
   		rc_user_text AS reverter 
   FROM 
   		change_tag, 
   		change_tag_def, 
   		recentchanges, 
   		revision AS r1, 
   		revision AS r2 
   WHERE 
   		rc_this_oldid=r1.rev_id 
   		AND r1.rev_page=r2.rev_page 
   		AND r1.rev_timestamp > r2.rev_timestamp 
   		AND r1.rev_sha1=r2.rev_sha1 
   		AND ct_rc_id=rc_id 
   		AND ct_tag_id=ctd_id 
   		AND ctd_name IN ("mw-rollback", "mw-undo") 
   		AND rc_source="mw.edit" 
   		AND rc_namespace=0 
   GROUP BY r1.rev_sha1
 ) AS reverts, 
 recentchanges 
 LEFT JOIN ipblocks ON rc_user_text=ipb_address, 
 ores_model, 
 ores_classification,
 change_tag, 
 change_tag_def 
WHERE 
	rc_cur_id = rev_page 
    AND rc_this_oldid > min_rev_id 
    AND rc_this_oldid < max_rev_id 
    AND rc_source="mw.edit" 
    AND ct_rc_id=rc_id 
   	AND ct_tag_id=ctd_id    
   	AND ctd_name IN ("seulottavat") 
    AND  oresc_model=oresm_id 
    AND oresc_rev=rc_this_oldid 
    AND oresm_name="goodfaith" 
    AND rc_user_text!=reverter 
    AND ipb_address IS NOT NULL
SQL

Checking query status...
