Artículos de mujeres creados en marzo de 2019

Fork of Artículos de mujeres creados en marzo de 2019 by Superzerocool

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

SQL

use eswiki_p;

SELECT (SUM(IF(cl_to = 'Mujeres', 1, 0))) mujeres, (SUM(IF(cl_to = 'Hombres', 1, 0))) hombres
FROM revision, page, categorylinks 
WHERE rev_timestamp BETWEEN '201903010000000' AND '20190331235959' 
	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');

SELECT page_title, rev_timestamp, rev_user_text 
FROM revision, page, categorylinks 
WHERE rev_timestamp BETWEEN '201903010000000' AND '20190331235959' 
	AND rev_parent_id = 0
	AND page_id = rev_page AND page_namespace = 0
    AND cl_from = page_id
    AND cl_to = 'Mujeres'

SQL

Checking query status...