Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | ||
SELECT ?item ?itemLabel ?same_wikidata ?wikidata_iri ?url | SELECT ?item ?itemLabel ?same_wikidata ?wikidata_iri ?url ?twitter ?instagram | ||
WHERE | WHERE | ||
{ | { | ||
| Line 12: | Line 12: | ||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
?wikidata_iri wdt:P856 ?url | OPTIONAL {?wikidata_iri wdt:P856 ?url.} | ||
OPTIONAL {?wikidata_iri wdt:P2002 ?twitter.} | |||
OPTIONAL {?wikidata_iri wdt:P2003 ?instagram.} | |||
} | } | ||
Revision as of 14:38, 24 April 2023
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
SELECT ?item ?itemLabel ?same_wikidata ?wikidata_iri ?url ?twitter ?instagram
WHERE
{
?item wbt:P5 wb:Q13 .
?item wbt:P1 ?same_wikidata.
BIND(URI(concat("http://www.wikidata.org/entity/",?same_wikidata)) AS ?wikidata_iri)
SERVICE <https://query.wikidata.org/sparql> {
OPTIONAL {?wikidata_iri wdt:P856 ?url.}
OPTIONAL {?wikidata_iri wdt:P2002 ?twitter.}
OPTIONAL {?wikidata_iri wdt:P2003 ?instagram.}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}