query-b66b99958d63b7cf066db64c0b1d361f

rq turtle/ttl

Propertiesinstance of (P31)used by (P1535)Wikidata item of this property (P1629)

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#>
SELECT DISTINCT ?registry ?registryLabel ?count



WHERE {
   {
  SELECT DISTINCT ?registry (COUNT(*) AS ?count) WHERE {
     {
  SELECT DISTINCT ?item WHERE {
    ?item wdt:P31 wd:Q30612 ;
  }
  LIMIT 400000
}
     {
  SELECT DISTINCT ?registry ?registryIDitem WHERE {
    ?registry wdt:P31 wd:Q2138567 .
    ?registryIDitem wdt:P1535 ?registry .
  }
  GROUP BY ?registry ?registryIDitem
  LIMIT 100
}
    ?item ?p [ ] .
    ?property wdt:P1629 ?registryIDitem;
              wikibase:claim ?p.
    ?property wikibase:propertyType wikibase:ExternalId .
  }
  GROUP BY ?registry 
  LIMIT 100
}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?count)
LIMIT 100

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Clinical_Trials/Query