query-6bea4e72122a95a095dc07e0d6ef9277

rq turtle/ttl

this is a list of pictures whose legends include a Korean one. You can download the results & filter out those that already have an English legend. MargaretRDonald@ 15:13, 10 July 2023 (UTC)) talk (Vincent TepAny comments & help to make this query better would be much appreciated. Thanks! I've come up with the request below to look for all media legends containing Korean characters: ,MargaretRDonaldHello again @ 05:15, 11 July 2023 (UTC)) talk (Vincent TepThat's one of the things that bother me - I guess there must be many more than 606 images with a legend in Korean. Either my request is poorly-written (quite likely) and/or there are legends in Korean w/o a language tag (I guess that's possible?), in which case looking for legends that contain Korean characters would be a possibility. 23:19, 10 July 2023 (UTC)) talk (MargaretRDonald: Returned 606 images(!) And I have now annotated a few, thanks to you. Regards, Vincent TepThanks @

Use at

PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT 
?imageSrc 
?imageLegend 
?imageLegendLanguage 
WHERE {
  OPTIONAL {
    ?statement ps:P18 ?imageSrc;
      pq:P2096 ?imageLegend.
    BIND(LANG(?imageLegend) AS ?imageLegendLanguage)
  }
  FILTER(REGEX(?imageLegend, "[가-힣]"))
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?imageLegend"):::projected v4("?imageLegendLanguage"):::projected v3("?imageSrc"):::projected v2("?statement") f0[["regex(?imageLegend,'#91;가-힣#93;')"]] f0 --> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."ps:P18".-> v3 v2 --"pq:P2096"--> v1 bind1[/"?imageLegend"/] v1 --o bind1 bind1 --as--o v4 end