Uncategorised redirects to stubs in Project Plants

SQL

SELECT CONCAT('[[',page_title,']]') AS page_title
FROM page INNER JOIN redirect ON rd_from = page_id LEFT JOIN categorylinks ON cl_from = rd_from
WHERE rd_namespace=0 AND page_namespace=0
AND cl_from IS NULL
AND rd_title IN (SELECT page_title FROM page AS p1 LEFT JOIN categorylinks AS c1 ON c1.cl_from = p1.page_id WHERE p1.page_namespace=1 AND c1.cl_to = 'Stub-Class_plant_articles')
ORDER BY page_title ASC LIMIT 3000

AخA
 
SELECT CONCAT('[[',page_title,']]') AS page_titleFROM page INNER JOIN redirect ON rd_from = page_id LEFT JOIN categorylinks ON cl_from = rd_fromWHERE rd_namespace=0 AND page_namespace=0AND cl_from IS NULLAND rd_title IN (SELECT page_title FROM page AS p1 LEFT JOIN categorylinks AS c1 ON c1.cl_from = p1.page_id WHERE p1.page_namespace=1 AND c1.cl_to = 'Stub-Class_plant_articles')ORDER BY page_title ASC LIMIT 3000

SQL

Checking query status...