Untitled query #36406

SQL

SELECT MIN(rev_id), rev_user_text, rev_user, rev_timestamp, page_title, cl_to, user_name, log_timestamp
FROM enwiki_p.page p 
INNER JOIN enwiki_p.categorylinks cl ON p.page_id = cl.cl_from 
INNER JOIN enwiki_p.revision r ON p.page_id = r.rev_page 
INNER JOIN enwiki_p.user u ON r.rev_user = u.user_id
INNER JOIN logging.log_user lu ON r.rev_user = lu.user_id
WHERE p.page_namespace = 2
AND cl.cl_to IN ("Members_of_the_Ten_Year_Society_of_Wikipedia_editors") 
AND lu.log_type = 'newusers'
GROUP BY log_timestamp;
SQL

Checking query status...
