query-0c4d63399b506d3be4e54be517da5bc0

rq turtle/ttl

Articles where the main subject is "Younger Dryas impact hypothesis" and the reference for that statement is a link to "The Bib"

SELECT DISTINCT ?item ?date ?itemLabel ?publisherLabel ?doi ?statements ?ids (COUNT(?cite) AS ?cites) # ?ref ?sitelinks WHERE { ?item wdt:P921 wd:Q1092095.

?item p:P921 ?statement. ?statement prov:wasDerivedFrom ?refnode. ?refnode pr:P854 ?ref.

FILTER(CONTAINS(STR(?ref), "younger-dryas-impact-hypothesis-bibliography-and-paper-archive")).

OPTIONAL { ?item wdt:P577 ?date } OPTIONAL { ?item wdt:P1433 ?publisher } OPTIONAL { ?item wdt:P356 ?doi } OPTIONAL { ?item wdt:P2860 ?cite } OPTIONAL { ?item wikibase:statements ?statements ; wikibase:identifiers ?ids ; wikibase:sitelinks ?sitelinks }

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". } } GROUP BY ?item ?date ?itemLabel ?publisherLabel ?doi ?statements ?ids ORDER BY ?date ?itemLabel

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Articles where the main subject is "Younger Dryas impact hypothesis" and the reference for that statement is a link to "The Bib"

SELECT DISTINCT ?item ?date ?itemLabel ?publisherLabel ?doi ?statements ?ids (COUNT(?cite) AS ?cites) # ?ref ?sitelinks
WHERE
{ 
  ?item wdt:P921 wd:Q1092095.

  ?item p:P921 ?statement.
  ?statement prov:wasDerivedFrom ?refnode.
  ?refnode   pr:P854 ?ref.

  FILTER(CONTAINS(STR(?ref), "younger-dryas-impact-hypothesis-bibliography-and-paper-archive")).

  OPTIONAL { ?item wdt:P577 ?date }
  OPTIONAL { ?item wdt:P1433 ?publisher }
  OPTIONAL { ?item wdt:P356 ?doi }
  OPTIONAL { ?item wdt:P2860 ?cite }
  OPTIONAL { ?item wikibase:statements ?statements ; wikibase:identifiers ?ids ; wikibase:sitelinks ?sitelinks }


  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
GROUP BY ?item ?date ?itemLabel ?publisherLabel ?doi ?statements ?ids
ORDER BY ?date ?itemLabel

Query found at

• https://www.wikidata.org/wiki/User:Aluxosm/Scratchpad