SELECT page_title,pl_title

FROM pagelinks,categorylinks,page

WHERE

    cl_from=pl_from and

    page_title=pl_title and

    pl_namespace=0 AND

    page_namespace=0 and

    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) */