query-e8910c7fb9ef85d2b42f170b47d53064
Look after a/some specific Directorate General of Civil Aeronautics (Mexico) code (P5746) code(s)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?DGAC_LID ?item ?itemLabel (group_concat(?natureLabel) as ?natures) {
SELECT distinct ?DGAC_LID ?item ?itemLabel ?nature ?natureLabel WHERE {
{?item wdt:P5746 ?DGAC_LID
VALUES ?DGAC_LID {"AR44" "CO20" }.} #item has a P5746 value
OPTIONAL { ?item wdt:P31 ?nature. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,es" } . #this bit gets labels for Qid values
}
} group by ?Russian_LID ?item ?itemLabel