use commonswiki_p;

select 

    page_title, 

    page_namespace, 

    user_registration, 

    max(rev_timestamp) as max_ts, 

    min(rev_timestamp) as min_ts, 

    rev_user_text  

FROM 

    page, 

    categorylinks, 

    image, 

    user, 

    fiwiki_p.revision_userindex 

WHERE rev_user_text=user_name 

    and rev_user >0 

    and user_id=img_user 

    and img_name=page_title 

    and page_id=cl_from 

    and cl_to = "Images_from_Wiki_Loves_Monuments_2017_in_Finland" 

    and page_namespace=6 

    and user_registration > 20170900151240 

group by user_name

UNION

select 

    page_title, 

    page_namespace, 

    user_registration, 

    max(rev_timestamp) as max_ts, 

    min(rev_timestamp) as min_ts, 

    rev_user_text  

FROM 

    page, 

    categorylinks, 

    image, 

    user, 

    revision_userindex 

WHERE rev_user_text=user_name 

    and rev_user >0 

    and user_id=img_user 

    and img_name=page_title 

    and page_id=cl_from 

    and cl_to = "Images_from_Wiki_Loves_Monuments_2017_in_Finland" 

    and page_namespace=6 

    and user_registration > 20170900151240 

group by user_name