Directors with longer film duration

film directors whose father and mother are also director.sparql

SELECT ?item ?cLabel ?itemLabel ?fatherLabel ?motherLabel
WHERE 
{
  ?item wdt:P31 wd:Q5.
  ?item wdt:P27 ?c.
  ?item wdt:P22 ?father.
  ?item wdt:P25 ?mother.
  ?item wdt:P106 wd:Q2526255.
  ?father wdt:P106 wd:Q2526255.
  ?mother wdt:P106 wd:Q2526255.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

film_directors.sparql

# The Chinese Film Director whose films have the longest avg duration
SELECT ?director ?directorLabel (COUNT(?film) as ?count) (AVG(?duration) AS ?avg_dur)
{
   VALUES (?country) { ( wd:Q148 ) ( wd:Q29520 )  (wd:Q865)}
#   VALUES (?country) { ( wd:Q17)}
   ?director wdt:P27 ?country.
#     FILTER(?country IN (wd:Q148 wd:Q29520 wd:Q865)).
  
   ?film wdt:P31  wd:Q11424.
   ?film wdt:P57  ?director.
   ?film wdt:P2047 ?duration.
      SERVICE wikibase:label {               # ... include the labels
        bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"
    }
} GROUP BY ?director ?directorLabel
ORDER BY DESC(?avg_dur)

no_zh_desc_human.sparql

SELECT ?item ?itemLabel ?itemdesc
WHERE 
{
  ?item wdt:P31 wd:Q5.
  ?item wdt:P106/wdt:P279* wd:Q2526255.
  FILTER(NOT EXISTS {
    ?item schema:description ?itemdesc.
    FILTER(LANG(?itemdesc) = "zh")
  })
  SERVICE wikibase:label { bd:serviceParam wikibase:language "zh". }
}