use eswiki_p;

SELECT now() as 'ultima ejecucion';

​

SELECT substr(rev_timestamp, 1, 6) as mes, sum(cl_to = 'Mujeres') as mujeres, sum(cl_to = 'Hombres') as hombres

FROM page

INNER JOIN revision ON rev_page = page_id

INNER JOIN categorylinks ON cl_from = page_id

-- WHERE rev_timestamp between '20200301000000' AND '20200401000000'

AND rev_parent_id = 0

AND page_namespace = 0

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

GROUP BY 1;

​

/** SELECT page_title, page_len, rev_timestamp

FROM page

INNER JOIN revision ON rev_page = page_id

INNER JOIN categorylinks ON cl_from = page_id

-- WHERE rev_timestamp between '20200301000000' AND '20200401000000'

AND rev_parent_id = 0

AND page_namespace = 0

AND cl_to = 'Mujeres'

ORDER BY 3 ASC;

*/