Wikidata:WikiProject Lithuania/Maintenance Queries

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" }
}

Try it!

Also works with "WikiData Free Image Search Tool"

Item merging edit

User:Ivan A. Krestinin/To merge/ltwiki

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)

Try it!