select

    substring(rev_timestamp, 1, 8) as date,

    count(rev_id)

from

    revision,

    page

where

    rev_page = page_id and

    page_namespace = 146 and -- Lexeme

    rev_parent_id = 0 and

    rev_timestamp like '2024%'

group by

    date

order by

    date;