search

fnielsen / ordia

Wikidata lexemes presentations
https://ordia.toolforge.org
Apache License 2.0
24 stars 13 forks source link

list aspect, e.g., with weekdays #19

Open fnielsen opened 5 years ago

fnielsen commented 5 years ago 
SELECT
  ?language ?languageLabel 
  ?monday ?mondayLabel
  ?tuesday ?tuesdayLabel
  ?wednesday ?wednesdayLabel
  ?thursday ?thursdayLabel
  ?friday ?fridayLabel
  ?saturday ?saturdayLabel
  ?sunday ?sundayLabel
WHERE {
  VALUES (?monday_concept ?tuesday_concept ?wednesday_concept
          ?thursday_concept ?friday_concept ?saturday_concept ?sunday_concept) {
    (wd:Q105 wd:Q127 wd:Q128 wd:Q129 wd:Q130 wd:Q131 wd:Q132) }
  ?monday ontolex:sense / wdt:P5137 ?monday_concept ; dct:language ?language ; wikibase:lemma ?mondayLabel . MINUS { ?monday wikibase:lexicalCategory wd:Q102786 }
  OPTIONAL {
    ?tuesday ontolex:sense / wdt:P5137 ?tuesday_concept ; dct:language ?language ; wikibase:lemma ?tuesdayLabel . MINUS { ?tuesday wikibase:lexicalCategory wd:Q102786. }
  }
  OPTIONAL {
    ?wednesday ontolex:sense / wdt:P5137 ?wednesday_concept ; dct:language ?language ; wikibase:lemma ?wednesdayLabel . MINUS { ?wednesday wikibase:lexicalCategory wd:Q102786 }
  }
  OPTIONAL {
    ?thursday ontolex:sense / wdt:P5137 ?thursday_concept ; dct:language ?language ; wikibase:lemma ?thursdayLabel . MINUS { ?thursday wikibase:lexicalCategory wd:Q102786 }
  }
  OPTIONAL {
    ?friday ontolex:sense / wdt:P5137 ?friday_concept ; dct:language ?language ; wikibase:lemma ?fridayLabel . MINUS { ?friday wikibase:lexicalCategory wd:Q102786 }
  }
  OPTIONAL {
    ?saturday ontolex:sense / wdt:P5137 ?saturday_concept ; dct:language ?language ; wikibase:lemma ?saturdayLabel . MINUS { ?saturday wikibase:lexicalCategory wd:Q102786 }
  }
  OPTIONAL {
  ?sunday ontolex:sense / wdt:P5137 ?sunday_concept ; dct:language ?language ; wikibase:lemma ?sundayLabel . MINUS { ?sunday wikibase:lexicalCategory wd:Q102786 }
  }
    OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (LANG(?languageLabel) = "en") }

  # Exclude British Sign Language
  FILTER (?language != wd:Q33000)
}
ORDER BY (?languageLabel)
fnielsen commented 5 years ago

Find items that has a next and a sense.

SELECT DISTINCT ?q ?qLabel {
  [] wdt:P5137 ?q .
  ?q wdt:P156 | (p:P31 / pq:P156 ) [] .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}