query-b40f195e25ad975d3ac52bb8ecaa7c5f

rq turtle/ttl

Scientific articles from journals with "engineering" in the title select DISTINCT ?work ?workLabel ?journal ?journalLabel where { ?work wdt:P1433 ?journal . ?journal wdt:P31 wd:Q1002697 ; rdfs:label ?journalLabel . FILTER(CONTAINS(LCASE(?journalLabel), "engineering")) FILTER (LANG(?journalLabel)="en") ?work rdfs:label ?workLabel . FILTER (LANG(?workLabel)="en") } GROUP BY ?work ?workLabel ?journal ?journalLabel

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
# Scientific articles from journals with "engineering" in the title
select DISTINCT ?work ?workLabel ?journal ?journalLabel where {
  ?work wdt:P1433 ?journal .
  ?journal wdt:P31 wd:Q1002697 ;
           rdfs:label ?journalLabel .
  FILTER(CONTAINS(LCASE(?journalLabel), "engineering"))
  FILTER (LANG(?journalLabel)="en") 
  ?work rdfs:label ?workLabel .
  FILTER (LANG(?workLabel)="en") 
}
GROUP BY ?work ?workLabel ?journal ?journalLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?journal"):::projected v2("?journalLabel"):::projected v3("?work"):::projected v1("?workLabel"):::projected c5(["wd:Q1002697"]):::iri f0[["?workLabel = 'en'"]] f0 --> v1 f1[["?journalLabel = 'en'"]] f1 --> v2 f2[["contains(lower-case(?journalLabel),'engineering')"]] f2 --> v2 v3 --"wdt:P1433"--> v4 v4 --"wdt:P31"--> c5 v4 --"rdfs:label"--> v2 v3 --"rdfs:label"--> v1