SPARQL edit

  • Произведения Стругацких:
    SELECT ?item ?itemLabel ?year ?isbn10 ?isbn13 WHERE {
      SERVICE wikibase:label { bd:serviceParam wikibase:language "ru,en". }
      ?item wdt:P50 wd:Q153796.
      ?item wdt:P31/wdt:P279* wd:Q386724.
      OPTIONAL { ?item wdt:P577 ?year. }
      OPTIONAL { ?item wdt:P957 ?isbn10. }
      OPTIONAL { ?item wdt:P212 ?isbn13. }
    }
    
    Try it!
  • Фамилии со ссылкой на страницы значений:
    SELECT ?surname ?surnameLabel (COUNT(?item) AS ?count)
    WHERE {
      SERVICE wikibase:label { bd:serviceParam wikibase:language "ru,en". }
      ?item wdt:P31 wd:Q5.
      ?item wdt:P734 ?surname.
    #  ?item wdt:P735 ?surname. # имя
      ?surname wdt:P31 wd:Q4167410
    }
    GROUP BY ?surname ?surnameLabel
    ORDER BY DESC(?count)
    LIMIT 100
    
    Try it!