Q49, run 2026-11-05-1515-sonnet-query
Who is Cerid Rosor Holdings SA's ultimate parent?
Tests: Paths and identity: a chain of parents several levels long, with one link naming a RESEARCH record of the parent.
Expected: parent = E5001
sql run 1
E5167 (Cerid Chemicals SA). The chain is E5167>E5011>E5023>E5035>E5047, although E5167 is a RESEARCH-source record.
JSON: {"parent": "E5167"}
Why: parent: expected E5001, got E5167
sql run 2
E5001. The chain runs E5047, E5035, E5023, E5011, then E5167, which is a duplicate of E5005, then E5002 and E5001.
JSON: {"parent": "E5001"}
sql run 3
E5001. The chain is E5047 to E5035, E5023, E5011, E5005, E5002, then E5001.
JSON: {"parent": "E5001"}
sql run 4
E5001. The chain runs E5047 → E5035 → E5023 → E5011 → E5167 (a duplicate of E5005) → E5002 → E5001.
JSON: {"parent": "E5001"}
sql run 5
E5001. E5047's chain runs E5035, E5023, E5011, then E5167, which is a duplicate record of E5005 (same LEI), then E5002 and E5001.
JSON: {"parent": "E5001"}
sql+markdown run 1
E5001.
JSON: {"parent": "E5001"}
sql+markdown run 2
E5001.
JSON: {"parent": "E5001"}
sql+markdown run 3
E5001. The chain from Cerid Rosor Holdings SA to the top is 6 levels.
JSON: {"parent": "E5001"}
sql+markdown run 4
E5001. The chain from E5047 reaches E5001 at depth 6.
JSON: {"parent": "E5001"}
sql+markdown run 5
E5001.
JSON: {"parent": "E5001"}
sparql run 1
E5001. The chain is E5047 → E5035 → E5023 → E5011 → E5167 → E5001, and E5167 is a research-system duplicate of E5001 (same LEI).
JSON: {"parent": "E5001"}
sparql run 2
E5001. The chain is E5047 → E5035 → E5023 → E5011 → E5167. E5167 shares E5005's LEI, so it is a duplicate record and the chain continues E5005 → E5002 → E5001.
JSON: {"parent": "E5001"}
sparql run 3
(no answer found)
JSON: {"parent": null}
Why: parent: expected E5001, got None
sparql run 4
E5167. The chain is E5047 → E5035 → E5023 → E5011 → E5167.
JSON: {"parent": "E5167"}
Why: parent: expected E5001, got E5167
sparql run 5
E5167.
JSON: {"parent": "E5167"}
Why: parent: expected E5001, got E5167
sparql+ontology run 1
(no answer found)
JSON: {"parent": null}
Why: parent: expected E5001, got None
sparql+ontology run 2
E5167. The chain from E5047 runs through E5035, E5023 and E5011 to E5167.
JSON: {"parent": "E5167"}
Why: parent: expected E5001, got E5167
sparql+ontology run 3
E5001. Following the parent chain through E5167, which shares its LEI with E5005, leads to E5002 and then E5001.
JSON: {"parent": "E5001"}
sparql+ontology run 4
E5001.
JSON: {"parent": "E5001"}
sparql+ontology run 5
E5001. The chain is E5047, E5035, E5023, E5011, E5167 (same LEI as E5005), E5002, E5001.
JSON: {"parent": "E5001"}
sql+executed run 1
E5001.
JSON: {"parent": "E5001"}
sql+executed run 2
E5001 (Cerid Group plc).
JSON: {"parent": "E5001"}
sql+executed run 3
E5001.
JSON: {"parent": "E5001"}
sql+executed run 4
E5001. The ancestors table shows E5001 at 6 levels up from E5047.
JSON: {"parent": "E5001"}
sql+executed run 5
E5001.
JSON: {"parent": "E5001"}
sparql+axioms run 1
E5001.
JSON: {"parent": "E5001"}
sparql+axioms run 2
E5001.
JSON: {"parent": "E5001"}
sparql+axioms run 3
E5001 (Cerid Group plc).
JSON: {"parent": "E5001"}
sparql+axioms run 4
(no answer found)
JSON: {"parent": null}
Why: parent: expected E5001, got None
sparql+axioms run 5
E5001.
JSON: {"parent": "E5001"}