User:Magnus Manske/listeria test3: Difference between revisions

Content deleted Content added

Inline

Revision as of 16:24, 15 December 2020

Update the list now |SPARQL |Find images

This list is automatically generated from data in Wikidata and is periodically updated by Listeriabot.
Edits made within the list area will be removed on the next update!

End of auto-generated list.

@@ Line 1: / Line 1: @@
 {{Wikidata list
-|sparql=SELECT ?item { VALUES ?item { wd:Q80 wd:Q12345 } }
+|sparql=  SELECT ?item ?films ?l
+WITH
-|columns=item,label:name,alias/en,P31
+{
+  SELECT ?item (COUNT(*) as ?films)
+  {
+    VALUES ?filmtype {wd:Q11424 wd:Q24862 wd:Q20667187 wd:Q226730} .
+    ?f wdt:P31 ?filmtype .
+    # ?f wdt:P577 ?released .
+    ?f wdt:P57 ?item .
+    # FILTER (?released < "1900-01-01T00:00:00Z"^^xsd:dateTime)
+  }
+  GROUP BY ?item
+} as %filmcount
+WHERE
+{
+    hint:Query hint:optimizer "None".
+    INCLUDE %filmcount
+    # select directors without label in cy
+    FILTER NOT EXISTS { ?item rdfs:label ?cylabel . FILTER( lang(?cylabel) = "cy" ) }
+    SERVICE wikibase:label {
+      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,nl,es,de,pt,nn,fr".
+      ?item rdfs:label ?l .
+    }
+}
+ORDER BY (?released) ?item
+LIMIT 100
+|columns=number:#,label:Film,P1476,P2047,P344,P57,P577:released,P495,P10
+|autolist=fallback
+|short=true
+|thumb=100
 }}
-{| class='wikitable sortable' style='width:100%'
-! item
-! name
-! alias/en
-! instance of
-|-
-| [[:d:Q80|Q80]]
-| [[Tim Berners-Lee]]
-| Sir Tim Berners-Lee<br/>T Berners-Lee<br/>T. Berners-Lee<br/>T.J. Berners-Lee<br/>TBL<br/>Tim Berners Lee<br/>TimBL<br/>Timothy John Berners-Lee
-| [[human]]
-|-
-| [[:d:Q12345|Q12345]]
-| [[Count von Count]]
-| The Count
-| ''[[:d:Q30061417|vampire in a work of fiction]]''<br/>''[[:d:Q15773317|television character]]''
-|}
 {{Wikidata list end}}