other short pages on rowiki

SQL

USE rowiki_p;
SELECT page_title, page_len
FROM page
JOIN templatelinks
ON tl_from = page_id
/*JOIN categorylinks
ON cl_from = page_id
WHERE cl_to = "Living_people"*/
WHERE tl_title IN ("Ciot-Bavaria", "Ciot-Baden-Württemberg"/*, "Ciot-Mecklenburg-Pomerania_Inferioară"*/)
#WHERE tl_title IN ("Ciot-Saxonia-Anhalt", "Ciot-Hessa", "Saxonia_Inferioară")
#WHERE tl_title IN ("Ciot-Schleswig-Holstein", "Ciot-Saarland", "Ciot-Turingia")
#WHERE tl_title IN ("Ciot-Renania_de_Nord-Westfalia", "Ciot-Renania-Palatinat", "Ciot-Brandenburg")
AND tl_namespace = 10
AND page_len < 500
AND page_namespace = 0
LIMIT 600;
SQL

Checking query status...
