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

SQL

​x
 
SELECT inlinks, COUNT(title)
FROM (SELECT COUNT(pl_title) AS inlinks, artpage.page_title AS title
      FROM templatelinks
      JOIN page AS talkpage
        ON talkpage.page_id = tl_from
      JOIN page AS artpage
        ON artpage.page_namespace = 0 AND artpage.page_title = talkpage.page_title
      LEFT JOIN pagelinks
        ON pl_namespace = 0 AND pl_title = artpage.page_title AND pl_from_namespace = 0
      WHERE tl_from_namespace = 1
        AND tl_namespace = 10
        AND tl_title = 'WikiProject_Military_history'
        AND artpage.page_is_redirect = 0
      GROUP BY artpage.page_title
      HAVING COUNT(pl_title) <= 10) sq
GROUP BY inlinks
ORDER BY inlinks ASC;
​
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...