Abc10 talk page activity 1

SQL

SELECT t1.d as "year_month", t1.c as "abc10_talk_page_comments", t1.u as "abc10_talk_page_comment_users", t2.c as "user_jmk_abc10_talk_page_comments", t3.c as "user_jmk_edits" FROM
(select floor(rev_timestamp/100000000) as d, sum(1) as c, count(distinct(rev_user)) as u from revision_compat  where rev_page=733514 and rev_timestamp > 20220000000000 and rev_user_text NOT IN ("4shadowwBOT", "Ukbot", "Abc10") group by d) as t1
LEFT JOIN
(select floor(rev_timestamp/100000000) as d, sum(1) as c, count(distinct(rev_page)) as p  from revision_userindex, actor_revision, page where rev_page=733514 AND rev_actor=actor_id and actor_name="Jmk"  and rev_timestamp > 20220000000000 and rev_page=page_id group by d) as t2
ON t1.d=t2.d
LEFT JOIN
(select floor(rev_timestamp/100000000) as d, sum(1) as c, count(distinct(rev_page)) as p  from revision_userindex, actor_revision, page where rev_actor=actor_id and actor_name="Jmk"  and rev_timestamp > 20220000000000 and rev_page=page_id group by d) as t3
ON t1.d=t3.d
ORDER BY t1.d
SQL

Checking query status...
