Tewiki: Deletions by user and subsequent restoraions

SQL

use tewiki_p;
SET @user = 'Chaduvari';
SET @user_id = (
  SELECT actor_id
  FROM actor_logging
  WHERE actor_name = @user);

SET @deleted = (
  SELECT count(distinct(ll.log_title))
  FROM logging_userindex lu
  JOIN logging_logindex ll ON lu.log_title = ll.log_title
  WHERE lu.log_actor = @user_id
  AND lu.log_namespace = 0
  AND ll.log_namespace = 0
  AND lu.log_type = 'delete'
  AND lu.log_action = 'delete');

SET @restored = (
  SELECT count(distinct(ll.log_title))
  FROM logging_userindex lu
  JOIN logging_logindex ll ON lu.log_title = ll.log_title
  WHERE lu.log_actor = @user_id
  AND lu.log_namespace = 0
  AND ll.log_namespace = 0
  AND lu.log_type = 'delete'
  AND lu.log_action = 'delete'
  AND ll.log_type = 'delete'
  AND ll.log_action = 'restore'
  AND ll.log_timestamp > lu.log_timestamp);

SELECT @deleted, @restored, 100 * @restored / @deleted as percentage;
SQL

Checking query status...
