Untitled query #82047

SQL

SELECT ltd.lt_title AS title, COUNT(pld.pl_from) AS count
FROM pagelinks pld
INNER JOIN linktarget ltd ON (pld.pl_target_id = ltd.lt_id)
INNER JOIN page pd ON (pd.page_title = ltd.lt_title AND pd.page_namespace = ltd.lt_namespace)
LEFT JOIN page ps ON (ps.page_id = pld.pl_from)
LEFT JOIN linktarget lts ON (lts.lt_title = ps.page_title AND lts.lt_namespace = 0)
LEFT JOIN pagelinks pls ON (pls.pl_target_id = lts.lt_id AND pls.pl_from_namespace = 0 AND ps.page_is_redirect = 1)
LEFT JOIN page plsp ON (plsp.page_id = pls.pl_from)
INNER JOIN page_props ppd ON (ppd.pp_page = pd.page_id AND ppd.pp_propname = 'disambiguation')
WHERE ltd.lt_namespace = 0
AND pld.pl_from_namespace = 0
AND NOT EXISTS(
  SELECT pps.pp_page
  FROM page_props pps
  WHERE (pps.pp_page = ps.page_id)
  AND pps.pp_propname = 'disambiguation'
)
AND NOT EXISTS(
  SELECT pps.pp_page
  FROM page_props pps
  WHERE (pps.pp_page = plsp.page_id)
  AND pps.pp_propname = 'disambiguation'
)
GROUP BY ltd.lt_title
ORDER BY COUNT(pld.pl_from) DESC, ltd.lt_title
LIMIT 200
SQL

Checking query status...
