Revision ID per file caricati in WLM IT

SQL

USE commonswiki_p;
SELECT rev_user_text, MIN(rev_id), COUNT(rev_id)
FROM revision
JOIN categorylinks
ON rev_page = cl_from
AND rev_parent_id = 0
AND cl_to = 'Uploaded_via_Campaign:wlm-it'
AND rev_user NOT IN ( SELECT distinct(log_user)
FROM logging
WHERE log_action = 'upload'
AND log_timestamp BETWEEN '20180900' AND '20181000'
AND log_page IN ( SELECT cl_from
	FROM categorylinks 
	WHERE cl_to = 'Uploaded_via_Campaign:wlm-it'
	AND cl_timestamp BETWEEN '20180800' AND '20181000' )
)
GROUP BY rev_user;

SQL

Checking query status...