query-d0050df0679520afeb054ac5412298c8

rq turtle/ttl

Compound ScienceSource ingest query

With checking of presence of paper on the SS wiki.

Checks for publishers found on Beall's list (final version, as found on Wikidata

Removes "no derivatives" Creative Commons licenses

Reverse chronological order used for selection.

PREFIX ss: http://sciencesource.wmflabs.org/entity/ PREFIX sst: http://sciencesource.wmflabs.org/prop/direct/

SELECT DISTINCT ?item ?itemLabel ?pmcid ?journalLabel ?title ?date ?licenseLabel ?mainsubjectLabel WHERE { ?item wdt:P31 wd:Q7318358; wdt:P5008 wd:Q55439927; wdt:P932 ?pmcid; wdt:P1433 ?journal; wdt:P1476 ?title; wdt:P577 ?date; wdt:P275 ?license; wdt:P921 ?mainsubject. ?mainsubject wdt:P1995 ?spec. ?spec wdt:P361* wd:Q162555. MINUS {?item wdt:P275 wd:Q36795408} #Remove these ND licences MINUS {?item wdt:P275 wd:Q6937225} MINUS {?item wdt:P275 wd:Q19125045} MINUS {?item wdt:P275 wd:Q24082749}

MINUS { ?item wdt:P5008 wd:Q55439927; wdt:P1433 ?journal. ?journal wdt:P123 ?publisher.

      {
       VALUES ?publisher

      {wd:Q52636754 wd:Q52635805 wd:Q4689899 wd:Q52620137 wd:Q4732612 
       wd:Q43080819 wd:Q30270870 wd:Q30297686 wd:Q52661346 wd:Q52636079 
       wd:Q52557383 wd:Q54958933 wd:Q2896740 wd:Q18712923 wd:Q52609680 
       wd:Q52609536 wd:Q52636154 wd:Q52609215 wd:Q80796 wd:Q52636535 
       wd:Q52633727 wd:Q52636944 wd:Q63254434 wd:Q52637577 wd:Q52665969 wd:Q52660711
       wd:Q52659576 wd:Q56979398 wd:Q52670242 wd:Q29891111 wd:Q63254475 wd:Q52619294 
       wd:Q52662151 wd:Q7072722 wd:Q52609375 wd:Q7259709 wd:Q52636843 
       wd:Q45251004 wd:Q52637573 wd:Q52662489 wd:Q52635330 wd:Q47116994 
       wd:Q30267116 wd:Q24706265 wd:Q52620720 wd:Q52633876 wd:Q56416796 
       wd:Q52660351 wd:Q52635690 wd:Q7433770 wd:Q27991304 wd:Q55566796 
       wd:Q52619286 wd:Q30265175 wd:Q8035326 
       } 
    } }

MINUS { SERVICE http://sciencesource-query.wmflabs.org/proxy/wdqs/bigdata/namespace/wdq/sparql { ?articleitem sst:P3 ss:Q4; sst:P2 ?stritem. }

      BIND(substr(str(?item),32,39) AS ?stritem) .}

    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

    }

ORDER BY DESC(?date) LIMIT 1000

Use at

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#>
#Compound ScienceSource ingest query
#With checking of presence of paper on the SS wiki.
#Checks for publishers found on Beall's list (final version, as found on Wikidata
#Removes "no derivatives" Creative Commons licenses
#Reverse chronological order used for selection.

PREFIX ss: <http://sciencesource.wmflabs.org/entity/>
PREFIX sst: <http://sciencesource.wmflabs.org/prop/direct/>

SELECT DISTINCT ?item ?itemLabel ?pmcid ?journalLabel ?title ?date ?licenseLabel ?mainsubjectLabel
WHERE {
         ?item wdt:P31 wd:Q7318358;
               wdt:P5008 wd:Q55439927;
               wdt:P932 ?pmcid;
               wdt:P1433 ?journal;
               wdt:P1476 ?title;
               wdt:P577 ?date;
               wdt:P275 ?license;
               wdt:P921 ?mainsubject. 
  ?mainsubject wdt:P1995 ?spec.
          ?spec wdt:P361* wd:Q162555.
         MINUS {?item wdt:P275 wd:Q36795408} #Remove these ND licences
         MINUS {?item wdt:P275 wd:Q6937225}
         MINUS {?item wdt:P275 wd:Q19125045}
         MINUS {?item wdt:P275 wd:Q24082749}

  MINUS {
         ?item wdt:P5008 wd:Q55439927;
               wdt:P1433 ?journal.
         ?journal wdt:P123 ?publisher.

          {
           VALUES ?publisher

          {wd:Q52636754 wd:Q52635805 wd:Q4689899 wd:Q52620137 wd:Q4732612 
           wd:Q43080819 wd:Q30270870 wd:Q30297686 wd:Q52661346 wd:Q52636079 
           wd:Q52557383 wd:Q54958933 wd:Q2896740 wd:Q18712923 wd:Q52609680 
           wd:Q52609536 wd:Q52636154 wd:Q52609215 wd:Q80796 wd:Q52636535 
           wd:Q52633727 wd:Q52636944 wd:Q63254434 wd:Q52637577 wd:Q52665969 wd:Q52660711
           wd:Q52659576 wd:Q56979398 wd:Q52670242 wd:Q29891111 wd:Q63254475 wd:Q52619294 
           wd:Q52662151 wd:Q7072722 wd:Q52609375 wd:Q7259709 wd:Q52636843 
           wd:Q45251004 wd:Q52637573 wd:Q52662489 wd:Q52635330 wd:Q47116994 
           wd:Q30267116 wd:Q24706265 wd:Q52620720 wd:Q52633876 wd:Q56416796 
           wd:Q52660351 wd:Q52635690 wd:Q7433770 wd:Q27991304 wd:Q55566796 
           wd:Q52619286 wd:Q30265175 wd:Q8035326 
           } 
        } }    

  MINUS { SERVICE <http://sciencesource-query.wmflabs.org/proxy/wdqs/bigdata/namespace/wdq/sparql>
       { ?articleitem sst:P3 ss:Q4;
            sst:P2 ?stritem. }

          BIND(substr(str(?item),32,39) AS ?stritem) .}

        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

        }
ORDER BY
 DESC(?date)
LIMIT 1000

Query found at