Q&A about the site for members of the workforce navigating the professional setting
select top 20 p.id as [Post Link] from posts p left outer join comments c on c.postid = p.id inner join posttags pt on p.id = pt.postid inner join tags t on t.id = pt.tagid where p.posttypeid = 1 -- Questions and c.id is null and t.tagname ='java' and answercount = 0 and p.score > 0 and closeddate is null and p.creationdate > getdate()-100 order by p.creationdate asc