WP:MILHIST articles w/ <11 inbound mainspace links

Fork of WP:MILHIST articles w/ <11 inbound mainspace links 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.

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;

AخA
 
SELECT COUNT(inlinkpage.page_id) AS inlinks, artpage.page_title AS titleFROM templatelinksJOIN page AS talkpage  ON talkpage.page_id = tl_fromJOIN page AS artpage  ON artpage.page_namespace = 0 AND artpage.page_title = talkpage.page_titleLEFT JOIN pagelinks  ON pl_namespace = 0 AND pl_title = artpage.page_title AND pl_from_namespace = 0LEFT JOIN page AS inlinkpage  ON inlinkpage.page_id = pl_from AND inlinkpage.page_is_redirect = 0LEFT 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 NULLGROUP BY artpage.page_titleHAVING COUNT(inlinkpage.page_id) <= 10ORDER BY inlinks ASC, title 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...