Q57, run 2026-11-05-1515-sonnet-query
Which is the nearest entity that Cerid Guven Energy SA and Cerid Telecom SA both have in their chains of parents?
Tests: Paths: the nearest common ancestor, below the top of the group.
Expected: entity = E5002
sql run 1
None can be given. E5011 sits under the root E5167 and E5013 under the root E5001, so the data shows no shared parent.
JSON: {"entity": "none"}
Why: entity: expected E5002, got none
sql run 2
E5002, Cerid Energy plc. It is the first parent in both chains.
JSON: {"entity": "E5002"}
sql run 3
E5002. It is the nearest common ancestor, two levels above both E5011 and E5013.
JSON: {"entity": "E5002"}
sql run 4
E5002. Both entities sit three levels below E5001, and E5002 is the nearest shared ancestor.
JSON: {"entity": "E5002"}
sql run 5
E5002 (Cerid Energy plc). E5011 reaches it through E5167/E5005, and E5013 through E5006.
JSON: {"entity": "E5002"}
sql+markdown run 1
E5002. E5011 goes via E5005 to E5002, and E5013 goes via E5006 to E5002.
JSON: {"entity": "E5002"}
sql+markdown run 2
E5002. It is the nearest shared ancestor of E5011 and E5013.
JSON: {"entity": "E5002"}
sql+markdown run 3
E5002, 2 levels above each of them.
JSON: {"entity": "E5002"}
sql+markdown run 4
E5002. Both E5011 and E5013 reach it at 2 levels up; the next shared ancestor is E5001.
JSON: {"entity": "E5002"}
sql+markdown run 5
E5002 (Cerid Energy plc). It is 2 levels above E5011, and E5001 is the next common ancestor.
JSON: {"entity": "E5002"}
sparql run 1
E5001. E5011's parent is E5167, which is an alias of E5001, and E5013's chain (E5006 → E5002) also ends at E5001.
JSON: {"entity": "E5001"}
Why: entity: expected E5002, got E5001
sparql run 2
E5002, via E5011 → E5167 (= E5005) → E5002 and E5013 → E5006 → E5002.
JSON: {"entity": "E5002"}
sparql run 3
(no answer found)
JSON: {"entity": null}
Why: entity: expected E5002, got None
sparql run 4
None. E5011 reaches only E5167 above it, while E5013 reaches E5006, E5002 and E5001.
JSON: {"entity": "none"}
Why: entity: expected E5002, got none
sparql run 5
None. E5011's chain ends at E5167, while E5013's chain runs through E5006, E5002 and E5001, so there is no common ancestor.
JSON: {"entity": "none"}
Why: entity: expected E5002, got none
sparql+ontology run 1
(no answer found)
JSON: {"entity": null}
Why: entity: expected E5002, got None
sparql+ontology run 2
E5001. E5011's chain ends at E5167 and E5013's chain ends at E5001, so they share no ancestor. I put E5001 for the Cerid pair, but this does not hold strictly, and the question may rest on a premise the data doesn't support.
JSON: {"entity": "E5001"}
Why: entity: expected E5002, got E5001
sparql+ontology run 3
E5002. Cerid Guven Energy goes via E5167≡E5005 to E5002, and Cerid Telecom goes via E5006 to E5002.
JSON: {"entity": "E5002"}
sparql+ontology run 4
E5002. It is the first shared ancestor of E5011 and E5013.
JSON: {"entity": "E5002"}
sparql+ontology run 5
E5002. E5011 reaches it via E5167 (same entity as E5005), and E5013 reaches it via E5006.
JSON: {"entity": "E5002"}
sql+executed run 1
E5002. It is the nearest ancestor shared by E5011 (2 levels up) and E5013 (2 levels up).
JSON: {"entity": "E5002"}
sql+executed run 2
E5002 (Cerid Energy plc). E5011's chain runs E5005, E5002, E5001 and E5013's runs E5006, E5002, E5001.
JSON: {"entity": "E5002"}
sql+executed run 3
E5002, two levels above both E5011 and E5013.
JSON: {"entity": "E5002"}
sql+executed run 4
E5002. Both entities have it as a parent 2 levels up.
JSON: {"entity": "E5002"}
sql+executed run 5
E5002 (Cerid Energy plc).
JSON: {"entity": "E5002"}
sparql+axioms run 1
E5002.
JSON: {"entity": "E5002"}
sparql+axioms run 2
E5002 (Cerid Energy plc).
JSON: {"entity": "E5002"}
sparql+axioms run 3
E5002 (Cerid Energy plc).
JSON: {"entity": "E5002"}
sparql+axioms run 4
(no answer found)
JSON: {"entity": null}
Why: entity: expected E5002, got None
sparql+axioms run 5
E5002.
JSON: {"entity": "E5002"}