Untitled query #59480

SQL

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
  ;
SQL

Checking query status...
