Q&A for power users of Apple hardware and software
select v.id , v.postid [Post Link] , v.creationdate , pn.deletiondate , pn.owneruserid [User Link] , pn.deletionuserid [User Link] , p.owneruserid [User Link] from votes v inner join posts p on v.postid = p.id inner join postnotices pn on pn.postid = p.parentid where votetypeid = 9 and p.owneruserid=##answererid?5363## and pn.owneruserid=##userid?8297## and pn.Postnoticetypeid IN (10,11,12,13,14,15) ---and pn.creationdate < v.creationdate and v.creationdate = convert(date,pn.deletiondate) order by v.creationdate desc