query-bc0a01b908165ce3947692a19994bce8
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?itemDescription ?partOfLabel ?headquarterLocationLabel ?VAT ?IndicePA ?OfficialWebsite ?coord ?inception ?phone ?facebook
(GROUP_CONCAT(DISTINCT ?subLabel; separator=", ") as ?sub_ )
WHERE {
?item (wdt:P31/(wdt:P279*)) wd:Q87648631;
OPTIONAL { ?item wdt:P361 ?partOf. }
OPTIONAL { ?item wdt:P159 ?headquarterLocation. }
OPTIONAL { ?item wdt:P3608 ?VAT. }
OPTIONAL { ?item wdt:P6832 ?IndicePA . }
OPTIONAL { ?item wdt:P856 ?OfficialWebsite .}
OPTIONAL { ?item wdt:P625 ?coord .}
OPTIONAL { ?item wdt:P355 ?sub .}
OPTIONAL { ?item wdt:P571 ?inception .}
OPTIONAL { ?item wdt:P1329 ?phone .}
OPTIONAL { ?item wdt:P2013 ?facebook .}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
}
}
GROUP BY ?item ?itemLabel ?itemDescription ?partOfLabel ?headquarterLocationLabel ?VAT ?IndicePA ?OfficialWebsite ?coord ?inception ?phone ?facebook
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?IndicePA"):::projected
v6("?OfficialWebsite"):::projected
v4("?VAT"):::projected
v7("?coord"):::projected
v11("?facebook"):::projected
v3("?headquarterLocation")
v9("?inception"):::projected
v1("?item"):::projected
v2("?partOf")
v10("?phone"):::projected
v8("?sub")
v12("?subLabel"):::projected
v13("?sub_")
a1((" "))
c17(["en"]):::literal
c15(["bd:serviceParam"]):::iri
c3(["wd:Q87648631"]):::iri
v1 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c3
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P361".-> v2
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P159".-> v3
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P3608".-> v4
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P6832".-> v5
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P856".-> v6
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P625".-> v7
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P355".-> v8
end
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P571".-> v9
end
subgraph optional8["(optional)"]
style optional8 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P1329".-> v10
end
subgraph optional9["(optional)"]
style optional9 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P2013".-> v11
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c15 --"wikibase:language"--> c17
end
bind1[/"?subLabel"/]
v12 --o bind1
bind1 --as--o v13