To create these dumps, import pages.sql and langlinks.sql and execute the following (not optimized) query:
SELECT page_id, page_len, page_title
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id NOT IN (SELECT ll_from FROM langlinks)
ORDER BY page_title;