Wind Power

From solab
Jump to navigation Jump to search
sandbox

Wind_turbine_manufacturers
{{#gu_gen: sparql | http://dbpedia.org/sparql | |

PREFIX dbpprop: <http://dbpedia.org/property/> 

PREFIX dbpedia-owl:<http://dbpedia.org/ontology/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/> 
SELECT distinct  ?label_en ?page
WHERE 
 {
 ?subject dcterms:subject <http://dbpedia.org/resource/Category:Wind_turbine_manufacturers>.
 FILTER (REGEX(?subject, '[^a-z A-Z 0-9]*')) . 
<http://dbpedia.org/resource/Category:Wind_turbine_manufacturers>  rdfs:label ?label  . 
         FILTER (LANG(?label) = 'en') .
         ?subject rdfs:label ?label_en .
         FILTER (LANG(?label_en) = 'en' || LANG(?label_en) = 'it' ) .
           
OPTIONAL {
        ?subject  foaf:isPrimaryTopicOf  ?page .
 }} limit 10

|yes |WIKITABLE |{{{x}}} |{{{y}}}

}}

Error query  : PREFIX dct: <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/>
PREFIX dbrcat: <http://dbpedia.org/resource/Category:>
SELECT 
            #?id 
            # concat("", ?name, "") as ?Name
            ?name
            #concat("", ?h, "") as ?Homepage
            #concat("", ?c, "") as ?City
            #concat("[", ?thumbnail, "]") as ?Thumbnail
            #(group_concat(concat("",?p,""",?p,"" is not in the list (mobility, E-mobility, Crystalline modules, Building integrated solutions (BIPV), PV, ST, Absorbers, Law, Certification, Standards, ...) of allowed values for the "Product" property.");separator=",\n") as ?Product)
            #?s
            ?oc
            # concat("", ?o, "") as ?CompanyName
            ?o

    ?b
    #?c
  WHERE {
       VALUES ?s {dbrcat:Wind_Power}
       VALUES ?b { 1 1}
       OPTIONAL {?oc dct:subject ?s.
                 ?oc rdfs:label ?o .
                 FILTER (lang(?o) = 'en')
                }        
       OPTIONAL { ?s dbo:wikiPageID ?id}
       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')
}

Error endpoint: http://dbpedia.org/sparql Error http_response_code: 500 Error message: Virtuoso 40001 Error SR...: Transaction deadlock, from SQL built-in function.

SPARQL query: PREFIX dct: <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/>
PREFIX dbrcat: <http://dbpedia.org/resource/Category:>
SELECT 
            #?id 
            # concat("", ?name, "") as ?Name
            ?name
            #concat("", ?h, "") as ?Homepage
            #concat("", ?c, "") as ?City
            #concat("[", ?thumbnail, "]") as ?Thumbnail
            #(group_concat(concat("",?p,""",?p,"" is not in the list (mobility, E-mobility, Crystalline modules, Building integrated solutions (BIPV), PV, ST, Absorbers, Law, Certification, Standards, ...) of allowed values for the "Product" property.");separator=",\n") as ?Product)
            #?s
            ?oc
            # concat("", ?o, "") as ?CompanyName
            ?o

    ?b
    #?c
  WHERE {
       VALUES ?s {dbrcat:Wind_Power}
       VALUES ?b { 1 1}
       OPTIONAL {?oc dct:subject ?s.
                 ?oc rdfs:label ?o .
                 FILTER (lang(?o) = 'en')
                }        
       OPTIONAL { ?s dbo:wikiPageID ?id}
       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')
}

Error number: 0 Error message:

Error data: Array ( 

   [query] => PREFIX dct: <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/>
PREFIX dbrcat: <http://dbpedia.org/resource/Category:>
SELECT 
            #?id 
            # concat("", ?name, "") as ?Name
            ?name
            #concat("", ?h, "") as ?Homepage
            #concat("", ?c, "") as ?City
            #concat("[", ?thumbnail, "]") as ?Thumbnail
            #(group_concat(concat("",?p,""",?p,"" is not in the list (mobility, E-mobility, Crystalline modules, Building integrated solutions (BIPV), PV, ST, Absorbers, Law, Certification, Standards, ...) of allowed values for the "Product" property.");separator=",\n") as ?Product)
            #?s
            ?oc
            # concat("", ?o, "") as ?CompanyName
            ?o

    ?b
    #?c
  WHERE {
       VALUES ?s {dbrcat:Wind_Power}
       VALUES ?b { 1 1}
       OPTIONAL {?oc dct:subject ?s.
                 ?oc rdfs:label ?o .
                 FILTER (lang(?o) = 'en')
                }        
       OPTIONAL { ?s dbo:wikiPageID ?id}
       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')
}
   [output] => xml
   [Accept] => application/sparql-results+xml

)



Wind power

en:Wind power

Retrieved from "http://solab.eu/solab/index.php?title=Wind_Power&oldid=51780"