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
Q3920722BelarusBelarusian daily newspaper
Q4705174Alabamastate song of Alabama
Q4705175AlabamaGloucester fishing schooner built in 1926
Q4705176Alabamacomputer virus
Q4781117AppleAmerican automobile (1915-1917)
Q4783389Berlinsculpture on the Tauentzienstraße in western Berlin
Q4881914Belarusmanufacturer of upright pianos
Q4892379Berlinmusical written by Erik Orton
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
Q20313255Berlinepisode of The Blacklist
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
Q41498343ALSouth Korean girl group
Q50732139Applespainting by Hilda Rix nicholas
Q51438799AlabamaSavannah?1919? | Library of Congress
Q2052807ChinaSuperleague Formula team
Q2278475Eurekaside-wheel paddle steamboat, built in 1890
Q2585219Piancient Chinese state
Q294011Great BritainWikimedia disambiguation page
Q404304Island1973 film by Fyodor Khitruk
Q586680George Washington1984 television miniseries
Q1025752CahabaWikipedia disambiguation page
Q1026788Californiatitular see of the Catholic Church
Q1030498President BushWikipedia disambiguation page
Q1073195Chinasteamboat
Q1213623Islandnovel by Richard Laymon
Q1374359EurekaFrench automobile manufactured from 1906 until 1909
Q1465047Friscoghost town
Q1710184LifeBBC TV series
Q592915Chocolate2005 Bollywood crime thriller film
Q685885Iceland1942 film by H. Bruce Humberstone
Q764663Pidecentralized municipal entity
Q769466knightpiece in standard shogi
Q778708San FranciscoDecorative typeface
Q877012Piart project
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
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
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
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
Q5763870Polandvillage in Kiribati
Q5807368Germanvillage in Iran
Q5985649Icelandformer settlement in California, USA
Q6082951Island1989 Australian film
Q6082965Islandbook of short stories by Alistair MacLeod
Q6082968Islandnovel by Jane Rogers
Q6544651Life1928 British film
Q6544652Life1996 Australian film
Q6544682Lifebreakfast cereal
Q6544688LifeBiology textbook
Q6555378Lionearly 20th-century automobile
Q6555382LionBritish weekly comic
Q6555383Lion2006 Malayalam film
Q6555385Lionfamily name
Q5099551Chinaepisode of The Office (S7 E10)
Q5205719DNAepisode of Red Dwarf
Q5205726DNAmagazine
Q5301194Douglas AdamsWikipedia disambiguation page
Q5378653LionEnglish full-rigged ship, built 1557
Q27700782Catisland in Myanmar
Q27863966Irishgiven name

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