Christianity Questions to Answer (custom)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Good questions, custom tags, without great answers or any accepted answers, or answers by a particular user, that have been around for at least X months.

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

DECLARE @Exclude int = ##Exclude?21576##;
-- Exclude: Exclude questions posted by these users:   "Returns all users with at least this many qualifying edits"


select id as [Post Link], creationdate as 'Creation Date', score as 'Question Score'
from posts
where posttypeid = 1
and OwnerUserID NOT IN  (@Exclude)
and (tags like '%##Tag1?protestant##%'
or tags like '%##Tag2?NULL##%'
or tags like '%##Tag3?NULL##%')
and score >= 3
and acceptedanswerid is null
and (select max(score) from posts answers
  where posttypeid = 2 
  and parentid = posts.id) <= 2
and closeddate is  null
and not exists (select * from posts answers where owneruserid = ##AlreadyAnsweredBy?21576## and posttypeid = 2 and parentid = posts.id)
and datediff(mm,creationdate,getdate()) >= ##MonthsOld?3##
order by creationdate

Enter Parameters

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