Untitled query #33119

SQL

use fiwiki_p;
select 
    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, 
    group_concat(distinct(COALESCE(fi_i.img_user_text, c_i.img_user_text))) as ucc, 
    fi_u.user_registration as fi_u_user_reg,
    c_u.user_registration as c_u_user_reg   
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 
    LEFT JOIN fiwiki_p.user as fi_u ON fi_u.user_id=fi_i.img_user 
    LEFT JOIN commonswiki_p.user as c_u ON c_u.user_id=c_i.img_user     
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...
