Talk:ArchiveBot/Wikidata lists

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

• https://transfer.notkiska.pw/aVG4c/museums-top-1000.txt

Cities query

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

• https://transfer.notkiska.pw/6rYxe/cities-top-1000.txt

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

• https://transfer.notkiska.pw/PTUBR/newspapers-top-100.txt
• https://transfer.notkiska.pw/qORue/newspapers-top-500.txt
• https://transfer.notkiska.pw/5HnU0/newspapers-top-1000.txt
• https://transfer.notkiska.pw/scnOs/newspapers-top-5000.txt

Government bodies

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