Notre Avenir dans l'Air

Query 1

        
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

        SELECT ?uri 
               (SAMPLE(COALESCE(?inner_title_label, ?inner_label, "")) as ?label)
               (GROUP_CONCAT(DISTINCT ?inner_type; separator="|") as ?type)
               (SAMPLE(?inner_apelation) as ?apelation)
               (SAMPLE(?inner_label_starting_date) as ?label_starting_date)
               (SAMPLE(?inner_label_ending_date) as ?label_ending_date)
               (SAMPLE(?inner_production_place) as ?production_place)
               (GROUP_CONCAT(DISTINCT CONCAT(?inner_author, ":::", STR(?uri_author)); separator="|") as ?authors)
               (GROUP_CONCAT(DISTINCT CONCAT(?inner_owner, ":::", STR(?uri_owner)); separator="|") as ?owners)
               (GROUP_CONCAT(DISTINCT ?inner_topic; separator="|") as ?topic)
               (GROUP_CONCAT(DISTINCT CONCAT(?inner_exhibition, ":::", STR(?uri_exhibition)); separator="|") as ?exhibitions)
        WHERE 
        {
            ?uri rdf:type <https://w3id.org/OntoExhibit#Work_Manifestation> .
            
            OPTIONAL { ?uri rdfs:label ?inner_label . }
            OPTIONAL { 
                ?uri <https://w3id.org/OntoExhibit#hasTitle> ?title_entity .
                ?title_entity rdfs:label ?inner_title_label .
            }
            
            FILTER (regex(str(?uri), "4f0e21f5ff949f0a3ffa2468cfa3dcf9ec5cbac3ff770005cdb6203dd4eedcaa", "i"))
            
            OPTIONAL { ?uri <https://w3id.org/OntoExhibit#type> ?inner_type . }
            OPTIONAL { ?uri <https://w3id.org/OntoExhibit#apelation> ?inner_apelation }
            
            OPTIONAL {
                ?uri <https://w3id.org/OntoExhibit#hasOwner> ?owner_role .
                ?uri_owner <https://w3id.org/OntoExhibit#hasRole> ?owner_role .
                ?uri_owner rdfs:label ?inner_owner
            }
            OPTIONAL {
                ?uri <https://w3id.org/OntoExhibit#hasProduction> ?prod .
                OPTIONAL {
                    ?prod <https://w3id.org/OntoExhibit#hasProductionAuthor> ?author_role .
                    ?uri_author <https://w3id.org/OntoExhibit#hasRole> ?author_role .
                    ?uri_author rdfs:label ?inner_author
                }
                OPTIONAL {
                    ?prod <https://w3id.org/OntoExhibit#hasTimeSpan> ?tr .
                    ?tr <https://w3id.org/OntoExhibit#hasStartingDate> ?start_date .
                    ?start_date rdfs:label ?inner_label_starting_date .
                }
                OPTIONAL {
                    ?prod <https://w3id.org/OntoExhibit#hasTimeSpan> ?tr .
                    ?tr <https://w3id.org/OntoExhibit#hasEndingDate> ?end_date .
                    ?end_date rdfs:label ?inner_label_ending_date .
                }
                OPTIONAL {
                    ?prod <https://w3id.org/OntoExhibit#takesPlaceAt> ?place_uri .
                    ?place_uri rdfs:label ?inner_production_place .
                }
            }
            OPTIONAL {
                ?uri <https://w3id.org/OntoExhibit#isDisplayedAt> ?uri_exhibition .
                ?uri_exhibition rdfs:label ?inner_exhibition
            }
            OPTIONAL {
                ?uri <https://w3id.org/OntoExhibit#hasTheme> ?uri_topic .
                ?uri_topic rdfs:label ?inner_topic
            }
        } 
        GROUP BY ?uri