query-b757e9d8e9d8af643754ec01ada38cf3

rq turtle/ttl

50 films interdit aux moins de 18 ans quelque part ayant eu une récompense

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?itemLabel ?rewardLabel ?classifLabel ?pLabel WHERE {

  # get list of property related to classification of movie in ?p2
  ?p rdf:type wikibase:Property;
    wdt:P31 wd:Q24716199;
    wikibase:directClaim ?p2.

  # get movie
  ?item wdt:P31 wd:Q11424;
  # with a reward
    wdt:P166 ?reward;
  # and a classification  
    ?p2 ?classif.
  # get age limit   
  ?classif wdt:P2899 ?c.
  # and keep classification for more than 18
  FILTER(?c >= 18 )

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 50

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?c") v6("?classif") v4("?item") v2("?p") v3("?p2") v5("?reward") c5(["wd:Q24716199"]):::iri c3(["wikibase:Property"]):::iri c11(["bd:serviceParam"]):::iri c13(["#91;AUTO_LANGUAGE#93;,en"]):::literal c7(["wd:Q11424"]):::iri f0[["?c >= '18^^xsd:integer'"]] f0 --> v1 v2 --"a"--> c3 v2 --"wdt:P31"--> c5 v2 --"wikibase:directClaim"--> v3 v4 --"wdt:P31"--> c7 v4 --"wdt:P166"--> v5 v4 -->v3--> v6 v6 --"wdt:P2899"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end