Q48, run 2026-11-06-0519-sonnet-query
Why is W70 not one of the University of Albury's research works, though its author lists the Tessel Laboratory?
Tests: Local rules: the last-listed affiliation, and affiliated institutes.
Expected: Tomasz Wierzba lists the Tessel Laboratory first and the Halloran Institute second; the house rule credits the last-listed one, Halloran. Halloran is an affiliated institute (AFF): its parent link is an agreement, so its works are not the University of Albury's.
sql run 1
The premise doesn't hold in the data. W70's primary affiliation I04 sits under I03, I02 and I01, so W70 does count towards the University of Albury (I02), and I could not find any rule that excludes it.
Why: Rejects the premise and says W70 counts for Albury; the key says only the last-listed affiliation counts, crediting Halloran Institute, an affiliated institute not rolling up to Albury
sql run 2
The premise looks wrong. I04 sits under I03, which sits under I02, so W70 should count for the University of Albury.
Why: Claims W70 should count for Albury; misses that only the last-listed affiliation (Halloran Institute) counts and that it is an affiliated institute, not a unit.
sql run 3
The data doesn't support the premise. W70 is credited to I04 (Tessel Laboratory), and I04 sits under I03, I02 and I01, so W70 does count towards I02's output. Excluding it would need a rule such as excluding the second-listed affiliation I06, but nothing in the data states that rule.
Why: Rejects the premise and misses both points: the last-listed affiliation rule and Halloran being an affiliated institute, not a unit
sql run 4
The premise doesn't hold in this data. W70 is credited to I04, which sits under I03 and I02, so it counts as a University of Albury work.
Why: Contradicts the key: W70 is not a University of Albury work because the last-listed affiliation (Halloran Institute) is credited, and that institute is affiliated, not a unit, so it doesn't roll up.
sql run 5
The data doesn't support the premise. W70 lists I04, which rolls up through I03 to I02, so it should count as a University of Albury work.
Why: Rejects the premise and says W70 counts for Albury; the checklist says only the last-listed affiliation counts (Halloran Institute), and that institute is affiliated, not a unit, so it does not roll up.
sql+markdown run 1
W70's credited affiliation is the last one listed, I06, the Halloran Institute. It is an affiliated institute (AFF), so it is not a unit of I02, and the Tessel Laboratory (I04) listed first is ignored.
sql+markdown run 2
W70's author lists the Tessel Laboratory (I04), but the credited affiliation is the one with the highest affiliation sequence, which is I06. I06 is an affiliated institute (AFF), so its parent link to I02 does not make W70 a University of Albury work.
sql+markdown run 3
Only A08's last-listed affiliation counts, and on W70 that is I06 (sequence 2), not I04. I06 is an affiliated institute (AFF), so its works are never credited to I02.
sql+markdown run 4
W70's author listed I04 first and I06 second, and only the last-listed affiliation counts, so W70 is credited to I06. I06 is an affiliated institute, so its works are never credited to I02.
sql+markdown run 5
W70's author lists I04 (under I02) at sequence 1 and I06 at sequence 2. Only the last-listed affiliation is credited, so W70 is credited to I06. I06 is an affiliated institute, so its works never roll up to I02.
sql+executed run 1
W70 is credited to I06 (the Halloran Institute, an affiliate), not I04. Affiliates do not roll up to I02 in institution_units.
Why: It says W70 is credited to the Halloran Institute and that affiliates don't roll up to the University of Albury. It omits the rule that only the last-listed affiliation counts.
sql+executed run 2
W70's author is credited to I06, an affiliate whose institution_units row counts only towards itself. I06's works do not roll up to I02, unlike I04 (Tessel), which does roll up.
Why: Says the author is credited to I06 (Halloran), an affiliate that doesn't roll up to I02, but omits that only the last-listed affiliation counts.
sql+executed run 3
W70 is credited to I06, which is an affiliate with no counts_towards link to I02. Its works therefore do not roll up to the University of Albury.
Why: Gives the affiliate/no roll-up point and the credit to I06, but omits that only the last-listed affiliation counts.
sql+executed run 4
I06 is an affiliate, so it does not count towards I02. W70 is credited to I06, not to I04, which would roll up to I02.
Why: Says the work is credited to the affiliate I06, which doesn't roll up to I02, but never states that only the last-listed affiliation counts.
sql+executed run 5
W70's credit goes to I06, the Halloran Institute, which is an affiliate with no roll-up to I02. The Tessel Laboratory (I04) is credited only on W71.
Why: Says the Halloran Institute is an affiliate with no roll-up to the University, but does not state that only the last-listed affiliation counts
sparql run 1
The data does not show that W70 is excluded. I04 sits under I03, which sits under I02, and W70 is a non-retracted 2023 article, so it should count for the University of Albury. If it is excluded, the data I queried does not say why.
Why: Denies that W70 is excluded and misses both points: only the last-listed affiliation counts (Halloran Institute) and Halloran is an affiliated institute, not a unit, so it doesn't roll up.
sparql run 2
Not determined. The data shows W70 credited to I04 and I06, both under I02.
Why: Answer does not state the last-listed-affiliation rule or that Halloran is an affiliated institute not rolling up; it only says not determined.
sparql run 3
Not resolved from the data. W70 lists I04 and I06, so the exclusion may come from I06's affiliate type (itype-AFF) or from how unit membership is defined, but I could not confirm either.
Why: Does not state the last-listed-affiliation rule or that the Halloran Institute is an affiliate, not a unit, so its works don't roll up; it only guesses at the itype-AFF exclusion and admits it is unconfirmed.
sparql run 4
The data I retrieved does not show it. W70 is a non-retracted 2023 article, and its authorships list I04 and I06, both under I02, so I could not confirm the reason.
Why: Does not state the last-listed-affiliation rule or Halloran Institute being an affiliated institute, not a unit; says reason could not be confirmed
sparql run 5
(no answer found)
Why: No answer given; meets none of the checklist points
sparql+ontology run 1
A08 listed I06 last for W70, so the work is credited to I06 only. I06 is an affiliated institute, so the credit does not pass up to I02, and the I04 affiliation is ignored.
sparql+ontology run 2
For the author of W70, the house rule credits only the highest-sequence affiliation, which is I06. I06 is an affiliated institute, so its parent link does not credit I02.
sparql+ontology run 3
W70's author A08 listed I04 at sequence 1 and I06 at sequence 2, so only I06 is credited. I06 is an affiliated institute (AFF), which does not roll up to I02.
sparql+ontology run 4
W70's author listed I04 (sequence 1) and I06 (sequence 2). Only the last-listed affiliation, I06, is credited. I06 is an affiliated institute, so its work is never credited to I02.
sparql+ontology run 5
A08's credited affiliation on W70 is the last-listed one, I06, which is an affiliated institute. Its parent link to I02 is not membership, so the work is not credited to I02. The Tessel Laboratory (I04) was listed first and is ignored.