query-af139263c64d3263bc82dd29882e03f5
Vollständigkeit von der Liste der Tatort-Ermittler verwende ich unter anderem die folgende Abfrage. Liste der Tatort-ErmittlerZur Prüfung der Vollständigkeit der
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
SELECT ?ordinal ?film ?publication WHERE {
?film p:P179 ?series . ?series v:P179 wd:Q689438 . ?series pq:P1545 ?ordinal .
?film wdt:P577 ?publication FILTER(?publication<NOW())
FILTER NOT EXISTS {?film wdt:P179 ?subseries . VALUES ?subseries {wd:Q110839889 wd:Q110737643 wd:Q110835471 wd:Q110864497 wd:Q110862588 wd:Q110861914 wd:Q110856934 wd:Q110863111 wd:Q110858551 wd:Q110994246 wd:Q110894625 wd:Q110883559 wd:Q110884381 wd:Q110894531 wd:Q110900805 wd:Q110900686 wd:Q110894547 wd:Q110894613 wd:Q110894533 wd:Q110894708 wd:Q115247621 wd:Q110857629 wd:Q110892512 wd:Q110897668 wd:Q110888856 wd:Q110880147 wd:Q110898182 wd:Q110892363 wd:Q110900933 wd:Q110887846 wd:Q110887868 wd:Q110904257 wd:Q110904360 wd:Q110866363 wd:Q110894699 wd:Q110864620 wd:Q110896340 wd:Q110883509 wd:Q110899154 wd:Q110862815 wd:Q110864856 wd:Q110898276 wd:Q111046522 wd:Q111046592 wd:Q110897017 wd:Q110897620 wd:Q110899236 wd:Q111046630 wd:Q110892151 wd:Q110897611 wd:Q110899190 wd:Q111046658 wd:Q111046648 wd:Q111046675 wd:Q111046686 wd:Q110894690 wd:Q111046914 wd:Q110897648 wd:Q110899828 wd:Q111049984 wd:Q110896447 wd:Q111049935 wd:Q110899932 wd:Q110883782 wd:Q110899881 wd:Q110896434 wd:Q110974815 wd:Q110866422 wd:Q111050003 wd:Q111046691 wd:Q111046848 wd:Q111047718 wd:Q111047800 wd:Q111050095 wd:Q110896860 wd:Q111050102 wd:Q110899671} }
}
ORDER BY DESC(xsd:integer(?ordinal))
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?film"):::projected
v1("?ordinal"):::projected
v4("?publication"):::projected
v5("?series")
v4("?subseries")
c4(["wd:Q689438"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"p:direct/P179"--> e0v3
bind0[/VALUES ?subseries/]
bind0-->e0v3
bind00(["wd:Q110839889"])
bind00 --> bind0
bind01(["wd:Q110737643"])
bind01 --> bind0
bind02(["wd:Q110835471"])
bind02 --> bind0
bind03(["wd:Q110864497"])
bind03 --> bind0
bind04(["wd:Q110862588"])
bind04 --> bind0
bind05(["wd:Q110861914"])
bind05 --> bind0
bind06(["wd:Q110856934"])
bind06 --> bind0
bind07(["wd:Q110863111"])
bind07 --> bind0
bind08(["wd:Q110858551"])
bind08 --> bind0
bind09(["wd:Q110994246"])
bind09 --> bind0
bind010(["wd:Q110894625"])
bind010 --> bind0
bind011(["wd:Q110883559"])
bind011 --> bind0
bind012(["wd:Q110884381"])
bind012 --> bind0
bind013(["wd:Q110894531"])
bind013 --> bind0
bind014(["wd:Q110900805"])
bind014 --> bind0
bind015(["wd:Q110900686"])
bind015 --> bind0
bind016(["wd:Q110894547"])
bind016 --> bind0
bind017(["wd:Q110894613"])
bind017 --> bind0
bind018(["wd:Q110894533"])
bind018 --> bind0
bind019(["wd:Q110894708"])
bind019 --> bind0
bind020(["wd:Q115247621"])
bind020 --> bind0
bind021(["wd:Q110857629"])
bind021 --> bind0
bind022(["wd:Q110892512"])
bind022 --> bind0
bind023(["wd:Q110897668"])
bind023 --> bind0
bind024(["wd:Q110888856"])
bind024 --> bind0
bind025(["wd:Q110880147"])
bind025 --> bind0
bind026(["wd:Q110898182"])
bind026 --> bind0
bind027(["wd:Q110892363"])
bind027 --> bind0
bind028(["wd:Q110900933"])
bind028 --> bind0
bind029(["wd:Q110887846"])
bind029 --> bind0
bind030(["wd:Q110887868"])
bind030 --> bind0
bind031(["wd:Q110904257"])
bind031 --> bind0
bind032(["wd:Q110904360"])
bind032 --> bind0
bind033(["wd:Q110866363"])
bind033 --> bind0
bind034(["wd:Q110894699"])
bind034 --> bind0
bind035(["wd:Q110864620"])
bind035 --> bind0
bind036(["wd:Q110896340"])
bind036 --> bind0
bind037(["wd:Q110883509"])
bind037 --> bind0
bind038(["wd:Q110899154"])
bind038 --> bind0
bind039(["wd:Q110862815"])
bind039 --> bind0
bind040(["wd:Q110864856"])
bind040 --> bind0
bind041(["wd:Q110898276"])
bind041 --> bind0
bind042(["wd:Q111046522"])
bind042 --> bind0
bind043(["wd:Q111046592"])
bind043 --> bind0
bind044(["wd:Q110897017"])
bind044 --> bind0
bind045(["wd:Q110897620"])
bind045 --> bind0
bind046(["wd:Q110899236"])
bind046 --> bind0
bind047(["wd:Q111046630"])
bind047 --> bind0
bind048(["wd:Q110892151"])
bind048 --> bind0
bind049(["wd:Q110897611"])
bind049 --> bind0
bind050(["wd:Q110899190"])
bind050 --> bind0
bind051(["wd:Q111046658"])
bind051 --> bind0
bind052(["wd:Q111046648"])
bind052 --> bind0
bind053(["wd:Q111046675"])
bind053 --> bind0
bind054(["wd:Q111046686"])
bind054 --> bind0
bind055(["wd:Q110894690"])
bind055 --> bind0
bind056(["wd:Q111046914"])
bind056 --> bind0
bind057(["wd:Q110897648"])
bind057 --> bind0
bind058(["wd:Q110899828"])
bind058 --> bind0
bind059(["wd:Q111049984"])
bind059 --> bind0
bind060(["wd:Q110896447"])
bind060 --> bind0
bind061(["wd:Q111049935"])
bind061 --> bind0
bind062(["wd:Q110899932"])
bind062 --> bind0
bind063(["wd:Q110883782"])
bind063 --> bind0
bind064(["wd:Q110899881"])
bind064 --> bind0
bind065(["wd:Q110896434"])
bind065 --> bind0
bind066(["wd:Q110974815"])
bind066 --> bind0
bind067(["wd:Q110866422"])
bind067 --> bind0
bind068(["wd:Q111050003"])
bind068 --> bind0
bind069(["wd:Q111046691"])
bind069 --> bind0
bind070(["wd:Q111046848"])
bind070 --> bind0
bind071(["wd:Q111047718"])
bind071 --> bind0
bind072(["wd:Q111047800"])
bind072 --> bind0
bind073(["wd:Q111050095"])
bind073 --> bind0
bind074(["wd:Q110896860"])
bind074 --> bind0
bind075(["wd:Q111050102"])
bind075 --> bind0
bind076(["wd:Q110899671"])
bind076 --> bind0
e0v1("?film"):::projected
e0v3("?subseries"):::projected
end
f0--EXISTS--> f0e0
f0 --> v2
f0 --> c1
f0 --> v4
v2 --"p:direct/P179"--> v4
bind1[/VALUES ?subseries/]
bind1-->v4
bind10(["wd:Q110839889"])
bind10 --> bind1
bind11(["wd:Q110737643"])
bind11 --> bind1
bind12(["wd:Q110835471"])
bind12 --> bind1
bind13(["wd:Q110864497"])
bind13 --> bind1
bind14(["wd:Q110862588"])
bind14 --> bind1
bind15(["wd:Q110861914"])
bind15 --> bind1
bind16(["wd:Q110856934"])
bind16 --> bind1
bind17(["wd:Q110863111"])
bind17 --> bind1
bind18(["wd:Q110858551"])
bind18 --> bind1
bind19(["wd:Q110994246"])
bind19 --> bind1
bind110(["wd:Q110894625"])
bind110 --> bind1
bind111(["wd:Q110883559"])
bind111 --> bind1
bind112(["wd:Q110884381"])
bind112 --> bind1
bind113(["wd:Q110894531"])
bind113 --> bind1
bind114(["wd:Q110900805"])
bind114 --> bind1
bind115(["wd:Q110900686"])
bind115 --> bind1
bind116(["wd:Q110894547"])
bind116 --> bind1
bind117(["wd:Q110894613"])
bind117 --> bind1
bind118(["wd:Q110894533"])
bind118 --> bind1
bind119(["wd:Q110894708"])
bind119 --> bind1
bind120(["wd:Q115247621"])
bind120 --> bind1
bind121(["wd:Q110857629"])
bind121 --> bind1
bind122(["wd:Q110892512"])
bind122 --> bind1
bind123(["wd:Q110897668"])
bind123 --> bind1
bind124(["wd:Q110888856"])
bind124 --> bind1
bind125(["wd:Q110880147"])
bind125 --> bind1
bind126(["wd:Q110898182"])
bind126 --> bind1
bind127(["wd:Q110892363"])
bind127 --> bind1
bind128(["wd:Q110900933"])
bind128 --> bind1
bind129(["wd:Q110887846"])
bind129 --> bind1
bind130(["wd:Q110887868"])
bind130 --> bind1
bind131(["wd:Q110904257"])
bind131 --> bind1
bind132(["wd:Q110904360"])
bind132 --> bind1
bind133(["wd:Q110866363"])
bind133 --> bind1
bind134(["wd:Q110894699"])
bind134 --> bind1
bind135(["wd:Q110864620"])
bind135 --> bind1
bind136(["wd:Q110896340"])
bind136 --> bind1
bind137(["wd:Q110883509"])
bind137 --> bind1
bind138(["wd:Q110899154"])
bind138 --> bind1
bind139(["wd:Q110862815"])
bind139 --> bind1
bind140(["wd:Q110864856"])
bind140 --> bind1
bind141(["wd:Q110898276"])
bind141 --> bind1
bind142(["wd:Q111046522"])
bind142 --> bind1
bind143(["wd:Q111046592"])
bind143 --> bind1
bind144(["wd:Q110897017"])
bind144 --> bind1
bind145(["wd:Q110897620"])
bind145 --> bind1
bind146(["wd:Q110899236"])
bind146 --> bind1
bind147(["wd:Q111046630"])
bind147 --> bind1
bind148(["wd:Q110892151"])
bind148 --> bind1
bind149(["wd:Q110897611"])
bind149 --> bind1
bind150(["wd:Q110899190"])
bind150 --> bind1
bind151(["wd:Q111046658"])
bind151 --> bind1
bind152(["wd:Q111046648"])
bind152 --> bind1
bind153(["wd:Q111046675"])
bind153 --> bind1
bind154(["wd:Q111046686"])
bind154 --> bind1
bind155(["wd:Q110894690"])
bind155 --> bind1
bind156(["wd:Q111046914"])
bind156 --> bind1
bind157(["wd:Q110897648"])
bind157 --> bind1
bind158(["wd:Q110899828"])
bind158 --> bind1
bind159(["wd:Q111049984"])
bind159 --> bind1
bind160(["wd:Q110896447"])
bind160 --> bind1
bind161(["wd:Q111049935"])
bind161 --> bind1
bind162(["wd:Q110899932"])
bind162 --> bind1
bind163(["wd:Q110883782"])
bind163 --> bind1
bind164(["wd:Q110899881"])
bind164 --> bind1
bind165(["wd:Q110896434"])
bind165 --> bind1
bind166(["wd:Q110974815"])
bind166 --> bind1
bind167(["wd:Q110866422"])
bind167 --> bind1
bind168(["wd:Q111050003"])
bind168 --> bind1
bind169(["wd:Q111046691"])
bind169 --> bind1
bind170(["wd:Q111046848"])
bind170 --> bind1
bind171(["wd:Q111047718"])
bind171 --> bind1
bind172(["wd:Q111047800"])
bind172 --> bind1
bind173(["wd:Q111050095"])
bind173 --> bind1
bind174(["wd:Q110896860"])
bind174 --> bind1
bind175(["wd:Q111050102"])
bind175 --> bind1
bind176(["wd:Q110899671"])
bind176 --> bind1
f2[["?publication < NOW()"]]
f2 --> v4
v2 --"p:P179"--> v5
v5 --"p:statement/P179"--> c4
v5 --"p:qualifier/P1545"--> v1
v2 --"p:direct/P577"--> v4