query-36ae73a76578821d2cd10b194180330a

rq turtle/ttl

TODO

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
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 ?Ceo ?CeoLabel ?Subsidiary ?SubsidiaryLabel ?SubsidiaryCEO ?SubsidiaryCEOLabel ?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
  # Add new fields
  ?Org wdt:P169 ?Ceo .        # Entity has Ceo
  ?Org wdt:P355 ?Subsidiary . # Entity has Subsidiary
  OPTIONAL { 
    ?Subsidiary wdt:P169 ?SubsidiaryCEO .
  }
  FILTER(?Ticker="FB") . #and we restrict the value of that qualifier to "FB"
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }

Query found at