View source for QuickSparqlStatements/TestOneOfDanielsQueries/250118120141

add FactGrid ID based on Wikidata<br/><h3>Form data:</h3><syntaxhighlight lang="json">{
    "query": "# This query produces statements for\n# https:\/\/quickstatements.portal.mardi4nfdi.de\/#\/batch\/new\n# Help: https:\/\/www.wikidata.org\/wiki\/Help:QuickStatements .\n\nPREFIX wdt: <https:\/\/portal.mardi4nfdi.de\/prop\/direct\/>\nPREFIX wd: <https:\/\/portal.mardi4nfdi.de\/entity\/>\n\nPREFIX wikidata_wd: <http:\/\/www.wikidata.org\/entity\/>\nPREFIX wikidata_wdt: <http:\/\/www.wikidata.org\/prop\/direct\/>\n\nSELECT DISTINCT\n\n#######\n# To get the QuickStatements commands, comment out the lines until the next hash line\n# ?mardi_item\n# ?mardi_item_label\n# ?wikidata\n# ?wikidata_label\n# ?zbMATH_author\n#######\n\n(REPLACE(STR(?mardi_item), \".*Q\", \"Q\") AS ?qid) \n# (\"P20\" AS ?property)\n# (CONCAT(\"\\\"\", REPLACE(STR(?wikidata), \".*Q\", \"Q\"), \"\\\"\") AS ?wikidata_qid) \n(CONCAT(\"\\\"\", ?ORCID, \"\\\"\") AS ?P20) \n\nWHERE {\n  SERVICE bd:sample { ?mardi_item wdt:P676 ?zbMATH_author . bd:serviceParam bd:sample.limit 20000 }\n\n  ?mardi_item wdt:P12 ?WikidataQID .\n  BIND(URI(STR(CONCAT(wikidata_wd:, ?WikidataQID))) AS ?wikidata)\n  service <https:\/\/query.wikidata.org\/sparql> {\n    ?wikidata wikidata_wdt:P1556 ?zbMATH_author .\n    ?wikidata wikidata_wdt:P496 ?ORCID .\n    ?wikidata rdfs:label ?wikidata_label .\n    FILTER (LANG(?wikidata_label) = \"en\")\n  }\n  ?mardi_item rdfs:label ?mardi_item_label .\n  FILTER (LANG(?mardi_item_label) = \"en\")\n}",
    "job-title": "TestOneOfDanielsQueries",
    "job-description": "add FactGrid ID based on Wikidata",
    "totalLimit": "2"
}</syntaxhighlight><h3>Endpoint</h3>https://query.portal.mardi4nfdi.de/proxy/wdqs/bigdata/namespace/wdq/sparql