living people categories

SQL

use fiwiki_p;
SELECT 
  page_title, 
  pp_value,
  c0.cl_to_concat, 
  c2.cl_to, 
  c3.cl_to, 
  c1.cl_to 
FROM 
 page_props,
 page LEFT JOIN (
   SELECT 
     cl_from,
     group_concat(cl_to) as cl_to_concat 
   FROM categorylinks 
   GROUP BY cl_from
 ) AS c0 ON c0.cl_from = page_id 
 LEFT JOIN (
   SELECT * 
   FROM categorylinks 
   WHERE  cl_to="Elävät_henkilöt"
 ) AS c1 ON c1.cl_from=page_id 
 LEFT JOIN (
   SELECT * 
   FROM categorylinks 
   WHERE cl_to like "Vuonna%syntyneet"
 ) AS c2 ON page_id=c2.cl_from 
 LEFT JOIN  (
   SELECT * 
   FROM categorylinks 
   WHERE cl_to LIKE "Vuonna%kuolleet"
 ) AS c3 ON page_id=c3.cl_from 
WHERE 
  page_namespace=0 
  AND ( 
    (c1.cl_to IS NOT NULL) 
    OR (c2.cl_to IS NOT NULL) 
    OR  (c3.cl_to IS NOT NULL)
  ) 
  AND c0.cl_to_concat LIKE "%uomalaiset%"
  AND pp_page=page_id 
  AND pp_propname="wikibase_item";
SQL

Checking query status...
