Partecipanti WLM-IT

This query is marked as a draft This query has been published by Nemo bis.

Partecipanti a Wiki Loves Monuments dal 2013 in poi secondo le categorie

SQL

USE commonswiki_p;
SELECT img_actor, actor_name, COUNT(*) AS photos
FROM image
JOIN page
ON page_title = img_name
AND img_width*img_height > 5000000
JOIN categorylinks
ON page_id = cl_from
AND cl_to = 'Uploaded_via_Campaign:wlm-it'
JOIN actor_logging
ON img_actor = actor_id
WHERE LOWER(actor_name) NOT LIKE '%bot%'
GROUP BY img_actor
HAVING photos > 3;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...