This query is marked as a draft This query has been published by Guillaume (WMF).

SQL

AخA
 
use enwiki_p;
SELECT count(page.page_id)
    FROM page
    WHERE 
            page.page_namespace = 10
        AND page.page_is_redirect = 0
        AND page.page_id IN (
            SELECT DISTINCT tl_from
                FROM templatelinks
                WHERE templatelinks.tl_namespace = 828
            );
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...