Difference between revisions of "Languages"

From Wikidocumentaries
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