Untitled query #29881

SQL

use fiwiki_p;
#select * from page ON `page_id` = `rev_page` where page_namespace = 1 and page_id = 386118 ;
SELECT
  p1.page_namespace,
  p1.page_title,
  p2.page_title
FROM page AS p1
JOIN page AS p2 ON p1.page_title = p2.page_title
WHERE p1.page_title NOT LIKE "%/%"
AND p1.page_namespace NOT IN (0,2,3,4,6,8,9,10,12,14,16,18,100,102,104,108, 118, 710, 828, 2300, 2600)
AND p1.page_id = 386118
AND CASE WHEN p1.page_namespace = 1
  THEN EXISTS (SELECT
                     1
                   FROM page AS p2
                   WHERE p2.page_namespace = 0
                   AND p1.page_title = p2.page_title)
  ELSE 1 END;
SQL

Checking query status...
