Untitled query #62270

SQL

SELECT
    p1.page_title, CONCAT("https://ru.wikinews.org/wiki/", p1.page_title) AS url, CONCAT("Викиновости:Статистика_страниц/", p1.page_title)
FROM page AS p1
WHERE NOT EXISTS (SELECT
                    page_title
                  FROM page AS p2
                  WHERE p2.page_title = CONCAT("Статистика_страниц/", p1.page_title)
                  AND p2.page_namespace = 4) # 102 -- комментарии
AND p1.page_title NOT LIKE "Лента_новостей_%"
AND p1.page_title NOT LIKE "Ожидаемые_события_%"
AND page_namespace = 0
AND page_is_redirect = 0;
SQL

Checking query status...
