0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

select post.Id as [Post Link], 
       vote.BountyAmount as Bounty,
       post.CreationDate as Date,
       parent.Tags
from posts post
join Votes vote on vote.PostId = post.Id
join posts parent on post.ParentId = parent.Id
where vote.VoteTypeId = 9 
      and vote.BountyAmount <> 0 
      and parent.Tags LIKE '%<##Tag##>%'   
      and vote.userId <> -1
    
order by post.CreationDate desc

fork query

created feb 5 11 Ani