Difference between revisions of "Q0.6"

From BITPlan cr Wiki
Jump to navigation Jump to search
(Created page with "=Query= {{Query |id=4 |title=All scholars |description=List all scholars that have at least once (co-)authored a paper that has been published through CEUR-WS. |sparql=# Q0.5...")
 
Line 5: Line 5:
 
|title=All scholars
 
|title=All scholars
 
|description=List all scholars that have at least once (co-)authored a paper that has been published through CEUR-WS.
 
|description=List all scholars that have at least once (co-)authored a paper that has been published through CEUR-WS.
|sparql=# Q0.5 List all scholars
+
|sparql=# Q0.6 List all institutions
 
SELECT DISTINCT ?institution ?institutionLabel
 
SELECT DISTINCT ?institution ?institutionLabel
 
   (SAMPLE(?_logoImage) as ?logoImage)  
 
   (SAMPLE(?_logoImage) as ?logoImage)  
Line 16: Line 16:
 
   ?proceeding wdt:P31 wd:Q1143604.
 
   ?proceeding wdt:P31 wd:Q1143604.
 
   ?proceeding wdt:P179 wd:Q27230297.
 
   ?proceeding wdt:P179 wd:Q27230297.
   ?proceeding p:P179/pq:P478 ?volumeNumber.
+
   {
   ?paper wdt:P1433 ?proceeding.
+
    # authors
  ?paper p:P50/pq:P1416 ?institution.
+
    ?paper wdt:P1433 ?proceeding.
 +
    ?paper p:P50/pq:P1416 ?institution.
 +
   }UNION{
 +
    # editors
 +
    ?proceeding p:P98/pq:P1416 ?institution.
 +
  }
 
    
 
    
 
   OPTIONAL{?institution rdfs:label ?institutionLabel. Filter(lang(?institutionLabel)="en")}  
 
   OPTIONAL{?institution rdfs:label ?institutionLabel. Filter(lang(?institutionLabel)="en")}  
Line 29: Line 34:
 
}
 
}
 
GROUP BY ?institution ?institutionLabel
 
GROUP BY ?institution ?institutionLabel
|wdqsurl=6UF2
+
|wdqsurl=6UFN
 
|relevance=1
 
|relevance=1
 
|task=Task0
 
|task=Task0
 
|storemode=property
 
|storemode=property
 
}}
 
}}
 +
=Freitext=

Revision as of 13:21, 21 March 2023

Query

Query
edit
id  4
name  
title  All scholars
description  List all scholars that have at least once (co-)authored a paper that has been published through CEUR-WS.
sparql  
# Q0.6 List all institutions
SELECT DISTINCT ?institution ?institutionLabel
  (SAMPLE(?_logoImage) as ?logoImage) 
  (SAMPLE(?_shortName) as ?shortName) 
  (SAMPLE(?_country) as ?country) 
  (SAMPLE(?_coordinateLocation) as ?coordinateLocation) 
  (SAMPLE(?_officialWebsite) as ?officialWebsite)
  (SAMPLE(?_gndId) as ?gndId)  
WHERE{
  ?proceeding wdt:P31 wd:Q1143604.
  ?proceeding wdt:P179 wd:Q27230297.
  {
    # authors
    ?paper wdt:P1433 ?proceeding.
    ?paper p:P50/pq:P1416 ?institution.
  }UNION{
    # editors
    ?proceeding p:P98/pq:P1416 ?institution.
  }
  
  OPTIONAL{?institution rdfs:label ?institutionLabel. Filter(lang(?institutionLabel)="en")} 
  OPTIONAL{?institution wdt:P154 ?_logoImage.} 
  OPTIONAL{?institution wdt:P1816 ?_shortName.} 
  OPTIONAL{?institution wdt:P17 ?_country.} 
  OPTIONAL{?institution wdt:P625 ?_coordinateLocation.} 
  OPTIONAL{?institution wdt:P856 ?_officialWebsite.}  
  OPTIONAL{?institution wdt:P227 ?_gndId.} 
}
GROUP BY ?institution ?institutionLabel
tryiturl  →z7hnKG
wdqsurl  6UFN→6UKK
scholia  →
relevance  1
comment  
task  Task0→Task0

Freitext