SQL
AخA
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.