Wikidata:WikiProject Lithuania/Maintenance Queries
Jump to navigation
Jump to search
Try it!
Try it!
Items without statements[edit]
Missing images[edit]
# Items in Lithuania that have coordinates missing an image
SELECT ?item ?itemLabel ?coord
WHERE
{
?item wdt:P17 wd:Q37 .
?item wdt:P625 ?coord .
FILTER NOT EXISTS {
?item wdt:P18 ?image
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "lt" }
}
Also works with "WikiData Free Image Search Tool"
Item merging[edit]
Lithuania errors[edit]
Missing labels[edit]
SELECT ?occup ?occupLabel ?count
WHERE
{
{
SELECT ?occup (COUNT(?person) as ?count)
WHERE
{
?person wdt:P106 ?occup .
}
GROUP BY ?occup
ORDER BY DESC(?count)
LIMIT 1000
}
OPTIONAL {?occup rdfs:label ?name_label filter(lang(?name_label) = "lt")}
FILTER(!BOUND(?name_label))
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
ORDER BY DESC(?count)
See also Help:Female form of label