SELECT
route.idzone, route.z_name
FROM
tbl_zone AS route
INNER JOIN
tbl_zone AS RepArea ON route.idzone_parent = RepArea.idzone
INNER JOIN
tbl_zone AS AgencyArea ON RepArea.idzone_parent = AgencyArea.idzone
INNER JOIN
tbl_zone AS Team ON AgencyArea.idzone_parent = Team.idzone
WHERE
Team.z_name = \'Gold Star\'