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
Q1077747Chris SimonCanadian ice hockey player (1972–2024)
Q1109797Collinslunar crater
Q271157871,6-dimethylnaphthalenechemical compound
Q271022131-guanidino-1-deoxy-scyllo-inositolchemical compound
Q271035323-Hydroxy-5-methoxy-6-prenylstilbene-2-carboxylic acidchemical compound
Q271250623',4',5-trihydroxy-3-methoxyflavon-7-olatechemical 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
Q27126539cefpiramide(1-)chemical compound
Q271358041beta-hydroxy-6,7alpha-dihydroxyeudesm-4(15)-enechemical compound
Q271358643''-deoxy-6'-O-desmethylcandidusin Bchemical compound
Q27140302(R)-mallotophilippen Echemical compound
Q271466513-[(1-carboxyvinyl)oxy]benzoic acidchemical compound
Q2714852016-Butyl-3-methoxy-estra-1,3,5(10)-triene-16beta,17beta-diolchemical compound
Q271486073-Methoxy-16-ethylestra-1,3,5(10)-triene-16beta,17beta-diolchemical 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
Q27225379(S)-demethyl-4-deoxygadusolchemical compound
Q272106082-hydroxy-5-[(4-methoxyphenyl)sulfamoyl]benzoic acid [2-[1-(3-bicyclo[2.2.1]heptanyl)ethylamino]-2-oxoethyl] esterchemical compound
Q271487126beta,19-Epoxy-17beta-hydroxyandrost-4-en-3-onechemical compound
Q272547973,3-bis(3-tert-butyl-4- hydroxyphenyl)ethylene esterbutyric acidchemical compound
Q271490796alpha-Fluoro-17beta-hydroxyandrost-4-en-3-one acetatechemical compound
Q271700291-[(2S,3R,6R)-2-(hydroxymethyl)-6-(2-oxo-2-piperidin-1-ylethyl)oxan-3-yl]-3-(3-methoxyphenyl)ureachemical 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
Q27255291(11Z)-11-eicosenyl oleatechemical compound
Q27259070benzomethamine chloridechemical compound
Q27263791benzyl bromoacetatechemical 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
Q271860771-(4-fluorophenyl)-2-[(2-propyl-4-quinazolinyl)thio]ethanonechemical compound
Q271213417alpha,24-dihydroxycholest-4-en-3-onechemical compound
Q271234244-methylenecyclohexa-2,5-dieniminechemical compound
Q27282768amifostine monohydratechemical compound
Q27285420dimetholizinechemical compound
Q27286324am-152chemical compound
Q120913138Captain Fantastic2016 soundtrack albums
Q121033153Collinsunincorporated community in Bingham County, Idaho, United States
Q122793945Collinsship built in 1979
Q123150743Collinsunincorporated community in Pike County, Kentucky
Q274554745-chloro-N,1-dimethyl-1H-pyrazole-4-carboxamidechemical compound
Q28472492Collinspainting by Selina Foote
Q19367457CollinsPhiladelphia printer
Q19899795CollinsCollins family (per. c.1820–c.1980)
Q20676428Dennis GilbertAmerican ice hockey player
Q20861365Collinspainting by Charles Lewis Fussell
Q22107732Chris SimonAmerican evolutionary biologist and entomologist
Q25340070Dennis Gilbertbaseball player, agent, and executive
Q27077045diamide 7chemical compound
Q224909CollinsWikimedia disambiguation page
Q1950738Collinshuman settlement in Tattnall County, Georgia, United States of America
Q3472875Collinscensus-designated place in central Townsend Township, Huron County, Ohio
Q3709221Collinstown in New York, United States
Q5036634Captain Fantastictelevision series
Q5147328Collinsformer settlement in California, United States
Q5147329Collinsunincorporated community in Whitley County, Indiana
Q5147330Collinsunincorporated community in California
Q5147331Collinscompact rural community in Thunder Bay District, Ontario, Canada
Q5147335Collinscensus-designated place in Wisconsin, United States
Q5147340CollinsEnglish cricketer (1744)
Q5147342CollinsEnglish cricketer
Q5258450Dennis GilbertAmerican sociologist
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
Q61775912Dzianis ShedauBelarusian rower
Q95845833Chris Simonaudio engineer
Q103916668Collinsshipwreck off the Scottish coast
Q104357682Collinstownland in Londonderry, Northern Ireland
Q104375920Dihydroedulan IIgroup of stereoisomers with the chemical formula C₁₃H₂₂O
Q106483705Collinscensus-designated place in Arkansas, United States
Q108512623CollinsSapper in Indian Engineers, British Indian Army
Q110242855CollinsAmerican photographer
Q110281265Collinsvillage in Antigua, Antigua and Barbuda
Q114731293Collinsimprint of HarperCollins Publishers Ltd.
Q115261147Collinsgeographic township in Ontario, Canada
Q119777205Collinspublishing house based in Milan, Italy
Q224615TestWikimedia disambiguation page
Q27205169N-[2-[(2R,5S,6R)-5-[[(3-fluoroanilino)-oxomethyl]amino]-6-(hydroxymethyl)-2-oxanyl]ethyl]-2-pyridin-4-ylacetamidechemical compound
Q27206952N-[[(2R,3R)-8-[2-(1-hydroxycyclopentyl)ethynyl]-5-[(2S)-1-hydroxypropan-2-yl]-3-methyl-6-oxo-3,4-dihydro-2H-pyrido[2,3-b][1,5]oxazocin-2-yl]methyl]-N-methyl-2-(3-pyridinyl)acetamidechemical compound
Q6843240Midwayunincorporated community in Washington County, Oregon, United States
Q6843243Midwayhuman settlement in Washington County, Virginia
Q6843245Midwayunincorporated community in La Crosse County, Wisconsin
Q6843247Midwayunincorporated community in Yazoo County, Mississippi
Q6843254Midwayghost town in Howard County, Arkansas
Q6843255Midwayunincorporated community in White County, Arkansas
Q6843256Midwayunincorporated community in Halifax County, United States
Q6843258Midwayhuman settlement in Halifax County, Virginia
Q6843259Midwayunincorporated community in Henry County, Tennessee
Q6863285minaxolonechemical compound
Q226520KontaktWikimedia disambiguation page
Q27216230N-methyl-3-(5-oxo-10-phenothiazinyl)-1-propanaminechemical compound
Q27225121iron(3+) sulfate hydratechemical compound
Q5521775gapicominechemical compound
Q5618154Gumlutown in Queensland, Australia
Q5660190Midwaycensus-designated place in Chaves County, New Mexico, United States
Q5687672Midwaycensus-designated place and unincorporated community in La Garde Township, Mahnomen County, Minnesota, United States
Q283716The Guardian2003 novel by Nicholas Sparks
Q368941lofepraminechemical compound
Q27213568N-[[(3R,9S,10R)-16-(dimethylamino)-12-[(2R)-1-hydroxypropan-2-yl]-3,10-dimethyl-13-oxo-2,8-dioxa-12-azabicyclo[12.4.0]octadeca-1(14),15,17-trien-9-yl]methyl]-N-methyl-4-pyridinecarboxamidechemical compound

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