WP:MILHIST articles w/ <11 inbound mainspace links

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

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

SQL

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
ORDER BY inlinks ASC, title ASC;

SQL

Checking query status...