Q59, run 2026-11-05-1515-sonnet-query
How many entities in the Cerid Group plc group sit exactly three levels below the top?
Tests: Paths: depth in the tree, across the RESEARCH record.
Expected: count = 12
sql run 1
11.
JSON: {"count": 11}
Why: count: expected 12, got 11
sql run 2
12.
JSON: {"count": 12}
sql run 3
12.
JSON: {"count": 12}
sql run 4
12.
JSON: {"count": 12}
sql run 5
12.
JSON: {"count": 12}
sql+markdown run 1
12.
JSON: {"count": 12}
sql+markdown run 2
12.
JSON: {"count": 12}
sql+markdown run 3
12.
JSON: {"count": 12}
sql+markdown run 4
12.
JSON: {"count": 12}
sql+markdown run 5
12.
JSON: {"count": 12}
sparql run 1
12, estimated from the tree structure. The 12 are E5012–E5022 (11 entities) plus E5035, which I count one level higher because E5011 hangs off E5167. I could not confirm this against the full 167-member group.
JSON: {"count": 12}
sparql run 2
12. There are 11 via direct parent links, plus E5011 reached via the E5167/E5005 duplicate.
JSON: {"count": 12}
sparql run 3
(no answer found)
JSON: {"count": null}
Why: count: expected 12, got None
sparql run 4
11.
JSON: {"count": 11}
Why: count: expected 12, got 11
sparql run 5
11.
JSON: {"count": 11}
Why: count: expected 12, got 11
sparql+ontology run 1
(no answer found)
JSON: {"count": null}
Why: count: expected 12, got None
sparql+ontology run 2
(no answer found)
JSON: {"count": null}
Why: count: expected 12, got None
sparql+ontology run 3
Not determined.
JSON: {"count": 0}
Why: count: expected 12, got 0
sparql+ontology run 4
12.
JSON: {"count": 12}
sparql+ontology run 5
12.
JSON: {"count": 12}
sql+executed run 1
12.
JSON: {"count": 12}
sql+executed run 2
12.
JSON: {"count": 12}
sql+executed run 3
12.
JSON: {"count": 12}
sql+executed run 4
12.
JSON: {"count": 12}
sql+executed run 5
12.
JSON: {"count": 12}
sparql+axioms run 1
12 (E5011 to E5022).
JSON: {"count": 12}
sparql+axioms run 2
12.
JSON: {"count": 12}
sparql+axioms run 3
12.
JSON: {"count": 12}
sparql+axioms run 4
(no answer found)
JSON: {"count": null}
Why: count: expected 12, got None
sparql+axioms run 5
11, uncertain.
JSON: {"count": 11}
Why: count: expected 12, got 11