WP:WikiProject Louisville/Nursery
{{WPLouisville page|suppressalerts=yes}}
Following is a list of WikiProject Louisville's 100 newest articles. Use this list to see if project-included articles newest to Wikipedia* need cleanup, tagging or improved categorization.
:
Newest articles in our project
{{Database report
|sql =
SELECT subjectpage.page_title AS 'Article',
(
SELECT actor_name
FROM actor
JOIN revision ON rev_actor = actor_id
WHERE rev_page = subjectpage.page_id
AND rev_parent_id = 0
ORDER BY rev_timestamp ASC
LIMIT 1
) AS 'Creator',
SUBSTRING_INDEX(cl2.cl_to, "-", 1) AS 'Rating', SUBSTRING_INDEX(cl3.cl_to, "-", 1) AS 'Importance'
FROM page AS subjectpage
JOIN page AS talkpage ON subjectpage.page_title = talkpage.page_title
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' -- substitute your project category of included articles, pages, etc.
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
JOIN categorylinks ON cl_from = dabtalkpage.page_id
WHERE cl_to = 'Disambig-Class_Louisville_pages' -- substitute your project category of included disambiguation pages
)
ORDER BY subjectpage.page_id DESC
LIMIT 100;
|wikilinks = 1, 2:2
|widths = 3:4em, 4:6em
|interval = 1
}}
----
{{Database report/footer|count=100|query_runtime=110.49|last_updated=09:28, 23 June 2025 (UTC)}}
{{Database report end}}