Untitled query #42303

SQL

use wikidatawiki_p;

select page_title from (select distinct(page_title) as w_qid, replace(ips_site_page, " ", "_") as w_page_title from page, pagelinks, wb_items_per_site where ips_site_id="fiwiki" and page_title=concat("Q", ips_item_id) and  page_id=pl_from and page_namespace=0 and pl_title in ('P1006','P1015','P1048','P1053','P1146','P1157','P1225','P1248','P1273','P1315','P1323','P1362','P1368','P1375','P1693','P1694','P1695','P1707','P1736','P1890','P1907','P2041','P2092','P213','P214','P2180','P2181','P2182','P227','P2349','P2387','P244','P245','P2456','P2558','P268','P269','P271','P2750','P3065','P3293','P3372','P3430','P347','P349','P350','P3544','P3706','P396','P4012','P409','P4186','P428','P434','P496','P5034','P549','P640','P650','P651','P6792','P6804','P691','P7314','P781','P864','P886','P902','P906','P947','P949','P950') and pl_namespace=120 limit 200000) as t, fiwiki_p.categorylinks, fiwiki_p.page as fp1 LEFT JOIN templatelinks ON tl_from=fp1.page_id and tl_namespace=0 AND fp1.page_namespace=0 AND tl_title="Auktoriteettitunnisteet" where page_title=w_page_title and page_namespace=0 and tl_from IS NULL and cl_from=fp1.page_id and cl_to="Elävät_henkilöt"  limit 20;
SQL

Checking query status...
