...
Bloque de código |
---|
|
SELECT ?person ?nombre ?email count(distinct ?documento) as ?colaboracionesDocumentos count(distinct ?proy) as ?colaboracionesProyectos
count(distinct ?documento) + count(distinct ?proy) as ?totalColaboraciones
from <http://gnoss.com/b836078b-78a0-4939-b809-3f2ccf4e5c01>
WHERE
{
?person a 'person'.
?person foaf:name ?nombre.
?person <https://www.w3.org/2006/vcard/ns#email> ?email
{
?documento <http://purl.org/ontology/bibo/authorList> ?listaAutoresA.
?listaAutoresA <http://www.w3.org/1999/02/22-rdf-syntax-ns#member> ?personaBuscar.
?documento a 'document'.
?documento <http://purl.org/ontology/bibo/authorList> ?listaAutores.
?listaAutores <http://www.w3.org/1999/02/22-rdf-syntax-ns#member> ?person.
}
UNION
{
?proy <http://
}
UNION
{
?proy <http://w3id.org/roh/membersProject> ?personaBuscar.
?proy a 'project'.
?proy <http://w3id.org/roh/membersProject> ?person.
}
FILTER(?person != ?personaBuscar)
?personaBuscar a 'person'.
?personaBuscar <https://www.w3.org/2006/vcard/ns#email> ?emailPersonaBuscar.
FILTER( ?emailPersonaBuscar="""+"'"+investigador_email+"'"+""")
}order by desc(?totalColaboraciones)"""
|