SELECT
	`p_1`.`ParentID`,
	`p_1`.`Value1`
FROM
	`Parent` `p_2`
		INNER JOIN `Child` `c_1` ON `p_2`.`ParentID` = `c_1`.`ParentID`
		INNER JOIN `Parent` `p` ON `p_2`.`ParentID` = `p`.`ParentID`
		INNER JOIN `Parent` `p_1` ON `p_2`.`ParentID` = `p_1`.`ParentID`
		INNER JOIN `Child` `c4` ON `c4`.`ParentID` = `p_1`.`ParentID`
WHERE
	EXISTS(
		SELECT
			*
		FROM
			`Parent` `p_3`
		WHERE
			EXISTS(
				SELECT
					*
				FROM
					`Child` `c_2`
				WHERE
					`c_2`.`ParentID` > 1 AND `c_2`.`ParentID` = `p_3`.`ParentID`
			) AND
			`p_3`.`ParentID` = `p_1`.`ParentID`
	) AND
	`c4`.`ParentID` % 2 = 0 AND
	EXISTS(
		SELECT
			*
		FROM
			`Child` `c_3`
		WHERE
			`c_3`.`ParentID` > 1 AND `c_3`.`ParentID` = `p`.`ParentID`
	) AND
	`c_1`.`ParentID` > 1 AND
	EXISTS(
		SELECT
			*
		FROM
			`Child` `c_4`
		WHERE
			`c_4`.`ParentID` > 1 AND `c_4`.`ParentID` = `p_2`.`ParentID`
	)