$tags = DB::get_results('
SELECT t.id AS id, t.term_display AS tag, t.term AS slug,
COUNT(tp.term_id) AS count
FROM {terms} t
LEFT JOIN {object_terms} tp ON t.id=tp.term_id
WHERE t.vocabulary_id = ?
GROUP BY id, tag, slug
ORDER BY count DESC, tag ASC
LIMIT 0, 50',
array( Vocabulary::get( 'post' ) )
);