SELECT 

  CONCAT('[[', p.page_title, ']]') AS "Title",

  CONCAT('[https://ta.wikipedia.org/wiki/', REPLACE(p.page_title, ' ', '_'), ' Link]') AS "Article Link",

  p.page_len AS "Size"

FROM page AS p

LEFT JOIN page_props AS pp ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'

WHERE p.page_namespace = 0  -- Main namespace

  AND p.page_is_redirect = 0  -- Exclude redirects

  AND pp.pp_page IS NULL  -- Exclude articles linked to Wikidata

  AND p.page_title NOT LIKE '%/%'  -- Exclude subpages

ORDER BY p.page_len DESC

LIMIT 50000;

​