query-dda61cf0a28edda0ceda79e9df2d36d6

rq turtle/ttl

productions of Pride and Prejudice and who played Elizabeth Bennet and what kind of thing they were SELECT ?production ?productionLabel ?actress ?actressLabel (group_concat(?instanceofLabel ;separator=", ") as ?typeofproduction)

WHERE {

?production wdt:P144 wd:Q170583 ; # thing based on Pride & Prejudice p:P161 [ ps:P161 ?actress; pq:P453 wd:Q2223341 ] . # cast member has character role elizabeth bennet ?production wdt:P31 ?instanceof

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
                          ?instanceof rdfs:label ?instanceofLabel . # i don't know what this bit does except that it's needed
                        ?production rdfs:label ?productionLabel .
                        ?actress rdfs:label ?actressLabel .

                     }

}

group by ?production ?productionLabel ?actress ?actressLabel

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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#>
#productions of Pride and Prejudice and who played Elizabeth Bennet and what kind of thing they were
SELECT ?production ?productionLabel ?actress ?actressLabel (group_concat(?instanceofLabel ;separator=", ") as ?typeofproduction)

WHERE {

  ?production wdt:P144 wd:Q170583 ; # thing based on Pride & Prejudice
              p:P161 [ ps:P161 ?actress; pq:P453 wd:Q2223341 ] . # cast member has character role elizabeth bennet
       ?production wdt:P31 ?instanceof     

    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
                              ?instanceof rdfs:label ?instanceofLabel . # i don't know what this bit does except that it's needed
                            ?production rdfs:label ?productionLabel .
                            ?actress rdfs:label ?actressLabel .

                         }
}

group by ?production ?productionLabel ?actress ?actressLabel

Query found at

• https://www.wikidata.org/wiki/User:Lirazelf/Learning