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
Q403522BelarusianWikimedia disambiguation page
Q23947968Applespainting by Gustave Courbet (NMWA P.1959-0059)
Q27700927Applespainting by Juan de Espinosa
Q28532540Applespainting by Sir Matthew Smith
Q29726439byprotein-coding gene in the species Drosophila melanogaster
Q1025752CahabaWikipedia disambiguation page
Q1026788Californiatitular see of the Catholic Church
Q3920722BelarusBelarusian daily newspaper
Q4783389Berlinsculpture on the Tauentzienstraße in western Berlin
Q4881914Belarusmanufacturer of upright pianos
Q4892379Berlinmusical written by Erik Orton
Q17324893Applespainting by Gustave Courbet
Q18159636Applesnovel by Richard Milward
Q19836013Applespainting by Vincent van Gogh, 1887
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
Q592915Chocolate2005 Bollywood crime thriller film
Q685885Iceland1942 film by H. Bruce Humberstone
Q764663Pidecentralized municipal entity
Q769466knightpiece in standard shogi
Q778708San FranciscoTypeface
Q877012Piart project
Q294011Great BritainWikimedia disambiguation page
Q404304Island1973 film by Fyodor Khitruk
Q586680George Washington1984 television miniseries
Q6555388Lion16th century class of warships from Scotland
Q6826183Mexicoship
Q6826184Mexico1966 Canadian documentary television miniseries
Q6826185Mexico1930 short animated film
Q6826186Mexicodice game
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
Q7208888PolandEuropean Parliament constituency
Q7208889Polandnovel by James A. Michener
Q7208890Polandart work
Q1030498President BushWikipedia disambiguation page
Q1073195Chinasteamboat
Q1213623Islandnovel by Richard Laymon
Q1374359EurekaFrench automobile manufactured from 1906 until 1909
Q1465047Friscoghost town
Q1519207appleheraldic figure
Q1710184LifeBBC TV series
Q2052807ChinaSuperleague Formula team
Q2278475Eurekaside-wheel paddle steamboat, built in 1890
Q2585219Piancient Chinese state
Q2635930GermanSouth Slavic mythological being
Q5301194Douglas AdamsWikipedia disambiguation page
Q5378653LionEnglish full-rigged ship, built 1557
Q5398858EsperantoFishing schooner
Q7208891Polandsurname
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
Q7413910San FranciscoMagazine
Q10489150Esperantorestaurant in Stockholm, Sweden
Q10953985PrinterWikimedia disambiguation page
Q2990861Germanvillage in central western Bulgaria
Q3650734California1927 film by W. S. Van Dyke
Q3708826Germantown in Chenango County, New York, United States
Q3733095Esperantocargo ship
Q3752500San Franciscoimportant neighbourhood of Bilbao, in the Basque Country, Spain
Q3833166LionVenetian family
Q3869752NPokémon character N
Q3947118San Franciscodistrict of Costa Rica
Q4137241Germanbishop of the Russian Orthodox Church
Q4417242Heart of Dixie1989 film by Martin Davidson
Q4705174Alabamastate song of Alabama
Q4705175AlabamaGloucester fishing schooner built in 1926
Q4705176Alabamacomputer virus
Q4781117AppleAmerican automobile (1915-1917)
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
Q5099551ChinaThe Office episode
Q5205719DNAepisode of Red Dwarf
Q5205726DNAmagazine
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
Q5545913George Washingtonchildren's book by Genevieve Foster
Q5545917George Washingtonnamed passenger train of the Chesapeake and Ohio Railway
Q5545919George Washingtonthoroughbred racehorse

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