select concat('site://q/',p.id, '|', 'Asked ', p.creation...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select concat('site://q/',p.id, '|',
  'Asked ', p.creationdate,
  ', Deleted ', p.deletiondate) [Deleted link] 
  , p.score
  , p.tags
from postswithdeleted p
where p.body like '%3rd table called TakesClasses%'
and p.deletiondate is not null
order by p.score desc

Enter Parameters

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