0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- PostTypeId = 1 -> Question
-- PostTypeId = 2 -> Answer

select Questions.Id as [Post Link] 
from Posts as Questions
INNER JOIN PostTags ON Questions.Id          = PostTags.PostId
INNER JOIN Tags     ON PostTags.TagId        = Tags.id
INNER JOIN Users    ON Questions.OwnerUserId = Users.id
where Questions.PostTypeId   = 1
and Questions.ViewCount > 1
and Users.Reputation>10
and Tags.TagName='Java'
-- and not exists (select * from Posts as Answers where
--                Answers.PostTypeId = 2
--                and Answers.ParentId  = Questions.Id
--                and Answers.Score > 0);

fork query

edited mar 26 15

created mar 25 15 Ortomala