query-807ac3ad7df59e0c84c3b67917417d88

rq turtle/ttl

title: Source code repositories on GitHub that have an OSI-approved license AND at least 10 Wikimedia sitelinks SELECT ?item ?sourcecode ?license ?licenseLabel ?sitelinks WHERE { ?item wdt:P1324 ?sourcecode . FILTER CONTAINS(LCASE(STR(?sourcecode)), "github") ?item wikibase:sitelinks ?sitelinks . ?item wdt:P275 ?license . ?license ?p wd:Q1156659 . ?license rdfs:label ?licenseLabel . FILTER(LANG(?licenseLabel) = "en"). FILTER(?sitelinks > 9) } ORDER BY DESC(?sitelinks)

Use at

https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
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: Source code repositories on GitHub that have an OSI-approved license AND at least 10 Wikimedia sitelinks
SELECT ?item ?sourcecode ?license ?licenseLabel ?sitelinks
WHERE {
  ?item wdt:P1324 ?sourcecode .
  FILTER CONTAINS(LCASE(STR(?sourcecode)), "github")
  ?item wikibase:sitelinks ?sitelinks .
  ?item wdt:P275 ?license .
  ?license ?p wd:Q1156659 .
  ?license rdfs:label ?licenseLabel .
  FILTER(LANG(?licenseLabel) = "en").
  FILTER(?sitelinks > 9)
}
ORDER BY DESC(?sitelinks)

Query found at

https://www.wikidata.org/wiki/Wikidata:WikiProject_Informatics/Software/Queries

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?item"):::projected v5("?license"):::projected v2("?licenseLabel"):::projected v6("?p") v1("?sitelinks"):::projected v3("?sourcecode"):::projected c7(["wd:Q1156659"]):::iri f0[["?sitelinks > '9^^xsd:integer'"]] f0 --> v1 f1[["?licenseLabel = 'en'"]] f1 --> v2 f2[["contains(lower-case(str(?sourcecode)),'github')"]] f2 --> v3 v4 --"wdt:P1324"--> v3 v4 --"wikibase:sitelinks"--> v1 v4 --"wdt:P275"--> v5 v5 -->v6--> c7 v5 --"rdfs:label"--> v2