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
Q271213417alpha,24-dihydroxycholest-4-en-3-onechemical compound
Q27126539cefpiramide(1-)chemical compound
Q271358041beta-hydroxy-6,7alpha-dihydroxyeudesm-4(15)-enechemical compound
Q271358643''-deoxy-6'-O-desmethylcandidusin Bchemical compound
Q271035323-Hydroxy-5-methoxy-6-prenylstilbene-2-carboxylic acidchemical compound
Q271157871,6-dimethylnaphthalenechemical compound
Q271234244-methylenecyclohexa-2,5-dieniminechemical compound
Q271250623',4',5-trihydroxy-3-methoxyflavon-7-olatechemical compound
Q27140302(R)-mallotophilippen Echemical compound
Q271466513-[(1-carboxyvinyl)oxy]benzoic acidchemical compound
Q5036634Captain Fantastictelevision series
Q5147328Collinsformer settlement in California, United States
Q5147331Collinshuman settlement in Ontario, Canada
Q5147335Collinscensus-designated place in Wisconsin, United States
Q5147341CollinsAmerican baseball player
Q19899795CollinsCollins family (per. c.1820–c.1980)
Q20861365Collinspainting by Charles Lewis Fussell
Q22107732Chris SimonAmerican evolutionary biologist and entomologist
Q271022131-guanidino-1-deoxy-scyllo-inositolchemical compound
Q2714852016-Butyl-3-methoxy-estra-1,3,5(10)-triene-16beta,17beta-diolchemical compound
Q271885661-[3-[2-(dimethylamino)ethylamino]-3-oxopropyl]-2-methyl-5-(4-methylphenyl)-3-pyrrolecarboxylic acid ethyl esterchemical compound
Q271791372-[(1R,3R,4aR,9aS)-6-(dimethylamino)-1-(hydroxymethyl)-3,4,4a,9a-tetrahydro-1H-pyrano[3,4-b]benzofuran-3-yl]-N-(pyridin-4-ylmethyl)acetamidechemical compound
Q271860771-(4-fluorophenyl)-2-[(2-propyl-4-quinazolinyl)thio]ethanonechemical compound
Q271486073-Methoxy-16-ethylestra-1,3,5(10)-triene-16beta,17beta-diolchemical compound
Q271487126beta,19-Epoxy-17beta-hydroxyandrost-4-en-3-onechemical compound
Q271490796alpha-Fluoro-17beta-hydroxyandrost-4-en-3-one acetatechemical compound
Q27149741(Z)-ajoenechemical compound
Q271700291-[(2S,3R,6R)-2-(hydroxymethyl)-6-(2-oxo-2-piperidin-1-ylethyl)oxan-3-yl]-3-(3-methoxyphenyl)ureachemical compound
Q271935453-(4-nitrophenyl)-2H-phthalazine-1,4-dionechemical compound
Q272106082-hydroxy-5-[(4-methoxyphenyl)sulfamoyl]benzoic acid [2-[1-(3-bicyclo[2.2.1]heptanyl)ethylamino]-2-oxoethyl] esterchemical compound
Q27215373(1S,5R)-3-methylsulfonyl-7-(4-phenylphenyl)-3,6-diazabicyclo[3.1.1]heptanechemical compound
Q272169551-[(8R,9S,10R)-10-(hydroxymethyl)-9-[4-(4-methoxyphenyl)phenyl]-1,6-diazabicyclo[6.2.0]decan-6-yl]-2-pyridin-4-ylethanonechemical compound
Q27218320[(1S)-1-(hydroxymethyl)-7-methoxy-1'-methyl-2-spiro[3,9-dihydro-1H-pyrido[3,4-b]indole-4,4'-piperidine]yl]-phenylmethanonechemical compound
Q27255291(11Z)-11-eicosenyl oleatechemical compound
Q27259070benzomethamine chloridechemical compound
Q27263791benzyl bromoacetatechemical compound
Q27225379(S)-demethyl-4-deoxygadusolchemical compound
Q272547973,3-bis(3-tert-butyl-4- hydroxyphenyl)ethylene esterbutyric acidchemical compound
Q27276974(1S)-1-(3-methoxyphenyl)-N,N-dimethylethanaminechemical compound
Q27281030(3R,4S)-3-(4-(4-fluorophenyl)-4-hydroxypiperidin-1-yl)-3,4-dihydro-2H-chromene-4,7-diolchemical compound
Q27282768amifostine monohydratechemical compound
Q27286324am-152chemical compound
Q274554745-chloro-N,1-dimethyl-1H-pyrazole-4-carboxamidechemical compound
Q28472492Collinspainting by Selina Foote
Q31549813Collinsdam in Lowndes County, Alabama, United States of America
Q41776070Collinsapple cultivar
Q52341517Captain Fantastic2018 studio album by Die Fantastischen Vier
Q55807687Collinslocality in the Shire of Manjimup, Western Australia
Q95845833Chris Simonaudio engineer
Q103916668Collinsshipwreck off the Scottish coast
Q104357682Collinstownland in Londonderry, Northern Ireland
Q106483705Collinscensus-designated place in Arkansas, United States
Q108512623CollinsSapper in Indian Engineers, British Indian Army
Q110242855CollinsAmerican photographer
Q110253752Collinsanime character designed to represent Wales ahead of the 2020–21 Olympic Games
Q110281265Collinsvillage in Antigua, Antigua and Barbuda
Q114731293Collinsimprint of HarperCollins Publishers Ltd.
Q115261147Collinsgeographic township in Ontario, Canada
Q119777205Collinspublishing house based in Milan, Italy
Q120913138Captain Fantastic2016 soundtrack albums
Q121033153Collinsunincorporated community in Bingham County, Idaho, United States
Q124670930Abersychanward or electoral division in Torfaen, Wales
Q27104372N-benzoyl-4-methoxyanthranilatechemical compound
Q271047942,5-diamino-6-(5-phosphono)ribitylamino-4(3H)-pyrimidinonechemical compound
Q27105968bracteatinchemical compound
Q27595161hsa-miR-3689chuman mature microRNA
Q27595163hsa-miR-3689a-3phuman mature microRNA
Q27595166hsa-miR-3689b-3phuman mature microRNA
Q27595188hsa-miR-6086human mature microRNA
Q27595189hsa-miR-548am-3phuman mature microRNA
Q27595190hsa-miR-548am-5phuman mature microRNA
Q27595191hsa-miR-4768-5phuman mature microRNA
Q27595194hsa-miR-6134human mature microRNA
Q27595195hsa-miR-4666bhuman mature microRNA
Q27595207hsa-miR-532-3phuman mature microRNA
Q27595214hsa-miR-362-3phuman mature microRNA
Q27595221hsa-miR-502-5phuman mature microRNA
Q27595237hsa-miR-223-5phuman mature microRNA
Q27595249hsa-miR-374a-5phuman mature microRNA
Q27595264hsa-miR-764human mature microRNA
Q27595273hsa-miR-1277-5phuman mature microRNA
Q27595285hsa-miR-106a-5phuman mature microRNA
Q27595293hsa-miR-542-3phuman mature microRNA
Q27595306hsa-miR-888-5phuman mature microRNA
Q27595315hsa-miR-513b-5phuman mature microRNA
Q27595335hsa-miR-2114-5phuman mature microRNA
Q27595348hsa-miR-6858-5phuman mature microRNA
Q27887323hexethalchemical compound
Q26299535Paniccharacter from Disney's Hercules
Q26649359Midwaybuilding in Standlake, West Oxfordshire, England, UK
Q26841026diethyl hydrogen phosphatechemical compound
Q27075330BLU9931chemical compound
Q13911916Mawanvillage-level division in Tanghe County, Henan, China
Q14712842Midwaybuilding in Virginia, United States
Q15220579Panic1928 film by Harry Piel
Q15409391methenolone enanthatechemical compound
Q15739820Strength and HonorUkrainian political party
Q16029541Wikipedia:WikiProject Editor Retention/Editor of the WeekWikimedia project page
Q16364112Magicalbum
Q16467176Driveepisode of ER (S10 E22)

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) = "fr") .
  }
}
LIMIT 100