Open main menu

My workEdit

DoneEdit

HelpEdit

To doEdit

Regular worksEdit

Схема для городаEdit

Смена фамилии или имениEdit

СерииEdit

InterestingEdit

LexicographyEdit

SELECT ?item ?itemLabel (GROUP_CONCAT(DISTINCT ?cct2l; SEPARATOR = ", ") AS ?langs) (GROUP_CONCAT(DISTINCT ?cctl; SEPARATOR = ", ") AS ?other) WHERE {
  ?item wdt:P971/wdt:P279* wd:Q24905.
  OPTIONAL {
    ?item wdt:P971 ?cct.
    ?cct rdfs:label ?cctl.
    FILTER(?cct != wd:Q24905)
    FILTER(NOT EXISTS { ?cct wdt:P220 _:b0. })
    FILTER((LANG(?cctl)) = "ru")
  }
  OPTIONAL {
    ?item wdt:P971 ?cct2.
    ?cct2 wdt:P220 _:b1.
    ?cct2 rdfs:label ?cct2l.
    FILTER((LANG(?cct2l)) = "ru")
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "ru,[AUTO_LANGUAGE],en,fr". }
}
GROUP BY ?item ?itemLabel
ORDER BY ?langs ?other ?itemLabel ?item

Try it!

SELECT ?item ?itemLabel (GROUP_CONCAT(DISTINCT ?cct2l; SEPARATOR = ", ") AS ?langs) (GROUP_CONCAT(DISTINCT ?cctl; SEPARATOR = ", ") AS ?other) WHERE {
  ?item wdt:P971/wdt:P279* wd:Q1084 .
  OPTIONAL {
    ?item wdt:P971 ?cct.
    ?cct rdfs:label ?cctl.
    FILTER(?cct != wd:Q1084 )
    FILTER(NOT EXISTS { ?cct wdt:P220 _:b0. })
    FILTER((LANG(?cctl)) = "ru")
  }
  OPTIONAL {
    ?item wdt:P971 ?cct2.
    ?cct2 wdt:P220 _:b1.
    ?cct2 rdfs:label ?cct2l.
    FILTER((LANG(?cct2l)) = "ru")
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "ru,[AUTO_LANGUAGE],en,fr". }
}
GROUP BY ?item ?itemLabel
ORDER BY ?langs ?other ?itemLabel ?item

Try it!

CategoriesEdit

ToolsEdit

Constraint violations to checkEdit

https://angryloki.github.io/wikidata-constraint-violations/

Wikidata:Database reports/Constraint violations/All properties. Wikidata:Database reports/Constraint violations/Summary

QueriesEdit

... and some genealogyEdit

Authority control

LinksEdit