Q49, run 2026-11-04-2024-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
E5001. E5047's chain is E5001 > E5002 > E5005 > E5011 > E5023 > E5035 > E5047, with E5167 being a duplicate of E5005.
JSON: {"parent": "E5001"}
sql run 2
E5167. The chain is E5047→E5035→E5023→E5011→E5167.
JSON: {"parent": "E5167"}
Why: parent: expected E5001, got E5167
sql run 3
E5167, via the chain E5167>E5011>E5023>E5035>E5047.
JSON: {"parent": "E5167"}
Why: parent: expected E5001, got E5167
sql+markdown run 1
E5002 (Cerid Group plc), the parent of E5010.
JSON: {"parent": "E5002"}
Why: parent: expected E5001, got E5002
sql+markdown run 2
E5001. The chain is E5047 → E5035 → E5023 → E5011 → E5167 (same entity as E5005) → E5002 → E5001.
JSON: {"parent": "E5001"}
sql+markdown run 3
E5001.
JSON: {"parent": "E5001"}
sparql run 1
(no answer found)
JSON: {"parent": "E5001"}
sparql run 2
E5001. E5167 duplicates E5005 (same LEI), and E5005 sits under E5002 and then E5001.
JSON: {"parent": "E5001"}
sparql run 3
(no answer found)
JSON: {"parent": "E5167"}
Why: parent: expected E5001, got E5167
sparql+ontology run 1
E5001. The chain runs E5047, E5035, E5023, E5011, E5167 (the same entity as E5005), E5002, E5001.
JSON: {"parent": "E5001"}
sparql+ontology run 2
E5001. The chain is E5047 → E5035 → E5023 → E5011 → E5167. E5167 is the RESEARCH record of E5005 (same LEI), whose parent is E5002, whose parent is E5001.
JSON: {"parent": "E5001"}
sparql+ontology run 3
E5001 (Cerid Group plc). The chain is E5047, E5035, E5023, E5011, E5167, then E5001, because E5167 shares its LEI with E5002, whose parent is E5001.
JSON: {"parent": "E5001"}
sql+executed run 1
E5001.
JSON: {"parent": "E5001"}
sql+executed run 2
E5001.
JSON: {"parent": "E5001"}
sql+executed run 3
E5001.
JSON: {"parent": "E5001"}
sparql+axioms run 1
E5001.
JSON: {"parent": "E5001"}
sparql+axioms run 2
(no answer found)
JSON: {"parent": "E5001"}
sparql+axioms run 3
E5001.
JSON: {"parent": "E5001"}