https://wiki.planetoid.info/index.php?action=history&feed=atom&title=Wikidata_SPARQL_query_examples Wikidata SPARQL query examples - Revision history 2026-06-24T02:17:01Z Revision history for this page on the wiki MediaWiki 1.39.6 https://wiki.planetoid.info/index.php?title=Wikidata_SPARQL_query_examples&diff=24392&oldid=prev Unknown user at 02:39, 2 February 2024 2024-02-02T02:39:59Z <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 10:39, 2 February 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l41">Line 41:</td> <td colspan="2" class="diff-lineno">Line 41:</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>&lt;/pre&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;/pre&gt;</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;">修改自維基數據:SPARQL查詢示例&lt;ref>[https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/zh#2017%E5%B9%B4%E4%B8%8A%E6%98%A0%E7%9A%84%E7%94%B5%E5%BD%B1 2017]&lt;/ref></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;"> SELECT DISTINCT ?item ?itemLabel 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:P31 wd:Q11424.</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:P577 ?pubdate.</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((?pubdate >= "{{CURRENTYEAR}}-01-01T00:00:00Z"^^xsd:dateTime) &amp;&amp; (?pubdate &lt;= "{{CURRENTYEAR}}-12-31T00:00:00Z"^^xsd:dateTime))</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;"></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;"><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>== Further reading ==</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>== Further reading ==</div></td></tr> </table> Unknown user https://wiki.planetoid.info/index.php?title=Wikidata_SPARQL_query_examples&diff=24299&oldid=prev Unknown user at 03:25, 14 January 2024 2024-01-14T03:25:35Z <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 11:25, 14 January 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l48">Line 48:</td> <td colspan="2" class="diff-lineno">Line 48:</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>== References ==</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>== References ==</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;references /&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;references /&gt;</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;">[[Category: Wikidata]] [[Category: Sparql]]</ins></div></td></tr> </table> Unknown user https://wiki.planetoid.info/index.php?title=Wikidata_SPARQL_query_examples&diff=24298&oldid=prev Unknown user at 03:25, 14 January 2024 2024-01-14T03:25:01Z <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 11:25, 14 January 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l41">Line 41:</td> <td colspan="2" class="diff-lineno">Line 41:</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>&lt;/pre&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;/pre&gt;</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;">== Further reading ==</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://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples Wikidata:SPARQL query service/queries/examples - Wikidata]</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://stackoverflow.com/questions/tagged/sparql Newest 'sparql' Questions - Stack Overflow]</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;"><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>== References ==</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>== References ==</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><del style="font-weight: bold; text-decoration: none;">* [https:</del>/<del style="font-weight: bold; text-decoration: none;">/www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples Wikidata:SPARQL query service/queries/examples - Wikidata]</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><ins style="font-weight: bold; text-decoration: none;">&lt;references </ins>/<ins style="font-weight: bold; text-decoration: none;">&gt;</ins></div></td></tr> </table> Unknown user https://wiki.planetoid.info/index.php?title=Wikidata_SPARQL_query_examples&diff=24297&oldid=prev Unknown user: Created page with " {{Draft}} == 2023年台灣放映的電影 == [https://query.wikidata.org/querybuilder/?uselang=zh Wikidata Query Builder] * 原產地 ([https://www.wikidata.org/wiki/Proper..." 2024-01-14T01:40:40Z <p>Created page with &quot; {{Draft}} == 2023年台灣放映的電影 == [https://query.wikidata.org/querybuilder/?uselang=zh Wikidata Query Builder] * 原產地 ([https://www.wikidata.org/wiki/Proper...&quot;</p> <p><b>New page</b></p><div><br /> {{Draft}}<br /> <br /> == 2023年台灣放映的電影 ==<br /> <br /> [https://query.wikidata.org/querybuilder/?uselang=zh Wikidata Query Builder]<br /> * 原產地 ([https://www.wikidata.org/wiki/Property:P495 P495]) = 中華民國 ([https://www.wikidata.org/wiki/Q865 Q865])<br /> * 隸屬於 ([https://www.wikidata.org/wiki/Q865 Q865]) = 電影 ([https://www.wikidata.org/wiki/Q11424 Q11424])<br /> * 出版日期 ([https://www.wikidata.org/wiki/Property:P577 P577]) after 2023-1-1<br /> * 出版日期 ([https://www.wikidata.org/wiki/Property:P577 P577]) before 2023-1-1<br /> * 影視作品原始語言 ([https://www.wikidata.org/wiki/Property:P364 P364]) = 國語 ([https://www.wikidata.org/wiki/Q262828 Q262828])<br /> * Limit the number of results to: 100<br /> <br /> [https://query.wikidata.org/#SELECT%20DISTINCT%20?item%20?itemLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase:label%20%7B%20bd:serviceParam%20wikibase:language%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%20%20%7B%0A%20%20%20%20SELECT%20DISTINCT%20?item%20WHERE%20%7B%0A%20%20%20%20%20%20?item%20p:P495%20?statement0.%0A%20%20%20%20%20%20?statement0%20(ps:P495/(wdt:P279*))%20wd:Q865.%0A%20%20%20%20%20%20?item%20p:P31%20?statement1.%0A%20%20%20%20%20%20?statement1%20(ps:P31/(wdt:P279*))%20wd:Q11424.%0A%20%20%20%20%20%20?item%20p:P577%20?statement_2.%0A%20%20%20%20%20%20?statement_2%20psv:P577%20?statementValue_2.%0A%20%20%20%20%20%20?statementValue_2%20wikibase:timePrecision%20?precision_2.%0A%20%20%20%20%20%20FILTER(?precision_2%20%3E=%2011%20)%0A%20%20%20%20%20%20?statementValue_2%20wikibase:timeValue%20?P577_2.%0A%20%20%20%20%20%20FILTER(?P577_2%20%3E%20%22+2023-01-01T00:00:00Z%22%5E%5Exsd:dateTime)%0A%20%20%20%20%20%20?item%20p:P364%20?statement3.%0A%20%20%20%20%20%20?statement3%20(ps:P364/(wdt:P279*))%20wd:Q262828.%0A%20%20%20%20%20%20?item%20p:P577%20?statement_4.%0A%20%20%20%20%20%20?statement_4%20psv:P577%20?statementValue_4.%0A%20%20%20%20%20%20?statementValue_4%20wikibase:timePrecision%20?precision_4.%0A%20%20%20%20%20%20FILTER(?precision_4%20%3E=%2011%20)%0A%20%20%20%20%20%20?statementValue_4%20wikibase:timeValue%20?P577_4.%0A%20%20%20%20%20%20FILTER(?P577_4%20%3C%20%22+2024-01-01T00:00:00Z%22%5E%5Exsd:dateTime)%0A%20%20%20%20%7D%0A%20%20%20%20LIMIT%20100%0A%20%20%7D%0A%7D Show query in the Query Service]<br /> &lt;pre&gt;<br /> SELECT DISTINCT ?item ?itemLabel WHERE {<br /> SERVICE wikibase:label { bd:serviceParam wikibase:language &quot;[AUTO_LANGUAGE]&quot;. }<br /> {<br /> SELECT DISTINCT ?item WHERE {<br /> ?item p:P495 ?statement0.<br /> ?statement0 (ps:P495/(wdt:P279*)) wd:Q865.<br /> ?item p:P31 ?statement1.<br /> ?statement1 (ps:P31/(wdt:P279*)) wd:Q11424.<br /> ?item p:P577 ?statement_2.<br /> ?statement_2 psv:P577 ?statementValue_2.<br /> ?statementValue_2 wikibase:timePrecision ?precision_2.<br /> FILTER(?precision_2 &gt;= 11 )<br /> ?statementValue_2 wikibase:timeValue ?P577_2.<br /> FILTER(?P577_2 &gt; &quot;+2023-01-01T00:00:00Z&quot;^^xsd:dateTime)<br /> ?item p:P364 ?statement3.<br /> ?statement3 (ps:P364/(wdt:P279*)) wd:Q262828.<br /> ?item p:P577 ?statement_4.<br /> ?statement_4 psv:P577 ?statementValue_4.<br /> ?statementValue_4 wikibase:timePrecision ?precision_4.<br /> FILTER(?precision_4 &gt;= 11 )<br /> ?statementValue_4 wikibase:timeValue ?P577_4.<br /> FILTER(?P577_4 &lt; &quot;+2024-01-01T00:00:00Z&quot;^^xsd:dateTime)<br /> }<br /> LIMIT 100<br /> }<br /> }<br /> &lt;/pre&gt;<br /> <br /> == References ==<br /> * [https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples Wikidata:SPARQL query service/queries/examples - Wikidata]</div> Unknown user