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
Q19913384Applespainting in the style of Gustave Courbet
Q20168332Applespainting by Paul Cézanne
Q20198175Applespainting by Chaim Soutine
Q20262847Applespainting by Henri Matisse
Q20475991Applespainting by Margaret Olley
Q20487088Applespainting by Constance Roth
Q20776291Applespainting by Thomas Worthington Whittredge
Q23947968Applespainting by Gustave Courbet (NMWA P.1959-0059)
Q27700927Applespainting by Juan de Espinosa
Q28532540Applespainting by Sir Matthew Smith
Q50732139Applespainting by Hilda Rix Nicholas
Q51438799AlabamaSavannah?1919? | Library of Congress
Q294011Great BritainWikimedia disambiguation page
Q5099551Chinaepisode of The Office (S7 E10)
Q5205719DNAepisode of Red Dwarf
Q1026788Californiatitular see of the Catholic Church
Q1030498President BushWikipedia disambiguation page
Q1213623Islandnovel by Richard Laymon
Q1710184LifeBBC TV series
Q2052807ChinaSuperleague Formula team
Q2151952Mexicosection in German Phantasialand
Q2278475Eurekaside-wheel paddle steamboat, built in 1890
Q2585219Piancient Chinese state
Q6826183Mexicoship
Q6826184Mexico1966 Canadian documentary television miniseries
Q6826185Mexico1930 short animated film
Q6826188Mexiconovel by James A. Michener
Q6956290NLos Angeles Railway route
Q7120269PRCcontainer format for code databases in Palm OS, Garnet OS and Access Linux Platform
Q7137385Paris of the WestWikipedia disambiguation page
Q404304Island1973 film by Fyodor Khitruk
Q586680George Washington1984 television miniseries
Q592915Chocolate2005 Bollywood crime thriller film
Q685885Iceland1942 film by H. Bruce Humberstone
Q769466knightpiece in standard shogi
Q778708San FranciscoDecorative typeface
Q877012Piart project
Q2635930GermanSouth Slavic mythological being
Q2990861Germanvillage in central western Bulgaria
Q3650734California1927 film by W. S. Van Dyke
Q3708826Germantown in Chenango County, New York, United States
Q3740828Icelandisland
Q3833166LionVenetian family
Q3869752NPokémon character
Q3947118San Franciscodistrict of Costa Rica
Q4137241Germanbishop of the Russian Orthodox Church
Q4417242Heart of Dixie1989 film by Martin Davidson
Q5020176Californianeighborhood of Louisville, Kentucky, United States
Q5020182CaliforniaCalifornia barangay in Ubay, Bohol
Q5020192Californiaformer rapid transit station in Chicago, United States
Q5020194CaliforniaDutch clipper ship launched in 1853
Q5050997Catsymbol of the Vietnamese zodiac
Q5050998Catfictional character in Red Dwarf
Q5053985Cats1925 film by Leslie S. Hiscott
Q6555385Lionfamily name
Q6555388Lion16th century class of warships from Scotland
Q16246324Esperantostudent magazine
Q16248918Lionsspecial police unit in Macedonia
Q16254770IrishJunior Cycle examination subject
Q16277127Irishfamily name
Q16415028Cat1933 film
Q16580097Island2011 film
Q16846846Icelanderbook by Dustin Long
Q16865313CalifornianWikimedia disambiguation page
Q7208888PolandEuropean Parliament constituency
Q7208889Polandnovel by James A. Michener
Q7208890Polandart work
Q7208891Polandfamily name
Q7413896San Franciscoabandoned townsite in Carver County, Minnesota, United States
Q7413900San Franciscobarangay in the province of Laguna, Philippines
Q7413901San FranciscoSan Francisco barangay in Ubay, Bohol
Q7413904San Franciscoquarter in San Juan, Puerto Rico
Q7413906San Francisco1968 film by Anthony Stern
Q19827478Island1967 film
Q19840132Genevaplay
Q19857386George Washingtonpainting by Gilbert Stuart (Frick Collection)
Q19880783Life1999 short film by Mo Willems
Q19884475Lionpainting by Morris Hirshfield
Q19922821George WashingtonWikimedia disambiguation page
Q19924503George Washingtonpainting by Charles Willson Peale
Q19924612George Washingtonpainting by Adolph Ulrich Wertmuller
Q19924633George Washingtonpainting by Anna Claypoole Peale
Q19924713George Washingtonpainting by Charles Peale Polk
Q5205726DNAmagazine
Q5378653LionEnglish full-rigged ship, built 1557
Q5398858EsperantoFishing schooner
Q5411128EurekaAmerican automobile manufactured only in 1900
Q5411133EurekaAmerican automobile made from 1907 to 1909
Q5411134Eurekacentral character in the Eureka Seven series
Q5411137Eurekauser interface for general users of the Research Library Information Network (RLIN)
Q5411138Eurekawhite kitten found by Dorothy Gale's Uncle Henry in "The Wizard in Oz"
Q5411141Eurekamonthly British science magazine
Q5411144EurekaBritish educational television series about science and inventiveness
Q5411146Eurekajournal published annually by The Archimedeans, the Mathematical Society of Cambridge University
Q5411192Eurekapreserved American 4-4-0 locomotive
Q5532965GenevaLocated in Alexandria, Louisiana
Q5545913George Washingtonchildren's book by Genevieve Foster
Q5545917George Washingtonnamed passenger train of the Chesapeake and Ohio Railway
Q5545919George Washingtonthoroughbred racehorse
Q5740169Californiaunincorporated village in Aroostook County, Maine

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