4 ms·
I short SPARQL query on wikidata would answer this
by brokensegue 5y ago
I short SPARQL query on wikidata would answer this
- zaik 5y agoHere is how such a SPARQL query could look like: https://w.wiki/54W6 https://w.wiki/54W6 EDIT: Excluding pornographic actors: https://w.wiki/54W8 https://w.wiki/54W8
- techdragon 5y agoI’d managed to forget how much I hate SPARQL. I really wanted to love wikidata but SPARQL ruined it for me.
- tuukkah 5y agoYou don't have to use SPARQL. For example, you could download a data dump and run Cypher queries using the Knowledge Graph Toolkit: https://github.com/usc-isi-i2/kgtk https://github.com/usc-isi-i2/kgtk
- tuukkah 5y agoVirtuoso can execute the query with an ORDER BY instead of LIMIT: https://wikidata.demo.openlinksw.com/sparql/?default-graph-uri=http%3A%2F%2Fwww.wikidata.org%2F&qtxt=select%20distinct%20%3Fitem%20%3FsiteLinks%20where%20%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ5.%20%23only%20humans%0A%20%20%3Fdocument%20schema%3Aabout%20%3Fitem.%0A%20%20%3Fdocument%20wikibase%3Asitelinks%20%3FsiteLinks.%0A%20%20filter%20(%3FsiteLinks%20%3E%2010).%0A%20%20filter%20not%20exists%20%7B%0A%20%20%20%20%3Farticle%20schema%3Aabout%20%3Fitem%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fen.wikipedia.org%2F%3E.%0A%20%20%7D%0A%20%20filter%20not%20exists%20%7B%20%3Fitem%20wdt%3AP106%20wd%3AQ488111.%20%7D%20%20%20%0A%7D%0Aorder%20by%20DESC(%3FsiteLinks)&format=text%2Fhtml&timeout=0&signal_void=on https://wikidata.demo.openlinksw.com/sparql/?default-graph-u... Top three: 1. Italian photographer https://www.wikidata.org/wiki/Q29419 https://www.wikidata.org/wiki/Q29419 2. German artist https://www.wikidata.org/wiki/Q88292 https://www.wikidata.org/wiki/Q88292 3. Indian writer https://www.wikidata.org/wiki/Q1053173 https://www.wikidata.org/wiki/Q1053173