80,530
edits
Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
no edit summary
Tdkiv-admin (talk | contribs) |
Tdkiv-admin (talk | contribs) No edit summary |
||
| Line 21: | Line 21: | ||
ORDER BY ASC(?itemLabel) | ORDER BY ASC(?itemLabel) | ||
</sparql> | |||
===Počty citací zdrojů použitých při vytváření terminologické databáze=== | |||
<sparql tryit="1"> | |||
#defaultView:BubbleChart | |||
PREFIX zp: <https://tdkiv.wikibase.cloud/prop/> | |||
PREFIX zps: <https://tdkiv.wikibase.cloud/prop/statement/> | |||
PREFIX zpr: <https://tdkiv.wikibase.cloud/prop/reference/> | |||
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |||
PREFIX owl: <http://www.w3.org/2002/07/owl#> | |||
PREFIX prov: <http://www.w3.org/ns/prov#> | |||
SELECT ?zdroj ?stitek (COUNT(?zdroj) AS ?pocet_citaci) WHERE { | |||
?item zp:P1 ?vykladstatement. | |||
?vykladstatement zps:P1 ?vyklad; | |||
prov:wasDerivedFrom ?ref. | |||
?ref zpr:P22 ?zdroj. | |||
OPTIONAL { | |||
?zdroj rdfs:label ?zdrojLabel. | |||
FILTER((LANG(?zdrojLabel)) = "cs") | |||
} | |||
OPTIONAL { | |||
?zdroj owl:sameAs ?presmerovany_zdroj. | |||
?presmerovany_zdroj rdfs:label ?presmerovany_label. | |||
} | |||
BIND(IF(BOUND(?presmerovany_label), ?presmerovany_label, ?zdrojLabel) AS ?stitek) | |||
} | |||
GROUP BY ?zdroj ?zdrojLabel ?presmerovany_zdroj ?presmerovany_label ?stitek | |||
ORDER BY DESC (?pocet_citaci) | |||
</sparql> | </sparql> | ||