Hi! I mostly fiddle around with items related to articles from nowiki! I also like to fill out more information when the Wikidata item is lacking!
sparql requests answered
[
edit
]
I just need somewhere where I can easily access them again!
This one's from Andrew Gray!!
# items with nowiki sitelinks but no nb labels
SELECT
distinct
?item
WHERE
{
?article
schema
:
about
?item
.
?article
schema
:
isPartOf
<https://no.wikipedia.org/>
.
FILTER
NOT EXISTS
{
?item
rdfs
:
label
?l
.
filter
(
lang
(
?l
)
=
"nb"
)
}
}
limit
10
Try it!
- Change
rdfs:label
to
schema:description
to get descriptions not labels. It times out without the LIMIT function. You can also combine both to eg find items that have a label but not a description:
# items with nowiki sitelinks, nb labels, no nb description
SELECT
distinct
?item
WHERE
{
?article
schema
:
about
?item
.
?article
schema
:
isPartOf
<https://no.wikipedia.org/>
.
?item
rdfs
:
label
?l
.
filter
(
lang
(
?l
)
=
"nb"
)
.
FILTER
NOT EXISTS
{
?item
schema
:
description
?l2
.
filter
(
lang
(
?l2
)
=
"nb"
)
}
}
limit
10
Try it!