Fiwiki stats of list of articles every Wikipedia should have

SQL

SELECT 
  concat("[[", page_title, "|]]") as page_title, 
  page_len, 
  concat("{{Q|", pp_value, "}}") as wikidata_item,
  group_concat(DISTINCT(IFNULL(cl_to,"")) separator ", " ) as categories
FROM 
  metawiki_p.iwlinks, 
  fiwiki_p.page_props,
  fiwiki_p.page 
  LEFT JOIN (select cl2.cl_from, page_title as cl_to from fiwiki_p.page, fiwiki_p.categorylinks as cl1, fiwiki_p.categorylinks as cl2 where cl1.cl_to="Huomiota_kaipaavat_sivut" and page_id=cl1.cl_from and cl2.cl_to=page_title) as problemcats ON cl_from=page_id
WHERE 
  iwl_prefix="d" 
  AND iwl_from=7066 
  AND pp_propname="wikibase_item" 
  AND iwl_title=pp_value 
  AND pp_page=page_id
ORDER BY page_title

SQL

Checking query status...