Q6-expert.sparql

# 14925 Rows. -- 24300 msec.

PREFIX  dbpp: <http://dbpedia.org/property/>
PREFIX  dbpo: <http://dbpedia.org/ontology/>
PREFIX  rdf:  <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX  dcterms: <http://purl.org/dc/terms/>
PREFIX  rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX  dbpr: <http://dbpedia.org/resource/>

SELECT  *
FROM <http://dbpedia.org>
WHERE
  { ?film  rdf:type       dbpo:Film ;
           dbpp:starring  ?actor ;
           dbpp:country   ?movie_country ;
           dbpp:genre     ?genre ;
           dbpp:director  ?director ;
           dbpp:producer  ?producer ;
           dbpp:language  ?language ;
           dbpp:story     ?story ;
           dbpp:runtime   ?runtime ;
           dbpp:studio    ?studio ;
           dbpp:title     ?title
    FILTER ( ( ( ?movie_country IN (dbpr:United_States, dbpr:India) ) &&
        ( ?genre IN (dbpr:Film_score, dbpr:Soundtrack, dbpr:Rock_music, dbpr:House_music, dbpr:Dubstep) ) )
        && ( ?studio != "Eskay Movies" ) )
  }