SQL
AخA
USE tewiki_p;
select substr(rev_timestamp,1,8) as dated, count(substr(rev_timestamp,1,8)) as Mainspace_new_pages
from page,revision,actor
where page_id=rev_page
and actor_id=rev_actor
and substr(rev_timestamp,1,4) in ("2024")
and page_namespace=0
and rev_parent_id=0
and page_is_redirect=0
-- and actor_name="Chaduvari"
group by substr(rev_timestamp,1,8)
order by substr(rev_timestamp,1,8)
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.