query-e9f56caf1fa78c31b31da53c22d736b4

rq turtle/ttl

TODO

Use at

• https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?movie ?title ?genre ?genreName ?grossNum ?grossUnit ?duration (MIN(?pubDate_) as  ?pubDate ) 
WHERE {
    ?movie wdt:P31 wd:Q11424 ;  # Instance of film
             rdfs:label ?title .
    ?movie wdt:P136 ?genre .# Genre
    ?movie p:P2142 ?gross  .# Gross revenue
    ?movie wdt:P577 ?releaseDate . 
    ?genre wdt:P1813 ?genreName .
    ?gross pq:P3005 wd:Q13780930 . # gross only in worldwide
    ?gross psv:P2142 ?grossValueNode .
    ?grossValueNode wikibase:quantityAmount ?grossNum.
    ?grossValueNode wikibase:quantityUnit ?grossUnit.
    ?movie wdt:P2047 ?duration .
    ?movie p:P577/psv:P577 ?stat . 
    ?stat wikibase:timeValue ?pubDate_ .
    ?stat wikibase:timePrecision "11"^^xsd:integer . 

    FILTER (REGEX(STR(?title), "^[A-Za-z]", "i") && LANG(?title) = "en") .
} GROUP BY ?movie ?title ?genre ?genreName ?grossNum ?grossUnit ?duration 
ORDER BY ?title ?pubDate
LIMIT 50
OFFSET 0

Query found at

• https://www.wikidata.org/wiki/Wikidata_talk:SPARQL_query_service/queries