total number of badges earned in January 2016 according to the badge class.


Please login or register to vote for this query.

(click on this box to dismiss)


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

SELECT top 10 Id, Title,PostTypeId, Score,
MAX(Score) over (Partition by PostTypeId) as MaxScoreByType,
Rank() over (Partition by PostTypeId ORDER BY PostTypeID) as ScoreRankByType,
COUNT(PostTypeId) over (Partition by PostTypeId) as total_post_per_type
    FROM Posts
Order By PostTypeId

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results