User:Jedudedek

#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).
 }

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". }
}