query-e59f966fac83e99d2d8af26e810bcda7

rq turtle/ttl

title: OSI-compatibly licenses software with a GitHub repo and some paper published about it SELECT DISTINCT ?item ?itemLabel ?sourcecode ?license ?licenseLabel WHERE {

?item wdt:P1324 ?sourcecode . FILTER CONTAINS(LCASE(STR(?sourcecode)), "github") ?item wdt:P275 ?license . ?license ?p wd:Q1156659 . ?license rdfs:label ?licenseLabel . FILTER(LANG(?licenseLabel) = "en"). ?work wdt:P921 ?item ; wdt:P1476 ?title . ?item rdfs:label ?itemLabel . FILTER(LANG(?itemLabel) = "en"). }

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#>
#title: OSI-compatibly licenses software with a GitHub repo and some paper published about it
SELECT DISTINCT ?item ?itemLabel ?sourcecode ?license ?licenseLabel WHERE {

  ?item wdt:P1324 ?sourcecode .
  FILTER CONTAINS(LCASE(STR(?sourcecode)), "github")
  ?item wdt:P275 ?license .
  ?license ?p wd:Q1156659 .
  ?license rdfs:label ?licenseLabel .
  FILTER(LANG(?licenseLabel) = "en").
  ?work wdt:P921 ?item ;
        wdt:P1476 ?title .
  ?item rdfs:label ?itemLabel .
  FILTER(LANG(?itemLabel) = "en").
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?item"):::projected v1("?itemLabel"):::projected v5("?license"):::projected v2("?licenseLabel"):::projected v6("?p") v3("?sourcecode"):::projected v8("?title") v7("?work") c5(["wd:Q1156659"]):::iri f0[["?itemLabel = 'en'"]] f0 --> v1 f1[["?licenseLabel = 'en'"]] f1 --> v2 f2[["contains(lower-case(str(?sourcecode)),'github')"]] f2 --> v3 v4 --"wdt:P1324"--> v3 v4 --"wdt:P275"--> v5 v5 -->v6--> c5 v5 --"rdfs:label"--> v2 v7 --"wdt:P921"--> v4 v7 --"wdt:P1476"--> v8 v4 --"rdfs:label"--> v1