use eswiki_p;

​

SELECT date_format(rev_timestamp, '%m/%Y') mes, 

    (SUM(IF(cl_to = 'Mujeres', 1, 0))) mujeres, (SUM(IF(cl_to = 'Hombres', 1, 0))) hombres

FROM revision, page, categorylinks 

WHERE year(rev_timestamp) between 2018 and 2019

    AND rev_parent_id = 0

    AND page_id = rev_page AND page_namespace = 0

    AND cl_from = page_id

    AND cl_to in ('Mujeres', 'Hombres')

    AND cl_timestamp >= '20180101000000'

group by 1

order by date_format(rev_timestamp, '%Y/%m');