Replicas browser and optimizer
This query is marked as a draft
This query has been published
Get all user with a image in a category and it determinates if it is a newbie (if I consider the registration timestamp) and the number of uploads
use commonswiki_p; select user_name, user_registration, (case when user_registration between '20190521000000' and '20190705000000' then 1 else 0 end) newbie, count(1) uploads from categorylinks join page pg on page_id = cl_from join image img on img_name = page_title join actor ac on actor_id = img_actor join `user` us on actor_user = user_id where cl_to = 'Images_from_Wiki_Loves_Earth_2019_in_Chile' and cl_type = 'file' group by 1, 2, 3 order by 4 desc
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in