Archaeologist for Node.js

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sitecore Meta

Q&A about the site for developers and end users of the Sitecore CMS and multichannel marketing software

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

Enter Parameters

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