query-f718be2300e9f2e6e3739ed95adc5f96

rq turtle/ttl

Featured articles of all Wikimedia projects

Get all Featured Articles (Q17437796)

SELECT distinct ?item ?itemLabel (count(distinct ?sitelink) as ?fa_count) WHERE { ?sitelink schema:name ?name; schema:inLanguage ?lang; schema:about ?item; # Sitelink is badged as a Featured Article wikibase:badge wd:Q17437796. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } group by ?item ?itemLabel order by desc(?fa_count)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Featured articles of all Wikimedia projects
# Get all Featured Articles (Q17437796)
SELECT distinct ?item ?itemLabel (count(distinct ?sitelink) as ?fa_count) WHERE {
  ?sitelink schema:name ?name;
    schema:inLanguage ?lang;
    schema:about ?item;
    # Sitelink is badged as a Featured Article
    wikibase:badge wd:Q17437796.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?item ?itemLabel order by desc(?fa_count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?fa_count") v5("?item"):::projected v4("?lang") v3("?name") v2("?sitelink"):::projected c7(["bd:serviceParam"]):::iri c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal c5(["wd:Q17437796"]):::iri v2 --"schema:name"--> v3 v2 --"schema:inLanguage"--> v4 v2 --"schema:about"--> v5 v2 --"wikibase:badge"--> c5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end bind1[/"count(?sitelink)"/] v2 --o bind1 bind1 --as--o v6