WP:MILHIST articles w/ <11 inbound mainspace links

This query is marked as a draft This query has been published by Cryptic.

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;

​x
 
SELECT COUNT(pl_title) 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 = 0WHERE tl_from_namespace = 1  AND tl_namespace = 10  AND tl_title = 'WikiProject_Military_history'  AND artpage.page_is_redirect = 0GROUP BY artpage.page_titleHAVING COUNT(pl_title) <= 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...