Fiwiki public art stats. Photos

SQL

use fiwiki_p;
select 
    floor(COALESCE(i1.img_timestamp, c_i1.img_timestamp)/10000000000) as d, 
	count(distinct(COALESCE(i1.img_name, c_i1.img_name))) as img_name_count, 
    count(distinct(COALESCE(a1.actor_name, c_a1.actor_name))) as actor_name_count 
from 
	page as p1, 
    categorylinks as cl, 
    imagelinks as il1 
    	LEFT JOIN image as i1 ON il1.il_to=i1.img_name 
    	LEFT JOIN commonswiki_p.image as c_i1 ON il1.il_to=c_i1.img_name 
        LEFT JOIN actor as a1 ON i1.img_actor=a1.actor_id AND a1.actor_user IS NOT NULL 
        LEFT JOIN commonswiki_p.actor AS c_a1 ON c_i1.img_actor=c_a1.actor_id AND c_a1.actor_user IS NOT NULL 
WHERE 
	il1.il_from=p1.page_id 
    and p1.page_namespace=0 
    and p1.page_id=cl.cl_from 
    and cl.cl_to='Luettelot_Suomen_julkisista_taideteoksista_ja_muistomerkeistä'
group by d
SQL

Checking query status...
