AriadnePlus/dnet-ariadneplus-graphdb-publisher/src/main/resources/eu/dnetlib/ariadneplus/sparql/enrich/DAI/ordered_sparql_insert_afe_rgk.sparql

ADD SILENT <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins2> TO <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins>;
DROP SILENT GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins2>;

PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX ariadneplus: <https://ariadne-infrastructure.eu/aocat/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
INSERT {
    GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins> {
        ?record aocat:has_creator ?coll_value .
        ?coll_value rdf:type ?type .
        ?coll_value rdfs:label ?label .
        ?coll_value aocat:has_name ?name .
        ?coll_value aocat:has_homepage ?homepage .
    }
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::CollectionInfo>
WHERE {
	?record aocat:is_part_of ?collection .
    ?collection aocat:has_creator ?coll_value .
    ?coll_value rdf:type ?type .
    ?coll_value rdfs:label ?label .
    ?coll_value aocat:has_name ?name .
    ?coll_value aocat:has_agent_identifier ?homepage .
    MINUS {
        ?record	aocat:has_creator ?rec_value .
    }
};

PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX ariadneplus: <https://ariadne-infrastructure.eu/aocat/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
INSERT {
    GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins> {
        ?record aocat:has_publisher ?coll_value .
        ?coll_value rdf:type ?type .
        ?coll_value rdfs:label ?label .
        ?coll_value aocat:has_name ?name .
        ?coll_value aocat:has_homepage ?homepage .
    }
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::CollectionInfo>
WHERE {
	?record aocat:is_part_of ?collection .
    ?collection aocat:has_publisher ?coll_value .
    ?coll_value rdf:type ?type .
    ?coll_value rdfs:label ?label .
    ?coll_value aocat:has_name ?name .
    ?coll_value aocat:has_homepage ?homepage .
    MINUS {
        ?record	aocat:has_publisher ?rec_value .
    }
};

PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX ariadneplus: <https://ariadne-infrastructure.eu/aocat/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
INSERT {
    GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins> {
        ?record aocat:has_owner ?coll_value .
        ?coll_value rdf:type ?type .
        ?coll_value rdfs:label ?label .
        ?coll_value aocat:has_name ?name .
        ?coll_value aocat:has_homepage ?homepage .
    }
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::CollectionInfo>
WHERE {
	?record aocat:is_part_of ?collection .
    ?collection aocat:has_owner ?coll_value .
    ?coll_value rdf:type ?type .
    ?coll_value rdfs:label ?label .
    ?coll_value aocat:has_name ?name .
    ?coll_value aocat:has_homepage ?homepage .
    MINUS {
        ?record	aocat:has_owner ?rec_value .
    }
};

PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX ariadneplus: <https://ariadne-infrastructure.eu/aocat/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
INSERT {
    GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins> {
        ?record aocat:has_responsible ?coll_value .
        ?coll_value rdf:type ?type .
        ?coll_value rdfs:label ?label .
        ?coll_value aocat:has_name ?name .
        ?coll_value aocat:has_homepage ?homepage .
    }
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::CollectionInfo>
WHERE {
	?record aocat:is_part_of ?collection .
    ?collection aocat:has_responsible ?coll_value .
    ?coll_value rdf:type ?type .
    ?coll_value rdfs:label ?label .
    ?coll_value aocat:has_name ?name .
    ?coll_value aocat:has_agent_identifier ?homepage .
    MINUS {
        ?record	aocat:has_responsible ?rec_value .
    }
};

PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
INSERT {
    GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins> {
          ?s	aocat:has_contributor <https://ariadne-infrastructure.eu/aocat/Agent/NOTPROVIDED> .
          <https://ariadne-infrastructure.eu/aocat/Agent/NOTPROVIDED> rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Agent> .
          <https://ariadne-infrastructure.eu/aocat/Agent/NOTPROVIDED> rdfs:label "Not provided" .
          <https://ariadne-infrastructure.eu/aocat/Agent/NOTPROVIDED> aocat:has_name "Not provided" .
        }
    }
    WHERE {
        GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins> {
            ?s rdf:type aocat:AO_Individual_Data_Resource .
            MINUS {
                ?s rdf:type aocat:AO_Individual_Data_Resource .
                ?s	aocat:has_contributor ?contributor .
            }
        }
};

PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
INSERT {
    GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins> {
        ?record	aocat:has_primary_visual_component ?visual_component .
    }
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins>
WHERE {
	?record aocat:has_visual_component ?visual_component .
	MINUS {
            ?record	aocat:has_primary_visual_component ?primary_visual_component .
        }
};

PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
INSERT {
    GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins> {
        ?record	aocat:has_original_id ?pid .
    }
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins>
WHERE {
	?record aocat:has_landing_page ?pid .
	MINUS {
            ?record	aocat:has_original_id ?id .
        }
};

PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX ariadneplus: <https://ariadne-infrastructure.eu/aocat/>
INSERT {
    GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins> {
        ?record aocat:was_issued ?coll_issued_value .
        ?record aocat:was_modified ?coll_modified_value .
    }
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::CollectionInfo>
WHERE {
	?record aocat:is_part_of ?collection .
    ?collection aocat:was_issued ?coll_issued_value .
    ?collection aocat:was_modified ?coll_modified_value .
    MINUS {
        ?record	aocat:was_issued ?rec_value .
        ?record	aocat:was_modified ?rec_value2 .
    }
};

PREFIX  skos: <http://www.w3.org/2004/02/skos/core#>
 PREFIX  aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
 PREFIX time: <http://www.w3.org/2006/time#>
 PREFIX  rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 INSERT {
     GRAPH <https://ariadne-infrastructure.eu/ariadneplus::afe_rgk::periodoplus> {
         ?temporal aocat:has_period ?native_period .
         ?temporal aocat:from ?from .
         ?temporal aocat:until ?until .
     }
 }
 WHERE {
 	GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins> {
       ?temporal aocat:has_native_period ?native_period .
       ?native_period rdfs:label|skos:prefLabel ?native_label .
       ?temporal aocat:from ?from .
       ?temporal aocat:until ?until .
   }
 };

 PREFIX  skos: <http://www.w3.org/2004/02/skos/core#>
  PREFIX  aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
  PREFIX time: <http://www.w3.org/2006/time#>
  PREFIX  rdfs: <http://www.w3.org/2000/01/rdf-schema#>
  INSERT {
      GRAPH <https://ariadne-infrastructure.eu/ariadneplus::afe_rgk::periodo> {
          ?native_period skos:prefLabel ?native_label .
      }
  }
  WHERE {
  	GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins> {
        ?temporal aocat:has_native_period ?native_period .
        ?native_period rdfs:label|skos:prefLabel ?native_label .
        ?temporal aocat:from ?from .
        ?temporal aocat:until ?until .
    }
  };

   PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
   PREFIX skos: <http://www.w3.org/2004/02/skos/core#>

   INSERT {
    GRAPH <https://ariadne-infrastructure.eu/ariadneplus::afe_rgk::aatplus> {
        ?record aocat:has_derived_subject ?aat_subject .
    }
   }
  USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::aat>
  USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::afe_rgk::coins>
   WHERE {
        {
            ?record aocat:has_native_subject ?native_subject .
            bind (IRI(concat( "https://ariadne-infrastructure.eu/aocat/Concept/AFE/", ucase(strafter(str(?native_subject),"AFE_RGK/")))) as ?modified_native_subject)
            ?modified_native_subject skos:exactMatch ?aat_subject	.
        }
        union
        {
            ?record aocat:has_native_subject ?native_subject .
            bind (IRI(concat( "https://ariadne-infrastructure.eu/aocat/Concept/AFE/", ucase(strafter(str(?native_subject),"AFE_RGK/")))) as ?modified_native_subject)
            ?modified_native_subject skos:broadMatch ?aat_subject	.

        }
        union
        {
            ?record aocat:has_native_subject ?native_subject .
            bind (IRI(concat( "https://ariadne-infrastructure.eu/aocat/Concept/AFE/", ucase(strafter(str(?native_subject),"AFE_RGK/")))) as ?modified_native_subject)
            ?modified_native_subject skos:closeMatch ?aat_subject	.

        }
        union
        {
            ?record aocat:has_native_subject ?native_subject .
            bind (IRI(concat( "https://ariadne-infrastructure.eu/aocat/Concept/AFE/", ucase(strafter(str(?native_subject),"AFE_RGK/")))) as ?modified_native_subject)
            ?modified_native_subject skos:narrowMatch ?aat_subject	.
        }
   };