Untitled query #46424

SQL

SELECT
  count(logusers.log_title), COUNT(pbusers.log_title)
FROM
  logging_logindex AS logusers
  LEFT JOIN logging_logindex AS pbusers ON (
    pbusers.log_type = "block"
    AND pbusers.log_action IN ("block", "reblock")
    AND pbusers.log_params LIKE "a:4:%\"sitewide\";b:0%"
    AND pbusers.log_title = logusers.log_title
    AND pbusers.log_timestamp < logusers.log_timestamp
  )
WHERE
  logusers.log_type = "block"
  AND logusers.log_action IN ("block", "reblock")
  AND logusers.log_params NOT LIKE "a:4:%\"sitewide\";b:0%"
SQL

Checking query status...
