SQL
AخA
SELECT pages.page_title, pl_title, pages.page_latest FROM pagelinks
LEFT JOIN page AS portals ON portals.page_title = pl_title AND portals.page_namespace = pl_namespace
JOIN page AS pages ON pages.page_id = pl_from
WHERE pl_namespace = 100 AND portals.page_title IS NULL AND pl_from_namespace = 0
ORDER BY pages.page_latest DESC;
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.