Q49, run 2026-11-05-1515-sonnet-query

← back to the run

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

❌ D1 sql run 1 graded by code · query session

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

✅ D1 sql run 2 graded by code · query session

E5001. The chain runs E5047, E5035, E5023, E5011, then E5167, which is a duplicate of E5005, then E5002 and E5001.

JSON: {"parent": "E5001"}

✅ D1 sql run 3 graded by code · query session

E5001. The chain is E5047 to E5035, E5023, E5011, E5005, E5002, then E5001.

JSON: {"parent": "E5001"}

✅ D1 sql run 4 graded by code · query session

E5001. The chain runs E5047 → E5035 → E5023 → E5011 → E5167 (a duplicate of E5005) → E5002 → E5001.

JSON: {"parent": "E5001"}

✅ D1 sql run 5 graded by code · query session

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"}

✅ D2 sql+markdown run 1 graded by code · query session

E5001.

JSON: {"parent": "E5001"}

✅ D2 sql+markdown run 2 graded by code · query session

E5001.

JSON: {"parent": "E5001"}

✅ D2 sql+markdown run 3 graded by code · query session

E5001. The chain from Cerid Rosor Holdings SA to the top is 6 levels.

JSON: {"parent": "E5001"}

✅ D2 sql+markdown run 4 graded by code · query session

E5001. The chain from E5047 reaches E5001 at depth 6.

JSON: {"parent": "E5001"}

✅ D2 sql+markdown run 5 graded by code · query session

E5001.

JSON: {"parent": "E5001"}

✅ D4 sparql run 1 graded by code · query session

E5001. The chain is E5047 → E5035 → E5023 → E5011 → E5167 → E5001, and E5167 is a research-system duplicate of E5001 (same LEI).

JSON: {"parent": "E5001"}

✅ D4 sparql run 2 graded by code · query session

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"}

❌ D4 sparql run 3 graded by code · query session

(no answer found)

JSON: {"parent": null}

Why: parent: expected E5001, got None

❌ D4 sparql run 4 graded by code · query session

E5167. The chain is E5047 → E5035 → E5023 → E5011 → E5167.

JSON: {"parent": "E5167"}

Why: parent: expected E5001, got E5167

❌ D4 sparql run 5 graded by code · query session

E5167.

JSON: {"parent": "E5167"}

Why: parent: expected E5001, got E5167

❌ D5 sparql+ontology run 1 graded by code · query session

(no answer found)

JSON: {"parent": null}

Why: parent: expected E5001, got None

❌ D5 sparql+ontology run 2 graded by code · query session

E5167. The chain from E5047 runs through E5035, E5023 and E5011 to E5167.

JSON: {"parent": "E5167"}

Why: parent: expected E5001, got E5167

✅ D5 sparql+ontology run 3 graded by code · query session

E5001. Following the parent chain through E5167, which shares its LEI with E5005, leads to E5002 and then E5001.

JSON: {"parent": "E5001"}

✅ D5 sparql+ontology run 4 graded by code · query session

E5001.

JSON: {"parent": "E5001"}

✅ D5 sparql+ontology run 5 graded by code · query session

E5001. The chain is E5047, E5035, E5023, E5011, E5167 (same LEI as E5005), E5002, E5001.

JSON: {"parent": "E5001"}

✅ D3 sql+executed run 1 graded by code · query session

E5001.

JSON: {"parent": "E5001"}

✅ D3 sql+executed run 2 graded by code · query session

E5001 (Cerid Group plc).

JSON: {"parent": "E5001"}

✅ D3 sql+executed run 3 graded by code · query session

E5001.

JSON: {"parent": "E5001"}

✅ D3 sql+executed run 4 graded by code · query session

E5001. The ancestors table shows E5001 at 6 levels up from E5047.

JSON: {"parent": "E5001"}

✅ D3 sql+executed run 5 graded by code · query session

E5001.

JSON: {"parent": "E5001"}

✅ D6 sparql+axioms run 1 graded by code · query session

E5001.

JSON: {"parent": "E5001"}

✅ D6 sparql+axioms run 2 graded by code · query session

E5001.

JSON: {"parent": "E5001"}

✅ D6 sparql+axioms run 3 graded by code · query session

E5001 (Cerid Group plc).

JSON: {"parent": "E5001"}

❌ D6 sparql+axioms run 4 graded by code · query session

(no answer found)

JSON: {"parent": null}

Why: parent: expected E5001, got None

✅ D6 sparql+axioms run 5 graded by code · query session

E5001.

JSON: {"parent": "E5001"}