query-cb6c74d7d48ffa0173a80492459ae6f2

rq turtle/ttl

How to add subject to this query 18:15, 1 September 2020 (UTC)) talk (Trilotat has been added to the items. How do I add subject in a way that returns results? Thank you. (P921)main subject I like this query. I don't remember who was kind enough to create it for me. I'd like to use it to search if appropriate

Use at

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?title ?doi
WHERE {
  hint:Query hint:optimizer "None".
{  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch ""california" haswbstatement:P31=Q13442814".
    ?page_title wikibase:apiOutput mwapi:title.
  } }

  BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)

  ?item wdt:P31 wd:Q13442814;
        wdt:P1476 ?title;
        wdt:P356 ?doi.
  FILTER CONTAINS(LCASE(?title), "california").
  ?item wdt:P356 ?doi . FILTER(STRSTARTS(?doi,'10.1785'))
}

Query found at