#
# example SPARQL query 151
#

@prefix schema: <https://schema.org/> . 
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> . 
@prefix sh: <http://www.w3.org/ns/shacl#> . 
@prefix cello: <https://purl.expasy.org/cellosaurus/rdf/ontology/> .


cello:Query_151 a sh:SPARQLExecutable ;
    sh:prefixes _:sparql_examples_prefixes ;
    rdfs:comment """Registered name(s) of some cell lines"""@en ; 
    schema:keywords "reg" , "registration" , "registeredName" ; 
    schema:target <https://sparql.cellosaurus.org/sparql> ; 
    sh:select """
PREFIX cello: <https://purl.expasy.org/cellosaurus/rdf/ontology/>
select ?cl ?cl_name
        (count(?registered_name) as ?registered_name_count)
        (group_concat(?registered_name ; separator=' , ') as ?registered_names)
where {
        ?cl cello:registeredName ?registered_name .
    ?cl cello:recommendedName ?cl_name .
}
group by ?cl ?cl_name
order by ?cl
limit 100
    """
    .