Relationship between Douris and other Greek artists

greek-artist-relations.sparql

PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
PREFIX crmgeo: <http://www.ics.forth.gr/isl/CRMgeo/>
PREFIX crmsci: <http://www.ics.forth.gr/isl/CRMsci/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX kid: <http://kerameikos.org/id/>
PREFIX kon: <http://kerameikos.org/ontology#>
PREFIX org: <http://www.w3.org/ns/org#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

SELECT DISTINCT ?artist ?name (GROUP_CONCAT(DISTINCT ?roleLabel; separator="/") as ?roles) (count(?object) as ?count) WHERE {
  ?object crm:P108i_was_produced_by/crm:P9_consists_of/crm:P14_carried_out_by kid:douris ;
          crm:P108i_was_produced_by/crm:P9_consists_of/crm:P14_carried_out_by ?artist FILTER (?artist != kid:douris) .
  ?artist skos:prefLabel ?name FILTER (langMatches(lang(?name), "en")) .
  ?artist org:hasMembership/org:role ?role .
  ?role skos:prefLabel ?roleLabel FILTER (langMatches(lang(?roleLabel), "en"))
} GROUP BY ?artist ?name ORDER BY ?name