Replicas browser and optimizer
This query is marked as a draft
This query has been published
USE fawiki_p; SELECT /*SLOW OK */ page_title, DATE ( CONCAT ( YEAR(rev_timestamp), "-", MONTH(rev_timestamp), "-", DAY(rev_timestamp) ) ) AS DAY FROM revision INNER JOIN page ON rev_page = page_id WHERE page_namespace = 14 AND rev_user_text = 'Modern_Sciences' AND rev_parent_id = 0 AND page.page_is_redirect = 0 and rev_timestamp > 20180101000000 GROUP BY DAY ORDER BY rev_timestamp;
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