query-e640667bc54a3bb69e24a82e4819bf45

rq turtle/ttl

Propertiesinstance of (P31)occupation (P106)CageMatch worker ID (P2728)

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 schema: <http://schema.org/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT  ?wrestler ?wrestlerLabel ?refLabel (SAMPLE(?link) AS ?link) 
WHERE {
# Wikidata entries with CageMatch worker ID in occupation as reference
# where the CageMatch worker ID was forgotten in the identifiers section
# (this query should return 0 results)

   ?wrestler wdt:P31 wd:Q5 .          # human
   ?wrestler wdt:P106 wd:Q13474373 .  # occupation professional wrestler

   ?article schema:about ?wrestler .  # limit to wrestlers with EN Wikipedia article
   ?article schema:inLanguage "en" .  # to quicken search - for now
   ?article schema:isPartOf <https://en.wikipedia.org/> .

   ?wrestler p:P106 ?cgid_query . # build statement with p:
   ?cgid_query ps:P106 ?occ .     # retrieve obj within statement with ps:
   ?cgid_query prov:wasDerivedFrom ?refnode . # build ref node 
   ?refnode pr:P2728 ?ref .       # ref node should be Cagematch worker ID

# only look for entries without the CageMatch ID in the identifiers section
# bind to format as clickable URL 
  MINUS {
   ?wrestler wdt:P2728 ?cgid .
   BIND(IRI(REPLACE(?cgid, '^(.+)$', ?url)) AS ?link).
      }
   SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
      }
   }
GROUP BY ?wrestler ?wrestlerLabel ?refLabel
ORDER BY ?wrestlerLabel

Query found at

• https://www.wikidata.org/wiki/User:HereinTheHague