Difference between revisions of "Q0.2"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
|title=All [[Concept:Paper|papers]] | |title=All [[Concept:Paper|papers]] | ||
|description=List all papers published via CEUR-WS | |description=List all papers published via CEUR-WS | ||
| − | |sparql=# List of all papers | + | |sparql=# Q0.2 List of all papers |
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | ||
PREFIX wd: <http://www.wikidata.org/entity/> | PREFIX wd: <http://www.wikidata.org/entity/> | ||
| Line 17: | Line 17: | ||
(SAMPLE(?_language_of_work_or_name) as ?language_of_work_or_name) | (SAMPLE(?_language_of_work_or_name) as ?language_of_work_or_name) | ||
(GROUP_CONCAT(?_author) as ?author) | (GROUP_CONCAT(?_author) as ?author) | ||
| + | (GROUP_CONCAT(?_authorName;SEPARATOR=",") as ?author_names) | ||
(SAMPLE(?_pubDate) as ?pubDate) | (SAMPLE(?_pubDate) as ?pubDate) | ||
(SAMPLE(?_dblpPublicationId) as ?dblpPublicationId) | (SAMPLE(?_dblpPublicationId) as ?dblpPublicationId) | ||
| Line 26: | Line 27: | ||
?paper wdt:P1476 ?title. Filter(lang(?title)="en") | ?paper wdt:P1476 ?title. Filter(lang(?title)="en") | ||
OPTIONAL{?paper wdt:P953 ?_url.} | OPTIONAL{?paper wdt:P953 ?_url.} | ||
| + | |||
OPTIONAL{?paper wdt:P5072 ?_event.} | OPTIONAL{?paper wdt:P5072 ?_event.} | ||
| − | OPTIONAL{?paper wdt:P50 ?_author} | + | OPTIONAL{ |
| + | ?paper wdt:P50 ?_author. | ||
| + | ?_author rdfs:label ?_authorName. | ||
| + | FILTER(LANG(?_authorName)="en") | ||
| + | } | ||
| + | |||
OPTIONAL{?proceeding wdt:P407 ?_language_of_work_or_name.} | OPTIONAL{?proceeding wdt:P407 ?_language_of_work_or_name.} | ||
OPTIONAL{?proceeding wdt:P8978 ?_dblpPublicationId.} | OPTIONAL{?proceeding wdt:P8978 ?_dblpPublicationId.} | ||
| Line 33: | Line 40: | ||
} GROUP BY ?paper ?title ?proceeding ?volumeNumber | } GROUP BY ?paper ?title ?proceeding ?volumeNumber | ||
ORDER BY DESC(?pubDate) | ORDER BY DESC(?pubDate) | ||
| − | |tryiturl= | + | |tryiturl=K452U4 |
| − | |wdqsurl= | + | |wdqsurl=6UJb |
|relevance=1 | |relevance=1 | ||
|task=Task0 | |task=Task0 | ||
|storemode=property | |storemode=property | ||
}} | }} | ||
| + | =Freitext= | ||
= Result LIMIT 7 = | = Result LIMIT 7 = | ||
{| class="wikitable" style="text-align: left;" | {| class="wikitable" style="text-align: left;" | ||
Revision as of 15:23, 21 March 2023
Query
| Query | |
|---|---|
 edit
| |
| id | 2 |
| name | AllPapers |
| title | All papers |
| description | List all papers published via CEUR-WS |
| sparql | # Q0.2 List of all papers
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT DISTINCT ?paper ?title ?proceeding ?volumeNumber
(SAMPLE(?_url) as ?url)
(SAMPLE(?_event) as ?event)
(SAMPLE(?_language_of_work_or_name) as ?language_of_work_or_name)
(GROUP_CONCAT(?_author) as ?author)
(GROUP_CONCAT(?_authorName;SEPARATOR=",") as ?author_names)
(SAMPLE(?_pubDate) as ?pubDate)
(SAMPLE(?_dblpPublicationId) as ?dblpPublicationId)
WHERE{
?proceeding wdt:P31 wd:Q1143604.
?proceeding wdt:P179 wd:Q27230297.
?proceeding p:P179/pq:P478 ?volumeNumber.
?paper wdt:P1433 ?proceeding.
?paper wdt:P1476 ?title. Filter(lang(?title)="en")
OPTIONAL{?paper wdt:P953 ?_url.}
OPTIONAL{?paper wdt:P5072 ?_event.}
OPTIONAL{
?paper wdt:P50 ?_author.
?_author rdfs:label ?_authorName.
FILTER(LANG(?_authorName)="en")
}
OPTIONAL{?proceeding wdt:P407 ?_language_of_work_or_name.}
OPTIONAL{?proceeding wdt:P8978 ?_dblpPublicationId.}
OPTIONAL{?proceeding wdt:P577 ?_pubDate.}
} GROUP BY ?paper ?title ?proceeding ?volumeNumber
ORDER BY DESC(?pubDate)
|
| tryiturl | K452U4→K452U4 |
| wdqsurl | 6UJb→6UJb |
| scholia | → |
| relevance | 1 |
| comment | |
| task | Task0→Task0 |