Tewiki:Ennikalu 2024 user-wise Page creation count

Fork of Tewiki:Ennikalu 2024 user-wise Page creation count by Chaduvari

This query is marked as a draft This query has been published by Divya4232.

SQL

USE tewiki_p;
SELECT actor_name వాడుకరిపేరు, count(actor_name) పేజీల_సంఖ్య, sum(p1.page_len) మొత్తం_బైట్లు
FROM page p1, page p2,revision,actor
where p2.page_title=p1.page_title
and p2.page_namespace=1
and p1.page_namespace=0

and p2.page_id IN (
  SELECT cl_from
  FROM categorylinks
  WHERE cl_to = 'ఎన్నికలు_2024_ప్రాజెక్టులో_భాగంగా_సృష్టించిన_పేజీలు'
)
  and rev_page=p1.page_id
  and rev_parent_id=0
  and actor_id=rev_actor
--  and rev_timestamp>=20230700000000
group by actor_name
order by count(actor_name) desc

SQL

Checking query status...