flaggedrevs promote

SQL

USE trwiki_p;
set @v1 = "uniqueContentPages";
select substr(frp_user_params from INSTR(frp_user_params,"reverted")+14) as revE
,substr(frp_user_params,length(v1)+1, INSTR(frp_user_params,"total")-length(v1)) 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...
