Stubs which may not be primary topics

SQL

SELECT Ps.page_title, Ps.page_len, Pq.page_title, Pq.page_len
FROM categorylinks Cs
JOIN page Ps ON Ps.page_id=Cs.cl_from AND Ps.page_namespace=0 AND Ps.page_title LIKE "Ab%"
JOIN page Pq ON Pq.page_namespace=0 AND Pq.page_title LIKE "Ab%" AND Pq.page_title LIKE CONCAT(Ps.page_title, "_(%)") AND Pq.page_len > Ps.page_len AND Pq.page_is_redirect=0
AND NOT EXISTS (SELECT 1 FROM categorylinks Cq WHERE Cq.cl_from=Pq.page_id AND Cq.cl_to="All_stub_articles" AND Cq.cl_type="page")
WHERE Cs.cl_to="All_stub_articles" AND Cs.cl_type="page"
ORDER BY Ps.page_title, Pq.page_title

SQL

Checking query status...