0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for community managers, administrators, and moderators

select concat(
       'site://q/'
       , id
       , '|'
       , Format(deletiondate, 'yyyy/MM/dd')
       , ' created on '
       , creationdate
       , ' - '
       , case when posttypeid = 1 then tags else '(answer)' end
       ) [Deleted post]
from postswithdeleted
where deletiondate between '2019-09-12' and '2019-09-13'

view current version

edited sep 16 19

created sep 16 19 rene