לדלג לתוכן

משתמש:Aviadhr/טיוטה

מתוך ויקיפדיה, האנציקלופדיה החופשית
select rev_user_text,  count(*) from revision_userindex inner join page on rev_page=page_id where page_namespace in (0,6,8,10,12,100, 108,828) and rev_user>0 and rev_timestamp >20181213000000 and not exists(select * from user where user_id=rev_user and user_registration>20190211000000) group by rev_user having count(*)>80 order by count(*) desc;