use commonswiki_p;

  SELECT img_user_text AS uploader, COUNT(page_title) AS pictures

   FROM image, page, categorylinks 

   WHERE page.page_id=categorylinks.cl_from 

       AND image.img_name = page.page_title

       AND .categorylinks.cl_to = "Onam_loves_Wikimedia_event_-_2016"

           GROUP BY uploader

   ORDER BY pictures DESC;