No scored/accepted answer in given time period

1

Please login or register to vote for this query.

(click on this box to dismiss)

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

-- Dates are in YYYY-MM-DD.
select q.Id as [Post Link], q.CreationDate from Posts q
where q.PostTypeId=1 and q.AcceptedAnswerId is null
  and q.CreationDate>'##StartDate##'
  and q.CreationDate<'##EndDate##'
  and q.ClosedDate is null
  and isnull((
      select max(a.Score) from Posts a
      where a.ParentId = q.Id and a.PostTypeId=2
    ),0) <= 0
order by q.CreationDate;

Enter Parameters

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