Deleted once-orphan talk pages on plwiktionary

SQL

select
	l1.log_timestamp as "sygnatura czasowa",
	concat("[[Dyskusja:", replace(l1.log_title, "_", " "), "]]") as "strona dyskusji",
	concat("<nowiki>", comment_text, "</nowiki>") as "uzasadnienie"
from logging as l1
	left join logging as l2 on
		l1.log_title = l2.log_title and
		l2.log_namespace = 0 and
		l2.log_type = "delete" and
		l2.log_action = "delete"
	left join page as p1 on
		l1.log_title = p1.page_title and
		p1.page_namespace = 0
	left join page as p2 on
		l1.log_title = p2.page_title and
		p2.page_namespace = 1
	left join comment on
		l1.log_comment_id = comment_id
where
	l1.log_type = "delete" and
	l1.log_action = "delete" and
	l1.log_namespace = 1 and
	l2.log_id is not null and
	p1.page_id is null and
	p2.page_id is null
group by l1.log_title
order by l1.log_timestamp desc;
SQL

Checking query status...
