0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

SELECT TOP 1000 P.id AS [Post Link],
                P.creationdate AS [Date],
                P.score,
                P.lastactivitydate,
                P.tags
FROM   posts AS P
WHERE  p.lastactivitydate < ( Getdate() - 180 )
       AND P.lasteditdate < Dateadd(month, -6, p.lastactivitydate)
       AND P.score >= 0
       AND P.acceptedanswerid IS NULL
       AND P.Posttypeid = 1
       AND P.tags LIKE '%<docker>%'
       AND P.closeddate IS NULL
ORDER  BY P.score DESC

fork query

edited sep 20 anonymous

created oct 14 18 Ｈｏｎｇａｒｃ