bridge_get_ranked_post_pinned_for_community performance improvements

Redefined hive_posts indexes being related to communities, to improve performance of bridge_get_ranked_post_pinned_for_community function.