query-c2835d5e9831bdf365eff8c4526e24de

rq turtle/ttl

Propertiespublication date (P577)main subject (P921)instance of (P31)subclass of (P279)part of (P361)facet of (P1269)cites work (P2860)

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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#>
# tool: scholia
#defaultView:Table
SELECT ?count ?cited_work ?cited_workLabel
WHERE {
   {
  SELECT (count(?work) as ?count) ?cited_work WHERE {
      ?cited_work wdt:P577 ?publicationdate .
    FILTER (?publicationdate > "2009-01-01T00:00:00"^^xsd:dateTime) . #works published on the subject after a certain date
    { ?work wdt:P921/wdt:P31*/wdt:P279* wd:Q2941393 . }
    union { ?work wdt:P921/wdt:P361+ wd:Q2941393 . }
    union { ?work wdt:P921/wdt:P1269+ wd:Q2941393 . }
    ?work wdt:P2860 ?cited_work .
  }
  GROUP BY ?cited_work
}  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da,de,es,fr,jp,nl,no,ru,sv,zh" . } 
}
ORDER BY DESC(?count)
LIMIT 200

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?cited_work"):::projected v5("?count"):::projected v2("?publicationdate") v4("?work") a1((" ")) a2((" ")) a3((" ")) a4((" ")) c13(["en,da,de,es,fr,jp,nl,no,ru,sv,zh"]):::literal c11(["bd:serviceParam"]):::iri c6(["wd:Q2941393"]):::iri f0[["?publicationdate > '2009-01-01T00:00:00^^xsd:dateTime'"]] f0 --> v2 v3 --"wdt:P577"--> v2 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; v4 --"wdt:P921"--> a4 a4 --"wdt:P1269"--> c6 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v4 --"wdt:P921"--> a3 a3 --"wdt:P361"--> c6 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v4 --"wdt:P921"--> a1 a1 --"wdt:P31"--> a2 a2 --"wdt:P279"--> c6 end union0r <== or ==> union0l end v4 --"wdt:P2860"--> v3 bind2[/"count(?work)"/] v4 --o bind2 bind2 --as--o v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end