Difference between revisions of "Languages"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
<pre> | <pre> | ||
| − | SELECT ?item ?itemLabel ?local ?wmcode ?systemLabel ?dirLabel ?iso1 ?iso2 ?iso3 ?ietf WHERE { | + | SELECT ?item ?itemLabel ?typeLabel ?local ?wmcode ?systemLabel ?dirLabel ?iso1 ?iso2 ?iso3 ?ietf WHERE { |
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } | ||
| − | ?item wdt:P424 ?wmcode. | + | ?item wdt:P424 ?wmcode; |
| + | wdt:P31 ?type . | ||
OPTIONAL { ?item wdt:P1705 ?local. } | OPTIONAL { ?item wdt:P1705 ?local. } | ||
OPTIONAL { ?item wdt:P218 ?iso1. } | OPTIONAL { ?item wdt:P218 ?iso1. } | ||
Revision as of 10:32, 21 May 2022
Query
SELECT ?item ?itemLabel ?typeLabel ?local ?wmcode ?systemLabel ?dirLabel ?iso1 ?iso2 ?iso3 ?ietf WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
?item wdt:P424 ?wmcode;
wdt:P31 ?type .
OPTIONAL { ?item wdt:P1705 ?local. }
OPTIONAL { ?item wdt:P218 ?iso1. }
OPTIONAL { ?item wdt:P219 ?iso2. }
OPTIONAL { ?item wdt:P220 ?iso3. }
OPTIONAL { ?item wdt:P305 ?ietf. }
OPTIONAL { ?item wdt:P282 ?system .
?system wdt:P1406 ?dir.}
}
Google sheets: https://docs.google.com/spreadsheets/d/1dUllEr-g8vLsLJDkOVYUNcnRavIZrqV2gfGu4BCfUw4/edit?usp=sharing
