Untitled query #78832

SQL

SELECT ct_rev_id, count(ct_rev_id)
FROM page,actor,revision,change_tag, change_tag_def
WHERE actor_id=rev_actor
and ctd_id=ct_tag_id
and ct_rev_id=rev_id
and rev_page=page_id
and page_title not in (select pl_title from pagelinks where pl_namespace=0 and pl_from_namespace=0)
and page_id not in (select pp_page from page_props where pp_propname="disambiguation")
and page_namespace = 0
-- and rev_parent_id=0
and page_is_redirect=0
 and	actor_name= "Batthini Vinay Kumar Goud"
 group by ct_rev_id
 order by ct_rev_id
SQL

Checking query status...
