Untitled query #50026

SQL

use fiwiki_p;
select  
    group_concat(pp_value, "|[[", replace(page_title, "_", " ") , "]]"), actor_name 
from 
	pagelinks, page, categorylinks, page_props, logging_userindex, actor_logging 
where 
	pl_from = 1568063 
    and page_title=pl_title and page_namespace=0 and page_id=cl_from
    AND log_page=page_id
    AND log_action="create"
    AND log_actor=actor_id
    AND actor_name IN ("Lax", "Kospo-75", "Lakritsa")
    AND (cl_to LIKE "Elävät_henkilöt" 
         OR cl_to LIKE "%syntyneet%" OR cl_to LIKE "%yntymävuosi%" OR cl_to LIKE "%uolinvuosi%"
         OR cl_to LIKE "%kuolleet%" ) 
    and pp_page = page_id 
    and pp_propname="page_image_free" 
group by page_title, pp_value;
SQL

Checking query status...
