Highest view rate questions in a particular tag (non-Community Wiki)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Highest view rate questions in a particular tag (non-Community Wiki).
-- 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,
    p.ViewCount / (DATEDIFF(day, p.CreationDate, CURRENT_TIMESTAMP) + 1) as [View rate]
FROM Posts p
WHERE p.ViewCount > 28 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) > 5 AND
      p.Tags LIKE '%<php>%'  -- '%<java>%' also matches "'javascript'" (after "p.Tags" ): 'LIKE %java%'. Does not work for exact match: "COLLATE SQL_Latin1_General_CP1_CS_AS"
      -- ViewCount / age >
ORDER BY [View Rate] DESC

Enter Parameters

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