Untitled query #63694

SQL

SELECT DISTINCT
  		u.user_name, u.user_registration
  	FROM
  		page p
  	INNER JOIN categorylinks cl ON cl.cl_from = p.page_id AND cl.cl_to = 'Images_from_Wiki_Loves_Earth_2014'
    INNER JOIN revision r on r.rev_id = p.page_latest
    INNER JOIN actor a on r.rev_actor = a.actor_id
    INNER JOIN user u on u.user_id = a.actor_id 
    where  cl.cl_type = 'file' and (cl.cl_timestamp >= 20140501000000 and cl.cl_timestamp <= 20140630000000) and 
    (u.user_registration >= 20140501000000 and u.user_registration <= 20140630000000) ;
SQL

Checking query status...
