query-4f7d302326ba9a2e8c64ba14f68db1c5

rq turtle/ttl

The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items) The number of times a cas registry number is shared by distinct Wikidata items SELECT ?cas ?items WHERE { {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE { ?compound wdt:P231 ?cas . } GROUP BY ?cas } FILTER (?items >1) } ORDER BY desc(?items)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
#The number of times a cas registry number is shared by distinct Wikidata items
SELECT ?cas ?items
WHERE
{
  {SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE {
      ?compound wdt:P231 ?cas .
  }
    GROUP BY ?cas }
    FILTER (?items >1)
}
ORDER BY desc(?items)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?cas"):::projected v2("?compound") v4("?items"):::projected f0[["?items > '1^^xsd:integer'"]] f0 --> v4 v2 --"wdt:P231"--> v3 bind2[/"count(?compound)"/] v2 --o bind2 bind2 --as--o v4