Very short articles in cswiki

SQL

USE cswiki_p;
SELECT page_title AS TITLE, page_len AS LENGTH, COUNT(links.pl_from) AS BACKLINKS
	FROM page
	LEFT JOIN (SELECT * FROM templatelinks WHERE tl_title = "Pahýl" AND tl_from_namespace = 0) AS stub
		ON stub.tl_from = page_id
	LEFT JOIN (SELECT * FROM templatelinks WHERE tl_title LIKE "Rozcestník%" AND tl_from_namespace = 0) AS dab
		ON dab.tl_from = page_id
	LEFT JOIN (SELECT * FROM templatelinks WHERE tl_title = "Copyvio" AND tl_from_namespace = 0) AS cv
		ON cv.tl_from = page_id
	LEFT JOIN (SELECT * FROM pagelinks WHERE pl_from_namespace = 0 AND pl_namespace = 0) AS links
		ON links.pl_title = page_title
WHERE page_len < 400 AND page_namespace = 0
AND stub.tl_from IS NULL AND dab.tl_from IS NULL AND cv.tl_from IS NULL
AND page_is_redirect = 0
AND page_title NOT RLIKE "^[1-9]"
GROUP BY page_title
ORDER BY page_len, COUNT(links.pl_from) DESC;
SQL

Checking query status...
