query-6a151cdb6ebe4739ef187f037693f33a
Filtering query to select articles from the focus list
From PLOS NTD and with PMC ID, main subject "infectious disease" or part of
PREFIX ss: http://sciencesource.wmflabs.org/entity/ PREFIX sst: http://sciencesource.wmflabs.org/prop/direct/
SELECT DISTINCT ?item ?stritem ?articleitem ?itemLabel ?pmcid ?journalLabel ?title ?date ?licenseLabel ?mainsubjectLabel WHERE {
SERVICE <http://sciencesource-query.wmflabs.org/proxy/wdqs/bigdata/namespace/wdq/sparql>
{ ?articleitem sst:P3 ss:Q4;
sst:P2 ?stritem. }
?item wdt:P31 wd:Q13442814 .
?item wdt:P5008 wd:Q55439927 .
?item wdt:P932 ?pmcid .
?item wdt:P1433 wd:Q3359737.
?item wdt:P1433 ?journal .
?item wdt:P1476 ?title .
?item wdt:P577 ?date .
?item wdt:P275 ?license .
?item wdt:P921 ?mainsubject .
?mainsubject wdt:P361* wd:Q18123741 .
BIND(substr(str(?item),32,39) AS ?stritem) .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
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 bd: <http://www.bigdata.com/rdf#>
#Filtering query to select articles from the focus list
#From PLOS NTD and with PMC ID, main subject "infectious disease" or part of
PREFIX ss: <http://sciencesource.wmflabs.org/entity/>
PREFIX sst: <http://sciencesource.wmflabs.org/prop/direct/>
SELECT DISTINCT ?item ?stritem ?articleitem ?itemLabel ?pmcid ?journalLabel ?title ?date ?licenseLabel ?mainsubjectLabel
WHERE
{
SERVICE <http://sciencesource-query.wmflabs.org/proxy/wdqs/bigdata/namespace/wdq/sparql>
{ ?articleitem sst:P3 ss:Q4;
sst:P2 ?stritem. }
?item wdt:P31 wd:Q13442814 .
?item wdt:P5008 wd:Q55439927 .
?item wdt:P932 ?pmcid .
?item wdt:P1433 wd:Q3359737.
?item wdt:P1433 ?journal .
?item wdt:P1476 ?title .
?item wdt:P577 ?date .
?item wdt:P275 ?license .
?item wdt:P921 ?mainsubject .
?mainsubject wdt:P361* wd:Q18123741 .
BIND(substr(str(?item),32,39) AS ?stritem) .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}