tewiki:Cricket 2023 user-wise Pages created

Fork of tewiki:Ennikalu 2024 user-wise articles created by Chaduvari

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

SQL

SELECT concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2)) సృష్టించిన_తేదీ, p1.page_title పేజీ_పేరు, p1.page_len పేజీ_పరిమాణం, actor_name వాడుకరిపేరు
FROM page p1,revision,actor
where p1.page_namespace=0
and p1.page_id IN (
  SELECT cl_from
  FROM categorylinks
  WHERE cl_to = 'సంగీత_నాటక_అకాడమీ_అవార్డు_గ్రహీతలు'
)
  and rev_page=p1.page_id
  and rev_parent_id=0
  and actor_id=rev_actor
--  and rev_timestamp>=20230700000000
  
order by rev_timestamp desc

SQL

Checking query status...