Don't touch my junk.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ebooks

Q&A for ebook publishers and readers

with optjava as (
Select PostId
from PostTags
where TagId = 5 or TagId = 42
group by PostId
having count(*) = 2)
select id as [Post Link],
       AcceptedAnswerId,
       Score,
       CreationDate,
       AnswerCount
from Posts inner join optjava on Id = PostId
where ClosedDate is null
  and Score > 0
order by Score Desc

Enter Parameters

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