This query is marked as a draft This query has been published by Huji.

SQL

​x
 
SELECT
  COUNT(*)
FROM templatelinks
JOIN page
  ON tl_from = page_id
JOIN linktarget
  ON tl_target_id = lt_id
  AND lt_title = 'یادکرد-ویکی'
  AND lt_namespace = 10
WHERE
  page_namespace = 0
  AND page_is_redirect = 0
  AND page_id NOT IN (
    SELECT
      page_id
    FROM templatelinks
    JOIN page
      ON tl_from = page_id
    JOIN linktarget
      ON tl_target_id = lt_id
      AND lt_title <> 'یادکرد-ویکی'
      AND lt_title IN (
        SELECT
          page_title
        FROM page
        JOIN categorylinks
          ON page_id = cl_from
          AND cl_to IN (
            'الگو:یادکرد',
            'الگو:شیوه_یادکرد_۱'
          )
        WHERE
          page_namespace = 10
      )
      AND lt_namespace = 10
    WHERE
      page_namespace = 0
      AND page_is_redirect = 0
  )
​
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...