def METHOD_NAME(self, author_id: int) -> List[WorkspaceSubscription]:
    return (
        self._base_query()
        .filter(WorkspaceSubscription.author_id == author_id)
        .order_by(WorkspaceSubscription.workspace_id, WorkspaceSubscription.author_id)
        .all()
    )