query-5bcdcfad73177397d68547e77cadcd71

rq turtle/ttl

Companies with largest revenue in USD (Q4917) SELECT ?item ?revenue ?unit ?revenue_USD ?date WHERE { ?item wdt:P31/wdt:P279* wd:Q4830453; p:P2139 ?statement . OPTIONAL { ?item wdt:P159 ?hq } . ?statement wikibase:rank ?rank . FILTER( ?rank != wikibase:DeprecatedRank ) . OPTIONAL { FILTER( ?rank != wikibase:PreferredRank ) . ?item p:P2139 ?statement1 . ?statement1 wikibase:rank wikibase:PreferredRank . FILTER( ?statement1 != ?statement ) . } . FILTER( !BOUND( ?statement1 ) ) . OPTIONAL { ?statement pq:P585 ?date } . { ?statement psv:P2139 [ wikibase:quantityAmount ?revenue; wikibase:quantityUnit wd:Q4917 ] . BIND( wd:Q4917 AS ?unit ) . BIND( ?revenue AS ?revenue_USD ) . } UNION { ?statement psv:P2139 [ wikibase:quantityAmount ?revenue; wikibase:quantityUnit ?unit ] . FILTER( ?unit != wd:Q4917 ) . ?unit p:P2284 ?unit_statement . ?unit_statement wikibase:rank ?unit_rank; psv:P2284 [ wikibase:quantityUnit wd:Q4917; wikibase:quantityAmount ?usd ] . FILTER( ?unit_rank != wikibase:DeprecatedRank ) . OPTIONAL { FILTER( ?unit_rank != wikibase:PreferredRank ) . ?unit p:P2284 ?unit_statement1 . ?unit_statement1 psv:P2284/wikibase:quantityUnit wd:Q4917; wikibase:rank wikibase:PreferredRank . FILTER( ?unit_statement1 != ?unit_statement ) . } . FILTER( !BOUND( ?unit_statement1 ) ) . BIND( ?revenue * ?usd AS ?revenue_USD ) . } . } ORDER BY DESC(?revenue_USD) LIMIT 10

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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#Companies with largest revenue in USD (Q4917)
SELECT ?item ?revenue ?unit ?revenue_USD ?date WHERE {
  ?item wdt:P31/wdt:P279* wd:Q4830453;
        p:P2139 ?statement .
  OPTIONAL { ?item wdt:P159 ?hq } .
  ?statement wikibase:rank ?rank .
  FILTER( ?rank != wikibase:DeprecatedRank ) .
  OPTIONAL {
    FILTER( ?rank != wikibase:PreferredRank ) .
    ?item p:P2139 ?statement1 .
    ?statement1 wikibase:rank wikibase:PreferredRank .
    FILTER( ?statement1 != ?statement ) .
  } .
  FILTER( !BOUND( ?statement1 ) ) .
  OPTIONAL { ?statement pq:P585 ?date } .
  {
    ?statement psv:P2139 [
      wikibase:quantityAmount ?revenue; wikibase:quantityUnit wd:Q4917
    ] .
    BIND( wd:Q4917 AS ?unit ) .
    BIND( ?revenue AS ?revenue_USD ) .
  } UNION {
    ?statement psv:P2139 [
      wikibase:quantityAmount ?revenue; wikibase:quantityUnit ?unit
    ] .
    FILTER( ?unit != wd:Q4917 ) .
    ?unit p:P2284 ?unit_statement .
    ?unit_statement wikibase:rank ?unit_rank;
                    psv:P2284 [ wikibase:quantityUnit wd:Q4917; wikibase:quantityAmount ?usd ] .
    FILTER( ?unit_rank != wikibase:DeprecatedRank ) .
    OPTIONAL {
      FILTER( ?unit_rank != wikibase:PreferredRank ) .
      ?unit p:P2284 ?unit_statement1 .
      ?unit_statement1 psv:P2284/wikibase:quantityUnit wd:Q4917;
                       wikibase:rank wikibase:PreferredRank .
      FILTER( ?unit_statement1 != ?unit_statement ) .
    } .
    FILTER( !BOUND( ?unit_statement1 ) ) .
    BIND( ?revenue * ?usd AS ?revenue_USD ) .
  } .
}
ORDER BY DESC(?revenue_USD)
LIMIT 10

Query found at

• https://www.wikidata.org/wiki/User:Rjlabs/WikiData_Company_Data_Project