USE fawiki_p;

SELECT

  ns_name,

  pg1.page_title

FROM page AS pg1

JOIN toolserver.namespace

ON dbname = %s

AND page_namespace = ns_id

WHERE pg1.page_title LIKE '%/%'

AND pg1.page_namespace IN (1,5,7,9,11,13,101)

AND NOT EXISTS (SELECT

                  1

                FROM page AS pg2

                WHERE pg2.page_namespace = pg1.page_namespace

                AND pg2.page_title = SUBSTRING_INDEX(pg1.page_title, '/', 1))

AND NOT EXISTS (SELECT

                  1

                FROM page AS pg3

                WHERE pg3.page_namespace = pg1.page_namespace - 1

                AND pg3.page_title = pg1.page_title)

AND NOT EXISTS (SELECT

                  1

                FROM page AS pg4

                WHERE pg4.page_namespace = pg1.page_namespace - 1

                AND pg4.page_title = SUBSTRING_INDEX(pg1.page_title, '/', 1))

​

​

LIMIT 2;