Untitled query #42307

SQL

use wikidatawiki_p;

SELECT 
   *
FROM
   (select 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 group by w_page_title,w_qid limit 250000) AS wikidatalist,
   (select cl_from, pp_value from fiwiki_p.page_props as pp1 LEFT JOIN fiwiki_p.templatelinks as tl1 ON tl1.tl_from=pp1.pp_page AND tl1.tl_title="Auktoriteettitunnisteet" and tl1.tl_from_namespace=0 and tl1.tl_namespace=10, fiwiki_p.categorylinks where pp1.pp_propname="wikibase_item" and pp1.pp_page=cl_from and (cl_to = "Elävät_henkilöt" OR cl_to LIKE "Vuonna%eet") AND tl1.tl_from IS NULL  group by cl_from) as fiwikilist
WHERE 
   wikidatalist.w_qid=fiwikilist.pp_value
SQL

Checking query status...
