posthumous name

SQL

#SELECT p.page_title title, cl.cl_to category
SELECT p.page_title title, pp.pp_value qid, 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 page_props pp
  ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'
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
  WHERE cl2.cl_to = '谥号'
)
LIMIT 10
SQL

Checking query status...
