Untitled query #4941

SQL

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;
SQL

Checking query status...
