revert list of selected day

SQL

SET @date_filter="20111005";
SELECT 
  CONCAT("{{kumouslista",
  " |sivu=",
  page_title,
  " |käyttäjä=", 
  r.rev_user_text, 
  " |kommentti=",
  r.rev_comment,
  " |rev_id=",
  r.rev_id,
  " |aikaleima=",
  r.rev_timestamp,
  "}}") as template
FROM
page,
revision as r
LEFT JOIN (
  SELECT ug_user AS user_id FROM user_groups WHERE ug_group='bot' 
  UNION 
  SELECT ufg_user AS user_id FROM user_former_groups WHERE ufg_group='bot' 
  UNION
  SELECT user_id FROM user WHERE user_name REGEXP "(\b|\s|[-_ ])[Bb][-_]?[o0O][-_]?[tT]|[Bb][-_]?[o0O][-_]?[tT](\b|\s|[-_ ]|$)"
  GROUP BY user_id
) AS robots 
ON robots.user_id=r.rev_user
,
(
SELECT 
  r1.rev_id 
FROM 
  revision as r1,
  revision as r2 
WHERE 
  FLOOR(r1.rev_timestamp/1000000)=@date_filter 
  AND r1.rev_page=r2.rev_page
  AND r1.rev_id > r2.rev_id 
  AND r1.rev_sha1 = r2.rev_sha1 
  AND r1.rev_comment NOT REGEXP "[Ss]iirsi|[Ss]uojasi|[Bb]otti muokkasi|[Bb]otti lisäsi|[Bb]otti poisti"
UNION
SELECT
  r1.rev_id
FROM 
  revision_userindex as r1
WHERE 
  FLOOR(r1.rev_timestamp/1000000)=@date_filter 
  AND rev_comment REGEXP "(\b|\s| |^)rvv?(\b|\s| |$)|(ontriributions/|uokkaukset/)|palautettu|kumottu|hylätty"
)
AS filter 
WHERE
filter.rev_id=r.rev_id
AND robots.user_id IS NULL
AND page_namespace=0 
AND page_id=r.rev_page
GROUP BY filter.rev_id;
SQL

Checking query status...
