Gio at 14:11, 5 May 2024

2024-05-05T14:11:10Z

New page

PREFIX dct: <http://purl.org/dc/terms/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dbp: <http://dbpedia.org/property/>
PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX dbr: <http://dbpedia.org/resource/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT
#?id
#concat("[[name::", ?name, "]]") as ?Name
?name
?h
# concat("[[homepage::", ?h, "]]") as ?Homepage
#concat("[[has_location_city::", ?c, "]]") as ?City
?c
?thumbnail
# concat("[", ?thumbnail, "]") as ?Thumbnail
(group_concat(distinct concat("[[Product::",?p,"]]");separator=",\n") as ?Product)
# (group_concat(distinct concat("[[subject::",?ob,"]]");separator=",\n") as ?Subjects)
(group_concat(distinct concat("",?ob,"");separator=",\n") as ?Subjects)
#?ob
#?s
WHERE {
VALUES ?s {dbr:{{PAGENAMEE}}}
OPTIONAL { ?s dbo:wikiPageID ?id}
OPTIONAL {?s dct:subject ?sob.
?sob rdfs:label ?ob .
FILTER (lang(?ob) = 'en')
}
OPTIONAL { ?s dbo:abstract ?label}
OPTIONAL { ?s dbp:name ?name }
OPTIONAL { ?s dbp:commonName ?name }
OPTIONAL { ?s foaf:name ?name }
OPTIONAL { ?s rdfs:label ?name }
OPTIONAL { ?s foaf:homepage ?h }
OPTIONAL { ?s dbo:locationCity ?sc .
?sc rdfs:label ?c .
}
OPTIONAL { ?s dbp:hqLocationCity ?sc .
?sc rdfs:label ?c .
FILTER (lang(?c) = 'en')
}
OPTIONAL { ?s dbo:thumbnail ?thumbnail }
OPTIONAL { ?s dbo:product ?sp .
?sp rdfs:label ?p .
FILTER (lang(?p) = 'en')
}
FILTER (lang(?label) = 'en')
FILTER (lang(?c) = 'en')
}
group by ?id ?c ?name ?h ?thumbnail #?ob #?s
#group by ?c ?name ?h ?thumbnail #?s

Template:Sparql company page - Revision history

Gio at 14:11, 5 May 2024