https://bugzilla.wikimedia.org/show_bug.cgi?id=55927

Nemo <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]
            Summary|Italian Wikivoyage page     |Italian Wikivoyage page
                   |count in Wikistats seems to |count in Wikistats seems
                   |low                         |too low, though
                   |                            |Special:Statistics is wrong
                   |                            |as well

--- Comment #2 from Nemo <[email protected]> ---
MariaDB [itwikivoyage_p]> SELECT
    ->   COUNT(*)
    -> FROM page
    -> WHERE page.page_namespace = 0
    -> AND page.page_is_redirect = 0;
+----------+
| COUNT(*) |
+----------+
|     3246 |
+----------+
1 row in set (0.03 sec)

MariaDB [itwikivoyage_p]> SELECT
    ->   page_namespace,
    ->   page_title
    -> FROM page
    -> LEFT JOIN pagelinks
    -> ON pl_from = page_id
    -> WHERE pl_namespace IS NULL
    -> LIMIT 1;
+----------------+------------+
| page_namespace | page_title |
+----------------+------------+
|              0 | Bug_54831  |
+----------------+------------+
1 row in set (0.10 sec)

----

[[voy:it:Special:Statistics]] says 3485 and it's surely wrong, there can be at
most 3246 countable articles. However, only 1 page (which I just created) has
no links, AFAICS, so the article count should not be lower than 3200. As
mentioned in the URL, Special:Statistics is wrong due to bug 40009; why
Wikistats is wrong, I don't know. I'm going to file a site request to fix the
former.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to