select *
from regression_notifications rn
         join notification_checks nc on rn.id = nc.regression_id
         join check_issues ci on nc.id = ci.check_id
where ci.status = "Open"

RegressionTable.join(CheckTable.join( IssueTable,JoinType.INNER),JoinType.INNER).select { IssueTable.status eq "Open" }

Table
	.join(Table1, JoinType.INNER, additionalConstraint = { //if needed })
	.join(Table2, JoinType.INNER, additionalConstraint = { //if needed })
	.select { Table1.id eq 10 }