User:Arjunaraoc/villagewithoutwd

#villages with tewiki or enwiki articles but without wikidata in OSM in a specific district
# when updating district, be sure to update the same value in subquery (Minus) section
#defaultView:Map
SELECT DISTINCT ?2011censuscode ?wd_label_village ?wd_label_village_te  ?wd_qid_village ?wd_loc_village ?wd_label_mandal ?wd_qid_mandal WHERE {
  hint:Query hint:optimizer "None".
  wd:Q110876712 wdt:P150 ?mandal.  
  ?village wdt:P131 ?mandal; 
    (wdt:P31/(wdt:P279*)) wd:Q56436498;
    wdt:P625 ?wd_loc_village.
 
  MINUS {
  wd:Q110876712 wdt:P150 ?mandal.  
  ?village wdt:P131 ?mandal; 
      (wdt:P31/(wdt:P279*)) wd:Q56436498;
      wdt:P625 [].
    SERVICE <https://sophox.org/sparql> {
      ?osmid <https://wiki.openstreetmap.org/wiki/Key:wikidata> ?village;
        <https://www.openstreetmap.org/meta/loc> ?osmloc.
    }
  }
  ?village    wdt:P131 ?wd_mandal.
  OPTIONAL {
  ?village  wdt:P5578 ?2011censuscode.
  }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en".
    ?village rdfs:label ?wd_label_village.
    ?wd_mandal rdfs:label ?wd_label_mandal.
  }
  OPTIONAL {
    ?village rdfs:label ?wd_label_village_te FILTER(LANG(?wd_label_village_te)="te").
  }  
  OPTIONAL {
    ?article schema:about ?village;
      schema:isPartOf <https://te.wikipedia.org/>;
      schema:name ?page_titleTE.
  }
  OPTIONAL {
    ?article schema:about ?village;
      schema:isPartOf <https://en.wikipedia.org/>;
      schema:name ?page_titleEN.
  }
  FILTER((BOUND(?page_titleEN))|| (BOUND(?page_titleTE)))
  BIND(REPLACE(STR(?village), "^.*/([^/]*)$", "$1") AS ?wd_qid_village)
  BIND(REPLACE(STR(?wd_mandal), "^.*/([^/]*)$", "$1") AS ?wd_qid_mandal)   
}
ORDER BY ?2011censuscode ?wd_label_mandal ?wd_label_village
Try it!