Users by number of files uploaded to certain category after certain date

SQL

SELECT DISTINCT(image.img_user_text), COUNT(1) AS files
FROM commonswiki_p.image
	LEFT JOIN commonswiki_p.page ON image.img_name=page.page_title
    LEFT JOIN commonswiki_p.categorylinks ON page.page_id=categorylinks.cl_from
WHERE image.img_timestamp > 20181016000000
	AND page.page_namespace=6
	AND categorylinks.cl_to LIKE "%ikimedia CEE Meeting 201%"
GROUP BY image.img_user_text
ORDER BY files DESC

AخA
 
SELECT DISTINCT(image.img_user_text), COUNT(1) AS filesFROM commonswiki_p.image    LEFT JOIN commonswiki_p.page ON image.img_name=page.page_title    LEFT JOIN commonswiki_p.categorylinks ON page.page_id=categorylinks.cl_fromWHERE image.img_timestamp > 20181016000000    AND page.page_namespace=6    AND categorylinks.cl_to LIKE "%ikimedia CEE Meeting 201%"GROUP BY image.img_user_textORDER BY files DESC

SQL

Checking query status...