SPARQL Query Editor
About
Tables
Namespace Prefixes
Inference Rules
Macros
RDF Views
Conductor
Facet Browser
Permalink
Extensions:
cxml
save to dav
sponge
User:
SPARQL
Default Data Set Name (Graph IRI)
Query Text
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX dbprop: <http://dbpedia.org/property/> SELECT lcase(xsd:string(?nationalteam)) as ?position COUNT(*) as ?number AVG(xsd:float(?cmheight)) as ?avheight AVG(?sumgoals) as ?avgoals FROM <http://dbpedia.org> WHERE { ?person rdf:type dbpedia-owl:SoccerPlayer . ?person <http://dbpedia.org/ontology/Person/height> ?cmheight FILTER (?person != <http://dbpedia.org/resource/Sanjiban_Ghosh>) . ?person dbpedia-owl:position ?nationalteam . { SELECT ?person SUM(?goals) as ?sumgoals WHERE { ?person dbpprop:goals ?goals FILTER (isNUMERIC(?goals)) FILTER (?person != <http://dbpedia.org/resource/Alcindo_Sartori> ). } GROUP BY ?person } }GROUP BY lcase(xsd:string(?nationalteam)) ORDER BY DESC(COUNT(*)) LIMIT 30
Results Format
Auto
HTML
HTML (Faceted Browsing Links)
Spreadsheet
XML
JSON
Javascript
Turtle
RDF/XML
N-Triples
CSV
TSV
Execution timeout
milliseconds
Options
Strict checking of void variables
Strict checking of variable names used in multiple clauses but not logically connected to each other
Suppress errors on wrong geometries and errors on geometrical operators (failed operations will return NULL)
Log debug info at the end of output (has no effect on some queries and output formats)
Generate SPARQL compilation report (instead of executing the query)