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 {?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 
       } 
      }      
     }    
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

    }

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#>
#Direct ScienceSource ingest query
#With checking of absence of paper from the focus list
#Checks for publishers found on Beall's list
#Removes "no derivatives" Creative Commons licenses

SELECT DISTINCT ?item ?itemLabel ?pmcid ?journalLabel ?title ?date ?licenseLabel ?mainsubjectLabel
WHERE {
         ?item wdt:P31 wd:Q7318358;
               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:Q177635.
           MINUS {?item wdt:P5008 wd:Q55439927}

       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 {?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 
           } 
          }      
         }    
        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

        }

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?date"):::projected v1("?item"):::projected v3("?journal") v6("?license") v7("?mainsubject") v2("?pmcid"):::projected v10("?publisher") v8("?spec") v4("?title"):::projected c16(["wd:Q19125045"]):::iri c11(["wd:Q177635"]):::iri c13(["wd:Q55439927"]):::iri c2(["wd:Q7318358"]):::iri c17(["wd:Q24082749"]):::iri c15(["wd:Q6937225"]):::iri c20(["bd:serviceParam"]):::iri c14(["wd:Q36795408"]):::iri c22(["#91;AUTO_LANGUAGE#93;,en"]):::literal v1 --"wdt:P31"--> c2 v1 --"wdt:P932"--> v2 v1 --"wdt:P1433"--> v3 v1 --"wdt:P1476"--> v4 v1 --"wdt:P577"--> v5 v1 --"wdt:P275"--> v6 v1 --"wdt:P921"--> v7 v7 --"wdt:P1995"--> v8 v8 --"wdt:P361"--> c11 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v1 --"wdt:P5008"--> c13 end subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v1 --"wdt:P275"--> c14 end subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v1 --"wdt:P275"--> c15 end subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; v1 --"wdt:P275"--> c16 end subgraph minus4["MINUS"] style minus4 stroke-width:6px,fill:pink,stroke:red; v1 --"wdt:P275"--> c17 end subgraph minus5["MINUS"] style minus5 stroke-width:6px,fill:pink,stroke:red; v3 --"wdt:P123"--> v10 bind6[/VALUES ?publisher/] bind6-->v10 bind60(["wd:Q52636754"]) bind60 --> bind6 bind61(["wd:Q52635805"]) bind61 --> bind6 bind62(["wd:Q4689899"]) bind62 --> bind6 bind63(["wd:Q52620137"]) bind63 --> bind6 bind64(["wd:Q4732612"]) bind64 --> bind6 bind65(["wd:Q43080819"]) bind65 --> bind6 bind66(["wd:Q30270870"]) bind66 --> bind6 bind67(["wd:Q30297686"]) bind67 --> bind6 bind68(["wd:Q52661346"]) bind68 --> bind6 bind69(["wd:Q52636079"]) bind69 --> bind6 bind610(["wd:Q52557383"]) bind610 --> bind6 bind611(["wd:Q54958933"]) bind611 --> bind6 bind612(["wd:Q2896740"]) bind612 --> bind6 bind613(["wd:Q18712923"]) bind613 --> bind6 bind614(["wd:Q52609680"]) bind614 --> bind6 bind615(["wd:Q52609536"]) bind615 --> bind6 bind616(["wd:Q52636154"]) bind616 --> bind6 bind617(["wd:Q52609215"]) bind617 --> bind6 bind618(["wd:Q80796"]) bind618 --> bind6 bind619(["wd:Q52636535"]) bind619 --> bind6 bind620(["wd:Q52633727"]) bind620 --> bind6 bind621(["wd:Q52636944"]) bind621 --> bind6 bind622(["wd:Q63254434"]) bind622 --> bind6 bind623(["wd:Q52637577"]) bind623 --> bind6 bind624(["wd:Q52665969"]) bind624 --> bind6 bind625(["wd:Q52660711"]) bind625 --> bind6 bind626(["wd:Q52659576"]) bind626 --> bind6 bind627(["wd:Q56979398"]) bind627 --> bind6 bind628(["wd:Q52670242"]) bind628 --> bind6 bind629(["wd:Q29891111"]) bind629 --> bind6 bind630(["wd:Q63254475"]) bind630 --> bind6 bind631(["wd:Q52619294"]) bind631 --> bind6 bind632(["wd:Q52662151"]) bind632 --> bind6 bind633(["wd:Q7072722"]) bind633 --> bind6 bind634(["wd:Q52609375"]) bind634 --> bind6 bind635(["wd:Q7259709"]) bind635 --> bind6 bind636(["wd:Q52636843"]) bind636 --> bind6 bind637(["wd:Q45251004"]) bind637 --> bind6 bind638(["wd:Q52637573"]) bind638 --> bind6 bind639(["wd:Q52662489"]) bind639 --> bind6 bind640(["wd:Q52635330"]) bind640 --> bind6 bind641(["wd:Q47116994"]) bind641 --> bind6 bind642(["wd:Q30267116"]) bind642 --> bind6 bind643(["wd:Q24706265"]) bind643 --> bind6 bind644(["wd:Q52620720"]) bind644 --> bind6 bind645(["wd:Q52633876"]) bind645 --> bind6 bind646(["wd:Q56416796"]) bind646 --> bind6 bind647(["wd:Q52660351"]) bind647 --> bind6 bind648(["wd:Q52635690"]) bind648 --> bind6 bind649(["wd:Q7433770"]) bind649 --> bind6 bind650(["wd:Q27991304"]) bind650 --> bind6 bind651(["wd:Q55566796"]) bind651 --> bind6 bind652(["wd:Q52619286"]) bind652 --> bind6 bind653(["wd:Q30265175"]) bind653 --> bind6 bind654(["wd:Q8035326"]) bind654 --> bind6 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c20 --"wikibase:language"--> c22 end