SQL
AخA
USE bnwikisource_p;
SELECT page_title, page_number FROM
(SELECT page_title, COUNT(DISTINCT pl_title) AS page_number FROM page, pagelinks WHERE page_namespace = 102 AND pl_from = page_id AND pl_namespace = 104 GROUP BY page_id) AS page_count
WHERE page_number <= 50
ORDER BY page_number ASC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.