flaggedrevs promote

SQL

USE trwiki_p;
set @v1 = "uniqueContentPages";
set @v2 = "totalContentEdits";
set @v3 = "editComments";
set @vn = "revertedEdits";
set @p = "tr.wikipedia.org/wiki?curid=";
select  user_name, user_editcount 
, substr(frp_user_params from INSTR(frp_user_params,@vn)+length(@vn)+1 for 4) as revE
,replace(substr(frp_user_params,INSTR(frp_user_params,@v2)+length(@v2)+1, INSTR(frp_user_params,@v3)-length(@v2)-2-INSTR(frp_user_params,@v2)),",","/") as tCE
,replace(substr(frp_user_params,INSTR(frp_user_params,@v3)+length(@v3)+1, INSTR(frp_user_params,@vn)-length(@v3)-2-INSTR(frp_user_params,@v3)),",","/") as eC
, concat(@p,page_id) as url
, concat("https://tools.wmflabs.org/xtools-ec/?project=tr.wikipedia.org&uselang=en&user=",replace(user_name," ","_")) as urlxt
,concat(@p,replace(substr(frp_user_params,length(@v1)+2, INSTR(frp_user_params,@v2)-length(@v1)-2),",",concat(" ",@p))) as uCP
-- , frp_user_params
from flaggedrevs_promote join user on user_id = frp_user_id
left join page on page_title = user_name
where user_editcount > 10000 and user_name not like '%Bot' and user_name not like '%bot'
and page_namespace = 2
order by length(uCP)
-- , revE+0 asc
, user_editcount desc
-- limit 2
;
select * from user u where u.user_real_name is not null and length(u.user_real_name) > 0 limit 10;
SQL

Checking query status...
