0

Please login or register to vote for this query.

(click on this box to dismiss)

Unanswered questions weighted on a composite score based on Votes, Favorites, Age, and Views

Q&A for enthusiasts and scholars of mythology and folklore

-- Most Interesting Unanswered Questions
-- Unanswered questions weighted on a composite score based on Votes, Favorites, Age, and Views

DECLARE @Tag varchar(50) = '##Tag##'

SELECT TOP 20
    p.[Id] as [Post Link],
    p.Score,
    p.[CreationDate]
FROM
    [Posts] p
WHERE
    p.[PostTypeId] = 1
  AND
    [ClosedDate] IS NULL
  AND
    datediff(day, CreationDate, GETDATE()) < 14.5
  AND
    CHARINDEX('<' + @Tag + '>', p.[Tags]) > 0
  AND
    NOT EXISTS (SELECT c.[Id] FROM [Posts] c WHERE p.[AcceptedAnswerId] = c.[Id] OR (c.[Score] > 0 AND c.[ParentId] = p.[Id]))
ORDER BY
    p.[Score] + (p.[FavoriteCount] * 3) + (p.[ViewCount] / 10000.0) + (-DateDiff(d, p.[CreationDate], getutcdate()) / 90.0) DESC

fork query

edited nov 27 Asmus

created jul 8 10 otac0n