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<20240600000000

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

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