select substr(ar_timestamp,1,4) Created_year, count(substr(ar_timestamp,1,4)) Deletion_count

from archive

where ar_namespace=0

and ar_parent_id=0

group by substr(ar_timestamp,1,4)

-- and substr(log_timestamp,1,4) in ("2025","2024")

-- and ar_timestamp like "2025%"

order by substr(ar_timestamp,1,4);

​

select substr(log_timestamp,1,4) Deleted_year, count(substr(log_timestamp,1,4)) Deletion_count

from archive,logging

where log_type="delete"

and log_action="delete"

and log_page=ar_page_id

and ar_namespace=0

and ar_parent_id=0

and log_namespace=0

group by substr(log_timestamp,1,4)

-- and substr(log_timestamp,1,4) in ("2025","2024")

-- and ar_timestamp like "2025%"

order by substr(log_timestamp,1,4);

​

​

​