WP:MILHIST articles w/ <11 inbound mainspace links (summary)

Fork of WP:MILHIST articles w/ <11 inbound mainspace links (summary) by Cryptic

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

Non-redirect, non-dab articles whose talk page is tagged {{WikiProject Military history}} with 10 or fewer inbound mainspace links from non-redirects, summarized.

For [[WP:RAQ#Orphans, and poorly-linked articles in a WikiProject]] circa 2 April 2022.

SQL

SELECT inlinks, COUNT(title)
FROM (SELECT COUNT(inlinkpage.page_id) 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
      LEFT JOIN page AS inlinkpage
        ON inlinkpage.page_id = pl_from AND inlinkpage.page_is_redirect = 0
      LEFT JOIN page_props
        ON pp_page = artpage.page_id AND pp_propname = 'disambiguation'
      WHERE tl_from_namespace = 1
        AND tl_namespace = 10
        AND tl_title = 'WikiProject_Military_history'
        AND artpage.page_is_redirect = 0
        AND pp_page IS NULL
      GROUP BY artpage.page_title
      HAVING COUNT(inlinkpage.page_id) <= 10) sq
GROUP BY inlinks
ORDER BY inlinks ASC;

AخA
 
SELECT inlinks, COUNT(title)FROM (SELECT COUNT(inlinkpage.page_id) 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      LEFT JOIN page AS inlinkpage        ON inlinkpage.page_id = pl_from AND inlinkpage.page_is_redirect = 0      LEFT JOIN page_props        ON pp_page = artpage.page_id AND pp_propname = 'disambiguation'      WHERE tl_from_namespace = 1        AND tl_namespace = 10        AND tl_title = 'WikiProject_Military_history'        AND artpage.page_is_redirect = 0        AND pp_page IS NULL      GROUP BY artpage.page_title      HAVING COUNT(inlinkpage.page_id) <= 10) sqGROUP BY inlinksORDER 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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...