Answers by a specific user that received bounties from me

1

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

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

Enter Parameters

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