A more powerful tool exists and you should use it: Wikidata Terminator ;-)

Label and description exist in:

or doesn't exist in:

Keep only items instance or subclass of: (example: Q55488)

Country: (example: Q142 for France)

QidLabelDescription
Q27273404isometheptene hydrochloridechemical compound
Q27592780hsa-miR-5584-5phuman mature microRNA
Q27592829hsa-miR-6077human mature microRNA
Q27592941hsa-miR-5699-5phuman mature microRNA
Q27592949hsa-miR-548qhuman mature microRNA
Q27592960hsa-miR-604human mature microRNA
Q27592977hsa-miR-7151-5phuman mature microRNA
Q27593053hsa-miR-6124human mature microRNA
Q27593098hsa-miR-6748-3phuman mature microRNA
Q27593263hsa-miR-6761-5phuman mature microRNA
Q27593400hsa-miR-770-5phuman mature microRNA
Q27593713hsa-miR-6883-5phuman mature microRNA
Q27593768hsa-miR-6884-5phuman mature microRNA
Q27593772hsa-miR-6867-5phuman mature microRNA
Q27593920hsa-miR-6789-3phuman mature microRNA
Q27594000hsa-miR-8085human mature microRNA
Q27594038hsa-miR-6801-5phuman mature microRNA
Q27594131hsa-miR-6807-3phuman mature microRNA
Q27594154hsa-miR-8485human mature microRNA
Q27594205hsa-miR-5590-3phuman mature microRNA
Q27594212hsa-miR-6888-3phuman mature microRNA
Q27594219hsa-miR-7704human mature microRNA
Q27594229hsa-miR-561-5phuman mature microRNA
Q27594290hsa-miR-6870-5phuman mature microRNA
Q27594370hsa-miR-6814-5phuman mature microRNA
Q27594539hsa-miR-7976human mature microRNA
Q27594559hsa-miR-7977human mature microRNA
Q27594596hsa-miR-573human mature microRNA
Q27594650hsa-miR-578human mature microRNA
Q27594666hsa-miR-6131human mature microRNA
Q27594799hsa-miR-7111-5phuman mature microRNA
Q27594852hsa-miR-6836-5phuman mature microRNA
Q27594871hsa-miR-550b-2-5phuman mature microRNA
Q27594912hsa-miR-6840-3phuman mature microRNA
Q27594924hsa-miR-593-3phuman mature microRNA
Q19662656John Coleman1862-1905 politician
Q21890405Issekatown in Shire of Northampton, Western Australia
Q27269869hydroxindasolchemical compound
Q27270599hydroxyethyl-3,4-methylenedioxyaniline hydrochloridechemical compound
Q27595003hsa-miR-8084human mature microRNA
Q27595048hsa-miR-661human mature microRNA
Q27595188hsa-miR-6086human mature microRNA
Q27595194hsa-miR-6134human mature microRNA
Q27595264hsa-miR-764human mature microRNA
Q27595306hsa-miR-888-5phuman mature microRNA
Q27595348hsa-miR-6858-5phuman mature microRNA
Q47477037John Coleman1935- greyhound trainer
Q57151157Jacob van Campen(?-1593)
Q64708103John ColemanRoman Catholic bishop (1887-1947)
Q75674140John ColemanPeerage person ID=283391
Q98100028John Coleman1694 Prince George Co., Virginia -
Q100746186John Coleman(1667-1762)
Q100770950John Colemancollege basketball player (1971–1971) North Texas
Q100770951John Colemancollege basketball player (1955–1955) Mississippi State
Q102443665John ColemanPh.D. University of London 1965
Q108283976John ColemanBritish Royal Navy officer, lieutenant in 1813
Q108283979John ColemanBritish Royal Navy officer, lieutenant in 1815
Q112024312John ColemanTitanic victim
Q112028050John ColemanAmerican businessperson, author, and board member, Managing Partner at Sovereign's Capital
Q118117255John Coleman1803-1869
Q125888291John ColemanCanadian lawyer
Q130930779John Colemanresearcher (ORCID 0000-0002-7261-3143)
Q134688576John ColemanNew Zealand farmer, rugby referee and community leader (born 1936)
Q137677656John ColemanCanadian political candidate
Q12953838Eastern Apurímac Quechualanguage
Q15409391methenolone enanthatechemical compound
Q15752933TestAn Official Journal of the Spanish Society of Statistics and Operations Research
Q16033930Enter the NinjaWikimedia disambiguation page
Q11148The GuardianBritish national daily newspaper
Q125361170The Guardianupcoming film directed by Jeong Jang-hwan
Q129935381The Guardianshort story by Gary Russell
Q131321939The Guardian2021 film
Q131428415Test2025 film directed by S. Sashikanth
Q131753706Tony SmithAmerican politician
Q134389498Test2025 soundtrack album by Shakthisree Gopalan
Q271022131-guanidino-1-deoxy-scyllo-inositolchemical compound
Q19193617The Guardianshort story by Anton Chekhov
Q19367457CollinsPhiladelphia printer
Q19665199Steve Petersongame designer
Q19899795CollinsCollins family (per. c.1820–c.1980)
Q20676428Dennis GilbertAmerican ice hockey player
Q134992273The Guardian2021 video game developed by IT-Fun
Q136086040Tony SmithAmerican businessperson
Q136107203The Guardian1982
Q137163090The GuardianNew Zealand community newspaper
Q137363263The Guardianshort story by Walter de la Mare
Q137364210Testshort story by Theodore L. Thomas
Q139593352Philip Jonesfilm actor
Q139681788The Guardiannovel by Linda McNabb
Q139814529The Guardianpoem by Robert A. W. Lowndes
Q139958012The Guardiannovel by Emma Holly
Q140027129The Guardiannovel by Angus Wells
Q140137698Test2026 American film
Q140305804Testnovel by William Sleator
Q1474352The GuardianBritish newspaper (London; 12 March to 1 October 1713)
Q2076243Collinscity in Covington County, Mississippi, United States
Q3521169The Guardian1997 television film
Q5036634Captain Fantastictelevision series
Q5147328Collinsformer settlement in California, United States
Q5147329Collinsunincorporated community in Whitley County, Indiana

SPARQL queries

#1 [WDQS]

SELECT ?code ?label
WHERE {
  ?language wdt:P218 ?code .
  ?language rdfs:label ?label .
  FILTER (lang(?label) = ?code) .
}
ORDER BY ?code

#2 [WDQS]

SELECT ?item ?label ?description
WHERE {
  
  
  
  ?item rdfs:label ?label .
  FILTER (LANG(?label) = "en") .
  ?item schema:description ?description .
  FILTER (LANG(?description) = "en") .
  FILTER NOT EXISTS {
    ?item rdfs:label ?no .
    FILTER (LANG(?no) = "de") .
  }
}
LIMIT 100