Dreams:report: Difference between revisions

(→‎Related works from co-citations: Change table column name)
Line 158: Line 158:
SELECT  
SELECT  
   (COUNT(?work) AS ?score)
   (COUNT(?work) AS ?score)
   (SAMPLE(?title_) AS ?title_)
 
   (SAMPLE(?title_) AS ?title)
  (SAMPLE(?titleUrl_) AS ?titleUrl)


   ("Scholia ↗" AS ?scholia)  
   ("Scholia ↗" AS ?scholia)  
Line 171: Line 173:
     ?work wdt:P1476 ?title_ .
     ?work wdt:P1476 ?title_ .
     BIND(CONCAT("https://scholia.toolforge.org/work/", SUBSTR(STR(?work), 32)) AS ?scholiaUrl_)
     BIND(CONCAT("https://scholia.toolforge.org/work/", SUBSTR(STR(?work), 32)) AS ?scholiaUrl_)
  }
  OPTIONAL {
    BIND(SUBSTR(STR(?work), 32) AS ?work_q)
    ?dreams_work dreamst:P3 ?work_q .
    BIND(CONCAT("#report/", SUBSTR(STR(?dreams_work), 38)) AS ?titleUrl_)
   }
   }
}
}