లక్ష: User wise, date wise articles created

SQL

USE tewiki_p;
SELECT concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2)) సృష్టించిన_తేదీ, actor_name వాడుకరిపేరు, count(concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2))) సృష్టించిన_పేజీల_సంఖ్య, sum(p1.page_len) మొత్తం_బైట్లు
FROM page p1, revision,actor
where p1.page_namespace=0
  and rev_page=p1.page_id
  and rev_parent_id=0
  and actor_id=rev_actor
  and page_is_redirect=0
    and rev_timestamp>=20240617000000
group by actor_name, concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2))  
order by rev_timestamp desc, count(concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2))) desc
SQL

Checking query status...
