#Tag
Log in
Lucas Werkmeister
Lucas Werkmeister
@LucasWerkmeister@wikis.world  ·  activity timestamp 3 days ago
Alexander Winkler
Alexander Winkler
@awinkler@openbiblio.social  ·  activity timestamp 3 months ago
SPARQL Code Snippet from Wikidata Query Service SELECT ?prefix ?qsStatementID WHERE { ?item p:PXXX ?s . # add more constraints here to get statements you want to remove BIND ( ("-STATEMENT") AS ?prefix ) BIND ( REPLACE(STR(?s), "http://www.wikidata.org/entity/statement/", "") AS ?statementID ) BIND ( REPLACE(STR(?item), "http://www.wikidata.org/entity/", "") AS ?qid) BIND ( REPLACE(?statementID, CONCAT(?qid, "-"), "") AS ?strippedStatementID ) BIND ( CONCAT(?qid, "$", ?strippedStatementID ) AS ?qsStatementID ) }
SPARQL Code Snippet from Wikidata Query Service SELECT ?prefix ?qsStatementID WHERE { ?item p:PXXX ?s . # add more constraints here to get statements you want to remove BIND ( ("-STATEMENT") AS ?prefix ) BIND ( REPLACE(STR(?s), "http://www.wikidata.org/entity/statement/", "") AS ?statementID ) BIND ( REPLACE(STR(?item), "http://www.wikidata.org/entity/", "") AS ?qid) BIND ( REPLACE(?statementID, CONCAT(?qid, "-"), "") AS ?strippedStatementID ) BIND ( CONCAT(?qid, "$", ?strippedStatementID ) AS ?qsStatementID ) }
SPARQL Code Snippet from Wikidata Query Service SELECT ?prefix ?qsStatementID WHERE { ?item p:PXXX ?s . # add more constraints here to get statements you want to remove BIND ( ("-STATEMENT") AS ?prefix ) BIND ( REPLACE(STR(?s), "http://www.wikidata.org/entity/statement/", "") AS ?statementID ) BIND ( REPLACE(STR(?item), "http://www.wikidata.org/entity/", "") AS ?qid) BIND ( REPLACE(?statementID, CONCAT(?qid, "-"), "") AS ?strippedStatementID ) BIND ( CONCAT(?qid, "$", ?strippedStatementID ) AS ?qsStatementID ) }
Alexander Winkler
Alexander Winkler
@awinkler@openbiblio.social  ·  activity timestamp 3 months ago
SPARQL Code Snippet from Wikidata Query Service SELECT ?prefix ?qsStatementID WHERE { ?item p:PXXX ?s . # add more constraints here to get statements you want to remove BIND ( ("-STATEMENT") AS ?prefix ) BIND ( REPLACE(STR(?s), "http://www.wikidata.org/entity/statement/", "") AS ?statementID ) BIND ( REPLACE(STR(?item), "http://www.wikidata.org/entity/", "") AS ?qid) BIND ( REPLACE(?statementID, CONCAT(?qid, "-"), "") AS ?strippedStatementID ) BIND ( CONCAT(?qid, "$", ?strippedStatementID ) AS ?qsStatementID ) }
SPARQL Code Snippet from Wikidata Query Service SELECT ?prefix ?qsStatementID WHERE { ?item p:PXXX ?s . # add more constraints here to get statements you want to remove BIND ( ("-STATEMENT") AS ?prefix ) BIND ( REPLACE(STR(?s), "http://www.wikidata.org/entity/statement/", "") AS ?statementID ) BIND ( REPLACE(STR(?item), "http://www.wikidata.org/entity/", "") AS ?qid) BIND ( REPLACE(?statementID, CONCAT(?qid, "-"), "") AS ?strippedStatementID ) BIND ( CONCAT(?qid, "$", ?strippedStatementID ) AS ?qsStatementID ) }
SPARQL Code Snippet from Wikidata Query Service SELECT ?prefix ?qsStatementID WHERE { ?item p:PXXX ?s . # add more constraints here to get statements you want to remove BIND ( ("-STATEMENT") AS ?prefix ) BIND ( REPLACE(STR(?s), "http://www.wikidata.org/entity/statement/", "") AS ?statementID ) BIND ( REPLACE(STR(?item), "http://www.wikidata.org/entity/", "") AS ?qid) BIND ( REPLACE(?statementID, CONCAT(?qid, "-"), "") AS ?strippedStatementID ) BIND ( CONCAT(?qid, "$", ?strippedStatementID ) AS ?qsStatementID ) }