Untitled query #75370

SQL

SELECT liste1.Target, liste1.LinkCount - COALESCE(liste2.LinkCount, 0) AS LinkCount
FROM (
  SELECT pl_title AS Target, SUM(page_title IS NULL) AS LinkCount
  FROM pagelinks
  LEFT JOIN page ON page_namespace=0 AND page_title=pl_title
  WHERE pl_from_namespace=0 AND pl_namespace=0
  GROUP BY Target
  HAVING LinkCount >= 1000
) AS liste1
LEFT JOIN (
  SELECT pl_title AS Target, SUM(page_title IS NULL) AS LinkCount
  FROM pagelinks
  LEFT JOIN page ON page_namespace=0 AND page_title=pl_title
  WHERE pl_from_namespace=10 AND pl_namespace=0
  GROUP BY Target
  HAVING LinkCount >= 1000
) AS liste2
ON liste1.Target = liste2.Target
ORDER BY LinkCount DESC;
SQL

Checking query status...
