Languages most covering Louisville area-related articles

Fork of All Louisville area-related articles in other languages by StefenTower

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

This uses your project's category of included articles/pages, esp. for cases where the project template doesn't directly indicate the project involved. These are mainspace pages, excluding redirects and disambiguation pages, thus genuine articles.

SQL

# All Louisville area-related pages
SELECT langlinks.ll_lang, COUNT(*)
FROM page AS subjectpage
INNER JOIN page AS talkpage on subjectpage.page_title = talkpage.page_title 
INNER JOIN categorylinks ON cl_from = talkpage.page_id
LEFT JOIN langlinks ON ll_from = subjectpage.page_id
WHERE 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'
        )
AND langlinks.ll_lang IS NOT NULL
GROUP BY langlinks.ll_lang
ORDER BY COUNT(*) DESC;

SQL

Checking query status...