query-18428bea84748212f1cb6dbe4e147f1c
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT * WHERE {
{
SELECT ?item (SUM(?x) AS ?i) WHERE {
{
SELECT DISTINCT ?item WHERE { ?item wdt:P279 wd:Q18602249 }
}.
{
SELECT (?item AS ?item2) WHERE { INCLUDE %all }
}.
BIND( IF( STR( ?item ) > STR( ?item2 ), 1, 0 ) AS ?x ) .
} GROUP BY ?item
}.
{
SELECT (COUNT(*) AS ?count) { {
SELECT DISTINCT ?item WHERE { ?item wdt:P279 wd:Q18602249 }
}}
}.
BIND( FLOOR( RAND() * ?count ) AS ?rnd ) .
FILTER( ?rnd = ?i ) .
}