query-797550b8f1ba3c8f73f27c1001b57584
title: Archive in de,fr,us,gb SELECT DISTINCT ?page_title ?article (GROUP_CONCAT(DISTINCT ?class; SEPARATOR = ", ") AS ?ist_ein) (GROUP_CONCAT(DISTINCT ?sitz; SEPARATOR = ", ") AS ?sitze) ?land ?website ?item WHERE { ?item (wdt:P31/(wdt:P279*)) wd:Q166118; wdt:P17 ?country; wdt:P31 ?klasse; wikibase:sitelinks ?sl. FILTER((?sl > 0 ) && (?country IN(wd:Q183, wd:Q30, wd:Q145, wd:Q142))) OPTIONAL { ?dearticle schema:about ?item; schema:isPartOf https://de.wikipedia.org/; schema:name ?depage_title. } OPTIONAL { ?enarticle schema:about ?item; schema:isPartOf https://en.wikipedia.org/; schema:name ?enpage_title. } OPTIONAL { ?item wdt:P131 ?ve. } OPTIONAL { ?item (wdt:P131/wdt:P131) ?vve. } OPTIONAL { ?item wdt:P856 ?website. } BIND(IF(BOUND(?dearticle), ?dearticle, ?enarticle) AS ?article) BIND(IF(BOUND(?depage_title), ?depage_title, ?enpage_title) AS ?page_title) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,en". ?ve rdfs:label ?sitz. ?country rdfs:label ?land. ?klasse rdfs:label ?class. } } GROUP BY ?page_title ?article ?land ?website ?item ORDER BY (?land) (?sitze) (?page_title)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Archive in de,fr,us,gb
SELECT DISTINCT ?page_title ?article (GROUP_CONCAT(DISTINCT ?class; SEPARATOR = ", ") AS ?ist_ein) (GROUP_CONCAT(DISTINCT ?sitz; SEPARATOR = ", ") AS ?sitze) ?land ?website ?item WHERE {
?item (wdt:P31/(wdt:P279*)) wd:Q166118;
wdt:P17 ?country;
wdt:P31 ?klasse;
wikibase:sitelinks ?sl.
FILTER((?sl > 0 ) && (?country IN(wd:Q183, wd:Q30, wd:Q145, wd:Q142)))
OPTIONAL {
?dearticle schema:about ?item;
schema:isPartOf <https://de.wikipedia.org/>;
schema:name ?depage_title.
}
OPTIONAL {
?enarticle schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>;
schema:name ?enpage_title.
}
OPTIONAL { ?item wdt:P131 ?ve. }
OPTIONAL { ?item (wdt:P131/wdt:P131) ?vve. }
OPTIONAL { ?item wdt:P856 ?website. }
BIND(IF(BOUND(?dearticle), ?dearticle, ?enarticle) AS ?article)
BIND(IF(BOUND(?depage_title), ?depage_title, ?enpage_title) AS ?page_title)
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,en".
?ve rdfs:label ?sitz.
?country rdfs:label ?land.
?klasse rdfs:label ?class.
}
}
GROUP BY ?page_title ?article ?land ?website ?item
ORDER BY (?land) (?sitze) (?page_title)