SET max_recursive_iterations=2;

​

WITH RECURSIVE artred AS

(SELECT talkpage.page_title AS art_title, talkpage.page_title AS red_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 "1%"

 UNION

 SELECT art_title, redpage.page_title AS red_title

  FROM artred

  JOIN redirect

  ON rd_namespace = 0 AND rd_title = art_title

  JOIN page AS redpage

  ON redpage.page_id = rd_from

)

​

SELECT COUNT(inlinkpage.page_id) AS inlinks, art_title AS title

FROM artred

LEFT JOIN pagelinks

  ON pl_namespace = 0 AND pl_title = red_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;