Select Git revision
Code owners
Assign users and groups as approvers for specific file changes. Learn more.
preperation.txt 12.28 KiB
##############################################################################
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX dbc: <http://dbpedia.org/resource/Category:>
SELECT DISTINCT ?film_title
WHERE {
?film_title rdf:type <http://dbpedia.org/ontology/Film> .
?film_title dct:subject dbc:Comedy.
} LIMIT 1000 OFFSET 0
##############################################################################
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT DISTINCT ?movie ?label
WHERE{
?movie wdt:P31 wd:Q11424.
?movie rdfs:label ?label.
}
921517 Ergebnisse in 9599 ms
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT DISTINCT ?movie ?label
WHERE{
# node who instances of films
?movie wdt:P31 wd:Q11424.
# nodes who are instances of y as a subclass of films.
OPTIONAL {
?movie wdt:P31 [
wdt:P279 wd:Q11424
].
}
?movie rdfs:label ?label.
}
921514 Ergebnisse
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT DISTINCT ?movie ?label
WHERE{
# node who instances of films
?movie wdt:P31 wd:Q11424.
# nodes who are instances of y as a subclass of films.
OPTIONAL {
?movie wdt:P31 [
wdt:P279 wd:Q11424
].
}
# nodes who are instances of y as a instance of a film genre. OPTIONAL {
?movie wdt:P31 [
wdt:P31 wd:Q201658
].
}
?movie rdfs:label ?label.
}
921514 Ergebnisse
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT DISTINCT ?movie ?label
WHERE{
# node who instances of films
?movie wdt:P31 wd:Q11424.
# nodes who are instances of y as a subclass of films.
OPTIONAL {
?movie wdt:P31 [
wdt:P279 wd:Q11424
].
}
# nodes who are instances of y as a instance of a film genre.
OPTIONAL {
?movie wdt:P31 [
wdt:P31 wd:Q201658
].
}
# node who instances of y and who are a instance or a subclass of z which is a subclass of film.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P279 wd:Q11424
]
].
}
?movie rdfs:label ?label.
}
921517 Ergebnisse
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT DISTINCT ?movie ?label
WHERE{
# node who instances of films
?movie wdt:P31 wd:Q11424.
# nodes who are instances of y as a subclass of films.
OPTIONAL {
?movie wdt:P31 [
wdt:P279 wd:Q11424
].
} # nodes who are instances of y as a instance of a film genre.
OPTIONAL {
?movie wdt:P31 [
wdt:P31 wd:Q201658
].
}
# node who instances of y and who are a instance or a subclass of z which is a subclass of film.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P279 wd:Q11424
]
].
}
# node who instances of y and who are a instance or a subclass of z which is a instance of a film genre.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P31 wd:Q201658
]
].
}
?movie rdfs:label ?label.
}
921517 Ergebnisse
#################################### Alternative #######
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?movie (SAMPLE (?label) AS ?title)
WHERE {
?movie wdt:P136 [
wdt:P279 wd:Q40831,
wd:Q11424
].
OPTIONAL {
?movie wdt:P136 [
wdt:P279 wd:Q40831;
wdt:P31 wd:Q201658
].
}
?movie rdfs:label ?label
}GROUP BY ?movie
151696 Ergebnisse
######################################################
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?movie (SAMPLE(?label) AS ?title)
WHERE{
# node who instances of films
?movie wdt:P31 wd:Q11424.
# nodes who are instances of y as a subclass of films.
OPTIONAL {
?movie wdt:P31 [
wdt:P279 wd:Q11424
].
}
# nodes who are instances of y as a instance of a film genre.
OPTIONAL {
?movie wdt:P31 [
wdt:P31 wd:Q201658
].
}
# node who instances of y and who are a instance or a subclass of z which is a subclass of film.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P279 wd:Q11424
]
].
}
# node who instances of y and who are a instance or a subclass of z which is a instance of a film genre.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P31 wd:Q201658
]
].
}
# nodes whos are of genre comedy and film
?movie wdt:P136 [
wdt:P279 wd:Q40831,
wd:Q11424
].
# nodes whos genre is comedy and a film genre (not theater)
OPTIONAL {
?movie wdt:P136 [
wdt:P279 wd:Q40831;
wdt:P31 wd:Q201658
].
}
?movie rdfs:label ?label.
}
GROUP BY ?movie
26268 Ergebnisse in 10322 ms
#################################
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?movie (SAMPLE(?label) AS ?title) (SAMPLE(?director) AS ?director_name) (SAMPLE(?birthday) AS ?director_birthday)
WHERE{
# node who instances of films
?movie wdt:P31 wd:Q11424.
# nodes who are instances of y as a subclass of films.
OPTIONAL {
?movie wdt:P31 [
wdt:P279 wd:Q11424
].
}
# nodes who are instances of y as a instance of a film genre.
OPTIONAL {
?movie wdt:P31 [
wdt:P31 wd:Q201658
].
}
# node who instances of y and who are a instance or a subclass of z which is a subclass of film.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P279 wd:Q11424
]
].
}
# node who instances of y and who are a instance or a subclass of z which is a instance of a film genre.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P31 wd:Q201658
]
].
}
# nodes who are of genre comedy
?movie wdt:P136 [
wdt:P279 wd:Q40831
]
# nodes whos are of genre comedy and film
OPTIONAL {
?movie wdt:P136 [
wdt:P279 wd:Q40831,
wd:Q11424
].
}
# nodes whos genre is comedy and a film genre (not theater)
OPTIONAL {
?movie wdt:P136 [
wdt:P279 wd:Q40831;
wdt:P31 wd:Q201658
].
}
?movie rdfs:label ?label.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
?movie wdt:P57 ?director.
?director wdt:P569 ?birthday.
}
GROUP BY ?movie
#25297 Ergebnisse in 34700 ms
Interessant Q1562657
#############################
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?director (SAMPLE(?label) AS ?title) (SAMPLE(?movie) AS ?movie_name) (SAMPLE(?birthday) AS ?director_birthday)
WHERE{
# node who instances of films
?movie wdt:P31 wd:Q11424.
# nodes who are instances of y as a subclass of films.
OPTIONAL {
?movie wdt:P31 [
wdt:P279 wd:Q11424
].
}
# nodes who are instances of y as a instance of a film genre.
OPTIONAL {
?movie wdt:P31 [
wdt:P31 wd:Q201658
].
}
# node who instances of y and who are a instance or a subclass of z which is a subclass of film.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P279 wd:Q11424
]
].
}
# node who instances of y and who are a instance or a subclass of z which is a instance of a film genre.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P31 wd:Q201658
]
].
}
# nodes who are of genre comedy
?movie wdt:P136 [
wdt:P279 wd:Q40831
]
# nodes whos are of genre comedy and film
OPTIONAL {
?movie wdt:P136 [
wdt:P279 wd:Q40831,
wd:Q11424
].
}
# nodes whos genre is comedy and a film genre (not theater)
OPTIONAL {
?movie wdt:P136 [
wdt:P279 wd:Q40831;
wdt:P31 wd:Q201658
].
}
?movie rdfs:label ?label.
?movie wdt:P57 ?director.
?director wdt:P569 ?birthday.
}
GROUP BY ?director
9880 Ergebnisse in 19491 ms
######################################################################
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?movie ?director ?birthday
WHERE{
# node who instances of films
?movie wdt:P31 wd:Q11424.
# nodes who are instances of y as a subclass of films.
OPTIONAL {
?movie wdt:P31 [
wdt:P279 wd:Q11424
].
}
# nodes who are instances of y as a instance of a film genre.
OPTIONAL {
?movie wdt:P31 [
wdt:P31 wd:Q201658
].
}
# node who instances of y and who are a instance or a subclass of z which is a subclass of film.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P279 wd:Q11424
]
].
}
# node who instances of y and who are a instance or a subclass of z which is a instance of a film genre.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P31 wd:Q201658
]
].
}
# nodes who are of genre comedy
?movie wdt:P136 [
wdt:P279 wd:Q40831
]
# nodes whos are of genre comedy and film
OPTIONAL {
?movie wdt:P136 [
wdt:P279 wd:Q40831,
wd:Q11424
].
}
# nodes whos genre is comedy and a film genre (not theater)
OPTIONAL {
?movie wdt:P136 [
wdt:P279 wd:Q40831;
wdt:P31 wd:Q201658
]. }
?movie wdt:P57 ?director.
?director wdt:P569 ?birthday.
}
# Group by those three variables will show:
# Each Director and his movies and if there is more then one birthday for one director
GROUP BY ?movie ?director ?birthday
26642 Ergebnisse in 6764 ms
#############
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?movie ?director
WHERE{
# node who instances of films
?movie wdt:P31 wd:Q11424.
# nodes who are instances of y as a subclass of films.
OPTIONAL {
?movie wdt:P31 [
wdt:P279 wd:Q11424
].
}
# nodes who are instances of y as a instance of a film genre.
OPTIONAL {
?movie wdt:P31 [
wdt:P31 wd:Q201658
].
}
# node who instances of y and who are a instance or a subclass of z which is a subclass of film.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P279 wd:Q11424
]
].
}
# node who instances of y and who are a instance or a subclass of z which is a instance of a film genre.
OPTIONAL {
?movie wdt:P31[
wdt:P31|wdt:P279 [
wdt:P31 wd:Q201658
]
].
}
# nodes who are of genre comedy
?movie wdt:P136 [
wdt:P279 wd:Q40831
]
# nodes whos are of genre comedy and film
OPTIONAL {
?movie wdt:P136 [ wdt:P279 wd:Q40831,
wd:Q11424
].
}
# nodes whos genre is comedy and a film genre (not theater)
OPTIONAL {
?movie wdt:P136 [
wdt:P279 wd:Q40831;
wdt:P31 wd:Q201658
].
}
?movie wdt:P57 ?director.
?director wdt:P569 ?birthday.
}
# Group by those three variables will show:
# Each Director and his movies
GROUP BY ?movie ?director
26343 Ergebnisse in 7285 ms