query-437632263534ac90dbdbecd3ee231d20
Scholiacited work graph with title ?citing_work wdt:P577 ?citing_date . ?cited_work wdt:P577 ?cited_date . ?citing_work wdt:P1476 ?citing_title. ?cited_work wdt:P1476 ?cited_title . bind(year(?citing_date) as ?citing_year) bind(year(?cited_date) as ?cited_year) bind(concat(?citing_title, ", ", str(?citing_year)) as ?citing_workLabel) bind(concat(?cited_title, ", ", str(?cited_year)) as ?cited_workLabel)
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
# tool: scholia
#defaultView:Graph
PREFIX target: <http://www.wikidata.org/entity/Q19237133>
SELECT
?citing_work ?citing_workLabel ?rgb
?cited_work ?cited_workLabel
WITH {
SELECT (COUNT(*) AS ?count) ?citing_work WHERE {
target: (^wdt:P2860| wdt:P2860) / (^wdt:P2860 | wdt:P2860)? ?citing_work .
}
GROUP BY ?citing_work
ORDER BY DESC(?count)
LIMIT 40
} AS %citing_works
WITH {
SELECT (COUNT(*) AS ?count_) ?cited_work WHERE {
target: (^wdt:P2860 | wdt:P2860) / (^wdt:P2860