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
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
Q27273404isometheptene hydrochloridechemical compound
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
Q271035323-Hydroxy-5-methoxy-6-prenylstilbene-2-carboxylic acidchemical compound
Q27104372N-benzoyl-4-methoxyanthranilatechemical compound
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
Q61775912Dzianis ShedauBelarusian rower
Q63530250Thredboparish of Wallace County, New South Wales, Australia
Q64516063The Guardianpainting by Lee Krasner
Q66859774Tony SmithSouth African former cricketer born 1951
Q69526075The Guardianweekly periodical (Albany, N.Y. : Van Benthuysen & Wood, 1807-1808.)
Q73896692Kontaktopen access academic journal
Q75455114Philip JonesPeerage person ID=152745
Q75489272Philip JonesPeerage person ID=172876
Q75489286Philip JonesPeerage person ID=172884
Q75967853Philip JonesPeerage person ID=436957
Q76336914Guy Richardson(born 1885)
Q76337767Philip JonesPeerage person ID=699086
Q76803563Guy RichardsonAustralian footballer
Q78992849KontaktSwedish periodical
Q15409391methenolone enanthatechemical compound
Q15752933TestAn Official Journal of the Spanish Society of Statistics and Operations Research
Q16033930Enter the NinjaWikimedia disambiguation page
Q27178680N-[(2S,3S,6R)-6-[2-(cyclobutylamino)-2-oxoethyl]-2-(hydroxymethyl)-3,6-dihydro-2H-pyran-3-yl]cyclopropanecarboxamidechemical compound
Q271860771-(4-fluorophenyl)-2-[(2-propyl-4-quinazolinyl)thio]ethanonechemical compound
Q27186081N-(3-pyridinylmethyl)-1,3-benzodioxol-5-aminechemical compound
Q271885661-[3-[2-(dimethylamino)ethylamino]-3-oxopropyl]-2-methyl-5-(4-methylphenyl)-3-pyrrolecarboxylic acid ethyl esterchemical compound
Q271935453-(4-nitrophenyl)-2H-phthalazine-1,4-dionechemical compound
Q20748867Philip JonesWelsh Calvinistic Methodist minister
Q20861365Collinspainting by Charles Lewis Fussell
Q21461804Tony SmithBritish painter (born 1953)
Q21464636Philip Jonespainter (born 1971)
Q22107732Chris SimonAmerican evolutionary biologist and entomologist
Q25340070Dennis Gilbertbaseball player, agent, and executive

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