SELECT COUNT(DISTINCT log_title)

FROM logging

WHERE log_type = 'block'

  AND log_action IN ('block', 'reblock')

  AND log_timestamp LIKE '2023%'

  AND log_params LIKE '%"sitewide";b:1%'

  AND log_namespace = 2

  AND NOT(IS_IPV4(log_title)

          OR IS_IPV6(log_title)

          OR (log_title LIKE '%/%'

              AND (IS_IPV4(REGEXP_REPLACE(log_title, '/[0-9]+$', ''))

                   OR IS_IPV6(REGEXP_REPLACE(log_title, '/[0-9]+$', '')))));