Q0.8: Difference between revisions
Jump to navigation
Jump to search
(Created page with "=Query= {{Query |id=8 |name=Duplicate URNs |title=Duplicate URNs of proceedings |description=List all proceedings with duplicate URN ids |sparql=# Que...") |
No edit summary |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
{{Query | {{Query | ||
|id=8 | |id=8 | ||
|name= | |name=DuplicateAndEmptyURNs | ||
|title=Duplicate URNs of [[Concept:Proceedings|proceedings]] | |title=Duplicate and Empty URNs of [[Concept:Proceedings|proceedings]] | ||
|description=List all proceedings with duplicate URN ids | |description=List all proceedings with duplicate URN ids | ||
|sparql=# Query 8 of Task 0 | |sparql=# Query 8 of Task 0 | ||
| Line 16: | Line 16: | ||
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | ||
SELECT ?urn (GROUP_CONCAT(DISTINCT ?proceeding; separator=", ") AS ? | SELECT | ||
?urn | |||
(COUNT(?proceeding) AS ?count) | |||
(GROUP_CONCAT(DISTINCT CONCAT("https://ceur-ws.org/Vol-", ?sVolume, " - ", STR(?proceeding)); separator=", ") AS ?volWithProceedings) | |||
WHERE { | WHERE { | ||
# Instance of Proceedings | # Instance of Proceedings | ||
| Line 25: | Line 28: | ||
# Part of the series | # Part of the series | ||
?proceeding p:P179 ?partOfTheSeries. | ?proceeding p:P179 ?partOfTheSeries. | ||
# Volumes via a a qualifier of the part of the series relation | |||
OPTIONAL { ?partOfTheSeries pq:P478 ?sVolume. } | |||
# CEUR Workshop proceedings | # CEUR Workshop proceedings | ||
?partOfTheSeries ps:P179 wd:Q27230297. | ?partOfTheSeries ps:P179 wd:Q27230297. | ||
# URN-NBN | # URN-NBN | ||
OPTIONAL { ?proceeding wdt:P4109 ?urn. } | OPTIONAL { ?proceeding wdt:P4109 ?urn. } | ||
FILTER(BOUND(?urn)) # Ensure URN is available | #FILTER(BOUND(?urn)) # Ensure URN is available | ||
} | } | ||
GROUP BY ?urn | GROUP BY ?urn | ||
HAVING (COUNT(?proceeding) > 1) # Only select URNs that appear more than once | HAVING (COUNT(?proceeding) > 1) # Only select URNs that appear more than once | ||
ORDER BY DESC(?count) | ORDER BY DESC(?count) | ||
|tryiturl= | |tryiturl=OLyKEm | ||
|wdqsurl= | |wdqsurl=8eaz | ||
|relevance=1 | |relevance=1 | ||
|task=Task0 | |task=Task0 | ||
|storemode=property | |storemode=property | ||
}} | }} | ||
=Freitext= | |||
Latest revision as of 11:51, 28 December 2023
Query
| Query | |
|---|---|
 edit
| |
| id | 8 |
| name | DuplicateAndEmptyURNs |
| title | Duplicate and Empty URNs of proceedings |
| description | List all proceedings with duplicate URN ids |
| sparql | # Query 8 of Task 0
# see https://cr.bitplan.com/index.php?title=Q0.8
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX schema: <http://schema.org/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT
?urn
(COUNT(?proceeding) AS ?count)
(GROUP_CONCAT(DISTINCT CONCAT("https://ceur-ws.org/Vol-", ?sVolume, " - ", STR(?proceeding)); separator=", ") AS ?volWithProceedings)
WHERE {
# Instance of Proceedings
?proceeding wdt:P31 wd:Q1143604.
# with english label
?proceeding rdfs:label ?proceedingLabel.
FILTER(LANG(?proceedingLabel) = "en")
# Part of the series
?proceeding p:P179 ?partOfTheSeries.
# Volumes via a a qualifier of the part of the series relation
OPTIONAL { ?partOfTheSeries pq:P478 ?sVolume. }
# CEUR Workshop proceedings
?partOfTheSeries ps:P179 wd:Q27230297.
# URN-NBN
OPTIONAL { ?proceeding wdt:P4109 ?urn. }
#FILTER(BOUND(?urn)) # Ensure URN is available
}
GROUP BY ?urn
HAVING (COUNT(?proceeding) > 1) # Only select URNs that appear more than once
ORDER BY DESC(?count)
|
| tryiturl | OLyKEm→OLyKEm |
| wdqsurl | 8eaz→8eaz |
| scholia | → |
| relevance | 1 |
| comment | |
| task | Task0→Task0 |