Number of listed public art photos in Finland

SQL

SELECT 
   floor(COALESCE(fi_i.img_timestamp, c_i.img_timestamp)/10000000000) as year, 
   count(distinct(il_to)) as number_of_images, 
   count(distinct(COALESCE(fi_i.img_user_text, c_i.img_user_text))) as number_of_uploaders 
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 year;

SQL

Checking query status...