User:Plagiat/sandbox

all-time roaster

• Items used:
  • list of 1. FFC Frankfurt players (Q1738085)
• Properties used:
  • has part(s) (P527)
  • start time (P580)
  • end time (P582)
  • series ordinal (P1545)
• Predicates
  • p:P527 entity to statement ?playerS
  • ps:P527 value to statement ?player

SELECT ?player ?playerLabel ?from ?to WHERE {
  wd:Q1738085 p:P527 ?playerS.
  ?playerS ps:P527 ?player.
  OPTIONAL { ?playerS pq:P580 ?_from. }
  OPTIONAL { ?playerS pq:P582 ?_to. }
  OPTIONAL { ?player wdt:P1545 ?sortname. }
  BIND(YEAR(?_from) AS ?from)
  BIND(YEAR(?_to) AS ?to)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}
ORDER BY ?sortname

Try it!

Fußballstadion Deutschland

# Fußballstadion Deutschland
SELECT ?stadion ?stadionLabel ?locationLabel WHERE {
  ?stadion wdt:P31/wdt:P279* wd:Q483110 .
  ?stadion wdt:P17 wd:Q183 .
  OPTIONAL { ?stadion wdt:P131 ?location }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en" . }
}
ORDER BY ?locationLabel

Try it!

?item has value

SELECT ?item ?itemLabel
WHERE
{
 ?item wdt:P31 wd:Q476028 .
  ?item wdt:P571 [] # has value
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

Try it!

Database reports

monolingual text

undetermined language

SELECT ?item ?itemLabel ?prop ( CONCAT("[[Property:", REPLACE(str(?p), "http://www.wikidata.org/prop/", ""), "]]") as ?propid ) ?propLabel ?id
    WHERE {
        hint:Query hint:optimizer "None" .

        ?prop wikibase:propertyType wikibase:Monolingualtext .
        ?prop wikibase:claim ?p .
        ?item ?p ?monolingualstatement .
        ?prop wikibase:statementProperty ?sp .
        ?monolingualstatement ?sp ?id .

        FILTER( lang(?id)="und" )
        FILTER( ?item != wd:Q22282914 )

        SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
    }
LIMIT 5000

Try it!

Ghanian politician

SELECT DISTINCT ?politican ?politicanLabel WHERE {
  ?politican	wdt:P106	wd:Q82955;
  ?country      wd:Q117 .
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}
}
ORDER BY ?politicanLabel

Try it!