Positive-scoring, unanswered questions that are not closed and without comments

1

Please login or register to vote for this query.

(click on this box to dismiss)

TeX - LaTeX

Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems

select top 1000
    p.id as [Post Link],
    p.lastactivitydate as [Last Active]
from posts p
left outer join comments c on c.postid = p.id
where p.posttypeid = 1 -- Questions
and c.id is null
and answercount = 0 
and p.score > 0
and closeddate is null
order by lastactivitydate

Enter Parameters

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