User:Daniel/Queries/LinkedWikiTest: Difference between revisions
From MaRDI portal
< User:Daniel | Queries
from https://linkedwiki.com/query/wikidata_Erdos_Numbers_and_images_of_people_who_have_oral_histories_in_the_Computer_History_Museum_s_collection |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 161: | Line 161: | ||
GROUP BY ?personLabel ?Erdos | GROUP BY ?personLabel ?Erdos | ||
order by ?Erdos | order by ?Erdos | ||
LIMIT 3 | |||
| endpoint = https://query.wikidata.org/sparql | | endpoint = https://query.wikidata.org/sparql | ||
| chart=bordercloud.visualization.DataTable | | chart=bordercloud.visualization.DataTable | ||
| options=colstyle=col1_img_max-width:250px | | options=colstyle=col1_img_max-width:250px | ||
| log=2 | |||
}} | |||
== Hyperlinks == | |||
{{#sparql: | |||
PREFIX bd: <http://www.bigdata.com/rdf#> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX wdt: <http://www.wikidata.org/prop/direct/> | |||
PREFIX wikibase: <http://wikiba.se/ontology#> | |||
SELECT | |||
?publication_date | |||
?html1 | |||
WHERE { | |||
?work wdt:P16 wd:Q676062 . | |||
OPTIONAL { | |||
?work wdt:P28 ?publication_datetime . | |||
BIND(xsd:date(?publication_datetime) AS ?publication_date) | |||
} | |||
?work rdfs:label ?label . | |||
FILTER (LANG(?label) = "en") | |||
BIND(CONCAT('<a href=\'', xsd:string(?work),'\'>',?label,'</a>') as ?html1) | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,da,de,es,fr,jp,nl,no,ru,sv,zh". } | |||
} | |||
ORDER BY DESC(?publication_date) | |||
LIMIT 5 | |||
| endpoint = https://query.wikidata.org/sparql | |||
| chart=bordercloud.visualization.DataTable | |||
| log=2 | | log=2 | ||
}} | }} |
Latest revision as of 00:37, 7 October 2023
About
This page assists in testing on-wiki query features.For background, see LinkedWiki and Module:Wd.
Map
Pie chart
Tables
publication_date | work | workLabel | workUrl |
---|---|---|---|
2024-01-01 | http://www.wikidata.org/entity/Q124254609 | Computational reproducibility of Jupyter notebooks from biomedical publications | /work/Q124254609 |
2022-04-04 | http://www.wikidata.org/entity/Q111507314 | WikiProject Clinical Trials for Wikidata | /work/Q111507314 |
2022-02-28 | http://www.wikidata.org/entity/Q111145762 | WikiProject Clinical Trials snapshot February 2022 | /work/Q111145762 |
2017-07-20 | http://www.wikidata.org/entity/Q33269085 | A multi-disciplinary perspective on emergent and future innovations in peer review | /work/Q33269085 |
2014-06-16 | http://www.wikidata.org/entity/Q22064488 | Enriched biodiversity data as a resource and service | /work/Q22064488 |
03:28:52 11/24/2024 -- Refresh -- Duration of query :0.08s -- CSV |
publication_date | work | workLabel | workUrl |
---|---|---|---|
03:28:52 11/24/2024 -- Refresh -- Duration of query :0.057s -- CSV |