Topic on User talk:Deryck Chan

This is a thread to generate internal shortlinks so I can share SPARQL queries without pasting the entire SPARQL code onto a discussion page.

SELECT DISTINCT ?asObject ?asObjectLabel
WHERE
{
  ?prop pq:P794 ?asObject .
  hint:Query hint:optimizer "None" .	
  ?item ?p ?prop . 
  ?property wikibase:claim ?p .  
  ?property wikibase:statementProperty ?ps .
  ?prop ?ps ?value .      
  wd:P108 wikibase:claim ?p .   
  ?asObject wdt:P31/wdt:P279* wd:Q12737077 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en"  }    
}
LIMIT 1000

link