Very short articles in cswiki

SQL

USE cswiki_p;
SELECT page_title, page_len /*, COUNT(pl_from) */, pl_title, pl_from FROM page
	LEFT JOIN templatelinks AS stub
		ON stub.tl_title = "Pahýl" AND stub.tl_from = page_id AND stub.tl_from_namespace = 0
	LEFT JOIN templatelinks AS dab
		ON dab.tl_title = "Rozcestník" AND dab.tl_from = page_id AND dab.tl_from_namespace = 0
	LEFT JOIN templatelinks AS cv
		ON stub.tl_title = "Copyvio" AND cv.tl_from = page_id AND cv.tl_from_namespace = 0
	JOIN pagelinks
		ON pl_title = page_title AND pl_from_namespace = 0
WHERE stub.tl_from IS NULL AND dab.tl_from IS NULL AND cv.tl_from IS NULL
AND page_is_redirect = 0 AND page_len < 400 AND page_namespace = 0;
# GROUP BY page_title
# ORDER BY page_len;

SELECT count(page_title) FROM page WHERE page_title = "XYZABC";
SQL

Checking query status...
