posthumous name

SQL

#SELECT p.page_title title, cl.cl_to category
SELECT p.page_title, cl.cl_to category
FROM page p
LEFT JOIN categorylinks cl
  ON cl.cl_from = p.page_id AND p.page_namespace = 0 AND p.page_is_redirect = 0
LEFT JOIN (
  SELECT cat.page_title category_title FROM page cat
  LEFT JOIN categorylinks cl2
  ON cat.page_namespace = 14
    AND cat.page_id = cl2.cl_from
    AND cl2.cl_to LIKE '谥号'
) cat2
ON cat2.category_title = cl.cl_to
#WHERE EXISTS (
#  SELECT 1 FROM page cat
#  LEFT JOIN categorylinks cl2
#  ON cat.page_title = cl.cl_to
#    AND cat.page_namespace = 14
#    AND cat.page_id = cl2.cl_from
#    AND cl2.cl_to = '谥号'
#)
LIMIT 10
SQL

Checking query status...
