Q50, run 2026-11-05-1515-sonnet-query
How many levels of ownership separate Cerid Rosor Holdings SA from its ultimate parent?
Tests: Paths: the length of the chain, counted across the RESEARCH record.
Expected: count = 6
sql run 1
4. E5047 sits four levels below E5167.
JSON: {"count": 4}
Why: count: expected 6, got 4
sql run 2
6.
JSON: {"count": 6}
sql run 3
6. E5047 sits at depth 6 below E5001.
JSON: {"count": 6}
sql run 4
6 levels.
**Q51–Q52.** The Cerid group has 59 entities and the Rotam group has 19.
JSON: {"count": 6}
sql run 5
6 levels (E5035, E5023, E5011, E5005, E5002, E5001).
JSON: {"count": 6}
sql+markdown run 1
6.
JSON: {"count": 6}
sql+markdown run 2
6 levels. The chain is E5035, E5023, E5011, E5005, E5002, E5001.
JSON: {"count": 6}
sql+markdown run 3
6.
JSON: {"count": 6}
sql+markdown run 4
6.
JSON: {"count": 6}
sql+markdown run 5
6.
JSON: {"count": 6}
sparql run 1
4 levels, because E5167 is the same entity as E5001 and adds no level.
JSON: {"count": 4}
Why: count: expected 6, got 4
sparql run 2
6 levels, counting E5167 as the same legal entity as E5005.
JSON: {"count": 6}
sparql run 3
(no answer found)
JSON: {"count": null}
Why: count: expected 6, got None
sparql run 4
4.
JSON: {"count": 4}
Why: count: expected 6, got 4
sparql run 5
4. The chain is E5047, E5035, E5023, E5011, E5167.
JSON: {"count": 4}
Why: count: expected 6, got 4
sparql+ontology run 1
(no answer found)
JSON: {"count": null}
Why: count: expected 6, got None
sparql+ontology run 2
4 levels, via E5035, E5023 and E5011 to E5167.
JSON: {"count": 4}
Why: count: expected 6, got 4
sparql+ontology run 3
6 (E5035, E5023, E5011, E5005, E5002, E5001).
JSON: {"count": 6}
sparql+ontology run 4
6. The chain is E5047, E5035, E5023, E5011, E5167 (same LEI as E5005), E5002, E5001.
JSON: {"count": 6}
sparql+ontology run 5
6 levels.
JSON: {"count": 6}
sql+executed run 1
6 levels (ancestors table: E5047 to E5001).
JSON: {"count": 6}
sql+executed run 2
6 levels, from the ancestors table (E5001 is at level 6 above E5047).
JSON: {"count": 6}
sql+executed run 3
6 levels, from the ancestors table.
JSON: {"count": 6}
sql+executed run 4
6.
JSON: {"count": 6}
sql+executed run 5
6 levels.
JSON: {"count": 6}
sparql+axioms run 1
6. The chain is E5047, E5035, E5023, E5011, E5005 (E5167 is a duplicate record of E5005), E5002, E5001.
JSON: {"count": 6}
sparql+axioms run 2
6 levels: E5047 → E5035 → E5023 → E5011 → E5005 → E5002 → E5001.
JSON: {"count": 6}
sparql+axioms run 3
6. The chain is E5035, E5023, E5011, E5005 (same entity as E5167), E5002, E5001.
JSON: {"count": 6}
sparql+axioms run 4
(no answer found)
JSON: {"count": null}
Why: count: expected 6, got None
sparql+axioms run 5
6 levels.
JSON: {"count": 6}