Bureaucrats, emailconfirmed, Administrators
58,048
edits
Project:SPARQL examples: Difference between revisions
→SPARQL Queries
(Created page with "= SPARQL Queries = == Get direct download links (P48) and corresponding bibItems == <sparql tryit="1"> PREFIX iwb: <https://wikibase.inguma.eus/entity/> PREFIX idp: <https://wikibase.inguma.eus/prop/direct/> PREFIX ip: <https://wikibase.inguma.eus/prop/> PREFIX ips: <https://wikibase.inguma.eus/prop/statement/> PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/> select distinct ?download (group_concat(str(?wikibase_item);SEPARATOR="|") as ?items) where { ?wiki...") |
|||
| Line 14: | Line 14: | ||
?wikibase_item idp:P48 ?download . | ?wikibase_item idp:P48 ?download . | ||
} group by ?download ?items | } group by ?download ?items | ||
</sparql> | |||
== Filter certain BibItems == | |||
Example: items of publisher "Uztaro" with INGUMA domain indicator "Politics" | |||
<sparql tryit="1"> | |||
PREFIX iwb: <https://wikibase.inguma.eus/entity/> | |||
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/> | |||
PREFIX ip: <https://wikibase.inguma.eus/prop/> | |||
PREFIX ips: <https://wikibase.inguma.eus/prop/statement/> | |||
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/> | |||
select ?wikibase_item (strafter(str(?wikibase_item),"https://wikibase.inguma.eus/entity/") as ?q_id) | |||
where { | |||
?wikibase_item idp:P5 iwb:Q8; # instance of: BibItem | |||
idp:P37 iwb:Q13091; # argitaratzailea: Uztaro | |||
idp:P59 iwb:Q13284. # INGUMA jakintza arloa: Politika | |||
} | |||
</sparql> | </sparql> | ||