Get trending posts by tipped, replies, and tipped + replies

[mjovanc]

Get trending post by how many replies a post has.

[mjovanc]

Example how to get top hashtags by number of posts:

SELECT
	ph.hashtag_id as hashtag_id,
	h.name as hashtag_name,
	COUNT(p.id) as num_posts
FROM
	post p,
    post_hashtag ph
JOIN
	hashtag h ON h.id = ph.hashtag_id
	--(SELECT h FROM hashtag h WHERE h.id=ph.hashtag_id) hashtag_name
WHERE
	p.id = ph.post_id
GROUP BY
	ph.hashtag_id,
	hashtag_name
ORDER BY
	num_posts DESC