HK anon 4 Canon IXUS 285 HS

SQL

USE commonswiki_p;
SELECT actor_name AS User,
	 LEFT(MIN(img_timestamp), 8) AS Date
FROM actor_image
JOIN image ON actor_id = img_actor AND img_major_mime = 'image' AND img_timestamp < 20180730000000
JOIN user ON user_name = actor_name
WHERE img_name LIKE "HK\_%" OR img_name LIKE "MC_%"
AND img_metadata LIKE "%Canon IXUS 285 HS%"
GROUP BY actor_name
HAVING TIMESTAMPDIFF( day, MIN(img_timestamp), MAX(img_timestamp) ) < 3 AND TIMESTAMPDIFF( day, MIN(user_registration), MIN(img_timestamp) ) < 3
ORDER BY Date;

SQL

Checking query status...