User:GranD

SPARQL

• Произведения Стругацких:

  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!