SQL
AخA
#1
SELECT DISTINCT rev_user_text, rev_user, cl_to
#2
FROM commonswiki_p.page p
#3
INNER JOIN commonswiki_p.categorylinks cl ON p.page_id = cl.cl_from
#4
INNER JOIN commonswiki_p.revision r ON p.page_id = r.rev_page
#5
WHERE p.page_namespace = 6
#6
AND cl.cl_to IN ("Images_from_Wiki_Loves_Africa_2017")
#7
AND r.rev_parent_id = 0;
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.