WP:MILHIST articles w/ <11 inbound mainspace links

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

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

SQL

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

SQL

Checking query status...