USE tewiki_p;

SELECT distinct page_title 

FROM page, revision,actor,change_tag,change_tag_def

where page_namespace=0

and   ctd_id=ct_tag_id

and ct_rev_id=rev_id 

and  ctd_name not in ("contenttranslation","వ్యాసాల అనువాదం","ContentTranslation2")

  and rev_page=page_id

  and rev_parent_id=0

  and actor_id=rev_actor

  and page_is_redirect=0

  and actor_name="Chaduvari"

--    and rev_timestamp like "2024%"    

order by rev_timestamp desc