query-1685cd91f188b3d89819b7a18a0cde00

rq turtle/ttl

or not.(Q5)human statements with that value, regardless of whether the subject item is a (P734)family name . Note that the “overall prevalence in Wikidata” part just counts on Mastodon and on TwitterOriginally posted

Use at

• https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT (SAMPLE(?familyNameLabel_) AS ?familyNameLabel) ?astronauts ?items (CONCAT(SUBSTR(STR(?astronauts / ?items * 100), 1, 5), "%") AS ?percent) WHERE {
   {
  SELECT ?familyName (COUNT(DISTINCT ?astronaut) AS ?astronauts) WHERE {
    ?astronaut wdt:P31 wd:Q5;
               wdt:P450 ?mission;
               wdt:P734 ?familyName.
  }
  GROUP BY ?familyName
  HAVING(?astronauts > 1)
}
   {
  SELECT ?familyName (COUNT(*) AS ?items) WHERE {
     {
  SELECT ?familyName (COUNT(DISTINCT ?astronaut) AS ?astronauts) WHERE {
    ?astronaut wdt:P31 wd:Q5;
               wdt:P450 ?mission;
               wdt:P734 ?familyName.
  }
  GROUP BY ?familyName
  HAVING(?astronauts > 1)
}
    ?item wdt:P734 ?familyName.
  }
  GROUP BY ?familyName
}
  ?familyName wdt:P1705 ?familyNameLabel_.
}
GROUP BY ?familyName ?astronauts ?items
ORDER BY DESC(?astronauts / ?items) ?familyNameLabel

Query found at

• https://www.wikidata.org/wiki/User:TweetsFactsAndQueries/Queries/family_names_shared_by_several_astronauts_ordered_by_overall_prevalence_in_Wikidata