SQL
AخA
USE commonswiki_p;
SELECT page_title, CONCAT(IF (pl_namespace = 14, 'Category:', ''), pl_title) FROM page
INNER JOIN pagelinks ON pl_from = page_id AND pl_from_namespace = 0 AND pl_title NOT LIKE 'Atlas_of_%'
WHERE page_namespace = 0 AND page_is_redirect = 1 AND page_title LIKE 'Atlas_of_%'
LIMIT 100;
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.