A set of SPARQL examples that are used in different TGX resources
License: https://www.gnu.org/licenses/gpl-3.0
Uses method in: https://github.com/WDscholia/scholia/tree/master/scholia/app/templates/work_wikipedia-mentions.sparql
Work aspect: wikipedia mentions
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX hint: <http://www.bigdata.com/queryHints#>
PREFIX mwapi: <>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX wd: <http://wikidata.org/entity/>
PREFIX wikibase: <http://wikiba.se/ontology#>
SELECT
?title ?titleUrl
?wikipedia ?wikipediaLabel
?item ?itemLabel ?itemDescription
WHERE {
{
SELECT ?title_ ?titleUrl ?item ?wikipedia {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:endpoint "da.wikipedia.org" ;
wikibase:api "Generator" ;
mwapi:generator "search" ;
mwapi:gsrsearch 'Q28942417' ;
mwapi:gsrlimit "200" .
?title_ wikibase:apiOutput mwapi:title .
?item wikibase:apiOutputItem mwapi:item .
}
BIND(URI(CONCAT("https://da.wikipedia.org/wiki/", ENCODE_FOR_URI(REPLACE(?title_, " ", "_")))) AS ?titleUrl)
BIND(wd:Q181163 AS ?wikipedia)
}
}
UNION
{
SELECT ?title_ ?titleUrl ?item ?wikipedia {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:endpoint "de.wikipedia.org" ;
wikibase:api "Generator" ;
mwapi:generator "search" ;
mwapi:gsrsearch 'Q28942417' ;
mwapi:gsrlimit "200" .
?title_ wikibase:apiOutput mwapi:title .
?item wikibase:apiOutputItem mwapi:item .
}
BIND(URI(CONCAT("https://de.wikipedia.org/wiki/", ENCODE_FOR_URI(REPLACE(?title_, " ", "_")))) AS ?titleUrl)
BIND(wd:Q48183 AS ?wikipedia)
}
}
UNION
{
SELECT ?title_ ?titleUrl ?item ?wikipedia {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:endpoint "en.wikipedia.org" ;
wikibase:api "Generator" ;
mwapi:generator "search" ;
mwapi:gsrsearch 'Q28942417' ;
mwapi:gsrlimit "200" .
?title_ wikibase:apiOutput mwapi:title .
?item wikibase:apiOutputItem mwapi:item .
}
BIND(URI(CONCAT("https://en.wikipedia.org/wiki/", ENCODE_FOR_URI(REPLACE(?title_, " ", "_")))) AS ?titleUrl)
BIND(wd:Q328 AS ?wikipedia)
}
}
UNION
{
SELECT ?title_ ?titleUrl ?item ?wikipedia {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:endpoint "fr.wikipedia.org" ;
wikibase:api "Generator" ;
mwapi:generator "search" ;
mwapi:gsrsearch 'Q28942417' ;
mwapi:gsrlimit "200" .
?title_ wikibase:apiOutput mwapi:title .
?item wikibase:apiOutputItem mwapi:item .
}
BIND(URI(CONCAT("https://fr.wikipedia.org/wiki/", ENCODE_FOR_URI(REPLACE(?title_, " ", "_")))) AS ?titleUrl)
BIND(wd:Q8447 AS ?wikipedia)
}
}
UNION
{
SELECT ?title_ ?titleUrl ?item ?wikipedia {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:endpoint "pt.wikipedia.org" ;
wikibase:api "Generator" ;
mwapi:generator "search" ;
mwapi:gsrsearch 'Q28942417' ;
mwapi:gsrlimit "200" .
?title_ wikibase:apiOutput mwapi:title .
?item wikibase:apiOutputItem mwapi:item .
}
BIND(URI(CONCAT("https://pt.wikipedia.org/wiki/", ENCODE_FOR_URI(REPLACE(?title_, " ", "_")))) AS ?titleUrl)
BIND(wd:Q11921 AS ?wikipedia)
}
}
hint:Prior hint:runFirst "true" .
BIND(CONCAT(?title_, " ↗") AS ?title)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . }
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v5("?title"):::projected
v5("?titleUrl"):::projected
v1("?title_")
v5("?wikipedia"):::projected
c10(["Q28942417"]):::literal
c26(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal
c8(["search"]):::literal
c18(["en.wikipedia.org"]):::literal
c2([http://www.bigdata.com/rdf#serviceParam]):::iri
c16([https://query.wikidata.org/sparqlitem]):::iri
c20(["pt.wikipedia.org"]):::literal
c21([http://www.bigdata.com/queryHints#Prior]):::iri
c17(["de.wikipedia.org"]):::literal
c12(["200"]):::literal
c19(["fr.wikipedia.org"]):::literal
c23(["true"]):::literal
c4(["da.wikipedia.org"]):::literal
c6(["Generator"]):::literal
c14([https://query.wikidata.org/sparqltitle]):::iri
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
subgraph union2[" Union "]
subgraph union2l[" "]
style union2l fill:#abf,stroke-dasharray: 3 3;
subgraph union3[" Union "]
subgraph union3l[" "]
style union3l fill:#abf,stroke-dasharray: 3 3;
subgraph s1["http://wikiba.se/ontology#mwapi"]
style s1 stroke-width:4px;
c2 --"wikibase:endpoint"--> c20
c2 --"wikibase:api"--> c6
c2 --https://query.wikidata.org/sparqlgenerator--> c8
c2 --https://query.wikidata.org/sparqlgsrsearch--> c10
c2 --https://query.wikidata.org/sparqlgsrlimit--> c12
v1 --"wikibase:apiOutput"--> c14
v2 --"wikibase:apiOutputItem"--> c16
end
bind0[/"concat('https://pt.wikipedia.org/wiki/',encode-for-uri(replace(?title_,' ','_')))"/]
v1 --o bind0
bind0 --as--o v5
bind1[/"http://wikidata.org/entity/Q11921"/]
bind1 --as--o v5
end
subgraph union3r[" "]
style union3r fill:#abf,stroke-dasharray: 3 3;
subgraph s1["http://wikiba.se/ontology#mwapi"]
style s1 stroke-width:4px;
c2 --"wikibase:endpoint"--> c19
c2 --"wikibase:api"--> c6
c2 --https://query.wikidata.org/sparqlgenerator--> c8
c2 --https://query.wikidata.org/sparqlgsrsearch--> c10
c2 --https://query.wikidata.org/sparqlgsrlimit--> c12
v1 --"wikibase:apiOutput"--> c14
v2 --"wikibase:apiOutputItem"--> c16
end
bind2[/"concat('https://fr.wikipedia.org/wiki/',encode-for-uri(replace(?title_,' ','_')))"/]
v1 --o bind2
bind2 --as--o v5
bind3[/"http://wikidata.org/entity/Q8447"/]
bind3 --as--o v5
end
union3r <== or ==> union3l
end
end
subgraph union2r[" "]
style union2r fill:#abf,stroke-dasharray: 3 3;
subgraph s1["http://wikiba.se/ontology#mwapi"]
style s1 stroke-width:4px;
c2 --"wikibase:endpoint"--> c18
c2 --"wikibase:api"--> c6
c2 --https://query.wikidata.org/sparqlgenerator--> c8
c2 --https://query.wikidata.org/sparqlgsrsearch--> c10
c2 --https://query.wikidata.org/sparqlgsrlimit--> c12
v1 --"wikibase:apiOutput"--> c14
v2 --"wikibase:apiOutputItem"--> c16
end
bind4[/"concat('https://en.wikipedia.org/wiki/',encode-for-uri(replace(?title_,' ','_')))"/]
v1 --o bind4
bind4 --as--o v5
bind5[/"http://wikidata.org/entity/Q328"/]
bind5 --as--o v5
end
union2r <== or ==> union2l
end
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
subgraph s1["http://wikiba.se/ontology#mwapi"]
style s1 stroke-width:4px;
c2 --"wikibase:endpoint"--> c17
c2 --"wikibase:api"--> c6
c2 --https://query.wikidata.org/sparqlgenerator--> c8
c2 --https://query.wikidata.org/sparqlgsrsearch--> c10
c2 --https://query.wikidata.org/sparqlgsrlimit--> c12
v1 --"wikibase:apiOutput"--> c14
v2 --"wikibase:apiOutputItem"--> c16
end
bind6[/"concat('https://de.wikipedia.org/wiki/',encode-for-uri(replace(?title_,' ','_')))"/]
v1 --o bind6
bind6 --as--o v5
bind7[/"http://wikidata.org/entity/Q48183"/]
bind7 --as--o v5
end
union1r <== or ==> union1l
end
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
subgraph s1["http://wikiba.se/ontology#mwapi"]
style s1 stroke-width:4px;
c2 --"wikibase:endpoint"--> c4
c2 --"wikibase:api"--> c6
c2 --https://query.wikidata.org/sparqlgenerator--> c8
c2 --https://query.wikidata.org/sparqlgsrsearch--> c10
c2 --https://query.wikidata.org/sparqlgsrlimit--> c12
v1 --"wikibase:apiOutput"--> c14
v2 --"wikibase:apiOutputItem"--> c16
end
bind8[/"concat('https://da.wikipedia.org/wiki/',encode-for-uri(replace(?title_,' ','_')))"/]
v1 --o bind8
bind8 --as--o v5
bind9[/"http://wikidata.org/entity/Q181163"/]
bind9 --as--o v5
end
union0r <== or ==> union0l
end
c21 --http://www.bigdata.com/queryHints#runFirst--> c23
bind10[/"concat(?title_,' ↗')"/]
v1 --o bind10
bind10 --as--o v5
subgraph s2["http://wikiba.se/ontology#label"]
style s2 stroke-width:4px;
c2 --"wikibase:language"--> c26
end