Accept comment by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bitcoin

Q&A for Bitcoin crypto-currency enthusiasts

SELECT 
PostId = 
     CASE
          WHEN p.PostTypeId = 2 THEN pp.Id
          ELSE p.Id
     END
 , c.Text , c.UserId, 
Tags = 
     CASE
          WHEN p.PostTypeId = 2 THEN pp.Tags
          ELSE p.Tags
     END
     
FROM Comments c
JOIN Posts p
ON c.PostId=p.Id
LEFT JOIN Posts pp
ON p.ParentId = pp.Id

WHERE     
      lower(c.Text) LIKE lower('%please%accept%')

Enter Parameters

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