Untitled query #36411

Fork of 100 shortest articles on Swedish Wikipedia by Jan Ainali (WMSE)

This query is marked as a draft This query has been published by Estopedist1.

SQL

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;

SQL

Checking query status...