USE skwiki_p;

​

SELECT

    -- p.page_id,

    (SELECT pp_value FROM page_props WHERE pp_page = page_id AND pp_propname = 'wikibase_item') as wb_item,

    REPLACE(p.page_title, '_', ' ') as page_title,

    pp_propname

  FROM

    page p left outer join page_props on pp_page = page_id and pp_propname = 'disambiguation'

  WHERE

    p.page_namespace = 0 and

    p.page_is_redirect = 0 and

    REPLACE(p.page_title, '_', ' ') in ('Banská Bystrica (mestská časť)', 'Fončorda', 'Iliaš', 'Jakub (Banská Bystrica)', 'Kostiviarska', 'Kremnička', 'Kráľová (Banská Bystrica)', 'Majer (Banská Bystrica)', 'Podlavice', 'Pršianska Terasa', 'Radvaň (Banská Bystrica)', 'Rakytovce', 'Rudlová', 'Senica (Banská Bystrica)', 'Skubín', 'Sásová', 'Uhlisko (Banská Bystrica)', 'Uľanka', 'Šalková')

  GROUP BY

    p.page_id

  ORDER BY

    -- p.page_id

    p.page_title

  -- LIMIT

    -- 60000

  -- OFFSET

    -- 0

    -- 60000

    -- 120000

    -- 180000

  ;