SELECT page_title, page_len, page_touched, pp_propname, tl_title

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 pp_propname != 'disambiguation'

ORDER BY page_len ASC

LIMIT 100;