Number of photographs an photographers of lists of public artworks

SQL

use fiwiki_p;
select 
	left(il_to,60), 
    count(distinct(il_to)) as il_c, 
    floor(COALESCE(fi_i.img_timestamp, c_i.img_timestamp)/10000000000) as d, 
    sum(1) as c, 
    count(distinct(COALESCE(fi_i.img_user_text, c_i.img_user_text))) as uc 
from 
	page as p1,
    categorylinks as cl, 
    imagelinks as il 
    LEFT JOIN fiwiki_p.image as fi_i ON il_to=fi_i.img_name 
    LEFT JOIN commonswiki_p.image as c_i ON c_i.img_name=il_to 
WHERE 
	il_from=cl_from 
    and p1.page_namespace=0 
    and p1.page_id=cl_from 
    and cl_to = "Luettelot_Suomen_julkisista_taideteoksista_ja_muistomerkeistä" 
    and (c_i.img_media_type != "DRAWING" or c_i.img_media_type IS NULL) 
group by d

SQL

Checking query status...