Replicas browser and optimizer
This query is marked as a draft
This query has been published
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
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in