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,
    p.page_title,
    pp_propname,
    pp_value
  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
    p.page_title in ('Tranzistor', 'Martin', 'Iliaš', 'Rakytovce', 'Kremnička', 'Kráľová', 'Radvaň', 'Podlavice', 'Skubín', 'Jakub', 'Kostiviarska', 'Senica', '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...
