MT-1 for CRMD - Quarry

Following is an SQL query on https://quarry.wmcloud.org/ to get a list of "unique" uploaders to the Wikimedia Commons category: Images from Wiki Loves Earth 2014, who have created their Wikimedia account during the campaign period i.e. May and June 2014. The output includes user_name and their account registration_timestamp.

Note: Below query is written for a Micro Task.

SQL

/* SQL code to get list of unique users and their account registration timestamo who have created their accounts
during the Wiki Loves Earth 2014 campaign period (i.e Beginning of 1 May 2014 to ending of 30 June 2014) and uploaded files to
Wikimedia Commons category:Images from Wiki Loves Earth 2014 */

SELECT DISTINCT user_name, user_registration as registration_timestamp 
FROM user -- Selecting distinct Users and their registrartion timestamp from user table

INNER JOIN actor ON actor_user = user_id AND user_id != 0 -- Joining non zero user_id of user table to actor_user of actor table   
INNER JOIN revision ON rev_actor = actor_id AND rev_actor != 0 -- Joining non zero rev_actor of revision table to actor_id of actor table
INNER JOIN categorylinks ON rev_page = cl_from -- Joining cl_from of categorylinks table to rev_page of revision table


WHERE cl_to = "Images_from_Wiki_Loves_Earth_2014" AND cl_type = "file" 
			   AND user_registration BETWEEN "20140501000000" and "20140630235959" 
       		   AND rev_parent_id = 0 AND actor_user IS NOT NULL;

SQL

Checking query status...