[Wikidata-bugs] [Maniphest] [Created] T197598: MWAPI query with LIMIT ignores MINUS

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE created this task. Lucas_Werkmeister_WMDE added projects: Wikidata, Wikidata-Query-Service. Herald added a subscriber: Aklapper. Herald added a project: Discovery.

TASK DESCRIPTION

@Daniel_Mietchen wanted to find scientific articles about the Zika virus without a corresponding “main subject” statement. This query (link) does the job:

SELECT DISTINCT ?item WHERE {
  hint:Query hint:optimizer "None".
  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "zika haswbstatement:P31=Q13442814".
    ?title wikibase:apiOutput mwapi:title.
  }
  BIND(IRI(CONCAT(STR(wd:), ?title)) AS ?item)
  MINUS { ?item wdt:P921 wd:Q202864. }
}

(It now only returns very few results, because @Daniel_Mietchen added the missing “main subjects” statements with QuickStatements. Originally it was a bit over 150 items.)

However, when you add some LIMIT (link), the query suddenly returns many more results – it seems like the MINUS is being ignored for some reason.

TASK DETAIL

https://phabricator.wikimedia.org/T197598

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Lucas_Werkmeister_WMDE
Cc: Smalyshev, Lucas_Werkmeister_WMDE, Daniel_Mietchen, Aklapper, Lahi, Gq86, Darkminds3113, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs