Replicas browser and optimizer
Created articles, grouped by month (arwiki)
This query is marked as a draft
This query has been published
use enwiki_p; SELECT left(t4.rev_timestamp,6) as Menesis, count(left(t4.rev_timestamp,6)) as Raksti FROM revision AS t4 WHERE t4.rev_id IN ( Select min(t45.rev_id) From revision t45 inner join page p on t45.rev_page=p.page_id where p.page_namespace=0 and p.page_is_redirect=0 group by t45.rev_page having min(t45.rev_id) order by min(t45.rev_id) desc ) GROUP BY left(t4.rev_timestamp,6)
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