query-23fc159151ea3b6c428f609d7cc530d0

rq turtle/ttl

title: Which are the available structures found in taxon on Wikidata, for which a CSD Refcode is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?csd_id) AS ?count) (GROUP_CONCAT(DISTINCT ?csd_id; SEPARATOR = ", ") AS ?csd) WHERE { ?structure p:P703 []; wdt:P11375 ?csd_id. } GROUP BY ?structure ORDER BY DESC (?count) title: Which are the available structures found in taxon on Wikidata, for which a CSD Refcode is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?csd_id) AS ?count) (GROUP_CONCAT(DISTINCT ?csd_id; SEPARATOR = ", ") AS ?csd) WHERE { ?structure p:P703 []; wdt:P11375 ?csd_id. } GROUP BY ?structure ORDER BY DESC (?count) title: Which are the available structures found in taxon on Wikidata, for which a CSD Refcode is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?csd_id) AS ?count) (GROUP_CONCAT(DISTINCT ?csd_id; SEPARATOR = ", ") AS ?csd) WHERE { ?structure p:P703 []; wdt:P11375 ?csd_id. } GROUP BY ?structure ORDER BY DESC (?count) title: Which are the available structures found in taxon on Wikidata, for which a CSD Refcode is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?csd_id) AS ?count) (GROUP_CONCAT(DISTINCT ?csd_id; SEPARATOR = ", ") AS ?csd) WHERE { ?structure p:P703 []; wdt:P11375 ?csd_id. } GROUP BY ?structure ORDER BY DESC (?count) title: Which are the available structures found in taxon on Wikidata, for which a CSD Refcode is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?csd_id) AS ?count) (GROUP_CONCAT(DISTINCT ?csd_id; SEPARATOR = ", ") AS ?csd) WHERE { ?structure p:P703 []; wdt:P11375 ?csd_id. } GROUP BY ?structure ORDER BY DESC (?count) title: Which are the available structures found in taxon on Wikidata, for which a CSD Refcode is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?csd_id) AS ?count) (GROUP_CONCAT(DISTINCT ?csd_id; SEPARATOR = ", ") AS ?csd) WHERE { ?structure p:P703 []; wdt:P11375 ?csd_id. } GROUP BY ?structure ORDER BY DESC (?count)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX p: <http://www.wikidata.org/prop/>
#title: Which are the available structures found in taxon on Wikidata, for which a CSD Refcode is available?
SELECT DISTINCT ?structure (COUNT(DISTINCT ?csd_id) AS ?count) (GROUP_CONCAT(DISTINCT ?csd_id; SEPARATOR = ", ") AS ?csd) WHERE {
  ?structure p:P703 [];
             wdt:P11375 ?csd_id.
}
GROUP BY ?structure
ORDER BY DESC (?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?count") v4("?csd") v3("?csd_id"):::projected v2("?structure"):::projected a1((" ")) v2 --"p:P703"--> a1 v2 --"p:direct/P11375"--> v3 bind2[/"count(?csd_id)"/] v3 --o bind2 bind2 --as--o v4 bind3[/"?csd_id"/] v3 --o bind3 bind3 --as--o v4