query-7fdb88087bec9c3cbe07f0be5ac43894

rq turtle/ttl

TODO

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?revenue ?unitLabel ?hqLabel (?usd * ?revenue AS ?revenue_USD) ?date
WHERE
{
  { ?item wdt:P31 wd:Q4830453;
        wdt:P159 ?hq;
        p:P2139 ?statement .
  FILTER NOT EXISTS { ?statement wikibase:rank wikibase:DeprecatedRank } .
  FILTER NOT EXISTS {
    ?item p:P2139 ?statement1 .
    ?statement1 wikibase:rank wikibase:PreferredRank .
    FILTER( ?statement1 != ?statement ) .
  } .
  OPTIONAL { ?statement pq:P585 ?date } .
  ?statement psv:P2139 [
    wikibase:quantityAmount ?revenue; wikibase:quantityUnit ?unit
  ] .
  ?unit p:P2284 ?unit_statement .
  FILTER NOT EXISTS { ?unit_statement wikibase:rank wikibase:DeprecatedRank } .
  FILTER NOT EXISTS {
    ?unit p:P2284 ?unit_statement1 .
    ?unit_statement1 wikibase:rank wikibase:PreferredRank .
    FILTER( ?unit_statement1 != ?unit_statement ) .
  } .
  ?unit_statement psv:P2284 [
    wikibase:quantityUnit wd:Q4917; wikibase:quantityAmount ?usd
  ] .
  } 
  UNION
  {
  ?item wdt:P31 wd:Q4830453;
        wdt:P159 ?hq;
        p:P2139 ?statement .
  ?statement psv:P2139 [
  wikibase:quantityUnit wd:Q4917; wikibase:quantityAmount ?revenue_USD
  ] .    
  FILTER NOT EXISTS { ?statement wikibase:rank wikibase:DeprecatedRank } .
  FILTER NOT EXISTS {
    ?item p:P2139 ?statement1 .
    ?statement1 wikibase:rank wikibase:PreferredRank .
    FILTER( ?statement1 != ?statement ) .
  } .
  OPTIONAL { ?statement pq:P585 ?date } .
  } 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "cs,en" } .
}
ORDER BY DESC(?revenue_USD)

Query found at