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;