Tewiki: Articles where a user contributed +50%

SQL

USE tewiki_p;
select page_title,page_len,
	count(page_title) as Edit_count, 
    SUM(CAST(rev.rev_len as signed)-if(rev.rev_parent_id=0,0,CAST(parent.rev_len as signed))) AS User_net_contribution,
    ((SUM(CAST(rev.rev_len as signed)-if(rev.rev_parent_id=0,0,CAST(parent.rev_len as signed)))/page_len)*100) as percentage
FROM revision rev
left join actor ON actor_id = rev.rev_actor
left JOIN revision parent
ON parent.rev_id = rev.rev_parent_id
left JOIN page
ON page_id = rev.rev_page
WHERE page_namespace = 0
and page_id not in (select pp_page from page_props where pp_propname="disambiguation")
and page_is_redirect=0
-- and substr(rev.rev_timestamp,1,4)="2020"
AND actor_name ="Chaduvari"
group by page_title
having percentage<100 and percentage >=50
order by percentage desc
limit 5000
SQL

Checking query status...
