query-cdc89e0e65b8f81c82870ba10e1aa18e

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?encat ?member ?item ?article (GROUP_CONCAT(DISTINCT ?class; SEPARATOR = ", ") AS ?is_a) (GROUP_CONCAT(DISTINCT ?einheit; SEPARATOR = ", ") AS ?unit) ?coordinates WHERE {
VALUES ?encat { "Category:Orkney" "Category:Transport_in_Orkney" "Category:Villages_in_Orkney" "Category:History_of_Orkney" "Category:Buildings_and_structures_in_Orkney" "Category:Sport_in_Orkney" "Category:Politics_of_Orkney" "Category:Sites_of_Special_Scientific_Interest_in_Orkney" "Category:Environment_of_Orkney" "Category:Organisations_based_in_Orkney" "Category:Orkney_stubs" "Category:People_associated_with_Orkney" "Category:Bishops_of_Aberdeen_and_Orkney" "Category:Earls_of_Orkney" "Category:Churches_in_Orkney" "Category:Castles_in_Orkney" "Category:Religion_in_Orkney" "Category:Bishops_of_Orkney" "Category:Education_in_Orkney" "Category:People_from_Orkney" "Category:Listed_buildings_in_Orkney" "Category:Deputy_Lieutenants_of_Orkney" "Category:Lord_Lieutenants_of_Orkney_and_Shetland" "Category:Lord-Lieutenants_of_Orkney" "Category:Uninhabited_islands_of_Orkney" "Category:World_War_I_warships_scuttled_at_Scapa_Flow" "Category:Parishes_of_Orkney" "Category:Sabhal_Mòr_Ostaig" "Category:Prehistoric_Orkney" "Category:People_executed_by_the_Earldom_of_Orkney" "Category:Hospitals_in_Orkney" "Category:Orcadian_culture" "Category:Archaeological_sites_in_Orkney" "Category:Tourist_attractions_in_Orkney" "Category:Orkney_geography_stubs" "Category:Towns_in_Orkney" "Category:Sports_venues_in_Orkney" "Category:Museums_in_Orkney" "Category:Gardens_in_Orkney" "Category:Protected_areas_of_Orkney" "Category:Geography_of_Orkney" "Category:Historic_house_museums_in_Orkney" "Category:Orkneyinga_saga_characters" "Category:Shapinsay" "Category:Islands_of_the_Orkney_Islands" "Category:University_of_the_Highlands_and_Islands" "Category:Companies_based_in_Orkney" "Category:Economy_of_Orkney" "Category:Burials_at_St_Magnus_Cathedral" "Category:Novels_set_in_Orkney" "Category:Lists_of_listed_buildings_in_Orkney" "Category:Historic_Scotland_properties_in_Orkney" "Category:Orkney-related_lists" "Category:Ruins_in_Orkney" "Category:Scapa_Flow" "Category:People_from_Kirkwall" "Category:Kirkwall" "Category:Houses_in_Orkney" "Category:Country_houses_in_Orkney" "Category:Populated_places_in_Orkney" "Category:Stromness" "Category:Rousay" "Category:Deans_of_Aberdeen_and_Orkney" "Category:Category_A_listed_buildings_in_Orkney" "Category:Category_B_listed_buildings_in_Orkney" "Category:Orkneyinga_saga_places" "Category:Orkneyinga_saga" "Category:Biota_of_Orkney" "Category:Orkney_navigational_boxes" "Category:Orkney_in_fiction" "Category:Members_of_the_Parliament_of_the_United_Kingdom_for_Orkney_and_Shetland" "Category:20th_century_in_Orkney" "Category:Centuries_in_Orkney" "Category:19th_century_in_Orkney" "Category:21st_century_in_Orkney" "Category:Honyman_family" "Category:Norn_language" "Category:Foula" "Category:Landforms_of_Orkney" "Category:Lochs_of_Orkney" "Category:Rivers_of_Orkney" "Category:Lakes_of_Orkney" "Category:Bays_of_Orkney" "Category:Stone_circles_in_Orkney" "Category:Academics_of_the_University_of_the_Highlands_and_Islands" "Category:Orkney_Islands_Council_elections" "Category:Lairds_of_Foula" "Category:Airports_in_Orkney" "Category:Westray" "Category:Sanday,_Orkney" "Category:Mountains_and_hills_of_Orkney" "Category:Films_set_in_Orkney" "Category:Scheduled_Ancient_Monuments_in_Orkney" "Category:Linguists_of_Norn" "Category:World_War_I_shipwrecks_in_Scapa_Flow" "Category:World_War_II_shipwrecks_in_Scapa_Flow" "Category:Shipwrecks_in_Scapa_Flow" "Category:Military_units_and_formations_in_Orkney" "Category:Rugby_union_in_Orkney" "Category:Hoy" "Category:Eday" "Category:North_Ronaldsay" "Category:Papa_Westray" "Category:Stronsay" "Category:Mainland,_Orkney" "Category:Villages_on_Mainland,_Orkney" "Category:People_associated_with_the_University_of_the_Highlands_and_Islands" "Category:Alumni_of_the_University_of_the_Highlands_and_Islands" "Category:Lighthouses_in_Orkney" "Category:Wards_of_Orkney" "Category:Football_in_Orkney" "Category:Councillors_in_Orkney" "Category:Brochs_in_Orkney" "Category:Rugby_union_players_from_the_Orkney_Islands" "Category:Rugby_league_players_from_the_Orkney_Islands" "Category:Heart_of_Neolithic_Orkney" "Category:Sportspeople_from_Orkney" "Category:Writers_from_Orkney" "Category:Category_C_listed_buildings_in_Orkney" }
  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:endpoint "en.wikipedia.org";
    wikibase:api "Generator";
    mwapi:generator "categorymembers";
    mwapi:gcmtitle ?encat;
    mwapi:gcmprop "ids%7Ctitle%7Ctype";
    mwapi:gcmlimit "max".
    ?member wikibase:apiOutput mwapi:title.
    ?ns wikibase:apiOutput "@ns".
    ?item wikibase:apiOutputItem mwapi:item.   
}
  FILTER(BOUND(?item) && ?ns = "0")
  ?article schema:about ?item;
          schema:isPartOf <https://en.wikipedia.org/>;
          schema:name ?page_title.
  OPTIONAL { ?item wdt:P31 ?instance. }
  OPTIONAL { ?item wdt:P131 ?verwaltungseinheit. }
  OPTIONAL { ?item wdt:P625 ?coordinates. }
  FILTER(!(?instance IN(wd:Q18019452, wd:Q46622, wd:Q89021600, wd:Q27971968, wd:Q152450, wd:Q40231)))
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
            ?instance rdfs:label ?class.
            ?verwaltungseinheit rdfs:label ?einheit.
  }
}
group by ?encat ?member ?item ?article ?coordinates 
order by ?encat ?member

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?article"):::projected v10("?class"):::projected v9("?coordinates"):::projected v11("?einheit"):::projected v6("?encat"):::projected v3("?instance") v12("?is_a") v4("?item"):::projected v2("?member"):::projected v5("?ns") v7("?page_title") v13("?unit") v8("?verwaltungseinheit") c25(["mwapi:item"]):::iri c23(["@ns"]):::literal c11(["en.wikipedia.org"]):::literal c28([https://en.wikipedia.org/]):::iri c9(["bd:serviceParam"]):::iri c18(["ids%7Ctitle%7Ctype"]):::literal c20(["max"]):::literal c15(["categorymembers"]):::literal c35(["#91;AUTO_LANGUAGE#93;,en"]):::literal c22(["mwapi:title"]):::iri c13(["Generator"]):::literal list0c3(["wd:Q89021600"]):::iri list0c1(["wd:Q18019452"]):::iri list0c4(["wd:Q27971968"]):::iri list0c6(["wd:Q40231"]):::iri list0c2(["wd:Q46622"]):::iri list0c5(["wd:Q152450"]):::iri list0c1 --o f0 list0c2 --o f0 list0c3 --o f0 list0c4 --o f0 list0c5 --o f0 list0c6 --o f0 f0[["not in "]] f0 --> v3 f1[["bound(?item)?ns = '0'"]] f1 --> v4 f1 --> v5 bind2[/VALUES ?encat/] bind2-->v6 bind20(["Category:Orkney"]) bind20 --> bind2 bind21(["Category:Transport_in_Orkney"]) bind21 --> bind2 bind22(["Category:Villages_in_Orkney"]) bind22 --> bind2 bind23(["Category:History_of_Orkney"]) bind23 --> bind2 bind24(["Category:Buildings_and_structures_in_Orkney"]) bind24 --> bind2 bind25(["Category:Sport_in_Orkney"]) bind25 --> bind2 bind26(["Category:Politics_of_Orkney"]) bind26 --> bind2 bind27(["Category:Sites_of_Special_Scientific_Interest_in_Orkney"]) bind27 --> bind2 bind28(["Category:Environment_of_Orkney"]) bind28 --> bind2 bind29(["Category:Organisations_based_in_Orkney"]) bind29 --> bind2 bind210(["Category:Orkney_stubs"]) bind210 --> bind2 bind211(["Category:People_associated_with_Orkney"]) bind211 --> bind2 bind212(["Category:Bishops_of_Aberdeen_and_Orkney"]) bind212 --> bind2 bind213(["Category:Earls_of_Orkney"]) bind213 --> bind2 bind214(["Category:Churches_in_Orkney"]) bind214 --> bind2 bind215(["Category:Castles_in_Orkney"]) bind215 --> bind2 bind216(["Category:Religion_in_Orkney"]) bind216 --> bind2 bind217(["Category:Bishops_of_Orkney"]) bind217 --> bind2 bind218(["Category:Education_in_Orkney"]) bind218 --> bind2 bind219(["Category:People_from_Orkney"]) bind219 --> bind2 bind220(["Category:Listed_buildings_in_Orkney"]) bind220 --> bind2 bind221(["Category:Deputy_Lieutenants_of_Orkney"]) bind221 --> bind2 bind222(["Category:Lord_Lieutenants_of_Orkney_and_Shetland"]) bind222 --> bind2 bind223(["Category:Lord-Lieutenants_of_Orkney"]) bind223 --> bind2 bind224(["Category:Uninhabited_islands_of_Orkney"]) bind224 --> bind2 bind225(["Category:World_War_I_warships_scuttled_at_Scapa_Flow"]) bind225 --> bind2 bind226(["Category:Parishes_of_Orkney"]) bind226 --> bind2 bind227(["Category:Sabhal_Mòr_Ostaig"]) bind227 --> bind2 bind228(["Category:Prehistoric_Orkney"]) bind228 --> bind2 bind229(["Category:People_executed_by_the_Earldom_of_Orkney"]) bind229 --> bind2 bind230(["Category:Hospitals_in_Orkney"]) bind230 --> bind2 bind231(["Category:Orcadian_culture"]) bind231 --> bind2 bind232(["Category:Archaeological_sites_in_Orkney"]) bind232 --> bind2 bind233(["Category:Tourist_attractions_in_Orkney"]) bind233 --> bind2 bind234(["Category:Orkney_geography_stubs"]) bind234 --> bind2 bind235(["Category:Towns_in_Orkney"]) bind235 --> bind2 bind236(["Category:Sports_venues_in_Orkney"]) bind236 --> bind2 bind237(["Category:Museums_in_Orkney"]) bind237 --> bind2 bind238(["Category:Gardens_in_Orkney"]) bind238 --> bind2 bind239(["Category:Protected_areas_of_Orkney"]) bind239 --> bind2 bind240(["Category:Geography_of_Orkney"]) bind240 --> bind2 bind241(["Category:Historic_house_museums_in_Orkney"]) bind241 --> bind2 bind242(["Category:Orkneyinga_saga_characters"]) bind242 --> bind2 bind243(["Category:Shapinsay"]) bind243 --> bind2 bind244(["Category:Islands_of_the_Orkney_Islands"]) bind244 --> bind2 bind245(["Category:University_of_the_Highlands_and_Islands"]) bind245 --> bind2 bind246(["Category:Companies_based_in_Orkney"]) bind246 --> bind2 bind247(["Category:Economy_of_Orkney"]) bind247 --> bind2 bind248(["Category:Burials_at_St_Magnus_Cathedral"]) bind248 --> bind2 bind249(["Category:Novels_set_in_Orkney"]) bind249 --> bind2 bind250(["Category:Lists_of_listed_buildings_in_Orkney"]) bind250 --> bind2 bind251(["Category:Historic_Scotland_properties_in_Orkney"]) bind251 --> bind2 bind252(["Category:Orkney-related_lists"]) bind252 --> bind2 bind253(["Category:Ruins_in_Orkney"]) bind253 --> bind2 bind254(["Category:Scapa_Flow"]) bind254 --> bind2 bind255(["Category:People_from_Kirkwall"]) bind255 --> bind2 bind256(["Category:Kirkwall"]) bind256 --> bind2 bind257(["Category:Houses_in_Orkney"]) bind257 --> bind2 bind258(["Category:Country_houses_in_Orkney"]) bind258 --> bind2 bind259(["Category:Populated_places_in_Orkney"]) bind259 --> bind2 bind260(["Category:Stromness"]) bind260 --> bind2 bind261(["Category:Rousay"]) bind261 --> bind2 bind262(["Category:Deans_of_Aberdeen_and_Orkney"]) bind262 --> bind2 bind263(["Category:Category_A_listed_buildings_in_Orkney"]) bind263 --> bind2 bind264(["Category:Category_B_listed_buildings_in_Orkney"]) bind264 --> bind2 bind265(["Category:Orkneyinga_saga_places"]) bind265 --> bind2 bind266(["Category:Orkneyinga_saga"]) bind266 --> bind2 bind267(["Category:Biota_of_Orkney"]) bind267 --> bind2 bind268(["Category:Orkney_navigational_boxes"]) bind268 --> bind2 bind269(["Category:Orkney_in_fiction"]) bind269 --> bind2 bind270(["Category:Members_of_the_Parliament_of_the_United_Kingdom_for_Orkney_and_Shetland"]) bind270 --> bind2 bind271(["Category:20th_century_in_Orkney"]) bind271 --> bind2 bind272(["Category:Centuries_in_Orkney"]) bind272 --> bind2 bind273(["Category:19th_century_in_Orkney"]) bind273 --> bind2 bind274(["Category:21st_century_in_Orkney"]) bind274 --> bind2 bind275(["Category:Honyman_family"]) bind275 --> bind2 bind276(["Category:Norn_language"]) bind276 --> bind2 bind277(["Category:Foula"]) bind277 --> bind2 bind278(["Category:Landforms_of_Orkney"]) bind278 --> bind2 bind279(["Category:Lochs_of_Orkney"]) bind279 --> bind2 bind280(["Category:Rivers_of_Orkney"]) bind280 --> bind2 bind281(["Category:Lakes_of_Orkney"]) bind281 --> bind2 bind282(["Category:Bays_of_Orkney"]) bind282 --> bind2 bind283(["Category:Stone_circles_in_Orkney"]) bind283 --> bind2 bind284(["Category:Academics_of_the_University_of_the_Highlands_and_Islands"]) bind284 --> bind2 bind285(["Category:Orkney_Islands_Council_elections"]) bind285 --> bind2 bind286(["Category:Lairds_of_Foula"]) bind286 --> bind2 bind287(["Category:Airports_in_Orkney"]) bind287 --> bind2 bind288(["Category:Westray"]) bind288 --> bind2 bind289(["Category:Sanday,_Orkney"]) bind289 --> bind2 bind290(["Category:Mountains_and_hills_of_Orkney"]) bind290 --> bind2 bind291(["Category:Films_set_in_Orkney"]) bind291 --> bind2 bind292(["Category:Scheduled_Ancient_Monuments_in_Orkney"]) bind292 --> bind2 bind293(["Category:Linguists_of_Norn"]) bind293 --> bind2 bind294(["Category:World_War_I_shipwrecks_in_Scapa_Flow"]) bind294 --> bind2 bind295(["Category:World_War_II_shipwrecks_in_Scapa_Flow"]) bind295 --> bind2 bind296(["Category:Shipwrecks_in_Scapa_Flow"]) bind296 --> bind2 bind297(["Category:Military_units_and_formations_in_Orkney"]) bind297 --> bind2 bind298(["Category:Rugby_union_in_Orkney"]) bind298 --> bind2 bind299(["Category:Hoy"]) bind299 --> bind2 bind2100(["Category:Eday"]) bind2100 --> bind2 bind2101(["Category:North_Ronaldsay"]) bind2101 --> bind2 bind2102(["Category:Papa_Westray"]) bind2102 --> bind2 bind2103(["Category:Stronsay"]) bind2103 --> bind2 bind2104(["Category:Mainland,_Orkney"]) bind2104 --> bind2 bind2105(["Category:Villages_on_Mainland,_Orkney"]) bind2105 --> bind2 bind2106(["Category:People_associated_with_the_University_of_the_Highlands_and_Islands"]) bind2106 --> bind2 bind2107(["Category:Alumni_of_the_University_of_the_Highlands_and_Islands"]) bind2107 --> bind2 bind2108(["Category:Lighthouses_in_Orkney"]) bind2108 --> bind2 bind2109(["Category:Wards_of_Orkney"]) bind2109 --> bind2 bind2110(["Category:Football_in_Orkney"]) bind2110 --> bind2 bind2111(["Category:Councillors_in_Orkney"]) bind2111 --> bind2 bind2112(["Category:Brochs_in_Orkney"]) bind2112 --> bind2 bind2113(["Category:Rugby_union_players_from_the_Orkney_Islands"]) bind2113 --> bind2 bind2114(["Category:Rugby_league_players_from_the_Orkney_Islands"]) bind2114 --> bind2 bind2115(["Category:Heart_of_Neolithic_Orkney"]) bind2115 --> bind2 bind2116(["Category:Sportspeople_from_Orkney"]) bind2116 --> bind2 bind2117(["Category:Writers_from_Orkney"]) bind2117 --> bind2 bind2118(["Category:Category_C_listed_buildings_in_Orkney"]) bind2118 --> bind2 subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c9 --"mwapi:endpoint"--> c11 c9 --"mwapi:api"--> c13 c9 --"mwapi:generator"--> c15 c9 --"mwapi:gcmtitle"--> v6 c9 --"mwapi:gcmprop"--> c18 c9 --"mwapi:gcmlimit"--> c20 v2 --"mwapi:apiOutput"--> c22 v5 --"mwapi:apiOutput"--> c23 v4 --"mwapi:apiOutputItem"--> c25 end v6 --"schema:about"--> v4 v6 --"schema:isPartOf"--> c28 v6 --"schema:name"--> v7 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P31".-> v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P131".-> v8 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P625".-> v9 end subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c9 --"mwapi:language"--> c35 v3 --"rdfs:label"--> v10 v8 --"rdfs:label"--> v11 end bind5[/"?class"/] v10 --o bind5 bind5 --as--o v12 bind6[/"?einheit"/] v11 --o bind6 bind6 --as--o v13