Jedudedek

Babel user information
cs-N Tento uživatel je rodilý mluvčí češtiny. en-0 This user has no knowledge of English (or understands it with considerable difficulty). de-0 Dieser Benutzer beherrscht Deutsch nicht (oder versteht es nur mit beträchtlichen Schwierigkeiten). pl-0 Ten użytkownik nie rozumie języka polskiego (albo ma z nim olbrzymie trudności).
Users by language

Jedudedek on cs:wiki

Upper Lusatian house (Q1362233)

#defaultView:Map
 SELECT ?item ?itemLabel ?coord ?layer WHERE {
   ?item wdt:P31 wd:Q1362233.
   ?item wdt:P625 ?coord.
   ?item wdt:P17 ?country.
   SERVICE wikibase:label {
     bd:serviceParam wikibase:language "cs". 
     ?country rdfs:label ?countryLabel
   }
   BIND (?countryLabel as ?layer).
 }

Try it!

SELECT ?countryLabel ?haspic ?count WHERE {
  {
    SELECT ?country ("Σ" AS ?haspic) (COUNT(DISTINCT ?item) AS ?count) WHERE {
      ?item wdt:P31 wd:Q1362233;
        wdt:P17 ?country;
    }
    GROUP BY ?country
  }
  UNION
  {
    SELECT ?country ("s obrázkem / whit picture" AS ?haspic) (COUNT(DISTINCT ?item) AS ?count) WHERE {
      ?item wdt:P31 wd:Q1362233;
        wdt:P17 ?country;
        wdt:P18 _:b1.
    }
    GROUP BY ?country
  }
  UNION
  {
    SELECT ?country ("bez obrázku / whitout picture" AS ?haspic) (COUNT(DISTINCT ?item) AS ?count) WHERE {
      ?item wdt:P31 wd:Q1362233;
        wdt:P17 ?country.
      MINUS { ?item wdt:P18 _:b3. }
    }
    GROUP BY ?country
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs". }
}

Try it!