https://wikihum.lab.dariah.pl/index.php?action=history&feed=atom&title=SPARQL_examples SPARQL examples - Revision history 2026-05-26T21:00:23Z Revision history for this page on the wiki MediaWiki 1.42.1 https://wikihum.lab.dariah.pl/index.php?title=SPARQL_examples&diff=1133843&oldid=prev Pjaskulski@ihpan.edu.pl at 09:15, 31 October 2025 2025-10-31T09:15:46Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 09:15, 31 October 2025</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l557">Line 557:</td> <td colspan="2" class="diff-lineno">Line 557:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ACities%20in%20the%20palatinates%20in%20the%2016th%20century%0A%23defaultView%3AMap%0ASELECT%20%3Fpalatinate%20%3FpalatinateLabel%20%3Fdistrict%20%3FdistrictLabel%20%3Fcity%20%3FcityLabel%20%3Fcoordinate%20%3Flayer%0AWHERE%20%7B%0A%20%20%3Fpalatinate%20wdt%3AP27%20wd%3AQ905%20.%0A%20%20%0A%20%20%3Fdistrict%20wdt%3AP27%20wd%3AQ903%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fpalatinate%20.%0A%20%20%0A%20%20%3Fcity%20wdt%3AP27%20wd%3AQ175698%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP70%20%3Fdistrict%20.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%3Fcity%20p%3AP62%20%3Fstatement1%20.%0A%20%20%3Fstatement1%20pq%3AP40%20%3Fpointintime1%20.%0A%20%20%3Fstatement1%20%28ps%3AP62%2F%28wdt%3AP56%2a%29%29%20wd%3AQ622%20.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%3Fcity%20p%3AP63%20%3Fstatement%20.%0A%20%20%3Fstatement%20ps%3AP63%20%3Fcoordinate%20.%0A%20%20%3Fstatement%20pq%3AP40%20%3Fpointintime%20.%0A%20%20%3Fpalatinate%20rdfs%3Alabel%20%3Flayer%20.%0A%20%20%0A%20%20FILTER%28YEAR%28%3Fpointintime%29%20%3D%201600%20%26%26%20LANG%28%3Flayer%29%20%3D%20%22en%22%29%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D Try it!]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ACities%20in%20the%20palatinates%20in%20the%2016th%20century%0A%23defaultView%3AMap%0ASELECT%20%3Fpalatinate%20%3FpalatinateLabel%20%3Fdistrict%20%3FdistrictLabel%20%3Fcity%20%3FcityLabel%20%3Fcoordinate%20%3Flayer%0AWHERE%20%7B%0A%20%20%3Fpalatinate%20wdt%3AP27%20wd%3AQ905%20.%0A%20%20%0A%20%20%3Fdistrict%20wdt%3AP27%20wd%3AQ903%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fpalatinate%20.%0A%20%20%0A%20%20%3Fcity%20wdt%3AP27%20wd%3AQ175698%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP70%20%3Fdistrict%20.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%3Fcity%20p%3AP62%20%3Fstatement1%20.%0A%20%20%3Fstatement1%20pq%3AP40%20%3Fpointintime1%20.%0A%20%20%3Fstatement1%20%28ps%3AP62%2F%28wdt%3AP56%2a%29%29%20wd%3AQ622%20.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%3Fcity%20p%3AP63%20%3Fstatement%20.%0A%20%20%3Fstatement%20ps%3AP63%20%3Fcoordinate%20.%0A%20%20%3Fstatement%20pq%3AP40%20%3Fpointintime%20.%0A%20%20%3Fpalatinate%20rdfs%3Alabel%20%3Flayer%20.%0A%20%20%0A%20%20FILTER%28YEAR%28%3Fpointintime%29%20%3D%201600%20%26%26%20LANG%28%3Flayer%29%20%3D%20%22en%22%29%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D Try it!]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=== Settlement unit - subclasses ===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;syntaxhighlight lang="SPARQL" class="mw-highlight-lang-sparql"&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#title:Settlement unit - subclasses</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#defaultView:Graph</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">SELECT ?item ?itemLabel ?parent ?parentLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">WHERE {</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  # all elements that are subclasses of “human settlement” (Q175698)</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?item wdt:P56* wd:Q175698 .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  # parent element for each result</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  OPTIONAL { ?item wdt:P56 ?parent . }</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  # item labels (if available)</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">}</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">ORDER BY ?parent ?item</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/syntaxhighlight&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ASettlement%20unit%20-%20subclasses%0A%23defaultView%3AGraph%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fparent%20%3FparentLabel%0AWHERE%20%7B%0A%20%20%23%20all%20elements%20that%20are%20subclasses%20of%20%E2%80%9Chuman%20settlement%E2%80%9D%20%28Q175698%29%0A%20%20%3Fitem%20wdt%3AP56%2a%20wd%3AQ175698%20.%0A%20%20%0A%20%20%23%20parent%20element%20for%20each%20result%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP56%20%3Fparent%20.%20%7D%0A%20%20%0A%20%20%23%20item%20labels%20%28if%20available%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20%3Fparent%20%3Fitem Try it!]</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=== List of properties (in English) ===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;syntaxhighlight lang="SPARQL" class="mw-highlight-lang-sparql"&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#title:List of properties (in English)</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">SELECT DISTINCT</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?property</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?propertyType</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?propertyLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  (GROUP_CONCAT(DISTINCT ?propertyAltLabel; SEPARATOR = ", ") AS ?propertyAltLabels)</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">WHERE {</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?property a wikibase:Property ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">            rdfs:label ?propertyLabel ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">            wikibase:propertyType ?propertyType .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  FILTER(LANG(?propertyLabel) = "en")</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  OPTIONAL { </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    ?property skos:altLabel ?propertyAltLabel .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">    FILTER(LANG(?propertyAltLabel) = "en")</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  }</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">}</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">GROUP BY ?property ?propertyType ?propertyLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">ORDER BY xsd:integer(REPLACE(STR(?property), "^.+/P", ""))</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/syntaxhighlight&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[https://wikihum.lab.dariah.pl/wdqs/#%23title%3AList%20of%20properties%20%28in%20English%29%0ASELECT%20DISTINCT%0A%20%20%3Fproperty%0A%20%20%3FpropertyType%0A%20%20%3FpropertyLabel%0A%20%20%28GROUP_CONCAT%28DISTINCT%20%3FpropertyAltLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3FpropertyAltLabels%29%0AWHERE%20%7B%0A%20%20%3Fproperty%20a%20wikibase%3AProperty%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20rdfs%3Alabel%20%3FpropertyLabel%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3ApropertyType%20%3FpropertyType%20.%0A%20%20FILTER%28LANG%28%3FpropertyLabel%29%20%3D%20%22en%22%29%0A%20%20%0A%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%3Fproperty%20skos%3AaltLabel%20%3FpropertyAltLabel%20.%0A%20%20%20%20FILTER%28LANG%28%3FpropertyAltLabel%29%20%3D%20%22en%22%29%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fproperty%20%3FpropertyType%20%3FpropertyLabel%0AORDER%20BY%20xsd%3Ainteger%28REPLACE%28STR%28%3Fproperty%29%2C%20%22%5E.%2B%2FP%22%2C%20%22%22%29%29 Try it!]</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=== List of object classes appearing in WikiHum, along with their numbers ===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;syntaxhighlight lang="SPARQL" class="mw-highlight-lang-sparql"&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#title:List of object classes appearing in WikiHum, along with their numbers</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">SELECT ?instanceOf ?instanceOfLabel (COUNT(?item) AS ?count)</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">WHERE {</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?item wdt:P27 ?instanceOf .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">}</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">GROUP BY ?instanceOf ?instanceOfLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">ORDER BY DESC(?count)</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/syntaxhighlight&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[https://wikihum.lab.dariah.pl/wdqs/#%23title%3AList%20of%20object%20classes%20appearing%20in%20WikiHum%2C%20along%20with%20their%20numbers%0ASELECT%20%3FinstanceOf%20%3FinstanceOfLabel%20%28COUNT%28%3Fitem%29%20AS%20%3Fcount%29%0AWHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP27%20%3FinstanceOf%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3FinstanceOf%20%3FinstanceOfLabel%0AORDER%20BY%20DESC%28%3Fcount%29 Try it!]</ins></div></td></tr> </table> Pjaskulski@ihpan.edu.pl https://wikihum.lab.dariah.pl/index.php?title=SPARQL_examples&diff=834896&oldid=prev Pjaskulski@ihpan.edu.pl at 18:49, 1 September 2024 2024-09-01T18:49:52Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 18:49, 1 September 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l527">Line 527:</td> <td colspan="2" class="diff-lineno">Line 527:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ANumber%20of%20settlements%20and%20districts%20in%20the%20palatinates%20in%20the%2016th%20century%0ASELECT%20%3Fpalatinate%20%3FpalatinateLabel%20%28COUNT%28DISTINCT%20%3Fdistrict%29%20AS%20%3Fnum_districts%29%20%28COUNT%28DISTINCT%20%3Fsettlement%29%20AS%20%3Fnum_settlements%29%0AWHERE%20%7B%0A%20%20%3Fpalatinate%20wdt%3AP27%20wd%3AQ905%20.%0A%20%20%0A%20%20%3Fdistrict%20wdt%3AP27%20wd%3AQ903%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fpalatinate%20.%0A%20%0A%20%20%3Fsettlement%20wdt%3AP27%20wd%3AQ175698%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP70%20%3Fdistrict%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fpalatinate%20%3FpalatinateLabel%0AORDER%20BY%20%3FpalatinateLabel Try it!]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ANumber%20of%20settlements%20and%20districts%20in%20the%20palatinates%20in%20the%2016th%20century%0ASELECT%20%3Fpalatinate%20%3FpalatinateLabel%20%28COUNT%28DISTINCT%20%3Fdistrict%29%20AS%20%3Fnum_districts%29%20%28COUNT%28DISTINCT%20%3Fsettlement%29%20AS%20%3Fnum_settlements%29%0AWHERE%20%7B%0A%20%20%3Fpalatinate%20wdt%3AP27%20wd%3AQ905%20.%0A%20%20%0A%20%20%3Fdistrict%20wdt%3AP27%20wd%3AQ903%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fpalatinate%20.%0A%20%0A%20%20%3Fsettlement%20wdt%3AP27%20wd%3AQ175698%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP70%20%3Fdistrict%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fpalatinate%20%3FpalatinateLabel%0AORDER%20BY%20%3FpalatinateLabel Try it!]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=== Cities in the palatinates in the 16th century ===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;syntaxhighlight lang="SPARQL" class="mw-highlight-lang-sparql"&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#title:Cities in the palatinates in the 16th century</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#defaultView:Map</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">SELECT ?palatinate ?palatinateLabel ?district ?districtLabel ?city ?cityLabel ?coordinate ?layer</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">WHERE {</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?palatinate wdt:P27 wd:Q905 .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?district wdt:P27 wd:Q903 ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">          wdt:P37 ?palatinate .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?city wdt:P27 wd:Q175698 ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">              wdt:P70 ?district .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">              </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?city p:P62 ?statement1 .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?statement1 pq:P40 ?pointintime1 .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?statement1 (ps:P62/(wdt:P56*)) wd:Q622 .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">              </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?city p:P63 ?statement .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?statement ps:P63 ?coordinate .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?statement pq:P40 ?pointintime .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?palatinate rdfs:label ?layer .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  FILTER(YEAR(?pointintime) = 1600 &amp;&amp; LANG(?layer) = "en")</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">}</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/syntaxhighlight&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ACities%20in%20the%20palatinates%20in%20the%2016th%20century%0A%23defaultView%3AMap%0ASELECT%20%3Fpalatinate%20%3FpalatinateLabel%20%3Fdistrict%20%3FdistrictLabel%20%3Fcity%20%3FcityLabel%20%3Fcoordinate%20%3Flayer%0AWHERE%20%7B%0A%20%20%3Fpalatinate%20wdt%3AP27%20wd%3AQ905%20.%0A%20%20%0A%20%20%3Fdistrict%20wdt%3AP27%20wd%3AQ903%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fpalatinate%20.%0A%20%20%0A%20%20%3Fcity%20wdt%3AP27%20wd%3AQ175698%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP70%20%3Fdistrict%20.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%3Fcity%20p%3AP62%20%3Fstatement1%20.%0A%20%20%3Fstatement1%20pq%3AP40%20%3Fpointintime1%20.%0A%20%20%3Fstatement1%20%28ps%3AP62%2F%28wdt%3AP56%2a%29%29%20wd%3AQ622%20.%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%3Fcity%20p%3AP63%20%3Fstatement%20.%0A%20%20%3Fstatement%20ps%3AP63%20%3Fcoordinate%20.%0A%20%20%3Fstatement%20pq%3AP40%20%3Fpointintime%20.%0A%20%20%3Fpalatinate%20rdfs%3Alabel%20%3Flayer%20.%0A%20%20%0A%20%20FILTER%28YEAR%28%3Fpointintime%29%20%3D%201600%20%26%26%20LANG%28%3Flayer%29%20%3D%20%22en%22%29%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D Try it!]</ins></div></td></tr> </table> Pjaskulski@ihpan.edu.pl https://wikihum.lab.dariah.pl/index.php?title=SPARQL_examples&diff=834894&oldid=prev Pjaskulski@ihpan.edu.pl at 17:47, 1 September 2024 2024-09-01T17:47:24Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:47, 1 September 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l507">Line 507:</td> <td colspan="2" class="diff-lineno">Line 507:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ANumber%20of%20parishes%20and%20deaneries%20in%20archdeaconries%20in%20the%2016th%20century%0ASELECT%20%3Farchidiakonat%20%3FarchidiakonatLabel%20%28COUNT%28DISTINCT%20%3Fdekanat%29%20AS%20%3Fliczba_dekanatow%29%20%28COUNT%28DISTINCT%20%3Fparafia%29%20AS%20%3Fliczba_parafii%29%0AWHERE%20%7B%0A%20%20%3Farchidiakonat%20wdt%3AP27%20wd%3AQ722%20.%0A%20%20%0A%20%20%3Fdekanat%20wdt%3AP27%20wd%3AQ719%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Farchidiakonat%20.%0A%20%20%0A%20%20%3Fparafia%20wdt%3AP27%20wd%3AQ714%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fdekanat%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Farchidiakonat%20%3FarchidiakonatLabel%0AORDER%20BY%20%3FarchidiakonatLabel%0A Try it!]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ANumber%20of%20parishes%20and%20deaneries%20in%20archdeaconries%20in%20the%2016th%20century%0ASELECT%20%3Farchidiakonat%20%3FarchidiakonatLabel%20%28COUNT%28DISTINCT%20%3Fdekanat%29%20AS%20%3Fliczba_dekanatow%29%20%28COUNT%28DISTINCT%20%3Fparafia%29%20AS%20%3Fliczba_parafii%29%0AWHERE%20%7B%0A%20%20%3Farchidiakonat%20wdt%3AP27%20wd%3AQ722%20.%0A%20%20%0A%20%20%3Fdekanat%20wdt%3AP27%20wd%3AQ719%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Farchidiakonat%20.%0A%20%20%0A%20%20%3Fparafia%20wdt%3AP27%20wd%3AQ714%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fdekanat%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Farchidiakonat%20%3FarchidiakonatLabel%0AORDER%20BY%20%3FarchidiakonatLabel%0A Try it!]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=== Number of settlements and districts in the palatinates in the 16th century ===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;syntaxhighlight lang="SPARQL" class="mw-highlight-lang-sparql"&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#title:Number of settlements and districts in the palatinates in the 16th century</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">SELECT ?palatinate ?palatinateLabel (COUNT(DISTINCT ?district) AS ?num_districts) (COUNT(DISTINCT ?settlement) AS ?num_settlements)</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">WHERE {</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?palatinate wdt:P27 wd:Q905 .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?district wdt:P27 wd:Q903 ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">            wdt:P37 ?palatinate .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?settlement wdt:P27 wd:Q175698 ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">              wdt:P70 ?district .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">}</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">GROUP BY ?palatinate ?palatinateLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">ORDER BY ?palatinateLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/syntaxhighlight&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ANumber%20of%20settlements%20and%20districts%20in%20the%20palatinates%20in%20the%2016th%20century%0ASELECT%20%3Fpalatinate%20%3FpalatinateLabel%20%28COUNT%28DISTINCT%20%3Fdistrict%29%20AS%20%3Fnum_districts%29%20%28COUNT%28DISTINCT%20%3Fsettlement%29%20AS%20%3Fnum_settlements%29%0AWHERE%20%7B%0A%20%20%3Fpalatinate%20wdt%3AP27%20wd%3AQ905%20.%0A%20%20%0A%20%20%3Fdistrict%20wdt%3AP27%20wd%3AQ903%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fpalatinate%20.%0A%20%0A%20%20%3Fsettlement%20wdt%3AP27%20wd%3AQ175698%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP70%20%3Fdistrict%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fpalatinate%20%3FpalatinateLabel%0AORDER%20BY%20%3FpalatinateLabel Try it!]</ins></div></td></tr> </table> Pjaskulski@ihpan.edu.pl https://wikihum.lab.dariah.pl/index.php?title=SPARQL_examples&diff=834891&oldid=prev Pjaskulski@ihpan.edu.pl: /* Number of parishes in deaneries and archdeaconries in the 16th century */ 2024-08-31T20:42:27Z <p><span dir="auto"><span class="autocomment">Number of parishes in deaneries and archdeaconries in the 16th century</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:42, 31 August 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l488">Line 488:</td> <td colspan="2" class="diff-lineno">Line 488:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3APalatinates%2C%20district%20and%20settlements%20in%20the%2016th%20century%0A%23defaultView%3ATree%0ASELECT%20%3Fwojewodztwo%20%3FwojewodztwoLabel%20%3Fpowiat%20%3FpowiatLabel%20%3Fmiejscowosc%20%3FmiejscowoscLabel%0AWHERE%20%7B%0A%20%20%3Fwojewodztwo%20wdt%3AP27%20wd%3AQ905%20.%0A%20%20%0A%20%20%3Fpowiat%20wdt%3AP27%20wd%3AQ903%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fwojewodztwo%20.%0A%20%20%0A%20%20%3Fmiejscowosc%20wdt%3AP27%20wd%3AQ175698%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP70%20%3Fpowiat%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cpl%22.%20%7D%0A%7D%0AORDER%20BY%20%3FwojewodztwoLabel%20%3FpowiatLabel%20%3FmiejscowoscLabel Try It!]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3APalatinates%2C%20district%20and%20settlements%20in%20the%2016th%20century%0A%23defaultView%3ATree%0ASELECT%20%3Fwojewodztwo%20%3FwojewodztwoLabel%20%3Fpowiat%20%3FpowiatLabel%20%3Fmiejscowosc%20%3FmiejscowoscLabel%0AWHERE%20%7B%0A%20%20%3Fwojewodztwo%20wdt%3AP27%20wd%3AQ905%20.%0A%20%20%0A%20%20%3Fpowiat%20wdt%3AP27%20wd%3AQ903%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fwojewodztwo%20.%0A%20%20%0A%20%20%3Fmiejscowosc%20wdt%3AP27%20wd%3AQ175698%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP70%20%3Fpowiat%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cpl%22.%20%7D%0A%7D%0AORDER%20BY%20%3FwojewodztwoLabel%20%3FpowiatLabel%20%3FmiejscowoscLabel Try It!]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>=== Number of parishes in <del style="font-weight: bold; text-decoration: none;">deaneries and </del>archdeaconries in the 16th century ===</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>=== Number of parishes <ins style="font-weight: bold; text-decoration: none;">and deaneries </ins>in archdeaconries in the 16th century ===</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;syntaxhighlight lang=&quot;SPARQL&quot; class=&quot;mw-highlight-lang-sparql&quot;&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;syntaxhighlight lang=&quot;SPARQL&quot; class=&quot;mw-highlight-lang-sparql&quot;&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#title:Number of parishes in <del style="font-weight: bold; text-decoration: none;">deaneries and </del>archdeaconries in the 16th century</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#title:Number of parishes <ins style="font-weight: bold; text-decoration: none;">and deaneries </ins>in archdeaconries in the 16th century</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>SELECT ?archidiakonat ?archidiakonatLabel (COUNT(DISTINCT ?dekanat) AS ?liczba_dekanatow) (COUNT(DISTINCT ?parafia) AS ?liczba_parafii)</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>SELECT ?archidiakonat ?archidiakonatLabel (COUNT(DISTINCT ?dekanat) AS ?liczba_dekanatow) (COUNT(DISTINCT ?parafia) AS ?liczba_parafii)</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>WHERE {</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>WHERE {</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l506">Line 506:</td> <td colspan="2" class="diff-lineno">Line 506:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>ORDER BY ?archidiakonatLabel</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>ORDER BY ?archidiakonatLabel</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ANumber%20of%20parishes%<del style="font-weight: bold; text-decoration: none;">20in</del>%20deaneries%<del style="font-weight: bold; text-decoration: none;">20and</del>%20archdeaconries%20in%20the%2016th%20century%0ASELECT%20%3Farchidiakonat%20%3FarchidiakonatLabel%20%28COUNT%28DISTINCT%20%3Fdekanat%29%20AS%20%3Fliczba_dekanatow%29%20%28COUNT%28DISTINCT%20%3Fparafia%29%20AS%20%3Fliczba_parafii%29%0AWHERE%20%7B%0A%20%20%3Farchidiakonat%20wdt%3AP27%20wd%3AQ722%20.%0A%20%20%0A%20%20%3Fdekanat%20wdt%3AP27%20wd%3AQ719%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Farchidiakonat%20.%0A%20%20%0A%20%20%3Fparafia%20wdt%3AP27%20wd%3AQ714%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fdekanat%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Farchidiakonat%20%3FarchidiakonatLabel%0AORDER%20BY%20%3FarchidiakonatLabel%0A Try it!]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ANumber%20of%20parishes%<ins style="font-weight: bold; text-decoration: none;">20and</ins>%20deaneries%<ins style="font-weight: bold; text-decoration: none;">20in</ins>%20archdeaconries%20in%20the%2016th%20century%0ASELECT%20%3Farchidiakonat%20%3FarchidiakonatLabel%20%28COUNT%28DISTINCT%20%3Fdekanat%29%20AS%20%3Fliczba_dekanatow%29%20%28COUNT%28DISTINCT%20%3Fparafia%29%20AS%20%3Fliczba_parafii%29%0AWHERE%20%7B%0A%20%20%3Farchidiakonat%20wdt%3AP27%20wd%3AQ722%20.%0A%20%20%0A%20%20%3Fdekanat%20wdt%3AP27%20wd%3AQ719%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Farchidiakonat%20.%0A%20%20%0A%20%20%3Fparafia%20wdt%3AP27%20wd%3AQ714%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fdekanat%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Farchidiakonat%20%3FarchidiakonatLabel%0AORDER%20BY%20%3FarchidiakonatLabel%0A Try it!]</div></td></tr> </table> Pjaskulski@ihpan.edu.pl https://wikihum.lab.dariah.pl/index.php?title=SPARQL_examples&diff=834890&oldid=prev Pjaskulski@ihpan.edu.pl at 20:40, 31 August 2024 2024-08-31T20:40:28Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:40, 31 August 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l487">Line 487:</td> <td colspan="2" class="diff-lineno">Line 487:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3APalatinates%2C%20district%20and%20settlements%20in%20the%2016th%20century%0A%23defaultView%3ATree%0ASELECT%20%3Fwojewodztwo%20%3FwojewodztwoLabel%20%3Fpowiat%20%3FpowiatLabel%20%3Fmiejscowosc%20%3FmiejscowoscLabel%0AWHERE%20%7B%0A%20%20%3Fwojewodztwo%20wdt%3AP27%20wd%3AQ905%20.%0A%20%20%0A%20%20%3Fpowiat%20wdt%3AP27%20wd%3AQ903%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fwojewodztwo%20.%0A%20%20%0A%20%20%3Fmiejscowosc%20wdt%3AP27%20wd%3AQ175698%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP70%20%3Fpowiat%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cpl%22.%20%7D%0A%7D%0AORDER%20BY%20%3FwojewodztwoLabel%20%3FpowiatLabel%20%3FmiejscowoscLabel Try It!]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3APalatinates%2C%20district%20and%20settlements%20in%20the%2016th%20century%0A%23defaultView%3ATree%0ASELECT%20%3Fwojewodztwo%20%3FwojewodztwoLabel%20%3Fpowiat%20%3FpowiatLabel%20%3Fmiejscowosc%20%3FmiejscowoscLabel%0AWHERE%20%7B%0A%20%20%3Fwojewodztwo%20wdt%3AP27%20wd%3AQ905%20.%0A%20%20%0A%20%20%3Fpowiat%20wdt%3AP27%20wd%3AQ903%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fwojewodztwo%20.%0A%20%20%0A%20%20%3Fmiejscowosc%20wdt%3AP27%20wd%3AQ175698%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP70%20%3Fpowiat%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cpl%22.%20%7D%0A%7D%0AORDER%20BY%20%3FwojewodztwoLabel%20%3FpowiatLabel%20%3FmiejscowoscLabel Try It!]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=== Number of parishes in deaneries and archdeaconries in the 16th century ===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;syntaxhighlight lang="SPARQL" class="mw-highlight-lang-sparql"&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#title:Number of parishes in deaneries and archdeaconries in the 16th century</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">SELECT ?archidiakonat ?archidiakonatLabel (COUNT(DISTINCT ?dekanat) AS ?liczba_dekanatow) (COUNT(DISTINCT ?parafia) AS ?liczba_parafii)</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">WHERE {</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?archidiakonat wdt:P27 wd:Q722 .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?dekanat wdt:P27 wd:Q719 ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">          wdt:P37 ?archidiakonat .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?parafia wdt:P27 wd:Q714 ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">          wdt:P37 ?dekanat .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">}</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">GROUP BY ?archidiakonat ?archidiakonatLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">ORDER BY ?archidiakonatLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/syntaxhighlight&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ANumber%20of%20parishes%20in%20deaneries%20and%20archdeaconries%20in%20the%2016th%20century%0ASELECT%20%3Farchidiakonat%20%3FarchidiakonatLabel%20%28COUNT%28DISTINCT%20%3Fdekanat%29%20AS%20%3Fliczba_dekanatow%29%20%28COUNT%28DISTINCT%20%3Fparafia%29%20AS%20%3Fliczba_parafii%29%0AWHERE%20%7B%0A%20%20%3Farchidiakonat%20wdt%3AP27%20wd%3AQ722%20.%0A%20%20%0A%20%20%3Fdekanat%20wdt%3AP27%20wd%3AQ719%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Farchidiakonat%20.%0A%20%20%0A%20%20%3Fparafia%20wdt%3AP27%20wd%3AQ714%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fdekanat%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Farchidiakonat%20%3FarchidiakonatLabel%0AORDER%20BY%20%3FarchidiakonatLabel%0A Try it!]</ins></div></td></tr> </table> Pjaskulski@ihpan.edu.pl https://wikihum.lab.dariah.pl/index.php?title=SPARQL_examples&diff=834887&oldid=prev Pjaskulski@ihpan.edu.pl at 20:28, 31 August 2024 2024-08-31T20:28:25Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:28, 31 August 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l467">Line 467:</td> <td colspan="2" class="diff-lineno">Line 467:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ACatholic%20archdeaconates%2C%20deaneries%20and%20parishes%20in%20the%2016th%20century%0A%23defaultView%3ATree%0ASELECT%20%3Farchidiakonat%20%3FarchidiakonatLabel%20%3Fdekanat%20%3FdekanatLabel%20%3Fparafia%20%3FparafiaLabel%0AWHERE%20%7B%0A%20%20%23%20Finding%20of%20archdeaconries%0A%20%20%3Farchidiakonat%20wdt%3AP27%20wd%3AQ722%20.%0A%20%20%0A%20%20%23%20Finding%20of%20deaneries%20that%20are%20part%20of%20archdeaconries%0A%20%20%3Fdekanat%20wdt%3AP27%20wd%3AQ719%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Farchidiakonat%20.%0A%20%20%0A%20%20%23%20Finding%20parishes%20that%20are%20part%20of%20deaneries%0A%20%20%3Fparafia%20wdt%3AP27%20wd%3AQ714%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fdekanat%20.%0A%20%20%0A%20%20%23%20Pobranie%20etykiet%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cpl%22.%20%7D%0A%7D%0AORDER%20BY%20%3FarchidiakonatLabel%20%3FdekanatLabel%20%3FparafiaLabel Try it!]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ACatholic%20archdeaconates%2C%20deaneries%20and%20parishes%20in%20the%2016th%20century%0A%23defaultView%3ATree%0ASELECT%20%3Farchidiakonat%20%3FarchidiakonatLabel%20%3Fdekanat%20%3FdekanatLabel%20%3Fparafia%20%3FparafiaLabel%0AWHERE%20%7B%0A%20%20%23%20Finding%20of%20archdeaconries%0A%20%20%3Farchidiakonat%20wdt%3AP27%20wd%3AQ722%20.%0A%20%20%0A%20%20%23%20Finding%20of%20deaneries%20that%20are%20part%20of%20archdeaconries%0A%20%20%3Fdekanat%20wdt%3AP27%20wd%3AQ719%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Farchidiakonat%20.%0A%20%20%0A%20%20%23%20Finding%20parishes%20that%20are%20part%20of%20deaneries%0A%20%20%3Fparafia%20wdt%3AP27%20wd%3AQ714%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fdekanat%20.%0A%20%20%0A%20%20%23%20Pobranie%20etykiet%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cpl%22.%20%7D%0A%7D%0AORDER%20BY%20%3FarchidiakonatLabel%20%3FdekanatLabel%20%3FparafiaLabel Try it!]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=== Palatinates, district and settlements in the 16th century ===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;syntaxhighlight lang="SPARQL" class="mw-highlight-lang-sparql"&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#title:Palatinates, district and settlements in the 16th century</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#defaultView:Tree</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">SELECT ?wojewodztwo ?wojewodztwoLabel ?powiat ?powiatLabel ?miejscowosc ?miejscowoscLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">WHERE {</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?wojewodztwo wdt:P27 wd:Q905 .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?powiat wdt:P27 wd:Q903 ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">          wdt:P37 ?wojewodztwo .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?miejscowosc wdt:P27 wd:Q175698 ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">              wdt:P70 ?powiat .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],pl". }</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">}</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">ORDER BY ?wojewodztwoLabel ?powiatLabel ?miejscowoscLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/syntaxhighlight&gt;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[https://wikihum.lab.dariah.pl/wdqs/#%23title%3APalatinates%2C%20district%20and%20settlements%20in%20the%2016th%20century%0A%23defaultView%3ATree%0ASELECT%20%3Fwojewodztwo%20%3FwojewodztwoLabel%20%3Fpowiat%20%3FpowiatLabel%20%3Fmiejscowosc%20%3FmiejscowoscLabel%0AWHERE%20%7B%0A%20%20%3Fwojewodztwo%20wdt%3AP27%20wd%3AQ905%20.%0A%20%20%0A%20%20%3Fpowiat%20wdt%3AP27%20wd%3AQ903%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fwojewodztwo%20.%0A%20%20%0A%20%20%3Fmiejscowosc%20wdt%3AP27%20wd%3AQ175698%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP70%20%3Fpowiat%20.%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cpl%22.%20%7D%0A%7D%0AORDER%20BY%20%3FwojewodztwoLabel%20%3FpowiatLabel%20%3FmiejscowoscLabel Try It!]</ins></div></td></tr> </table> Pjaskulski@ihpan.edu.pl https://wikihum.lab.dariah.pl/index.php?title=SPARQL_examples&diff=834877&oldid=prev Pjaskulski@ihpan.edu.pl: /* Human settlements by property type in the 16th century */ 2024-08-30T15:48:02Z <p><span dir="auto"><span class="autocomment">Human settlements by property type in the 16th century</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 15:48, 30 August 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l206">Line 206:</td> <td colspan="2" class="diff-lineno">Line 206:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ASettlements%20that%20were%20monarchically%20owned%20in%20the%2016th%20century%0A%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fahp_id%20%3Fcoordinate%0A%20%20WHERE%0A%20%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP81%20%3Fahp_id%20.%0A%20%20%20%20%20%20%3Fitem%20p%3AP63%20%3Fstatement%20.%0A%20%20%20%20%20%20%3Fitem%20p%3AP134%20%3Fstatement1.%0A%20%20%20%20%20%20%3Fstatement%20pq%3AP40%20%3Fpointintime%20.%0A%20%20%20%20%20%20%3Fstatement1%20pq%3AP40%20%3Fpointintime1%20.%0A%20%20%20%20%20%20%3Fstatement%20ps%3AP63%20%3Fcoordinate%20.%0A%20%20%20%20%20%20%3Fstatement1%20%28ps%3AP134%2F%28wdt%3AP56%2a%29%29%20wd%3AQ64.%20%20%23%20Q64%20-%20w%C5%82asno%C5%9B%C4%87%20monarsza%2C%20Q63%20-%20duchowna%2C%20Q65%20-%20mieszcza%C5%84ska%2C%20Q66%20-%20szlachecka%0A%20%20%20%20%20%20FILTER%28YEAR%28%3Fpointintime%29%20%3D%201600%29%0A%20%20%20%20%20%20FILTER%28YEAR%28%3Fpointintime1%29%20%3D%201600%29%0A%20%20%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%7D Try It!]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ASettlements%20that%20were%20monarchically%20owned%20in%20the%2016th%20century%0A%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fahp_id%20%3Fcoordinate%0A%20%20WHERE%0A%20%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP81%20%3Fahp_id%20.%0A%20%20%20%20%20%20%3Fitem%20p%3AP63%20%3Fstatement%20.%0A%20%20%20%20%20%20%3Fitem%20p%3AP134%20%3Fstatement1.%0A%20%20%20%20%20%20%3Fstatement%20pq%3AP40%20%3Fpointintime%20.%0A%20%20%20%20%20%20%3Fstatement1%20pq%3AP40%20%3Fpointintime1%20.%0A%20%20%20%20%20%20%3Fstatement%20ps%3AP63%20%3Fcoordinate%20.%0A%20%20%20%20%20%20%3Fstatement1%20%28ps%3AP134%2F%28wdt%3AP56%2a%29%29%20wd%3AQ64.%20%20%23%20Q64%20-%20w%C5%82asno%C5%9B%C4%87%20monarsza%2C%20Q63%20-%20duchowna%2C%20Q65%20-%20mieszcza%C5%84ska%2C%20Q66%20-%20szlachecka%0A%20%20%20%20%20%20FILTER%28YEAR%28%3Fpointintime%29%20%3D%201600%29%0A%20%20%20%20%20%20FILTER%28YEAR%28%3Fpointintime1%29%20%3D%201600%29%0A%20%20%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%7D Try It!]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>=== Human settlements by <del style="font-weight: bold; text-decoration: none;">property </del>type in the 16th century ===</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>=== Human settlements by <ins style="font-weight: bold; text-decoration: none;">settlement ownership </ins>type in the 16th century ===</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;syntaxhighlight lang=&quot;SPARQL&quot; class=&quot;mw-highlight-lang-sparql&quot;&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;syntaxhighlight lang=&quot;SPARQL&quot; class=&quot;mw-highlight-lang-sparql&quot;&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#title:Human settlements by <del style="font-weight: bold; text-decoration: none;">property </del>type in the 16th century</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#title:Human settlements by <ins style="font-weight: bold; text-decoration: none;">settlement ownership </ins>type in the 16th century</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#defaultView:Map</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#defaultView:Map</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>SELECT ?item ?itemLabel ?ahp_id ?coordinate ?layer</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>SELECT ?item ?itemLabel ?ahp_id ?coordinate ?layer</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l234">Line 234:</td> <td colspan="2" class="diff-lineno">Line 234:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>GROUP BY ?item ?itemLabel ?ahp_id ?coordinate ?layer</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>GROUP BY ?item ?itemLabel ?ahp_id ?coordinate ?layer</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3AHuman%20settlements%20by%<del style="font-weight: bold; text-decoration: none;">20property</del>%20type%20in%20the%2016th%20century%0A%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fahp_id%20%3Fcoordinate%20%3Flayer%0A%20%20WHERE%0A%20%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP81%20%3Fahp_id%20.%0A%20%20%20%20%20%20%3Fitem%20p%3AP63%20%3Fstatement%20.%0A%20%20%20%20%20%20%3Fitem%20p%3AP134%20%3Fstatement1.%0A%20%20%20%20%20%20%3Fstatement%20pq%3AP40%20%3Fpointintime%20.%0A%20%20%20%20%20%20%3Fstatement1%20pq%3AP40%20%3Fpointintime1%20.%0A%20%20%20%20%20%20%3Fstatement%20ps%3AP63%20%3Fcoordinate%20.%0A%20%20%20%20%20%20%3Fstatement1%20%28ps%3AP134%2F%28wdt%3AP56%2a%29%29%20%3Ftyp%0A%20%20%20%20%20%20%23%20Q64%20-%20royal%20property%2C%20Q63%20-%20ecclesiastical%20property%2C%20Q65%20-%20townsmen%20property%2C%20Q66%20-%20noble%20property%0A%20%20%20%20%20%20BIND%28%0A%20%20%20%20%20%20IF%28%3Ftyp%20%3D%20wd%3AQ64%2C%20%22royal%22%2C%0A%20%20%20%20%20%20IF%28%3Ftyp%20%3D%20wd%3AQ63%2C%20%22ecclesiastical%22%2C%0A%20%20%20%20%20%20IF%28%3Ftyp%20%3D%20wd%3AQ65%2C%20%22townsmen%22%2C%0A%20%20%20%20%20%20IF%28%3Ftyp%20%3D%20wd%3AQ66%2C%20%22noble%22%2C%0A%20%20%20%20%20%20%22inna%22%29%29%29%29%0A%20%20%20%20%20%20AS%20%3Flayer%29.%0A%20%20%20%20%20%20FILTER%28YEAR%28%3Fpointintime%29%20%3D%201600%29%0A%20%20%20%20%20%20FILTER%28YEAR%28%3Fpointintime1%29%20%3D%201600%29%0A%20%20%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Fahp_id%20%3Fcoordinate%20%3Flayer Try It!]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3AHuman%20settlements%20by%<ins style="font-weight: bold; text-decoration: none;">20settlement%20ownership</ins>%20type%20in%20the%2016th%20century%0A%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fahp_id%20%3Fcoordinate%20%3Flayer%0A%20%20WHERE%0A%20%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP81%20%3Fahp_id%20.%0A%20%20%20%20%20%20%3Fitem%20p%3AP63%20%3Fstatement%20.%0A%20%20%20%20%20%20%3Fitem%20p%3AP134%20%3Fstatement1.%0A%20%20%20%20%20%20%3Fstatement%20pq%3AP40%20%3Fpointintime%20.%0A%20%20%20%20%20%20%3Fstatement1%20pq%3AP40%20%3Fpointintime1%20.%0A%20%20%20%20%20%20%3Fstatement%20ps%3AP63%20%3Fcoordinate%20.%0A%20%20%20%20%20%20%3Fstatement1%20%28ps%3AP134%2F%28wdt%3AP56%2a%29%29%20%3Ftyp%0A%20%20%20%20%20%20%23%20Q64%20-%20royal%20property%2C%20Q63%20-%20ecclesiastical%20property%2C%20Q65%20-%20townsmen%20property%2C%20Q66%20-%20noble%20property%0A%20%20%20%20%20%20BIND%28%0A%20%20%20%20%20%20IF%28%3Ftyp%20%3D%20wd%3AQ64%2C%20%22royal%22%2C%0A%20%20%20%20%20%20IF%28%3Ftyp%20%3D%20wd%3AQ63%2C%20%22ecclesiastical%22%2C%0A%20%20%20%20%20%20IF%28%3Ftyp%20%3D%20wd%3AQ65%2C%20%22townsmen%22%2C%0A%20%20%20%20%20%20IF%28%3Ftyp%20%3D%20wd%3AQ66%2C%20%22noble%22%2C%0A%20%20%20%20%20%20%22inna%22%29%29%29%29%0A%20%20%20%20%20%20AS%20%3Flayer%29.%0A%20%20%20%20%20%20FILTER%28YEAR%28%3Fpointintime%29%20%3D%201600%29%0A%20%20%20%20%20%20FILTER%28YEAR%28%3Fpointintime1%29%20%3D%201600%29%0A%20%20%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Fahp_id%20%3Fcoordinate%20%3Flayer Try It!]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Summary of the number of people born in each century ===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Summary of the number of people born in each century ===</div></td></tr> </table> Pjaskulski@ihpan.edu.pl https://wikihum.lab.dariah.pl/index.php?title=SPARQL_examples&diff=834876&oldid=prev Pjaskulski@ihpan.edu.pl: /* Human settlements by property type in the 16th century */ 2024-08-30T15:46:12Z <p><span dir="auto"><span class="autocomment">Human settlements by property type in the 16th century</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 15:46, 30 August 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l220">Line 220:</td> <td colspan="2" class="diff-lineno">Line 220:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       ?statement ps:P63 ?coordinate .</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       ?statement ps:P63 ?coordinate .</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       ?statement1 (ps:P134/(wdt:P56*)) ?typ</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       ?statement1 (ps:P134/(wdt:P56*)) ?typ</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>       # Q64 - <del style="font-weight: bold; text-decoration: none;">royal </del>property, Q63 - <del style="font-weight: bold; text-decoration: none;">ecclesiastical </del>property, Q65 - <del style="font-weight: bold; text-decoration: none;">townsmen </del>property, Q66 - noble property</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>       # Q64 - <ins style="font-weight: bold; text-decoration: none;">monarchical </ins>property, Q63 - <ins style="font-weight: bold; text-decoration: none;">church </ins>property, Q65 - <ins style="font-weight: bold; text-decoration: none;">town </ins>property, Q66 - noble property</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       BIND(</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       BIND(</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>       IF(?typ = wd:Q64, "<del style="font-weight: bold; text-decoration: none;">royal</del>",</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>       IF(?typ = wd:Q64, "<ins style="font-weight: bold; text-decoration: none;">monarchical</ins>",</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>       IF(?typ = wd:Q63, "<del style="font-weight: bold; text-decoration: none;">ecclesiastical</del>",</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>       IF(?typ = wd:Q63, "<ins style="font-weight: bold; text-decoration: none;">church</ins>",</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>       IF(?typ = wd:Q65, "<del style="font-weight: bold; text-decoration: none;">townsmen</del>",</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>       IF(?typ = wd:Q65, "<ins style="font-weight: bold; text-decoration: none;">town</ins>",</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       IF(?typ = wd:Q66, &quot;noble&quot;,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       IF(?typ = wd:Q66, &quot;noble&quot;,</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       &quot;inna&quot;))))</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       &quot;inna&quot;))))</div></td></tr> </table> Pjaskulski@ihpan.edu.pl https://wikihum.lab.dariah.pl/index.php?title=SPARQL_examples&diff=834875&oldid=prev Pjaskulski@ihpan.edu.pl at 13:30, 30 August 2024 2024-08-30T13:30:33Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:30, 30 August 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l445">Line 445:</td> <td colspan="2" class="diff-lineno">Line 445:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Catholic archdeaconates, deaneries and parishes in the 16th century ===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== Catholic archdeaconates, deaneries and parishes in the 16th century ===</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;syntaxhighlight lang="SPARQL" class="mw-highlight-lang-sparql"&gt;</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#title:Catholic archdeaconates, deaneries and parishes in the 16th century</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#title:Catholic archdeaconates, deaneries and parishes in the 16th century</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#defaultView:Tree</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#defaultView:Tree</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l464">Line 464:</td> <td colspan="2" class="diff-lineno">Line 465:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>}</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>}</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>ORDER BY ?archidiakonatLabel ?dekanatLabel ?parafiaLabel</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>ORDER BY ?archidiakonatLabel ?dekanatLabel ?parafiaLabel</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/syntaxhighlight&gt;</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ACatholic%20archdeaconates%2C%20deaneries%20and%20parishes%20in%20the%2016th%20century%0A%23defaultView%3ATree%0ASELECT%20%3Farchidiakonat%20%3FarchidiakonatLabel%20%3Fdekanat%20%3FdekanatLabel%20%3Fparafia%20%3FparafiaLabel%0AWHERE%20%7B%0A%20%20%23%20Finding%20of%20archdeaconries%0A%20%20%3Farchidiakonat%20wdt%3AP27%20wd%3AQ722%20.%0A%20%20%0A%20%20%23%20Finding%20of%20deaneries%20that%20are%20part%20of%20archdeaconries%0A%20%20%3Fdekanat%20wdt%3AP27%20wd%3AQ719%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Farchidiakonat%20.%0A%20%20%0A%20%20%23%20Finding%20parishes%20that%20are%20part%20of%20deaneries%0A%20%20%3Fparafia%20wdt%3AP27%20wd%3AQ714%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fdekanat%20.%0A%20%20%0A%20%20%23%20Pobranie%20etykiet%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cpl%22.%20%7D%0A%7D%0AORDER%20BY%20%3FarchidiakonatLabel%20%3FdekanatLabel%20%3FparafiaLabel Try it!]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ACatholic%20archdeaconates%2C%20deaneries%20and%20parishes%20in%20the%2016th%20century%0A%23defaultView%3ATree%0ASELECT%20%3Farchidiakonat%20%3FarchidiakonatLabel%20%3Fdekanat%20%3FdekanatLabel%20%3Fparafia%20%3FparafiaLabel%0AWHERE%20%7B%0A%20%20%23%20Finding%20of%20archdeaconries%0A%20%20%3Farchidiakonat%20wdt%3AP27%20wd%3AQ722%20.%0A%20%20%0A%20%20%23%20Finding%20of%20deaneries%20that%20are%20part%20of%20archdeaconries%0A%20%20%3Fdekanat%20wdt%3AP27%20wd%3AQ719%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Farchidiakonat%20.%0A%20%20%0A%20%20%23%20Finding%20parishes%20that%20are%20part%20of%20deaneries%0A%20%20%3Fparafia%20wdt%3AP27%20wd%3AQ714%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fdekanat%20.%0A%20%20%0A%20%20%23%20Pobranie%20etykiet%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cpl%22.%20%7D%0A%7D%0AORDER%20BY%20%3FarchidiakonatLabel%20%3FdekanatLabel%20%3FparafiaLabel Try it!]</div></td></tr> </table> Pjaskulski@ihpan.edu.pl https://wikihum.lab.dariah.pl/index.php?title=SPARQL_examples&diff=834874&oldid=prev Pjaskulski@ihpan.edu.pl at 13:02, 30 August 2024 2024-08-30T13:02:43Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:02, 30 August 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l443">Line 443:</td> <td colspan="2" class="diff-lineno">Line 443:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/syntaxhighlight&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3AHuman%20settlements%20%28usually%20a%20village%29%20which%20forms%20a%20so-called%20neighbourhood%20in%2016%20century%0A%23defaultView%3AMap%0A%20%20%20%20SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fahp_id%20%3Fcoordinate%0A%20%20%20%20WHERE%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP81%20%3Fahp_id%20.%0A%20%20%20%20%20%20%3Fitem%20p%3AP63%20%3Fstatement%20.%0A%20%20%20%20%20%20%3Fstatement%20ps%3AP63%20%3Fcoordinate%20.%0A%20%20%20%20%20%20%3Fstatement%20pq%3AP40%20%3Fpointintime%20.%0A%20%20%20%20%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP84%20%3Fokolica%0A%20%20%20%20%20%20%0A%20%20%20%20%20%20FILTER%28%20YEAR%28%3Fpointintime%29%20%3D%201600%29%0A%20%20%20%20%7D Try it!]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://wikihum.lab.dariah.pl/wdqs/#%23title%3AHuman%20settlements%20%28usually%20a%20village%29%20which%20forms%20a%20so-called%20neighbourhood%20in%2016%20century%0A%23defaultView%3AMap%0A%20%20%20%20SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Fahp_id%20%3Fcoordinate%0A%20%20%20%20WHERE%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP81%20%3Fahp_id%20.%0A%20%20%20%20%20%20%3Fitem%20p%3AP63%20%3Fstatement%20.%0A%20%20%20%20%20%20%3Fstatement%20ps%3AP63%20%3Fcoordinate%20.%0A%20%20%20%20%20%20%3Fstatement%20pq%3AP40%20%3Fpointintime%20.%0A%20%20%20%20%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP84%20%3Fokolica%0A%20%20%20%20%20%20%0A%20%20%20%20%20%20FILTER%28%20YEAR%28%3Fpointintime%29%20%3D%201600%29%0A%20%20%20%20%7D Try it!]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=== Catholic archdeaconates, deaneries and parishes in the 16th century ===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#title:Catholic archdeaconates, deaneries and parishes in the 16th century</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#defaultView:Tree</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">SELECT ?archidiakonat ?archidiakonatLabel ?dekanat ?dekanatLabel ?parafia ?parafiaLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">WHERE {</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  # Finding of archdeaconries</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?archidiakonat wdt:P27 wd:Q722 .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  # Finding of deaneries that are part of archdeaconries</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?dekanat wdt:P27 wd:Q719 ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">          wdt:P37 ?archidiakonat .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  # Finding parishes that are part of deaneries</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  ?parafia wdt:P27 wd:Q714 ;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">          wdt:P37 ?dekanat .</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  # Pobranie etykiet</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],pl". }</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">}</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">ORDER BY ?archidiakonatLabel ?dekanatLabel ?parafiaLabel</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[https://wikihum.lab.dariah.pl/wdqs/#%23title%3ACatholic%20archdeaconates%2C%20deaneries%20and%20parishes%20in%20the%2016th%20century%0A%23defaultView%3ATree%0ASELECT%20%3Farchidiakonat%20%3FarchidiakonatLabel%20%3Fdekanat%20%3FdekanatLabel%20%3Fparafia%20%3FparafiaLabel%0AWHERE%20%7B%0A%20%20%23%20Finding%20of%20archdeaconries%0A%20%20%3Farchidiakonat%20wdt%3AP27%20wd%3AQ722%20.%0A%20%20%0A%20%20%23%20Finding%20of%20deaneries%20that%20are%20part%20of%20archdeaconries%0A%20%20%3Fdekanat%20wdt%3AP27%20wd%3AQ719%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Farchidiakonat%20.%0A%20%20%0A%20%20%23%20Finding%20parishes%20that%20are%20part%20of%20deaneries%0A%20%20%3Fparafia%20wdt%3AP27%20wd%3AQ714%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP37%20%3Fdekanat%20.%0A%20%20%0A%20%20%23%20Pobranie%20etykiet%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cpl%22.%20%7D%0A%7D%0AORDER%20BY%20%3FarchidiakonatLabel%20%3FdekanatLabel%20%3FparafiaLabel Try it!]</ins></div></td></tr> </table> Pjaskulski@ihpan.edu.pl