Tewiki: Wikiproject Visakhapatnam - Date-wise Pages creted

SQL

USE tewiki_p;
SELECT concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2)) సృష్టించిన_తేదీ,count(concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2))) సృష్టించిన_పేజీల_సంఖ్య, 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 rev_timestamp<20231100000000
and p2.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
group by concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2))  
order by concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2)) desc
SQL

Checking query status...
