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 (SELECT * FROM page WHERE page_len < 500) AS pages
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = "disambiguation") AS dab
		ON dab.pp_page = 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) AS links
#		ON pl_title = page_title AND pl_namespace = page_namespace
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id NOT IN (
  SELECT tl_from FROM templatelinks WHERE tl_title IN ("Pahýl", "Copyvio") AND tl_from_namespace = 0
)
AND dab.pp_page IS NULL
AND page_title NOT LIKE "[1-9]%"
GROUP BY page_title
ORDER BY page_len,
#BACKLINKS DESC,
page_title;
SQL

Checking query status...
