Wikidata:Request a query/Archive/2016/07

This page is an archive. Please do not modify it. Use the current page, even to continue an old discussion.

Items with specific string in image filename

Looking for query that will list items with instance of (P31) and human (Q5) having in image (P18) filename specific string (like COA). --Jklamo (talk) 19:25, 31 July 2016 (UTC)

SELECT ?item ?image WHERE {
  ?item wdt:P31 wd:Q5; wdt:P18 ?image .
  FILTER(CONTAINS(STR(?image), "COA")) .
}

Try it!

Matěj Suchánek (talk) 19:41, 31 July 2016 (UTC)

Hah, and I was thinking, why this one isn't working :) --Edgars2007 (talk) 19:47, 31 July 2016 (UTC)

Thanks! --Jklamo (talk) 20:47, 31 July 2016 (UTC)