Untitled query #16045

SQL

USE fiwiki_p;
SELECT 
  page_title,
  pp_value, 
  group_concat(cl4.cl_to) as suomalaiset,
  cl1.cl_to as syntyneet,
  cl2.cl_to as kuolleet,
  cl3.cl_to as elavat  
FROM 
  categorylinks AS cl4, 
  page_props, 
  page 
  LEFT JOIN (SELECT cl_to, cl_from FROM categorylinks WHERE cl_to LIKE "%uonna%yntyneet%") AS cl1 ON cl1.cl_from = page_id 
  LEFT JOIN (SELECT cl_to, cl_from FROM categorylinks WHERE cl_to LIKE "%uonna%uolleet%") AS cl2 ON cl2.cl_from = page_id 
  LEFT JOIN (SELECT cl_to, cl_from FROM categorylinks WHERE cl_to LIKE "Elävät_henkilöt") AS cl3 ON cl3.cl_from = page_id
WHERE 
  page_id=pp_page 
  AND page_namespace=0 
  AND (cl1.cl_to IS NOT NULL OR cl2.cl_to IS NOT NULL OR cl3.cl_to IS NOT NULL) 
  AND pp_propname="wikibase_item" 
  AND cl4.cl_from=page_id 
GROUP BY page_id
SQL

Checking query status...
