SPARQL examples - Revision history

Admin: /* Simple Queries */ fix wrong property

2023-06-01T13:08:09Z

Simple Queries: fix wrong property

← Older revision		Revision as of 13:08, 1 June 2023
Line 10:		Line 10:
	?item wdt:P1 ?dependency.		?item wdt:P1 ?dependency.
	?item wdt:P2 ?class		?item wdt:P2 ?class
	OPTIONAL{ ?item wdt:P9 ?image.}		OPTIONAL{ ?item wdt:P11 ?image.}
	OPTIONAL{ ?class wdt:P9 ?image.}		OPTIONAL{ ?class wdt:P11 ?image.}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}

Admin at 12:47, 31 May 2023

2023-05-31T12:47:05Z

← Older revision		Revision as of 12:47, 31 May 2023
Line 1:		Line 1:
	This page is automatically parsed by the query page to provide examples.		This page is automatically parsed by the query page to provide examples.


	== Simple Queries ==		== Simple Queries ==

Admin: change all examples to SPARQL2 template

2023-05-31T12:45:45Z

change all examples to SPARQL2 template

← Older revision		Revision as of 12:45, 31 May 2023
Line 16:		Line 16:

	=== Central topics (topics with a high number of dependencies) ===		=== Central topics (topics with a high number of dependencies) ===
	{{~~SPARQL~~\|query=		{{SPARQL2\|query=
	#defaultView:Graph		#defaultView:Graph
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
Line 38:		Line 38:

	=== Advanced topics (topics with a high number of prerequisites) ===		=== Advanced topics (topics with a high number of prerequisites) ===
	{{~~SPARQL~~\|query=		{{SPARQL2\|query=
	#defaultView:Graph		#defaultView:Graph
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
Line 60:		Line 60:

	=== Topics that Max Mustermann has completed ===		=== Topics that Max Mustermann has completed ===
	{{~~SPARQL~~\|query=		{{SPARQL2\|query=
	#defaultView:Timeline		#defaultView:Timeline
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
Line 80:		Line 80:

	=== Stuff you need to learn if you want to write an image editor ===		=== Stuff you need to learn if you want to write an image editor ===
	{{~~SPARQL~~\|query=		{{SPARQL2\|query=
	#defaultView:Graph		#defaultView:Graph
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
Line 108:		Line 108:

	=== All backlinks to a given topic ===		=== All backlinks to a given topic ===
	{{~~SPARQL~~\|query=		{{SPARQL2\|query=
	#defaultView:Graph		#defaultView:Graph
	PREFIX wdt: <https://graphit.ur.de/prop/direct/>		PREFIX wdt: <https://graphit.ur.de/prop/direct/>

Admin at 12:28, 31 May 2023

2023-05-31T12:28:54Z

← Older revision		Revision as of 12:28, 31 May 2023
Line 14:		Line 14:
	}		}
	}}		}}


	=== Central topics (topics with a high number of dependencies) ===		=== Central topics (topics with a high number of dependencies) ===

Admin: test

2023-05-31T12:17:35Z

test

← Older revision		Revision as of 12:17, 31 May 2023
Line 3:		Line 3:
	== Simple Queries ==		== Simple Queries ==
	=== Complete Dependency Graph ===		=== Complete Dependency Graph ===
	{{~~SPARQL~~\|query=		{{SPARQL2\|query=
	#defaultView:Graph		#defaultView:Graph
	PREFIX wdt: <https://graphit.ur.de/prop/direct/>		PREFIX wdt: <https://graphit.ur.de/prop/direct/>
Line 14:		Line 14:
	}		}
	}}		}}


	=== Central topics (topics with a high number of dependencies) ===		=== Central topics (topics with a high number of dependencies) ===

Admin: add backlinks example

2023-05-30T14:05:55Z

add backlinks example

← Older revision		Revision as of 14:05, 30 May 2023
Line 107:		Line 107:
	}}		}}

			=== All backlinks to a given topic ===
			{{SPARQL\|query=
			#defaultView:Graph
			PREFIX wdt: <https://graphit.ur.de/prop/direct/>
			PREFIX wd: <https://graphit.ur.de/entity/>
			select distinct ?subject ?subjectLabel ?item ?itemLabel { # ?property ?propertyLabel
			values (?item) {(wd:Q159)}
			?subject ?predicate ?item .
			?property wikibase:directClaim ?predicate
			service wikibase:label { bd:serviceParam wikibase:language "en" }
			}
			}}

	== Not yet implemented ==		== Not yet implemented ==

Admin: update goal example

2023-05-06T10:28:22Z

update goal example

← Older revision		Revision as of 10:28, 6 May 2023
Line 90:		Line 90:
	PREFIX pq: <https://graphit.ur.de/prop/qualifier/>		PREFIX pq: <https://graphit.ur.de/prop/qualifier/>

	SELECT ?topic ?topicLabel ?item2 ?item2Label ~~?goal ?goalLabel~~ ?image WHERE {		SELECT ?topic ?topicLabel ?item2 ?item2Label ?image WHERE {
	{		{
	SELECT ?goal ?goalLabel ?topic ?topicLabel ?image WHERE {		SELECT ?goal ?goalLabel ?topic ?topicLabel ?image WHERE {
			{
	BIND(wd:Q76 as ?goal).		BIND(wd:Q76 as ?goal).
	?goal wdt:P1+ ?topic.		?goal wdt:P1+ ?topic.
	OPTIONAL{ ?topic wdt:P11 ?image.}		OPTIONAL{ ?topic wdt:P11 ?image.}
			} UNION {
			VALUES ?topic { wd:Q76 } # we also want to include the root node itself
			}
	}		}
	}		}

Admin: add path to goal example

2023-05-05T22:41:46Z

add path to goal example

@@ Line 78: / Line 78: @@
+}
 }}
 == Not yet implemented ==
@@ Line 86: / Line 112: @@
 === Educational resources for learning Python ===

Admin: test

2023-05-05T22:19:58Z

test

← Older revision		Revision as of 22:19, 5 May 2023
Line 3:		Line 3:
	== Simple Queries ==		== Simple Queries ==
	=== Complete Dependency Graph ===		=== Complete Dependency Graph ===
			{{SPARQL\|query=
	#defaultView:Graph		#defaultView:Graph
	PREFIX wdt: <https://graphit.ur.de/prop/direct/>		PREFIX wdt: <https://graphit.ur.de/prop/direct/>
Line 12:		Line 13:
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}
			}}

	=== Central topics (topics with a high number of dependencies) ===		=== Central topics (topics with a high number of dependencies) ===
			{{SPARQL\|query=
	#defaultView:Graph		#defaultView:Graph
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
Line 33:		Line 35:
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}
			}}

	=== Advanced topics (topics with a high number of prerequisites) ===		=== Advanced topics (topics with a high number of prerequisites) ===
			{{SPARQL\|query=
	#defaultView:Graph		#defaultView:Graph
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
Line 54:		Line 57:
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}
			}}

	=== Topics that Max Mustermann has completed ===		=== Topics that Max Mustermann has completed ===
			{{SPARQL\|query=
	#defaultView:Timeline		#defaultView:Timeline
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
Line 72:		Line 77:
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}
			}}

	== Not yet implemented ==		== Not yet implemented ==

Admin: test

2023-05-05T22:18:34Z

test

← Older revision		Revision as of 22:18, 5 May 2023
Line 3:		Line 3:
	== Simple Queries ==		== Simple Queries ==
	=== Complete Dependency Graph ===		=== Complete Dependency Graph ===
	~~{{#widget:SPARQLquery\|code=~~
	#defaultView:Graph		#defaultView:Graph
	PREFIX wdt: <https://graphit.ur.de/prop/direct/>		PREFIX wdt: <https://graphit.ur.de/prop/direct/>
Line 13:		Line 12:
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}
	}}

	=== Central topics (topics with a high number of dependencies) ===		=== Central topics (topics with a high number of dependencies) ===
	~~{{#widget:SPARQLquery\|code=~~
	#defaultView:Graph		#defaultView:Graph
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
Line 35:		Line 33:
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}
	}}

	=== Advanced topics (topics with a high number of prerequisites) ===		=== Advanced topics (topics with a high number of prerequisites) ===
	~~{{#widget:SPARQLquery\|code=~~
	#defaultView:Graph		#defaultView:Graph
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
Line 57:		Line 54:
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}
	}}

	=== Topics that Max Mustermann has completed ===		=== Topics that Max Mustermann has completed ===
	~~{{#widget:SPARQLquery\|code=~~
	#defaultView:Timeline		#defaultView:Timeline
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>
Line 77:		Line 72:
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	}		}
	}}
			== Not yet implemented ==

			=== Topics that Max Mustermann wants to complete ===

			=== All topics in the CGBV course ===

			=== Educational resources for learning Python ===

			=== Stuff you need to learn if you want to write a tool that counts objects in an image ===