use hewiki_p;

select log_timestamp as date, log_title as name, log_user_text as sysop, log_comment as comment from logging_logindex as l1

where log_action = "delete"

and log_namespace = 1

and not exists

(select * from page

 where page_namespace = 1

 and page_title = log_title)

and (exists

(select * from logging_logindex as l3

 where l3.log_namespace = 1

 and l3.log_title = log_title)

or exists

(select * from page

 where page_namespace = 1

 and page_title = log_title))

and log_timestamp like "2006%"

order by log_timestamp

​