flaggedrevs promote

SQL

USE trwiki_p;
set @v1 = "uniqueContentPages";
set @v2 = "total";
select substr(frp_user_params from INSTR(frp_user_params,"reverted")+14) as revE
,replace(substr(frp_user_params,length(@v1)+2, INSTR(frp_user_params,@v2)-length(@v1)-2),",","/") as uCP
, user_id, user_name, user_editcount, concat("https://tools.wmflabs.org/xtools-ec/?project=tr.wikipedia.org&uselang=en&user=",replace(user_name," ","_")) as url
, frp_user_params
from flaggedrevs_promote join user on user_id = frp_user_id 
where user_editcount > 20000 and user_name not like '%Bot'
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...
