Most Views

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT TOP 10000
Questions.Id 
AS [Post Link],
Questions.Title,
Questions.AnswerCount, 
Questions.ViewCount,
Questions.FavoriteCount, 
Questions.Score,
Questions.LastActivityDate

FROM Posts AS Questions
GROUP BY
Questions.Id, 
Questions.Title,
Questions.AnswerCount, 
Questions.ViewCount,
Questions.FavoriteCount, 
Questions.Score,
Questions.LastActivityDate

ORDER BY ViewCount DESC

Enter Parameters

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