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
