Questions going from [status-declined] to [status-completed] after posting a bounty

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

SELECT DISTINCT(d.postid) AS [Post Link]
  FROM posthistory AS d
  INNER JOIN posthistory AS c
    ON d.postid = c.postid
  INNER JOIN votes AS v
    ON v.postid = c.postid
    AND v.creationdate > d.creationdate
    AND v.creationdate < c.creationdate
  WHERE d.posthistorytypeid = 6
    AND d.text LIKE '%<status-declined>%'
    AND c.posthistorytypeid = 6
    AND c.text LIKE '%<status-completed>%'
    AND v.votetypeid = 8

Enter Parameters

Options:
Switch sites
loading Hold tight while we fetch your results