Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
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
Toggle Highlighting
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;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...