Untitled query #83097

SQL

select p1.page_title Page_name,actor_name User_name,concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2)) creation_date from page p1,revision,actor
where not exists(select p2.page_title from page p2 where p2.page_title=p1.page_title and p2.page_namespace=1)
and p1.page_namespace=0
and rev_page=p1.page_id
and actor_id=rev_actor
and actor_name in ("Chaduvari","Pranayraj1985","Batthini Vinay Kumar Goud","యర్రా రామారావు")
and rev_parent_id=0
and p1.page_is_redirect=0
and rev_timestamp>=20240200000000
order by actor_name,  rev_timestamp
SQL

Checking query status...
