https://bugzilla.wikimedia.org/show_bug.cgi?id=59466
--- Comment #1 from Bugzilla Bug Importer (valhallasw)
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Mon, 28 May 2012 20:30:11
-------------------------------------------------------------------------------
I hope I understand that right, you want the number of not existing articles?
The following query get's the number of articles (namespace 0), which are
linked from the article namespace, but don't exist.
SQL:
mysql> SELECT /* SLOW_OK */ COUNT(*) FROM (SELECT DISTINCT pl_title FROM
pagelinks INNER JOIN page ON pl_from = page_id WHERE pl_title NOT IN(SELECT
page_title FROM page WHERE page_namespace = 0) AND pl_namespace = 0 AND
page_namespace = 0) AS innerQuery;
+----------+
| COUNT(*) |
+----------+
| 425033 |
+----------+
1 row in set (10 min 23.63 sec)
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
