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

WITH art AS
(SELECT talkpage.page_title AS art_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 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
  AND artpage.page_title LIKE "0%" /*TEMP*/
)

WITH art2 AS
(SELECT art_title FROM art)

SELECT COUNT(inlinkpage.page_id) AS inlinks, art_title AS title
FROM art2
LEFT JOIN pagelinks
  ON pl_namespace = 0 AND pl_title = art_title AND pl_from_namespace = 0
LEFT JOIN page AS inlinkpage
  ON inlinkpage.page_id = pl_from AND inlinkpage.page_is_redirect = 0
GROUP BY art_title
HAVING COUNT(inlinkpage.page_id) <= 10
ORDER BY inlinks ASC, title ASC;

SQL

Checking query status...