SQL
AخA
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 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.