wikidata: items deleted

SQL

WITH my_cte AS (
  SELECT
  	log_title,
  	MAX(log_timestamp) AS max_log_timestamp
  FROM
  	logging
  WHERE
    log_namespace=0
    AND log_type='delete'
    AND log_action='delete'
    AND log_title LIKE 'Q%'
    AND log_title NOT IN (
      SELECT
        page_title
      FROM
        page
      WHERE
        page_namespace=0
    )
  GROUP BY
    log_title
) SELECT
  l.log_title AS qid,
  a.actor_name AS admin,
  l.log_timestamp AS ts
FROM
  logging_userindex AS l
    JOIN actor_logging AS a ON l.log_actor=a.actor_id
    INNER JOIN my_cte AS g ON l.log_title=g.log_title AND l.log_timestamp=g.max_log_timestamp
ORDER BY
  CAST(SUBSTRING(l.log_title, 2) AS int) ASC;
SQL

Checking query status...
