Get list of all wikidata properties used to link to an item

Question

The first part of my question is, is there a SPARQL equivalent of the "What links here" link? E.g. as described at https://opendata.stackexchange.com/a/5271/20321

I tried:

WHERE {  ?item wdt:?property wd:Q1174 . }

which gave a syntax error, and:

WHERE {  ?item wdt:* wd:Q1174 . }

which doesn't give an error, but only returns one row: the item in the query!

The second part of my question is how can I get a list of all unique properties that are used to link to the item of interest? This is the bit I'm interested in, as I suspect there will typically just be 1 or 2 properties used for 99% of the links, and that any others are probably mistakes, that are good candidates for fixing to improve data quality.

Answer 1

The first part of my question is, is there a SPARQL equivalent of the "What links here" link?

The second part of my question is how can I get a list of all unique properties that are used to link?

Assuming you are interested in truthy statements only:

select distinct ?subject ?subjectLabel {
  values (?item) {(wd:Q42)}
  ?subject ?predicate ?item .
  ?property wikibase:directClaim ?predicate
  service wikibase:label { bd:serviceParam wikibase:language "en" }
}

(try it)

and

select distinct ?property ?propertyLabel {
  values (?item) {(wd:Q42)}
  ?subject ?predicate ?item .
  ?property wikibase:directClaim ?predicate
  service wikibase:label { bd:serviceParam wikibase:language "en" }
}

(try it)

respectively.

Update

If you want to use the label service with items that have large number of incoming links, you should place it outside of the inner query.

select ?property ?propertyLabel ?count {
  {
  select ?property (count(*) as ?count) {
    values (?item) {(wd:Q30)}
    ?subject ?predicate ?item .
    ?property wikibase:directClaim ?predicate
  } group by ?property  having (?count > 0) 
  }
  service  wikibase:label { bd:serviceParam wikibase:language "en" }
} order by desc(?count) 

Try it!