SELECT g.*, r.id AS reviewId, r.reviewedByRole AS reviewer, r.status AS statusOnGoing FROM oprisk.iam_issueGroup g LEFT JOIN oprisk.iam_issueGroupReview r ON g.id = r.groupId WHERE g.id = 4 'SELECT AS unitId\n
