Bigbossfarin

Bigboss

About me Hi, I am Bigboss. For my intrests see my German user page in the Wikipedia, I'm active on Wiktionary as well. Babel user information de-N Dieser Benutzer spricht Deutsch als Muttersprache. en-3 This user has advanced knowledge of English. la-2 Hic usor lingua Latina mediae difficultatis conferre potest. fr-1 Cet utilisateur dispose de connaissances de base en français. swg-1 This user has basic knowledge of Swabian. Users by language This user has created a global account. Bigbossfarin's main account is on Wikipedia.

My work There is no area where I am mainly working. Wikidata statistics   Number of pages 102,117,991     User total 5,468,257     Active users list 24,141     Administrators 63     Users/administrator 383

Contact me Me on openstreetmap Me on musicbrainz

SELECT ?item WHERE {
?item wikibase:sitelinks [] .
MINUS { ?item (wdt:P31|wdt:P279) [] } .
}
LIMIT 1000

Try it!

SELECT ?item
WHERE
{
  ?item wikibase:sitelinks 1 .
  MINUS { ?item (wdt:P31|wdt:P279) [] } .
  [] schema:about ?item ; schema:isPartOf <https://de.wikipedia.org/> .
}
LIMIT 100

Try it!

SELECT ?item ?itemLabel ?OpenStreetMap_Relations_ID WHERE {
  ?item wdt:P31 wd:Q3624078.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
  OPTIONAL { ?item wdt:P402 ?OpenStreetMap_Relations_ID. }
  MINUS { ?item wdt:P31 wd:Q3024240 } .
}

Try it!

SELECT ?item ?itemLabel ?ist_ein_e_Label WHERE {
  VALUES ?sitelink {
"Michael Jackson"@de
  }
  ?article schema:about ?item;
    schema:isPartOf <https://de.wikipedia.org/>;
    schema:name ?sitelink.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de,en". }
  OPTIONAL { ?item wdt:P31 ?ist_ein_e_. }
}

Try it!

SELECT ?item ?itemLabel ?Offizielle_Deutsche_Charts_Person_ID WHERE {
  ?item p:P6893 ?statement.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  OPTIONAL { ?item wdt:P10372 ?Offizielle_Deutsche_Charts_Person_ID. }
}
LIMIT 1000

Try it!

---

quickstatements

---

Offizielle-Deutsche-Charts-ID	P6893	Offizielle Deutsche Charts artist ID (former scheme) (P6893)
Offizielle Deutsche Charts Lied-ID	P8524	Offizielle Deutsche Charts song ID (P8524)
Offizielle Deutsche Charts Album-ID	P10262	Offizielle Deutsche Charts album ID (P10262)
Offizielle Deutsche Charts Person-ID	P10372	Offizielle Deutsche Charts composer ID (P10372)

Webscraper Firefox - Edit metadata - Start-URL - https://www.offiziellecharts.de/suche/person-[501-5000]