Lostam draft - Quarry

SQL

use hewiki_p;
select distinct(log_title), logging.*, archive.* from logging join archive
on log_namespace = ar_namespace
and log_title = ar_title
and datediff(log_timestamp, ar_timestamp) >= 5
where log_action = "delete"
and log_namespace = 0
and (log_comment like "%הובהרה חשיבות%"
     or log_comment like "%הבהרת חשיבות%")
and not exists
(select * from page
 where log_title = page_title
 and page_namespace = 0)
and (exists
(select * from page
 where log_title = page_title
 and page_namespace = 1)
or exists
(select * from archive
 where ar_title = log_title
 and ar_namespace = 1))
SQL

Checking query status...
