count-datasets-with-doi-in-mdc.rq

prefix obo: <http://purl.obolibrary.org/obo/>
prefix dc: <http://purl.org/dc/elements/1.1/>

select (count (distinct ?x ) as ?numberDatasetsWithDoi)
from <http://www.pitt.edu/obc/ide/apollo-sv>
from <http://www.pitt.edu/obc/ide/classes-and-indexing-instances>
from <http://www.pitt.edu/obc/ide/article-instances>
from <http://www.pitt.edu/obc/ide/article-deleted-instances>
from <http://ide.obc.io/auth>
from <http://www.pitt.edu/obc/mdc/content>
where {
  #dataset must be in MDC
  <http://www.pitt.edu/obc/IDE_ARTICLES_12000070095> obo:BFO_0000174 ?x  .

  ?x rdf:type ?datasetOrSubclass .
  ?datasetOrSubclass rdfs:subClassOf+ obo:IAO_0000100 .
  
  ?z rdf:type obo:OBI_0002110 .
  ?z obo:IAO_0000219 ?x .
  #filter out punned individuals
     FILTER ( ?x != obo:IAO_0000100 )
     FILTER ( ?x != ?datasetOrSubclass )
     FILTER ( ?datasetOrSubclass != obo:APOLLO_SV_00000522)
     }