SELECT DISTINCT
	LEFT(img_timestamp,8) AS date,
	img_name,
	FLOOR(LOG10(COUNT(*))) AS logreps,
	CONCAT(
	img_user_text, ', ',
	oi1.oi_user_text, ', ',
	oi2.oi_user_text, ', ',
	oi3.oi_user_text) AS users,
	pr_level AS protection
FROM image
INNER JOIN oldimage_userindex oi1 ON oi1.oi_name=img_name AND oi1.oi_sha1!=img_sha1 AND oi1.oi_user!=img_user
INNER JOIN oldimage_userindex oi2 ON oi2.oi_name=img_name AND oi1.oi_sha1!=oi2.oi_sha1 AND oi2.oi_user!=oi1.oi_user AND oi1.oi_timestamp>oi2.oi_timestamp
INNER JOIN oldimage_userindex oi3 ON oi3.oi_name=img_name AND oi2.oi_sha1!=oi3.oi_sha1 AND oi3.oi_user!=oi2.oi_user AND oi2.oi_timestamp>oi3.oi_timestamp
JOIN page ON page_title = img_name AND page_namespace = 6
LEFT JOIN page_restrictions ON page_id = pr_page AND pr_type = 'move'
WHERE
	img_name NOT LIKE "%Test%"
	AND	img_timestamp> DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -8 DAY), "%Y%m%d%H%i%s")
	AND oi1.oi_timestamp> DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -15 DAY), "%Y%m%d%H%i%s")
	AND oi2.oi_timestamp> DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -30 DAY), "%Y%m%d%H%i%s")
	AND oi3.oi_timestamp> DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -30 DAY), "%Y%m%d%H%i%s")
	AND img_user_text NOT REGEXP "review|Bot"
	AND oi1.oi_user_text NOT REGEXP "review|Bot"
	AND oi2.oi_user_text NOT REGEXP "review|Bot"
	AND oi3.oi_user_text NOT REGEXP "review|Bot"
GROUP BY img_name
ORDER BY logreps;

----

SELECT
	COUNT(DISTINCT gil_wiki),
	COUNT(DISTINCT gil_page),
	COUNT(DISTINCT (IF(gil_page_namespace="", gil_page, NULL)))
FROM globalimagelinks
WHERE gil_to='Map_of_2019_European_Parliament_election_in_the_United_Kingdom.svg';