0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

select
    q.score as [Score],
    q.id as [Post Link],
    q.creationdate as [Created],
    q.lastactivitydate as [Last Active],
    u.displayname as [User],
    u.reputation as [Reputation],
    q.title as [Title]
from posts q
  join users u on u.id = q.OwnerUserId
where q.posttypeid = 1 -- Questions
  and q.answercount = 0 
  and q.score >= ##MinScore:int##
  and q.closeddate is null
  and q.lastactivitydate > '20180101'
order by q.score desc

fork query

edited dec 17 18

created dec 17 18 anonymous