SELECT

        page_title, page_id

                    FROM

                        page,

                        templatelinks

                    WHERE

                        page_id=tl_from AND

                        page_namespace=0 AND

                        tl_namespace=10 AND

                        tl_title='Disambig' AND

    page_id IN (SELECT DISTINCT

                        tl_from

                    FROM

                        templatelinks,

                        page

                    WHERE

                        page_id=tl_from AND

                        tl_namespace = 100 AND

                        page_namespace = 0)

LIMIT 50;