User:Ark25/Scripts

Articles about people, containing string "Vale""

SELECT ?title ?article ?Wikipedia
WHERE
{
  ?article schema:about ?item.
  ?item wdt:P31 wd:Q5.
  ?article schema:name ?title.
  ?article schema:isPartOf ?Wikipedia.
  ?Wikipedia wikibase:wikiGroup "wikipedia".
  FILTER CONTAINS(?title, "Vale")
}
LIMIT 100

Try it!

Articles about people, starting with string "Vale""

SELECT ?title ?article ?Wikipedia
WHERE
{
  ?article schema:about ?item.
  ?item wdt:P31 wd:Q5.
  ?article schema:name ?title.
  ?article schema:isPartOf ?Wikipedia.
  ?Wikipedia wikibase:wikiGroup "wikipedia".
  FILTER STRSTARTS(?title, "Vale")
}
LIMIT 100

Try it!

Articles about people on English Wikipedia, containing the exact word "Vale""

SELECT ?title ?article
WHERE
{
  ?article schema:about [wdt:P31 wd:Q5].
  ?article schema:name ?title.
  ?article schema:isPartOf <https://en.wikipedia.org/>
  FILTER REGEX(?title, "\\bVale\\b")
}
LIMIT 1

Try it!