query-57dbf09026ae4ee3c5982390052ac307
Find items that have mismatched Threads username and Instagram username, respecting qualifiers) [3](Original post and rationale: A naive solution is already available: equal-value constraint?This request is forwarded from a Discord groupchat: (Justification and tutorial on how a threads account is bound to the instagram account are omitted).(P2003)Instagram username such that its value is identical to (P11892)Threads username I want to put a constraint on I dived into the list of available constraints and concluded that such constraint does not exist yet. I have managed to come up with the following SPARQL query:
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT ?item WHERE {
?item wdt:P2003 ?ig;
wdt:P11892 ?threads.
FILTER(?ig != ?threads).
}
Query found at
- https://www.wikidata.org/wiki/Wikidata:Project_chat/Archive/2024/03
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2024/03
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?ig")
v3("?item"):::projected
v2("?threads")
f0[["?ig != ?threads"]]
f0 --> v1
f0 --> v2
v3 --"wdt:P2003"--> v1
v3 --"wdt:P11892"--> v2