User:Lockal

From Wikidata
Jump to: navigation, search
Babel user information
ru-N Для этого участника русский язык является родным.
en-3 This user has advanced knowledge of English.
Logo fourth Wikidata Birthday cropped.png This user is celebrating Wikidata's 4th birthday.
Users by language

Wikipedia and Wikidata editor

Statements[edit]

instance of human (Q5)
sex or gender male (Q6581097)
native language Russian (Q7737)
field of work computer programming (Q80006)
programming language Python (Q28865)
C++ (Q2407)

Полезные ссылки под рукой[edit]

Queries[edit]

Items without P31 or P279[edit]

select ?item ?itemLabel {
  ?article schema:about ?item ; schema:inLanguage "ru" .
  filter (substr(str(?article), 1, 16) = "https://ru.wikip")
  minus { ?item wdt:P31 [] . }
  minus { ?item wdt:P279 [] . }
  minus { ?item wdt:P361 [] . }
  optional {
    ?item rdfs:label ?itemLabel .
    filter (lang(?itemLabel) = "ru")
  }
} limit 200

Try it!

Most commonly used external ids for genderless japanese people[edit]

select ?propertyLabel (count(?propertyLabel) as ?cnt)
  with {
    select ?item { ?item wdt:P31 wd:Q5 ; wdt:P27 wd:Q17 optional {?item wdt:P21 ?gender} filter (!bound(?gender)) }
  } as %items
{
  ?property wikibase:claim ?propertyclaim .
  ?item ?propertyclaim [] .
  ?property wikibase:propertyType wikibase:ExternalId .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }

  INCLUDE %items
}
group by ?propertyLabel
order by desc(?cnt)
limit 20

Try it!