Topic on Talk:Quarry

How would I check if the specific page has been previously deleted?

2 comments • 16:52, 10 January 2022 2 years ago

2

Gone Postal (talkcontribs)

I am trying to find categories, which have been deleted, but still have files in them. The latter part is trivial, but how do I check that the page existed before?

Reply 16:57, 9 January 2022 2 years ago

Matěj Suchánek (talkcontribs)

I see two possible ways:

1) check Special:Log (using EXISTS or JOIN) like

WHERE EXISTS (SELECT 1 FROM logging WHERE log_type = 'delete' AND log_action = 'delete' AND log_namespace = 14 AND log_title = cl_to)

2) check page archive

WHERE EXISTS (SELECT 1 FROM archive WHERE ar_title = cl_to AND ar_namespace = 14)

Reply 16:52, 10 January 2022 2 years ago

Reply to "How would I check if the specific page has been previously deleted?"