https://wiki.personaldata.io/w/index.php?action=history&feed=atom&title=Template%3ASPARQLhierarchy Template:SPARQLhierarchy - Revision history 2026-04-03T17:40:17Z Revision history for this page on the wiki MediaWiki 1.35.1 https://wiki.personaldata.io/w/index.php?title=Template:SPARQLhierarchy&diff=4361&oldid=prev Podehaye at 03:22, 21 May 2019 2019-05-21T03:22:12Z <p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" 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 03:22, 21 May 2019</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-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;"></del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-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;">PREFIX pdio: &lt;http://wiki.personaldata.io/entity/&gt;</del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-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;">PREFIX pdiot: &lt;http://wiki.personaldata.io/prop/direct/&gt;</del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-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;">PREFIX pdiop: &lt;http://wiki.personaldata.io/prop/&gt;</del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-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;">PREFIX pdiops: &lt;http://wiki.personaldata.io/prop/statement/&gt;</del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-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;">PREFIX pdiopq: &lt;http://wiki.personaldata.io/prop/qualifier/&gt;</del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-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;"></del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-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;"></del></div></td><td colspan="2"> </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:Graph</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:Graph</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 ?item1 ?item1Label ?rgb ?item2 ?item2Label ?link</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 ?item1 ?item1Label ?rgb ?item2 ?item2Label ?link</div></td></tr> <!-- diff cache key my_wiki:diff::1.12:old-4350:rev-4361 --> </table> Podehaye https://wiki.personaldata.io/w/index.php?title=Template:SPARQLhierarchy&diff=4350&oldid=prev Podehaye: Podehaye moved page SPARQLhierarchy to Template:SPARQLhierarchy 2019-05-21T03:14:16Z <p>Podehaye moved page <a href="/w/index.php?title=SPARQLhierarchy&amp;action=edit&amp;redlink=1" class="new" title="SPARQLhierarchy (page does not exist)">SPARQLhierarchy</a> to <a href="/wiki/Template:SPARQLhierarchy" title="Template:SPARQLhierarchy">Template:SPARQLhierarchy</a></p> <table class="diff diff-contentalign-left diff-editfont-monospace" 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 03:14, 21 May 2019</td> </tr> <!-- diff cache key my_wiki:diff::1.12:old-4346:rev-4350 --> </table> Podehaye https://wiki.personaldata.io/w/index.php?title=Template:SPARQLhierarchy&diff=4346&oldid=prev 192.168.0.1: Created page with " PREFIX pdio: <http://wiki.personaldata.io/entity/> PREFIX pdiot: <http://wiki.personaldata.io/prop/direct/> PREFIX pdiop: <http://wiki.personaldata.io/prop/> PREFIX pdiops: <..." 2019-05-21T03:11:14Z <p>Created page with &quot; PREFIX pdio: &lt;http://wiki.personaldata.io/entity/&gt; PREFIX pdiot: &lt;http://wiki.personaldata.io/prop/direct/&gt; PREFIX pdiop: &lt;http://wiki.personaldata.io/prop/&gt; PREFIX pdiops: &lt;...&quot;</p> <p><b>New page</b></p><div><br /> PREFIX pdio: &lt;http://wiki.personaldata.io/entity/&gt;<br /> PREFIX pdiot: &lt;http://wiki.personaldata.io/prop/direct/&gt;<br /> PREFIX pdiop: &lt;http://wiki.personaldata.io/prop/&gt;<br /> PREFIX pdiops: &lt;http://wiki.personaldata.io/prop/statement/&gt;<br /> PREFIX pdiopq: &lt;http://wiki.personaldata.io/prop/qualifier/&gt;<br /> <br /> <br /> #defaultView:Graph<br /> SELECT ?item1 ?item1Label ?rgb ?item2 ?item2Label ?link<br /> WITH {SELECT ?nodeType ?nodeRGB WHERE {<br /> pdio:{{{visualization}}} pdiop:P26 ?nodeTypeStatement.<br /> ?nodeTypeStatement pdiops:P26 ?nodeType.<br /> OPTIONAL {<br /> ?nodeTypeStatement pdiopq:P115 ?nodeRGB<br /> }<br /> }<br /> }<br /> AS %nodeTypes<br /> WITH {SELECT ?edgeTypeDomain ?edgeTypeRange ?edgeType ?rgb WHERE {<br /> pdio:Q803 pdiop:P117 ?edgeTypeStatement.<br /> ?edgeTypeStatement pdiops:P117 ?edgeType.<br /> ?edgeTypeStatement pdiopq:P24 ?edgeTypeDomain.<br /> ?edgeTypeStatement pdiopq:P23 ?edgeTypeRange.<br /> OPTIONAL {<br /> ?edgeTypeStatement pdiopq:P115 ?rgb <br /> }<br /> }<br /> }<br /> AS %edgeTypes<br /> WITH {SELECT ?node ?nodeType ?nodeRGB WHERE {<br /> ?node pdiot:{{{predicate}}} pdio:{{{value}}}.<br /> ?node pdiot:P3 ?nodeType.<br /> INCLUDE %nodeTypes.<br /> }<br /> }<br /> AS %nodes<br /> WITH {SELECT ?domain ?range ?rgb WHERE {<br /> INCLUDE %edgeTypes.<br /> ?domain pdiot:P3 ?edgeTypeDomain.<br /> ?range pdiot:P3 ?edgeTypeRange.<br /> ?edgeType pdiot:P105 ?Pid.<br /> BIND(URI(CONCAT(&quot;http://wiki.personaldata.io/prop/direct/&quot;, ?Pid)) AS ?link).<br /> ?domain ?link ?range.<br /> ?domain pdiot:{{{predicate}}} pdio:{{{value}}}. # This is filtering for each edge twice, potentially a huge waste: |E|*|V| instead of |V|<br /> ?range pdiot:{{{predicate}}} pdio:{{{value}}}.<br /> }<br /> } AS %edges<br /> WHERE {<br /> { <br /> INCLUDE %nodeTypes.<br /> BIND(?nodeType AS ?item1).<br /> BIND(?nodeRGB AS ?rgb).<br /> }<br /> UNION<br /> { <br /> INCLUDE %edgeTypes.<br /> BIND(?edgeTypeDomain AS ?item1).<br /> BIND(?edgeTypeRange AS ?item2).<br /> }<br /> UNION<br /> { <br /> INCLUDE %nodes.<br /> BIND(?node AS ?item1).<br /> BIND(?nodeRGB AS ?rgb).<br /> }<br /> UNION<br /> { <br /> INCLUDE %edges.<br /> BIND(?domain AS ?item1).<br /> BIND(?range AS ?item2).<br /> }<br /> SERVICE wikibase:label {<br /> bd:serviceParam wikibase:language &quot;en&quot; . <br /> }<br /> }<br /> LIMIT 10000</div> 192.168.0.1