User:Daniel/Queries/LinkedWikiTest: Difference between revisions

Revision as of 11:45, 8 June 2023

publication_date	work	workLabel	workUrl
2024-01-01	http://www.wikidata.org/entity/Q124254609	Computational reproducibility of Jupyter notebooks from biomedical publications	/work/Q124254609
2022-04-04	http://www.wikidata.org/entity/Q111507314	WikiProject Clinical Trials for Wikidata	/work/Q111507314
2022-02-28	http://www.wikidata.org/entity/Q111145762	WikiProject Clinical Trials snapshot February 2022	/work/Q111145762
2017-07-20	http://www.wikidata.org/entity/Q33269085	A multi-disciplinary perspective on emergent and future innovations in peer review	/work/Q33269085
2014-06-16	http://www.wikidata.org/entity/Q22064488	Enriched biodiversity data as a resource and service	/work/Q22064488
16:27:55 06/29/2024 -- Refresh -- Duration of query :0.192s -- CSV

publication_date	work	workLabel	workUrl
16:27:55 06/29/2024 -- Refresh -- Duration of query :0.173s -- CSV

node	nodeLabel	nodeImage	childNode	childNodeLabel	childNodeImage	rgb
16:27:55 06/29/2024 -- Refresh -- Duration of query :0.125s -- CSV

@@ Line 73: / Line 73: @@
 }}
 {{Use_Sparql|Q20895}}
+{{#sparql:
+# tool: scholia
+PREFIX target: <http://www.wikidata.org/entity/Q1195879>
+#defaultView:Graph
+SELECT ?node ?nodeLabel ?nodeImage ?childNode ?childNodeLabel ?childNodeImage ?rgb
+WITH {
+  SELECT DISTINCT ?property WHERE {
+      ?property a wikibase:Property;
+                wdt:P31 wd:Q18610173 ;
+                wdt:P31 wd:Q26940804 .
+    }
+} AS %properties
+WITH {
+  SELECT DISTINCT ?node ?childNode WHERE {
+      BIND(target: AS ?node)
+      ?node ?p ?i.
+      ?childNode ?x ?p.
+      ?childNode rdf:type wikibase:Property.
+      FILTER(STRSTARTS(STR(?i), "http://www.wikidata.org/entity/Q"))
+      FILTER(STRSTARTS(STR(?childNode), "http://www.wikidata.org/entity/P"))
+    }
+  LIMIT 5000
+} AS %nodes
+WITH {
+  SELECT DISTINCT ?childNode ?node ?rgb WHERE {
+      BIND("EFFBD8" AS ?rgb)
+      target: ?p ?childNode.
+      ?node ?x ?p.
+      ?node rdf:type wikibase:Property.
+      FILTER(STRSTARTS(STR(?childNode), "http://www.wikidata.org/entity/Q"))
+    }
+  LIMIT 5000
+} AS %childNodes
+WHERE {
+  {
+    INCLUDE %nodes
+  }
+  UNION
+  {
+    INCLUDE %childNodes
+  }
+  OPTIONAL {
+    INCLUDE %properties
+    ?property wikibase:directClaim ?nodeclaim.
+    ?node ?nodeclaim ?nodeImage.
+  }
+  OPTIONAL {
+    INCLUDE %properties
+    ?property wikibase:directClaim ?childNodeclaim.
+    ?childNode ?childNodeclaim ?childNodeImage.
+  }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
+}
+}}