Solar power stations

Italy

{{#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:Solar_power_stations_in_Italy>.
 FILTER (REGEX(?subject, '[^a-z A-Z 0-9]*')) . 
<http://dbpedia.org/resource/Category:Solar_power_stations_in_Italy>  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 100

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

Germany

{{#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:Solar_power_stations_in_Germany>.
 FILTER (REGEX(?subject, '[^a-z A-Z 0-9]*')) . 
<http://dbpedia.org/resource/Category:Solar_power_stations_in_Germany>  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 100

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

Solar

power

stations

Solar_power_stations_in_Italy

Solar_power_stations

{{#gu_gen: sparql | http://dbpedia.org/sparql | | PREFIX dbpedia: <http://dbpedia.org/property/>

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

  OPTIONAL {
        ?subject rdfs:label  ?label_en .
        FILTER (LANG(?label_en) = 'en') .
          }
 OPTIONAL {
        ?subject rdfs:label  ?label_it .
        FILTER (LANG(?label_it) = 'it') .
          }
 OPTIONAL {
         ?subject foaf:page ?page .
           }
 }

|no |{{{format}}} |{{{x}}} |{{{y}}} }}