SELECT pl_title,page2.page_title

FROM pagelinks,categorylinks,page page1, page page2, page_props

WHERE

    cl_from=pl_from and

    page1.page_title=pl_title and

    page2.page_id=pl_from and

    page2.page_namespace=0 and

    pp_page=page1.page_id and

    pl_namespace=0 AND

    page1.page_namespace=0 and

    page1.page_is_redirect=1 and

#    pl_from_namespace = 0 AND

    pp_propname="Disambiguation" and

    cl_to = "విడుదల_సంవత్సరం_వారీగా_తెలుగు_సినిమాలు" 

/*    and not exists (select page_title

                from page 

                where page_title = pl_title

                and page_namespace = 0) */