SELECT DISTINCT page_title, page_len, page_touched

FROM svwiki_p.page

LEFT JOIN svwiki_p.templatelinks

ON tl_from = page_id

LEFT JOIN svwiki_p.page_props

ON pp_page = page_id

WHERE page_namespace = 0 

AND page_is_redirect = 0

AND tl_namespace = 10

AND tl_title != 'Wiktionary-omdirigering'

AND tl_title != 'Förgrening'

AND tl_title != 'Förgrening_bas'

AND tl_title != 'Gren'

AND tl_title != 'Namnförgrening'

AND tl_title != 'Grensida'

AND tl_title != 'Förgreningssida'

AND tl_title != 'Disambig'

AND tl_title != 'Hndis'

AND tl_title != 'Gaffel'

AND tl_title != 'Namngrensida'

AND pp_propname != 'disambiguation'

AND pp_propname != 'wikibase_item'

ORDER BY page_len ASC

LIMIT 100;