Lucas_Werkmeister_WMDE added a comment.
@EgonWillighagen the `rangeSafe` hint only helps when there is a `FILTER`, not with `ORDER BY`. This completes within three seconds: SELECT ?wikis ?compound WHERE { ?compound wdt:P31 wd:Q11173 ; wikibase:sitelinks ?wikis . hint:Prior hint:rangeSafe true . FILTER(?wikis >= 50) FILTER(NOT EXISTS {?compound wdt:P2119 []}) } ORDER BY DESC(?wikis) LIMIT 100 (Though I had to make a few tries before I determined `>= 50` as the threshold; `> 50` only produced 98 results, so you may want to use a slightly lower limit to ensure you always get 100 results back.) TASK DETAIL https://phabricator.wikimedia.org/T175380 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Smalyshev, Lucas_Werkmeister_WMDE Cc: EgonWillighagen, Aklapper, Smalyshev, Lucas_Werkmeister_WMDE, darthmon_wmde, ET4Eva, Nandana, Lahi, Gq86, Darkminds3113, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, _jensen, rosalieper, Scott_WUaS, 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