async def _pinned(db, community):
    """Get a list of pinned post `id`s in `community`."""
    sql = """SELECT id FROM hive_posts
              WHERE is_pinned = '1'
                AND is_deleted = '0'
                AND community = :community
            ORDER BY id DESC"""
    return await db.query_col(sql, community=community)