Talk:ArchiveBot/Wikidata lists

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

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