query-f8e90cb4f37edb08d1c1fcf730f407d7

rq turtle/ttl

Church image duplicates (culled from Magnus Manske, Jheald) SELECT ?church ?churchLabel ?img WITH { SELECT ?church ?img WHERE { ?church wdt:P31 wd:Q16970 . ?church wdt:P18 ?img } } AS %church_images WHERE { {
SELECT ?img (count(?church) AS ?cnt) { INCLUDE %church_images } GROUP BY ?img HAVING (?cnt>1) } INCLUDE %church_images . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY desc(?cnt) ?img ?churchLabel

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Church image duplicates (culled from Magnus Manske, Jheald)
SELECT ?church ?churchLabel ?img
WHERE {
  {     
     SELECT ?img (count(?church) AS ?cnt)  {
        {
  SELECT ?church ?img WHERE {
    ?church wdt:P31 wd:Q16970 . 
    ?church wdt:P18 ?img 
  }
}     } GROUP BY ?img 
     HAVING (?cnt>1)
  }
   {
  SELECT ?church ?img WHERE {
    ?church wdt:P31 wd:Q16970 . 
    ?church wdt:P18 ?img 
  }
}.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY desc(?cnt) ?img ?churchLabel

Query found at

• https://www.wikidata.org/wiki/User:Charles_Matthews/Queries