Q7, run 2026-11-06-0519-sonnet-query
How many research works has Mara Ellison authored?
Tests: Everything at once: identity, versions (W02 is W03), document types (W04, W05) and the delisted source (W07).
Expected: count = 19
sql run 1
23 distinct research works. I counted articles, reviews and preprints, merged preprints into their published versions, and kept retracted works.
JSON: {"count": 23}
Why: count: expected 19, got 23
sql run 2
22. Of her 32 works, the other 10 are 3 editorials, 3 errata, 3 preprints and the retracted W374.
JSON: {"count": 22}
Why: count: expected 19, got 22
sql run 3
23 articles, with no reviews. This includes the retracted W374.
JSON: {"count": 23}
Why: count: expected 19, got 23
sql run 4
22. This is her 32 works minus the 6 editorials/errata, the retracted W374, the preprints W612 and W663 (versions of W869 and W464), and W02 (version of W03).
JSON: {"count": 22}
Why: count: expected 19, got 22
sql run 5
23 research works (ART and REV) under her ORCID.
JSON: {"count": 23}
Why: count: expected 19, got 23
sql+markdown run 1
19.
JSON: {"count": 19}
sql+markdown run 2
19.
JSON: {"count": 19}
sql+markdown run 3
5. The research works are W01, W09, W10, W11 and W12; W04 and W06 are not research output.
JSON: {"count": 5}
Why: count: expected 19, got 5
sql+markdown run 4
29, counting each preprint and its published version once.
JSON: {"count": 29}
Why: count: expected 19, got 29
sql+markdown run 5
19.
JSON: {"count": 19}
sql+executed run 1
19.
JSON: {"count": 19}
sql+executed run 2
19 research works for Mara Ellison (A01).
JSON: {"count": 19}
sql+executed run 3
19 research works for A01.
JSON: {"count": 19}
sql+executed run 4
19.
JSON: {"count": 19}
sql+executed run 5
19 research works for A01.
JSON: {"count": 19}
sparql run 1
22. This is her ART and REV works, excluding the retracted W374 and counting the preprints W02, W612 and W663 with their published versions.
JSON: {"count": 22}
Why: count: expected 19, got 22
sparql run 2
23. By ORCID that is 20 + 2 CRIS + 1 retracted article, as the query returned them.
JSON: {"count": 23}
Why: count: expected 19, got 23
sparql run 3
22. This is 25 research records (types ART, REV or PPR, not retracted), less 3 preprint duplicates (W02, W663, W612).
JSON: {"count": 22}
Why: count: expected 19, got 22
sparql run 4
22. This counts articles and reviews that are not retracted and not staging records. It excludes the retracted W374 and the non-research types.
JSON: {"count": 22}
Why: count: expected 19, got 22
sparql run 5
17, from A01, A02 and A03 (A101 not counted).
JSON: {"count": 17}
Why: count: expected 19, got 17
sparql+ontology run 1
19. This is the count of her research works credited to I02, and her full tally may be higher because the result was truncated.
JSON: {"count": 19}
sparql+ontology run 2
19.
JSON: {"count": 19}
sparql+ontology run 3
19. This is the research works across A01, A02, A03 and A101, with the preprint counted under its published version.
JSON: {"count": 19}
sparql+ontology run 4
19. I counted from the visible rows. I excluded the editorials, errata, retracted works and K0-source works, and merged each preprint into its published version.
JSON: {"count": 19}
sparql+ontology run 5
19. This is her 32 works minus 3 editorials (W04, W271, W936), 3 errata (W05, W813, W949), 1 retracted (W374), 3 in K0 sources (W07, W449, W763), and 3 preprints that merge into their published versions (W02, W612, W663).
JSON: {"count": 19}