query-3026bca4f28f94795bd152339be3a829

rq turtle/ttl

Find Items with number of statements!At WIKIDATACON, it was mentioned that eventually items could be found, based on quality! But, until then; Is there a way to find/list/query items with the number of statements it contains? and, items with no labels in a particular language? or items with only one label, with no additional languages? and, items that have no "instance of and subclass of" statements? (without using the game!) and, items with no external identifiers? .10:15, 7 December 2017‎ (UTC)) at contribs • talk (Wallacegromit1 comment was added byunsignedThe preceding – If it has already been answered!? I apologise for asking again! 09:22, 7 December 2017 (UTC)) talk (MisterSynergyYes all of that is technically possible with the Query Service—but it only works if you restrict it to certain topics (otherwise the queries would time out). So could you please ask a more specific question? — Thanks for the swift reply! More specific questions would be; Query: 1. items with only 1(one) or 2 statements (example: only Commons Category, Or, Commons Category and Topics Main Category)? 2. items with labels only in one language(en)? 3. items with only Freebase external identifiers? items with exactly two statements

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel
WHERE{
  ?item wikibase:statements 2 .
  FILTER ( ?item not in ( wd:Q16943273,wd:Q17566023 ) ) #Exclude item of wikidata tour
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
} 
Limit 100

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2017/12