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