sparql-examples

A set of SPARQL examples

View the Project on GitHub Adafede/sparql-examples

wd_articles_topic

rq turtle/ttl

Scholarly articles containing 'quassin' (Q2079986) in title.

Use at


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