Q50, run 2026-11-04-2024-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
6.
JSON: {"count": 6}
sql run 2
4.
JSON: {"count": 4}
Why: count: expected 6, got 4
sql run 3
4 levels.
JSON: {"count": 4}
Why: count: expected 6, got 4
sql+markdown run 1
1. E5010 sits directly under E5002.
JSON: {"count": 1}
Why: count: expected 6, got 1
sql+markdown run 2
6.
JSON: {"count": 6}
sql+markdown run 3
6 levels.
JSON: {"count": 6}
sparql run 1
(no answer found)
JSON: {"count": 0}
Why: count: expected 6, got 0
sparql run 2
6. The chain is E5047, E5035, E5023, E5011, E5005 (E5167), E5002, E5001.
JSON: {"count": 6}
sparql run 3
(no answer found)
JSON: {"count": 0}
Why: count: expected 6, got 0
sparql+ontology run 1
6 levels.
JSON: {"count": 6}
sparql+ontology run 2
6 levels: E5035, E5023, E5011, E5167/E5005, E5002, E5001.
JSON: {"count": 6}
sparql+ontology run 3
5.
JSON: {"count": 5}
Why: count: expected 6, got 5
sql+executed run 1
6 levels (E5047 to E5001 in the ancestors table).
JSON: {"count": 6}
sql+executed run 2
6 levels (ancestors table, E5047 to E5001).
JSON: {"count": 6}
sql+executed run 3
6. The ancestors table puts E5001 at levels_up = 6 from E5047.
JSON: {"count": 6}
sparql+axioms run 1
6 levels: E5047, E5035, E5023, E5011, E5005, E5002, E5001.
JSON: {"count": 6}
sparql+axioms run 2
(no answer found)
JSON: {"count": 3}
Why: count: expected 6, got 3
sparql+axioms run 3
6 levels, treating E5005 and E5167 as the same entity.
JSON: {"count": 6}