#from http://quarry.wmflabs.org/query/1135

use lvwiki_p;

SELECT page_title, page_len

FROM page

WHERE page_namespace = 0 AND page_len < 1000 AND page_is_redirect = 0 and page_title NOT LIKE "%gads"

AND page_id NOT IN (

  SELECT tl_from FROM templatelinks WHERE tl_title IN

        ("Asbox", "Nozīmju_atdalīšana", "Copyvio", "Autortiesību_problēmas",

         "Īss_aizmetnis", "Disambig")

  )

ORDER BY page_len ASC

LIMIT 100;

/*

http://quarry.wmflabs.org/query/871

 use iswiki_p;

SELECT page_title, page_len FROM page

WHERE page_namespace = 0

AND page_len < 1000

AND page_is_redirect = 0

AND page_id NOT IN (

  SELECT pp_page FROM page_props WHERE pp_propname IN ('disambiguation')

  )

AND page_id NOT IN (

  SELECT tl_from FROM templatelinks WHERE tl_title IN ('Stubbur')

  )

ORDER BY page_len ASC LIMIT 300;

*/