Difference between revisions of "Talk:ArchiveBot/Wikidata lists"

From Archiveteam
Jump to navigation Jump to search
Line 89: Line 89:
}
}
ORDER BY ?website
ORDER BY ?website
</pre>
== Newspapers ==
Sorted by number of wikipedia languages for each newspaper.
<pre>
Wikidata query:
SELECT DISTINCT ?web
WHERE {
    ?item wdt:P31/wdt:P279* wd:Q11032.
    ?item wdt:P856 ?web.
    ?item wikibase:sitelinks ?sitelinks.
}
ORDER BY DESC(?sitelinks) LIMIT 1000
</pre>
</pre>

Revision as of 10:46, 11 March 2020

You can run these queries in https://query.wikidata.org/

Facebook query

SELECT DISTINCT ?item ?facebook
WHERE {
    { ?item wdt:P4003 ?facebook. } UNION { ?item wdt:P2013 ?facebook. }
}
ORDER BY ?facebook

Telegram query

SELECT DISTINCT ?item ?telegram
WHERE {
    ?item wdt:P3789 ?telegram.
}
ORDER BY ?telegram

Twitter query

SELECT DISTINCT ?item ?twitter
WHERE {
    ?item wdt:P2002 ?twitter.
}
ORDER BY ?twitter

Sorted by followers

SELECT DISTINCT ?item ?twitter ?followers
WHERE {
    ?item wdt:P2002 ?twitter.
    ?item p:P2002 [ pq:P3744 ?followers ].
}
ORDER BY DESC(?followers)

YouTube query

SELECT DISTINCT ?item ?youtube
WHERE {
    ?item wdt:P2397 ?youtube.
}
ORDER BY ?youtube

Museums query

SELECT DISTINCT ?item ?website
WHERE {
    ?item wdt:P31/wdt:P279* wd:Q33506.
    ?item wdt:P856 ?website.
}
ORDER BY ?website

Cities query

SELECT DISTINCT ?website
WHERE {
    ?item wdt:P31/wdt:P279* wd:Q486972.
    ?item wdt:P856 ?website.
}
ORDER BY ?website

Archives query

SELECT DISTINCT ?website
WHERE {
    ?item wdt:P31/wdt:P279* wd:Q166118.
    ?item wdt:P856 ?website.
}
ORDER BY ?website

Sport events

SELECT DISTINCT ?website
WHERE {
    ?item wdt:P31/wdt:P279* wd:Q13406554.
    ?item wdt:P856 ?website.
}
ORDER BY ?website

Newspapers

Sorted by number of wikipedia languages for each newspaper.

Wikidata query:
SELECT DISTINCT ?web
WHERE {
    ?item wdt:P31/wdt:P279* wd:Q11032.
    ?item wdt:P856 ?web.
    ?item wikibase:sitelinks ?sitelinks.
}
ORDER BY DESC(?sitelinks) LIMIT 1000