Untitled query #64755

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 user_registration BETWEEN "20210901000000" and "20210930235959" -- Filtering user accounts created during campaign
	AND rev_parent_id = 0 AND actor_user IS NOT NULL -- Checking for newly uloaded files by teh above filtered user
    AND cl_to = "Wiki_Loves_Monuments_2021" AND cl_type = "file"; -- Filtering out uploads done to the required category
SQL

Checking query status...
