Deletions since date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select concat(
          'site://q/'
         , id
         , '| deleted '
         , case posttypeid 
           when 1 then 'question'
           when 2 then 'answer'
           else convert(nvarchar, posttypeid) 
           end
         ) as [Post Link]
     , posttypeid
     , score
     , datediff(d, creationdate, deletiondate) [Post age]
     , closeddate
     , coalesce(tags, (select tags from postswithdeleted q where q.id = postswithdeleted.parentid)) [tags]
     , (select deletiondate from postswithdeleted q where q.id = postswithdeleted.parentid) [question deleted at]
from postswithdeleted
where deletiondate > ##date:string?2024-04-06##
and score > 0
and creationdate < ##date:string?2024-04-06##
order by score desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results