Partecipanti WLM-IT

SQL

USE commonswiki_p;
SELECT img_actor, actor_name, COUNT(*) AS photos, COUNT(DISTINCT(SUBSTR(img_timestamp, 1, 4))) AS years, COUNT(gil_page) AS usages, t.page_id AS talkid
FROM image
JOIN page p
ON p.page_title = img_name
AND img_width*img_height > 2000000
JOIN categorylinks
ON p.page_id = cl_from
AND cl_to = 'Uploaded_via_Campaign:wlm-it'
JOIN actor_logging
ON img_actor = actor_id
AND LOWER(actor_name) NOT LIKE '%bot%'
LEFT JOIN globalimagelinks
ON gil_to = img_name
AND gil_page_namespace_id = 0
JOIN page t
ON t.page_namespace = 3
AND t.page_title = REPLACE(actor_name, " ", "_")
GROUP BY img_actor
HAVING photos > 0;
SQL

Checking query status...
