use eswiki_p;

SELECT date_format(rev_timestamp, '%w') semana, sum(mujer) as mujer, sum(hombre) as hombre

FROM (

SELECT rev_timestamp, cl_to = 'Mujeres' as mujer, cl_to = 'Hombres' as hombre

FROM categorylinks, page, revision

WHERE cl_to IN ('Mujeres', 'Hombres')

AND cl_from = page_id

AND page_namespace = 0

AND rev_page = page_id

AND rev_parent_id = 0

AND year(rev_timestamp) = 2019

) a

order by semana