Mulheres e homens criados em março de 2020

Fork of Mujeres y hombres creados en marzo de 2020 by Superzerocool

This query is marked as a draft This query has been published by GoEThe.

Quantidade de artigos sobre homens e mulheres criados na Wikipedia em português em março de 2020. Considera só as categorias de pessoas (não wikidata), assim como se o artigo existe no momento de executar a consulta

SQL

use ptwiki_p;
SELECT now() as 'última execução';

SELECT if(cl_to = 'Mulheres', 'Mulheres', 'Homens') as genero, count(1) as counted
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 ('Mulheres', 'Homens')
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 = 'Mulheres'
ORDER BY 3 ASC;

SQL

Checking query status...