Untitled

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