Articles least linked to from mainspace in WikiProject

SQL

SELECT subjectpage.page_title AS 'Article', SUBSTRING_INDEX(cl2.cl_to, "-", 1) AS 'Rating', SUBSTRING_INDEX(cl3.cl_to, "-", 1) AS 'Importance',
(
  SELECT COUNT(*)
  FROM page p
  INNER JOIN linktarget lt ON lt.lt_title = subjectpage.page_title
  INNER JOIN pagelinks pl ON pl.pl_target_id = lt.lt_id
  WHERE p.page_id = pl.pl_from
  AND p.page_is_redirect = 0
  AND lt.lt_namespace = 0
) AS incominglinks
FROM page AS subjectpage
INNER JOIN page AS talkpage on subjectpage.page_title = talkpage.page_title 
INNER JOIN categorylinks cl1 ON cl1.cl_from = talkpage.page_id
LEFT JOIN categorylinks AS cl2 ON cl2.cl_from = talkpage.page_id
 AND cl2.cl_to REGEXP "^\\w+-Class_Louisville_articles$" -- substitute your project BASE category name for the rating
LEFT JOIN categorylinks AS cl3 ON cl3.cl_from = talkpage.page_id
 AND cl3.cl_to REGEXP "^\\w+-importance_Louisville_articles$" -- substitute your project BASE category name for project importance
WHERE cl1.cl_to = 'WikiProject_Louisville_articles'
AND subjectpage.page_namespace = 0 
AND subjectpage.page_is_redirect = 0
AND talkpage.page_namespace = 1
AND talkpage.page_id NOT IN
        (
        SELECT  page_id
        FROM    page AS dabtalkpage
        INNER JOIN categorylinks ON cl_from = dabtalkpage.page_id
        WHERE cl_to = 'Disambig-Class_Louisville_articles'
        )
ORDER BY incominglinks ASC, subjectpage.page_title ASC
SQL

Checking query status...
