A set of SPARQL examples
Scholarly articles containing 'quassin' (Q2079986) in title.
PREFIX mwapi: <https://www.mediawiki.org/ontology#API/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Scholarly articles containing 'quassin' (Q2079986) in title
SELECT ?article ?article_title WHERE {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:endpoint "www.wikidata.org";
wikibase:api "Search";
mwapi:srsearch "quassin haswbstatement:P31=Q13442814 -haswbstatement:P921=Q2079986";
mwapi:srlimit "max".
?article wikibase:apiOutputItem mwapi:title.
}
SERVICE <https://query-scholarly.wikidata.org/sparql> { ?article wdt:P1476 ?article_title. }
FILTER(CONTAINS(LCASE(STR(?article_title)), "quassin"))
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?article"):::projected
v1("?article_title"):::projected
c5(["www.wikidata.org"]):::literal
c11(["max"]):::literal
c13([https://www.mediawiki.org/ontology#API/title]):::iri
c9(["quassin haswbstatement:P31=Q13442814 -haswbstatement:P921=Q2079986"]):::literal
c3([http://www.bigdata.com/rdf#serviceParam]):::iri
c7(["Search"]):::literal
f0[["contains(lower-case(str(?article_title)),'quassin')"]]
f0 --> v1
subgraph s1["http://wikiba.se/ontology#mwapi"]
style s1 stroke-width:4px;
c3 --"wikibase:endpoint"--> c5
c3 --"wikibase:api"--> c7
c3 --https://www.mediawiki.org/ontology#API/srsearch--> c9
c3 --https://www.mediawiki.org/ontology#API/srlimit--> c11
v2 --"wikibase:apiOutputItem"--> c13
end
subgraph s2["https://query-scholarly.wikidata.org/sparql"]
style s2 stroke-width:4px;
v2 --"p:direct/P1476"--> v1
end