query-4e63dda883451a96f14fa2093c8ef978
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?Org ?OrgLabel ?StockExchange ?StockExchangeLabel ?Ticker
WHERE {
?Org p:P414 ?SE . # look for an entity with a "stock exchange" statement
?SE ps:P414 ?StockExchange . # of which we get the value
?SE pq:P249 ?Ticker . # and the "ticker symbol" qualifier
FILTER(?Ticker="FB") . #and we restrict the value of that qualifier to "FB"
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
Query found at
- https://www.wikidata.org/wiki/User_talk:Alphos
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2016/08
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?Org"):::projected
v3("?SE")
v4("?StockExchange"):::projected
v1("?Ticker"):::projected
c6(["bd:serviceParam"]):::iri
c8(["en"]):::literal
f0[["?Ticker = 'FB'"]]
f0 --> v1
v2 --"p:P414"--> v3
v3 --"p:statement/P414"--> v4
v3 --"p:qualifier/P249"--> v1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c8
end