query-500b9ab1b7f810327951e3e176e4efab

rq turtle/ttl

مخرجو أفلام مرتبون حسب عدد روابط المواقع مضروبة في عدد أفلامهم Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Filmoví režiséři seřazení podle počtu odkazů na stránky Wikipedie vynásobeného počtem jejich filmů Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Réalisateurs classés par leur nombre de liens de site multipliés par leur nombre de films במאי סרטים מדורגים לפי מספר קישורי אתר כפול מספר הסרטים שלהם Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Registi cinematografici classificati per numero di sitelink moltiplicato per il loro numero di film Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Filmregisseurs gerangschikt op aantal sitelinks vermenigvuldigd met hun aantal films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Filmregissörer rankade efter antalet webbplatslänkar gånger antalet filmer de gjort Film directors ranked by number of sitelinks multiplied by their number of films Film directors ranked by number of sitelinks multiplied by their number of films Кінорежисери, упорядковані за добутком кількості інтервікі на кількість їхніх фільмів Film directors ranked by number of sitelinks multiplied by their number of films 电影导演，排名按站点链接数量乘以其电影数量

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?director ?director_label ?films ?sitelinks ((?films * ?sitelinks) as ?rank)
WHERE {
  {SELECT ?director (count(DISTINCT ?film) as ?films) (count(DISTINCT ?sitelink) as ?sitelinks)
     WHERE {
       ?director wdt:P106 wd:Q2526255 .         # has "film director" as occupation
     ?film wdt:P57 ?director .            # get all films directed by the director
       ?sitelink schema:about ?director .       # get all the sitelinks about the director
       } GROUP BY ?director }
SERVICE wikibase:label {
  bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". # Get label if it exists
?director rdfs:label ?director_label }
} ORDER BY DESC(?rank)
LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?director"):::projected v7("?director_label"):::projected v3("?film") v5("?films"):::projected v8("?rank") v4("?sitelink") v6("?sitelinks"):::projected c6(["bd:serviceParam"]):::iri c2(["wd:Q2526255"]):::iri c8(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal v2 --"wdt:P106"--> c2 v3 --"wdt:P57"--> v2 v4 --"schema:about"--> v2 bind2[/"count(?film)"/] v3 --o bind2 bind2 --as--o v5 bind3[/"count(?sitelink)"/] v4 --o bind3 bind3 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 v2 --"rdfs:label"--> v7 end bind4[/"?films * ?sitelinks"/] v5 --o bind4 v6 --o bind4 bind4 --as--o v8