3

Please login or register to vote for this query.

(click on this box to dismiss)

Highest hitrate non-CW questions, (presumably) what questions are viewed the most per time unit from Google searches.

Q&A about the site for linguists, teachers and students of the Ukrainian language

-- Highest view rate questions (non-Community Wiki). [5]
-- Highest hitrate non-CW questions, (presumably) what questions are viewed the most per time unit from Google searches.

SELECT TOP 100
    p.Id as [Post Link],
    p.Id as [Post ID],
    Score as [Votes],
    ViewCount as [Views],
    DATEDIFF(day, p.CreationDate, CURRENT_TIMESTAMP) as [Age (days)],
    p.ViewCount / (DATEDIFF(day, p.CreationDate, CURRENT_TIMESTAMP) + 1) as [View rate]
FROM Posts p
WHERE p.ViewCount > 100 AND --On Stack Overflow there are 100 non-CW post with more than about 28000.
      p.CommunityOwnedDate is null and -- Field CommunityOwnedDate is absent for non-CW posts.
      p.ViewCount / (DATEDIFF(day, p.CreationDate, CURRENT_TIMESTAMP) + 1) > 50
      -- ViewCount / age >
ORDER BY [View Rate] DESC

fork query

edited nov 11 12 Peter Mortensen (resurrected)

created may 23 11 Peter Mortensen