query-996fa3a22042fd9cb4d1be4ccbaf6010

rq turtle/ttl

Duplicated vakyes

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select distinct ?item ?itemLabel ?twitter1 ?twitter2  where
{
  ?item wdt:P2002 ?twitter1 . ?item wdt:P2002 ?twitter2 . 
  filter(?twitter1 > ?twitter2) . 
  # item has two values for twitter account
  filter((lcase(?twitter1)) = (lcase(?twitter2)) ) .
  # but they are the same case-insensitive text

  # nb please do *not* fix automatically by removing entries without checking them first
  # as one value may have key qualifiers (follower count, verification, sources, etc)!

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?item"):::projected v1("?twitter1"):::projected v2("?twitter2"):::projected c3(["bd:serviceParam"]):::iri c5(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["lower-case(?twitter1) = lower-case(?twitter2)"]] f0 --> v1 f0 --> v2 f1[["?twitter1 > ?twitter2"]] f1 --> v1 f1 --> v2 v3 --"wdt:P2002"--> v1 v3 --"wdt:P2002"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c3 --"wikibase:language"--> c5 end