query-98e8b0f7b2877d0c3699f0d0cf4d140e

rq turtle/ttl

Propertiesmain subject (P921)publication date (P577)author (P50)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?node1 ?node2 ?node1Label ?node2Label ?pdate ?topicLabel ?authorLabel (COUNT(?work) AS ?count)
WHERE {
  VALUES ?nucleation_topics { wd:Q84263196 wd:Q82069695 wd:Q81068910 }
  ?work wdt:P921 ?nucleation_topics, ?node1, ?node2. # Find co-nodes
  FILTER   (?node1 != ?node2)                  # Exclude self-links
#  OPTIONAL { ?work wdt:P577 ?pdate. }
#  OPTIONAL { ?work wdt:P50  ?author. }
  SERVICE  wikibase:label { bd:serviceParam wikibase:language "en,fr,de,ru,es,zh,jp". }
}
GROUP BY ?node1 ?node2 ?node1Label ?node2Label ?pdate ?topicLabel ?authorLabel 
ORDER BY DESC(?count)
LIMIT 10000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?count") v2("?node1"):::projected v3("?node2"):::projected v4("?nucleation_topics") v5("?work"):::projected c5(["en,fr,de,ru,es,zh,jp"]):::literal c3(["bd:serviceParam"]):::iri f0[["?node1 != ?node2"]] f0 --> v2 f0 --> v3 bind1[/VALUES ?nucleation_topics/] bind1-->v4 bind10(["wd:Q84263196"]) bind10 --> bind1 bind11(["wd:Q82069695"]) bind11 --> bind1 bind12(["wd:Q81068910"]) bind12 --> bind1 v5 --"wdt:P921"--> v4 v5 --"wdt:P921"--> v2 v5 --"wdt:P921"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c3 --"wikibase:language"--> c5 end bind3[/"count(?work)"/] v5 --o bind3 bind3 --as--o v6