Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation
select concat('site://q/',p.id, '|',
'Asked ', p.creationdate,
', Deleted ', p.deletiondate) [Deleted link]
from postswithdeleted p
where p.tags like '%<gpl>%'
and p.deletiondate is not null
order by p.score desc