1nd1go

Я еще order by забыл. Попробуйте с limit

select * from (select hashtag_id, count(*) as cnt from comments_hashtags group by hashtag_id order by cnt) LIMIT 1