SQL
x
USE tewiki_p;
SELECT actor_name వాడుకరిపేరు, p1.page_title పేజీ_పేరు, concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,8,2)) సృష్టించిన_తేదీ
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 p2.page_id IN (
SELECT cl_from
FROM categorylinks
WHERE cl_to = 'క్రికెట్_2023_ప్రాజెక్టులో_భాగంగా_సృష్టించిన_పేజీలు'
)
and rev_page=p1.page_id
and rev_parent_id=0
and actor_id=rev_actor
-- and rev_timestamp>=20230700000000
order by substr(rev_timestamp,1,8)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.