PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Defensa civil en LATAM
# https://w.wiki/6LmB
SELECT DISTINCT ?item ?itemLabel ?country ?countryLabel ?operating_areaLabel ?official_website WHERE {
  VALUES ?in_latam {
    wd:Q77
    wd:Q96
    wd:Q155
    wd:Q241
    wd:Q298
    wd:Q414
    wd:Q419
    wd:Q717
    wd:Q733
    wd:Q736
    wd:Q739
    wd:Q750
    wd:Q774
    wd:Q783
    wd:Q786
    wd:Q790
    wd:Q792
    wd:Q800
    wd:Q804
    wd:Q811
    wd:Q1183
    wd:Q25228
    wd:Q781
    wd:Q244
    wd:Q242
    wd:Q25305
    wd:Q784
    wd:Q769
    wd:Q766
    wd:Q13353
    wd:Q13353
    wd:Q763
    wd:Q760
    wd:Q757
    wd:Q730
    wd:Q778
    wd:Q754
    wd:Q18221
    wd:Q734
  }
  ?item wdt:P101 wd:Q1460420;
    (p:P31/ps:P31/(wdt:P279*)) wd:Q327333;
    wdt:P17 ?in_latam.
  OPTIONAL { ?item wdt:P17 ?country. }
  OPTIONAL { ?item wdt:P2541 ?operating_area. }
  OPTIONAL { ?item wdt:P856 ?official_website. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,fr,ru,es,ja,zh,ar". }
}
ORDER BY (?countryLabel) (?operating_areaLabel)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?country"):::projected v1("?countryLabel"):::projected v3("?in_latam") v4("?item"):::projected v7("?official_website"):::projected v6("?operating_area") v2("?operating_areaLabel"):::projected a1((" ")) a2((" ")) c13(["#91;AUTO_LANGUAGE#93;,en,de,fr,ru,es,ja,zh,ar"]):::literal c11(["bd:serviceParam"]):::iri c6(["wd:Q327333"]):::iri c2(["wd:Q1460420"]):::iri bind0[/VALUES ?in_latam/] bind0-->v3 bind00(["wd:Q77"]) bind00 --> bind0 bind01(["wd:Q96"]) bind01 --> bind0 bind02(["wd:Q155"]) bind02 --> bind0 bind03(["wd:Q241"]) bind03 --> bind0 bind04(["wd:Q298"]) bind04 --> bind0 bind05(["wd:Q414"]) bind05 --> bind0 bind06(["wd:Q419"]) bind06 --> bind0 bind07(["wd:Q717"]) bind07 --> bind0 bind08(["wd:Q733"]) bind08 --> bind0 bind09(["wd:Q736"]) bind09 --> bind0 bind010(["wd:Q739"]) bind010 --> bind0 bind011(["wd:Q750"]) bind011 --> bind0 bind012(["wd:Q774"]) bind012 --> bind0 bind013(["wd:Q783"]) bind013 --> bind0 bind014(["wd:Q786"]) bind014 --> bind0 bind015(["wd:Q790"]) bind015 --> bind0 bind016(["wd:Q792"]) bind016 --> bind0 bind017(["wd:Q800"]) bind017 --> bind0 bind018(["wd:Q804"]) bind018 --> bind0 bind019(["wd:Q811"]) bind019 --> bind0 bind020(["wd:Q1183"]) bind020 --> bind0 bind021(["wd:Q25228"]) bind021 --> bind0 bind022(["wd:Q781"]) bind022 --> bind0 bind023(["wd:Q244"]) bind023 --> bind0 bind024(["wd:Q242"]) bind024 --> bind0 bind025(["wd:Q25305"]) bind025 --> bind0 bind026(["wd:Q784"]) bind026 --> bind0 bind027(["wd:Q769"]) bind027 --> bind0 bind028(["wd:Q766"]) bind028 --> bind0 bind029(["wd:Q13353"]) bind029 --> bind0 bind030(["wd:Q13353"]) bind030 --> bind0 bind031(["wd:Q763"]) bind031 --> bind0 bind032(["wd:Q760"]) bind032 --> bind0 bind033(["wd:Q757"]) bind033 --> bind0 bind034(["wd:Q730"]) bind034 --> bind0 bind035(["wd:Q778"]) bind035 --> bind0 bind036(["wd:Q754"]) bind036 --> bind0 bind037(["wd:Q18221"]) bind037 --> bind0 bind038(["wd:Q734"]) bind038 --> bind0 v4 --"p:direct/P101"--> c2 v4 --"p:P31"--> a1 a1 --"p:statement/P31"--> a2 a2 --"p:direct/P279"--> c6 v4 --"p:direct/P17"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P17".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P2541".-> v6 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P856".-> v7 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end