SELECT pl_title,page2.page_title

FROM pagelinks,categorylinks,page page1, page page2

WHERE

    cl_from=pl_from and

    page1.page_title=pl_title and

    page2.page_id=pl_from and

    page2.page_namespace=0 and

    page2.page_id in (select pp_page from page_props where pp_propname="Disambiguation") and

    pl_namespace=0 AND

    page1.page_namespace=0 and

#    page1.page_is_redirect=1 and

    pl_from_namespace = 0 AND

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

/*    and not exists (select page_title

                from page 

                where page_title = pl_title

                and page_namespace = 0) */