use trwiki_p;

SELECT revision.rev_user, 

user.user_name, 

COUNT(revision.rev_user) 

AS cnt 

FROM page 

JOIN revision 

ON page.page_id=revision.rev_page 

JOIN user ON revision.rev_user=user.user_id 

WHERE page.page_namespace=0 

AND page.page_is_redirect=0 

AND page.page_id 

NOT IN (SELECT pp_page FROM page_props WHERE pp_propname='anlam ayrımı') 

AND revision.rev_parent_id=0 

GROUP BY revision.rev_user 

ORDER BY cnt 

DESC LIMIT 200;