Untitled query #42305

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 10000) AS wikidalist,
   (select cl_from, page_title as f_page_title from page, fiwiki_p.categorylinks where page_namespace=0 and page_id=cl_from and (cl_to = "Elävät_henkilöt" OR cl_to LIKE "Vuonna%eet") group by cl_from, page_title) as fiwikilist
WHERE 
   wikidatalist.w_page_title=fiwikilist.page_title
SQL

Checking query status...
