Find potential bounty targets

1

Please login or register to vote for this query.

(click on this box to dismiss)

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

select distinct
q.id as [Post Link],
q.score,
users.reputation,
q.answercount,
q.viewcount,
q.body,
q.ViewCount,
q.FavoriteCount,
q.Tags from posts q
inner join posttags on posttags.postid = q.id
inner join users on q.owneruserid = users.id 
inner join tags on posttags.tagid = tags.id
where not exists(select * from posts a where parentid = q.id and a.score > 0)
and users.reputation < 3000
and q.creationdate > DATEADD(month, -1, GETDATE())
and q.acceptedanswerid is null
and q.posttypeid = 1
and ('##tags##' = ' ' or tags.tagname = '##tags##')
and closeddate is null
and score > 3
order by score desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results